Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for blank
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! -- EW - Analyst |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for blank
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) --- Regards, Norman "ewagz" wrote in message ... 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! -- EW - Analyst |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
Copying and pasting a worksheet to a blank and removing blank rows | Excel Programming |