Thread: VBA - How to put data in cell with macro?
View Single Post
  #2   Spotlight this post!  
Unread 28-12-2008, 21:37
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
no team (formerly with 2834)
  
Join Date: Apr 2008
Rookie Year: 2009
Location: Foster City, CA, USA
Posts: 752
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Re: VBA - How to put data in cell with macro?
Quote:
Originally Posted by indieFan View Post
I'm a complete novice when it comes to VBA. (I'm currently without anything to do at work, so I'm trying to write a program.)

I'm trying to write a macro code in VBA to open a bunch of files and calculate how many lines are in the file. I then want to write the total number of lines in the cell of the column of a "blank" file. When I've tried to use the line

cells(k,1) = total

I get an "object" error. Can anyone help me?

Thanks,
indieFan
It is not nice that nobody is answering your question, maybe because it has nothing to do with robotics. I am only an intermediate Excel user but you will have better luck asking the question on another forum. That is where I learn all my VBA stuff. The website is www.mrexcel.com. They have over 1.6 million posts there about Excel and VBA. Good luck.

Ed
__________________
Please don't call me Mr. Ed, I am not a talking horse.
Reply With Quote