Results 1 to 6 of 6

Freeze panes in vba

Threaded View

j_Southern Freeze panes in vba 10-31-2019, 12:52 PM
Winon Re: Freeze panes in vba 10-31-2019, 01:15 PM
Rick Rothstein Re: Freeze panes in vba 10-31-2019, 02:56 PM
j_Southern Re: Freeze panes in vba 11-01-2019, 10:25 AM
Rick Rothstein Re: Freeze panes in vba 11-01-2019, 01:04 PM
j_Southern Re: Freeze panes in vba 11-04-2019, 10:00 AM
  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Freeze panes in vba

    I am using the following snippet of code to try and freeze the left 4 columns and the upper 4 rows
    Worksheets("Sheet1").Activate
    ActiveWindow.ScrollRow = 1
    ActiveWindow.ScrollColumn = StartPlace - 4
       
     ActiveWindow.FreezePanes = False
        With ActiveWindow
         10   .SplitColumn = StartPlace - 4
               .SplitRow = 5
            .FreezePanes = True
        End With
    End Sub
    Freeze panes works on the SplitRow = 4
    It does not appear to be working on SplitColumn = StartPlace-4 (= 2224) I have searched for a column which is not the one I needed that is Frozen but Have not found it.
    I have also tried adding another FreezePanes =True after row 10 still not working. I have attached a copy of the important part of the worksheet. Can some body show me where I have gone wrong?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. macro w/ Freeze panes keeps shifting where panes freeze on worksheet
    By sschwant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2015, 02:30 AM
  2. Freeze Panes - Can I freeze a specific set of cells?
    By Rosco88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2013, 09:17 AM
  3. Freeze Panes - Freeze Tabs
    By samprince in forum Excel General
    Replies: 1
    Last Post: 01-23-2007, 05:16 PM
  4. Replies: 3
    Last Post: 11-27-2006, 05:24 PM
  5. [SOLVED] Excel 2003 freeze panes won't freeze top row only
    By macbone2002 in forum Excel General
    Replies: 1
    Last Post: 05-31-2006, 11:10 AM
  6. Freeze Panes-When freeze panes is employed it leave a black line
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2006, 01:40 AM
  7. Freeze Panes-can you freeze more than one column
    By rexmann in forum Excel General
    Replies: 4
    Last Post: 06-09-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1