Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find first blank row in worksheet to import data from txt file
I am trying to import data into a worksheet on a weekly basis. I need to
access the specific worksheet, find the first blank row on that worksheet to import the next weeks data into the worksheet. I got the import but not finding the first blank row and specifying that as the starting ppint for the imort. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find first blank row in worksheet to import data from txt file
The first empty cell in Column A:
Dim lngRow As Long With Worksheets("Sheet1") lngRow = .Cells(.Rows.Count, 1).End(xlUp).Row + 1 End With assuming there is nothing in the very last row of Column A. If that is a concern you could test it: Dim lngRow As Long With Worksheets("Sheet1") If IsEmpty(.Cells(.Rows.Count, 1)) Then lngRow = .Cells(.Rows.Count, 1).End(xlUp).Row + 1 Else: MsgBox "No last cell in Column A" End If End With "DDK" wrote: I am trying to import data into a worksheet on a weekly basis. I need to access the specific worksheet, find the first blank row on that worksheet to import the next weeks data into the worksheet. I got the import but not finding the first blank row and specifying that as the starting ppint for the imort. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing a particular excel worksheet into another excel file | Excel Worksheet Functions | |||
mail merging 2 workbooks??? | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |