Adding text to first empy cell in column A

  • Thread starter Thread starter Sunnmann
  • Start date Start date
S

Sunnmann

Would someone be able to help me to get excel to type in the word "End
(without quotations of course) in the first empty cell in column A?

I tried to make a macro by hitting Ctrl+down arrow in coulmn A, bu
that still records it by the row number. So at the time I would hav
typed End in row 803, but next time I run the excel sheet, it migh
grow to encompass row 825, and now I would overwrite what ever is i
row 803.

Could anyone show me the script or macro to be able to do this
 
Sunnmann

Use the End property

Range("A1").End(xlDown).Offset(1,0).Value = "End"

Some people like to go up instead of down in case there are blanks

Range("A65536").End(xlUp).Offset(1,0).Value = "End"
 
Thank you very much. This helps me emensly and i will now add it to my
ever growing sheet of hints for working with Excel.
 
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
Named cells in an array to a column and to a row 3
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
Search for first empty cell in column 3
paste value column based on first cell command button 1
How to autofit variable columns? 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Select first cell in active row? 1

Back
Top