Thread: Setting a print range using variables
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_138_] mudraker[_138_] is offline
external usenet poster
  
Posts: 1
Default Setting a print range using variables
a couple of examples of using variables with range


Range("a1:d" & myval).Select ' myVal = row number
Range("a1:" & MyCol & MyRow).Select 'MyCol = Column letter, MyRow
row number




myval = ActiveCell.SpecialCells(xlLastCell).Address
Range("a1:" & myval).Selec

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote