empty cell

  • Thread starter Thread starter Ric Parris
  • Start date Start date
R

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
 
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)
 
Back
Top