When running Excel macros from Access for the second time I get the error
' Object variable not set...'
The code breaks on the tagged line :
.Application.ActiveCell.Offset(-2, -3).Range("a1:c1").Select
**** .Range(Selection, Selection.End(xlUp)).Select****
Selection.FillDown
and after working correctly once requires re setting.
The problem appears to be the word Selection and I am wondering how best to re-phrase the above code.
I have studied other problems like this but so far have failed to find a solution that matches.
Any further help would be very much appreciated
' Object variable not set...'
The code breaks on the tagged line :
.Application.ActiveCell.Offset(-2, -3).Range("a1:c1").Select
**** .Range(Selection, Selection.End(xlUp)).Select****
Selection.FillDown
and after working correctly once requires re setting.
The problem appears to be the word Selection and I am wondering how best to re-phrase the above code.
I have studied other problems like this but so far have failed to find a solution that matches.
Any further help would be very much appreciated