C
ChemicalJasper
I have a sheet that on running the macro, pulls in certain data from
the master page and formats it for printing a display.
The last item in the macro is to sort one of the columns in ascending
order.
Most of the macros are recorded from screen actions.
1. If I do not edit the macro, it sorts the data, but moves everthing
up one line (in this case into the colum headers box, row 9)
2. If I change the selection reference to the cells below (B9
500) ->
(B10500) it then fails to sort the first row of data into an
ascending order. (PS the first row of data is actually on row 10, row
9 is the bottom of the column headers row).
Is this a glitch, have I done something wrong???
Any pointers would be much appreciated!
the master page and formats it for printing a display.
The last item in the macro is to sort one of the columns in ascending
order.
Most of the macros are recorded from screen actions.
I record it, I get one of two problems...
1. If I do not edit the macro, it sorts the data, but moves everthing
up one line (in this case into the colum headers box, row 9)
2. If I change the selection reference to the cells below (B9
500) ->(B10
500) it then fails to sort the first row of data into anascending order. (PS the first row of data is actually on row 10, row
9 is the bottom of the column headers row).
Is this a glitch, have I done something wrong???
Any pointers would be much appreciated!