Hi,
I have a programme which works fine on my computer at home but when I send it via email to work the 'sort' function messes up (there is a chance it could be the 'vlookup' function, though) and all the cells in the sort range lose their formula reference - which is of course a tad annoying.
The part of the programme I'm having difficulty with is this:
Range("SsNo1").Resize(d, f).Offset(a, 0).Select
Selection.Sort Key1:=Range("FRSet1"), Order1:=xlDescending, Header:=xlGuess _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Looking around on the net, I think the problem may lie with the fact I haven't yet named my project file and this is causing the above not to be recognized on the new computer - but I'm still confused about the steps I should take and what I should be looking for...
Any ideas about which proverbial tree I should be barking up, here?
Thank you in advance
Adam
I have a programme which works fine on my computer at home but when I send it via email to work the 'sort' function messes up (there is a chance it could be the 'vlookup' function, though) and all the cells in the sort range lose their formula reference - which is of course a tad annoying.
The part of the programme I'm having difficulty with is this:
Range("SsNo1").Resize(d, f).Offset(a, 0).Select
Selection.Sort Key1:=Range("FRSet1"), Order1:=xlDescending, Header:=xlGuess _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Looking around on the net, I think the problem may lie with the fact I haven't yet named my project file and this is causing the above not to be recognized on the new computer - but I'm still confused about the steps I should take and what I should be looking for...
Any ideas about which proverbial tree I should be barking up, here?
Thank you in advance
Adam
Last edited: