Thread: 'Range' set by userform
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default 'Range' set by userform
You could offer default cells, too.

Set rng = Application.InputBox("Highlight two cells with Y-axis
info.", Default:="Sheet1!B4:B5", Type:=8)

Hth,
Merjet


Reply With QuoteReply With Quote