I have the following code:
It returns a range object, "PasteRng".
If i declare a variable: Dim Variable1 as Range, how do i set Variable1 equal to PasteRng offset by lets say 1 cell?
I tried a bunch of different things and nothing seems to work. I've tried:
and some others that i have since deleted. Does anyone have any suggestions?
Thanks!!
Code:
Dim PasteRng As Range
On Error Resume Next
Set PasteRng = Application.InputBox("What cell do you want your data in?", Type:=8)
If PasteRng Is Nothing Then Exit Sub
It returns a range object, "PasteRng".
If i declare a variable: Dim Variable1 as Range, how do i set Variable1 equal to PasteRng offset by lets say 1 cell?
I tried a bunch of different things and nothing seems to work. I've tried:
Code:
Dim Variable1 As Range
Variable1 = Cells(PasteRng.Row + 1, PasteRng.Column)
'&
Variable1 = PasteRng.offset(1,0)
msgbox(Variable1.address)
and some others that i have since deleted. Does anyone have any suggestions?
Thanks!!