Skip to main content

Excel freeze panes in vbscript or lotusscript

Freeze 1st row of excel:
Set xlApp = CreateObject("Excel.Application")
xlApp.Rows(2).Select
xlApp.ActiveWindow.FreezePanes = True

Freeze 1st column of excel:
Set xlApp = CreateObject("Excel.Application")
xlApp.Columns(2).Select
xlApp.ActiveWindow.FreezePanes = True

Freeze 1st row AND 1st column of excel:
Set xlApp = CreateObject("Excel.Application")
xlApp.Range("B2").Select
xlApp.ActiveWindow.FreezePanes = True
Labels:

Comments

Paul said…
Helped me nicely - Thank you
June 2, 2014 at 8:16 AM
Post a Comment

Popular posts from this blog

Sikkim Darjeeling Tour

Visited Sikkim and Darjeeling on 13-Jun-2015 to 20-Jun-2015 with my wife. Here is trip information which you might find helpful to plan your North East trip  Day 1 -  1) Mumbai to Bagdogra flight ( Rs 8000 per person) 2) Bagdogra to Kalimpong (Prepaid cab Rs 1400, 3 hours) 3) Kalimpong siteseeing (takes 2 - 3 hours)     1. Cactus Nurseries     2. Durbin Dara Monastery     3. Mangal Dham     4. Deolo Hill 4) Kalimpong to Gangtok (2.5 hours)     Full day taxi 4200     Overnight stay at Gangtok Day 2 - 1) Gangtok 10 point siteseeing (local taxi Rs 1600. 5 hours)     1. Bakhtang waterfall     2. Gunjung Monetrary     3. Tashi view point     4. Lasa waterfall     5. Plant Consertaion     6. Ganesh Tok     7. Flower show (must visit)     8. Ropeway     9. Institute of Tibetology (Closed on Sunday...
25 comments
Read more

eFiling of I.T. Returns AY 2016-17

e-Filing of income tax is quite simplified process. This blog will help you to file own IT returns online with ITR-1 form. ITR-1 form is applicable if you have income from following sources: Salary House rent / loan Interest on saving bank account / FD Agriculture income less than Rs 5000 Prerequisites for e-filing Form 16 Form 26AS (refer Step 4 below) Interest from saving bank account / FD Any investment that is not declared with company or not reflected in Form 16 Follow below steps to e-file your IT Returns (click on pictures to enlarge) Step 1 – Get Form 16 from your employer Step 2  – Register yourself at site  http://incometaxindiaefiling.gov.in/ Step 3  – Login on site User ID is your PAN Step 4  – Download From 26AS Follow link View Form 26AS (Tax Credit), you will be redirected to TRACES site. Download form 26AS for current Assessment year. Step 5  –  Quick e-File ITR-1 Click Q...
18 comments
Read more