Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting
Hi Ppl, How to format the Worksheet programatically from a software like Visual Basic ? For e.g. the worksheets specific rows have to be changed into numberformat="Number" instead of default "General" Thanks, Vijay -- vgurusa ------------------------------------------------------------------------ vgurusa's Profile: http://www.excelforum.com/member.php...o&userid=28100 View this thread: http://www.excelforum.com/showthread...hreadid=478321 |
#2
|
|||
|
|||
Formatting
One way:
Application.Workbooks("Book1.xls").Sheets("Sheet1" ).Range( _ "1:10").NumberFormat = "0.00" In article , vgurusa wrote: Hi Ppl, How to format the Worksheet programatically from a software like Visual Basic ? For e.g. the worksheets specific rows have to be changed into numberformat="Number" instead of default "General" Thanks, Vijay |
#3
|
|||
|
|||
Formatting
Hi JE, Thats not working, I always get an error subscript out of range error! Can you suggest another way ! Thanks, Vijay -- vgurusa ------------------------------------------------------------------------ vgurusa's Profile: http://www.excelforum.com/member.php...o&userid=28100 View this thread: http://www.excelforum.com/showthread...hreadid=478321 |
#4
|
|||
|
|||
Formatting
Vijay
A #9 subscript out of range error is generated if the code can't find a referenced element in the code, for example if you reference Sheet10 and you don't have one -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "vgurusa" wrote in message ... Hi JE, Thats not working, I always get an error subscript out of range error! Can you suggest another way ! Thanks, Vijay -- vgurusa ------------------------------------------------------------------------ vgurusa's Profile: http://www.excelforum.com/member.php...o&userid=28100 View this thread: http://www.excelforum.com/showthread...hreadid=478321 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) |