View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
moonhk moonhk is offline
external usenet poster
 
Posts: 62
Default How to select range like page setup

On 11$B7n(B20$BF|(B, $B2<8a(B8$B;~(B56$BJ,(B, Dave Peterson wrote:
Dim myRng as range

on error resume next
set myrng = application.inputbox(Prompt:="Select a range", type:=8)
on error goto 0

if myrng is nothing then
'user hit cancel
else
msgbox myrng.address(external:=true)
end if

moonhk wrote:

Hi All
In the Page setup dialogs, sheet tab, you can select Page Area , Rows
to report at top and Columns to repeat at left, by click the icon,
allow you select worksheet range. Is this methods can be apply on
VBA ? If yes how to apply on vba coding ?


moonhk
GMT+8


--

Dave Peterson


Thank Dave , You coding tested OK.
Thank other also.