Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with non-static column length (name last row?)
I have a workbook that in column A has a list of dates (for example: A2
= sept 1, A3 = sept 2, and so on). My macro then enters a list of names into column B (for example: B2 = "bob, jim, john", B3 = "todd, bill, susan, bob"). My code copies the data from a bunch of other workbooks and pastes it all in column B. However, every month I have to go in to the code and change the range that the names are copied from (for example, from "B2:B32" to "B2:B33"). I would rather rename the last row to "end" and then cut and paste from range "B2:Bend". How do I do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with non-static column length (name last row?)
Joe
Range("B2:B" & Range("B65536").End(xlUp).Row) Regards Trevor "Joe D" wrote in message oups.com... I have a workbook that in column A has a list of dates (for example: A2 = sept 1, A3 = sept 2, and so on). My macro then enters a list of names into column B (for example: B2 = "bob, jim, john", B3 = "todd, bill, susan, bob"). My code copies the data from a bunch of other workbooks and pastes it all in column B. However, every month I have to go in to the code and change the range that the names are copied from (for example, from "B2:B32" to "B2:B33"). I would rather rename the last row to "end" and then cut and paste from range "B2:Bend". How do I do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with non-static column length (name last row?)
Thanks, I did not think that was going to be so easy. How does that
work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenating two variable fields into a static length text field | Excel Worksheet Functions | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming |