Thread: How to select range like page setup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_2_] Leith Ross[_2_] is offline
external usenet poster
  
Posts: 128
Default How to select range like page setup
On Nov 19, 8:15 pm, 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

Hello moonhk,

This line of code will display the PageSetup Dialog from VBA

X = Excel.Application.Dialogs(xlDialogPageSetup).Show

Sincerely,
Leith Ross
Reply With QuoteReply With Quote