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
 
You learn best by posting your efforts for comments and critique.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Insert selected cell value into next cell in range that is empty 6
Mapping integers to strings 5
Sum and If Function Problem with Excel 2007 5
Formula to add 4 lowest numbers from a column of 6 4
Average of lowest 6 from a range - 1 attachment 5
Excel VBA 1

Back
Top