drums4monty
09-27-2013, 03:13 AM
Hi All
I have written a macro that checks a serial number in one workbook and when it matches the number in another workbook copies the information in a column into the first workbook, this part works fine (I must be getting a little better at coding). What I need to do is tell the code that when it reaches the last row where data is, to finish. How do you do that? At the moment I just have a huge range which works but is not the correct way to do it I know.
Many thanks
Alan
I have written a macro that checks a serial number in one workbook and when it matches the number in another workbook copies the information in a column into the first workbook, this part works fine (I must be getting a little better at coding). What I need to do is tell the code that when it reaches the last row where data is, to finish. How do you do that? At the moment I just have a huge range which works but is not the correct way to do it I know.
Many thanks
Alan