Appending data with VBA

  • Thread starter Thread starter mr.mcfly
  • Start date Start date
M

mr.mcfly

Hi
I would like to append data after the last occupied cell of a row
using VBA. How do I determine the last cell containing data?
Ta much
Martin
 
cLastRow = Cells(Rows.Count,"A").End(xlUp).Row

--

HTH

RP
(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

Row and column count last occupied cells in range 2
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
Setting range to last occupied cell 3
Compare data set 1 with data set 2. Add to data set 2 if not found 0
VBA copy and paste data 2
How to append data from different sheet and different workbook? 2
Excel VBA 1
Sub to append data below existing 2

Back
Top