Thread: How to determine the height of a Range as an Integer
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
somethinglikeant somethinglikeant is offline
external usenet poster
  
Posts: 94
Default How to determine the height of a Range as an Integer
use expression.Address

this code prints the address of the current selection to the Immediate
window
Sub PrintAddress()
Debug.Print Selection.Address
End Sub

somethinglikeant

Reply With QuoteReply With Quote