Thread: VBA - How to put data in cell with macro?
View Single Post
  #1   Spotlight this post!  
Unread 28-12-2008, 14:13
indieFan indieFan is offline
RoboDox and LVHS - Missing you!
FRC #5941
Team Role: Engineer
  
Join Date: Jan 2002
Rookie Year: 2001
Location: Seattle (was SoCal, then SA,TX))
Posts: 382
indieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond reputeindieFan has a reputation beyond repute
VBA - How to put data in cell with macro?
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
Reply With Quote