Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA NEWBIE Need A Bit of Help
Am just starting to learn a bit about VBA & Hoping someone can offer some
help. have a worksheet with a table say 5 columns wide by 10 rows, however could at times have more rows i want to insert an object in the first row UNDER the table's Last Row i have been able to do that easily when the table is a fixed size and the row number is always the same, but i can't figure out how to make my code identify which is the last row of the table and go to the next row below that TIA for any help WC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA NEWBIE Need A Bit of Help
hi
number of ways to work this... if you want to know the row number... Dim r As Long r = Cells(Rows.Count, "a").End(xlUp).Row MsgBox r Range("A" & r + 1).Select or if the row number isn't important to what your are doing.. bottom up method.... range("A65536").end(xlup).offset(1,0).select or if you have a solid block of data, go the other way.... top down method.... range("A1").end(xldown).offset(1,0).select regards FSt1 "Wile Coyote" wrote: Am just starting to learn a bit about VBA & Hoping someone can offer some help. have a worksheet with a table say 5 columns wide by 10 rows, however could at times have more rows i want to insert an object in the first row UNDER the table's Last Row i have been able to do that easily when the table is a fixed size and the row number is always the same, but i can't figure out how to make my code identify which is the last row of the table and go to the next row below that TIA for any help WC |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA NEWBIE Need A Bit of Help
?B?RlN0MQ==?= wrote in
: Thank You ..... Works great! hi number of ways to work this... if you want to know the row number... Dim r As Long r = Cells(Rows.Count, "a").End(xlUp).Row MsgBox r Range("A" & r + 1).Select or if the row number isn't important to what your are doing.. bottom up method.... range("A65536").end(xlup).offset(1,0).select or if you have a solid block of data, go the other way.... top down method.... range("A1").end(xldown).offset(1,0).select regards FSt1 "Wile Coyote" wrote: Am just starting to learn a bit about VBA & Hoping someone can offer some help. have a worksheet with a table say 5 columns wide by 10 rows, however could at times have more rows i want to insert an object in the first row UNDER the table's Last Row i have been able to do that easily when the table is a fixed size and the row number is always the same, but i can't figure out how to make my code identify which is the last row of the table and go to the next row below that TIA for any help WC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real Newbie newbie question | New Users to Excel | |||
Newbie help pls | Excel Programming | |||
Newbie Help. Is this possible? | Excel Discussion (Misc queries) | |||
Very newbie | Excel Programming | |||
ADO newbie help please | Excel Programming |