empty cell

[Ric Parris]

Hi guys
Im working on a club golf score card situation.What I
need to do is copy three (3) independant cells to another
page in the same book, but to place data in the next
available cell on a particular line. I figured a macro
was the easiest way to go but stuck on finding empty cell.
any help would be appreciated.
regards Ric

 

[Don Guillett]

You learn best by posting your efforts for comments and critique.

 

[Bob Phillips]

nextfreecell = Cells(1, Cells(1, Columns.Count).End(xlToLeft).Column +
1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)