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.