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.
|