Looking for blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one sheet that will gather the needed info and a macor that will then
take that info and move it to another workbook (database like) it will then
deposit that info to the next open row and paste. What code do I use in my
macro to look for the next ava. cell in the A:A column?

Thanks for any help in this matter!
 
Hi EW,

Try something like::

Dim SH as Worksheet
Dim Rng As Range

Set SH = Workbooks("OtherBook.xls").Sheets("Sheet1")

Set Rng = SH.Cells(Rows.Count, "A").End(xlUp)(2)
 
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

Create if partial match then copy and paste data from one cell to another 1
Delete rows if column looks blank 4
Blank cells problem 5
For Each Next 16
Eliminate blanks while copy row and transpose 11
loop through looking for value 2
Get info from second sheet 3
Macros 1

Back
Top