cmrluvitlevit
New Member
- Joined
- Oct 9, 2007
- Messages
- 41
I have a table B7:R100. This table is not always filled out to row 100. I need to write a macro that will copy C7:R100 if there is a value in column B. Column B will always have a number until the end of the list.
For example today the list may go from B7:R50, but tomorrow the list is B7:R57.
Thanks for the help. I am not a VBA guru and can not figure how to write the variable.
For example today the list may go from B7:R50, but tomorrow the list is B7:R57.
Thanks for the help. I am not a VBA guru and can not figure how to write the variable.