Thread: Showing known cell reference in a popup
View Single Post
  #5  
Old May 31st, 2010, 04:19 PM posted to microsoft.public.excel.worksheet.functions
Colin Hayes
external usenet poster
  
Posts: 313
Default 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