Hi everyone i need a little help please
I have a work book with 2 sheets "MAIN" sheet and "CALC" sheet
i need a line of vba code to do this..
on MAIN select columns using cell value on "CALC" (A1) to using cell value on "CALC" (A2)

cell A1 on calc is "D" A2 is "K" so on main sheet cols D - K would be selected

Columns("D:K").Select is easy but i want to be able to change values in cells A1 and A2
I have been trying for ages to sort this
regards Steve