Showing known cell reference in a popup
In article , FSt1
writes
hi
in your second set, don't reference r1. instead refererce r1.address ie
Set r2 = Application.InputBox("Address of first cell chosen " & r1.Address & _
vbCr & vbCr & "Enter address of last cell" & vbCr & vbCr & _
"(Total Rows In Table : " & lrow & ")", Type:=8)
regards
FSt1
Hi FSt1
Yes , that's fixed it.
Perfect - thank you.
Best Wishes
|