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 IT Returns AY 2018-19

e-Filing of income tax is quite simplified process. This blog will help you to file own IT returns online with ITR-1 form for Assessment Year 2018-19 (Financial Year 2017-18). Last Date: 31st August 2018. This year penalty of Rs 1000 to Rs 5000 has been introduced for filing returns after the due date but before 31st Dec 2018 and Rs 10000 post 31st Dec 2018. 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 Shares dividend + Other non taxable income 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  https://www.incometaxindiaefiling.g...
10 comments
Read more

Top align excel cells in vbscript or lotusscript

I have searched many posts to top align excel cells while doing export to excel with lotus script, finally I got this working code: Const xlTop=-4160 Set xlApp = CreateObject("Excel.Application") Set xlsheet = xlApp.Workbooks(1).Worksheets(1) xlsheet.Cells.Select Set xlSelection=xlApp.Selection xlSelection.VerticalAlignment = xlTop
Post a Comment
Read more