I use this code all the time to define a variable based on the bottom Row of a specific column. (Last Row that has information) That way when I'm setting a copy range I can paste to the bottom of a chart.
I'm trying to use this same concept by defining a variable as a column number. Why doesn't this work?![]()
LastRow = Range("B" & Rows.Count).End(xlUp).Row
![]()
LastColumn= Range("1" & Rows.count).end(xlToLeft).column
Bookmarks