Results 1 to 3 of 3

Thread: Resizing Column & Row * RESOLVED *

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    May 2001
    Location
    Montréal, Québec
    Posts
    195

    Resizing Column & Row * RESOLVED *

    I want to resize sheets columns and rows when I open my file. (On startUp of the .xls)

    I have only the first sheets that is not like the others (in column and rows size)

    How do I do this?


    I would like to have something like that if possible:
    (cause I have a lot of sheet in my .xls)

    Dim form as sheet
    for each form in ?
    if (form.name <> "First Form") then
    form.row(6).pixelwidth = 50
    form.column(7 or "E").pixelwidth = 150
    end if
    next sheet

    ?

    thks
    Last edited by Megistal; Jul 19th, 2003 at 09:32 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width