View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pama pama is offline
external usenet poster
 
Posts: 5
Default moving to the next line in the appropriate column using VBA code

I am a beginner and would like to create a macro that inserts an address into
a worksheet. It works fine if I am in cell A1, because the code calls up
cells A2 and A3 with: Range("A2").Select or Range("A3").Select.
What code do I use to make the next line of the address go to the cell under
the first line of the address no matter where I am on the spreadsheet. I hope
that makes sense.
Thank you.