VBA Code for First EMPTY cell in column

jms2553

Board Regular
Joined
Jun 5, 2002
Messages
107
I found the code that will return the first non-empty cell, but can't find one for the first empty cell. I need to continually update data, and add it to different workbooks and sheets, at the end of the existing data. Any help will be greatly appreciated.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
700
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
Range("A65536").End(xlUp).Offset(1,0).Select

this will select the first empty cell from bottom row of the coloumn. you can manipulate this to suite for your purpose.

GNaga
 

jms2553

Board Regular
Joined
Jun 5, 2002
Messages
107
That worked great - thanks! One more question, I hope. When I'm filtering data, to copy and paste into another worksheet, occasionally I need to select everything but the header row and paste that data into the first empty cell of a differenct worksheet. This row (containing the information that is going to copied and pasted) is going to keep changing, so what might be Row 485 one day will be 845 the next.
 

Forum statistics

Threads
1,148,190
Messages
5,745,246
Members
423,938
Latest member
manilaphilips

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top