hey

The following code finds the last row used (variable
STACKEDUP) and find the last column used (variable
STACKEDLEFT). STACKEDUP works fine but STACKEDLEFT keeps
showing 256 which is column IV. There is no data in this
column so why does it keep finding it as the last column
with data in it. It should be finding column Z because
thats the last column that has data in it.


Worksheets("Location View").Select
STACKEDUP = Worksheets("Location View").Range("A65536").End
(xlUp).Row
STACKEDLEFT = Worksheets("Location View").Range("h:h").End
(xlToRight).Column


Thanks
Todd