Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to switch view
Hi,
Can someone tell me how do I switch view using VBA so that the cells displays the formula instead of the evaluated values? Also, how do i set the width of cell columns ? Thanks.. -- Regards, Adrian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to switch view
Hi Adrian,
Can someone tell me how do I switch view using VBA so that the cells displays the formula instead of the evaluated values? ActiveWindow.DisplayFormulas = True Also, how do i set the width of cell columns ? To set the width of column A to 20: Worksheets("Sheet1").Columns("A:A").ColumnWidth = 20 To autofit columns A to D: Worksheets("Sheet1").Columns("A:D").AutoFit --- Regards, Norman "Adrian" wrote in message ... Hi, Can someone tell me how do I switch view using VBA so that the cells displays the formula instead of the evaluated values? Also, how do i set the width of cell columns ? Thanks.. -- Regards, Adrian |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to switch view
displays the formula instead of the evaluated values?
One way... With ActiveWindow .DisplayFormulas = Not .DisplayFormulas End With HTH Dana DeLouis "Adrian" wrote in message ... Hi, Can someone tell me how do I switch view using VBA so that the cells displays the formula instead of the evaluated values? Also, how do i set the width of cell columns ? Thanks.. Regards, Adrian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View the code in a add-in | Excel Worksheet Functions | |||
View Code question | Excel Discussion (Misc queries) | |||
how view a WS code/properties | Excel Programming | |||
Mouse in Code View | Excel Programming | |||
Number Switch Code | Excel Programming |