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?

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?

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?