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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can I split a worksheet then have the 2 sections work independent 1
Excel Limit to Named Ranges 1
Split one worksheet to multiple 1
Splitting Worksheet 2
Programmatically add a Formula in a worksheet? 3
how do I sort a spreadsheet of daily events into weekly totals? 1
Relative worksheet reference for multiple worksheets in a workbook 5
Lookup in multple worksheets 5

Back
Top