worksheet split programmatically?

  • Thread starter Thread starter rob merritt
  • Start date Start date
R

rob merritt

Hi

is it possible to split a worksheet programmatically?

if so what is the syntax

I have vba to create 52 weekly worksheets and the top and bottom need
to be independantly scrollable
 
You need to provide more information about what you mean by "split a
worksheet" as well as what top and bottom you want to scroll
independently.

If you mean you want two windows, try to get the code yourself with the
help of the macro recorder. Turn it on (Tools | Macro > Record new
macro...), do whatever it is you want to do, and turn off the recorder.
XL should (though there are no guarantees) give you the necessary code.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top