Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to view properties of a cell
Excel,
I believe it's possible to view the properties of an individual cell but I can't figure out how. In the VBE, I've opened the Properties window, but I can only see properties for the Workbook or Worksheet. How can I view the properties of an individual cell? Thanks, Alan -- achidsey |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to view properties of a cell
The CELL() worksheet can return many properties of a cell. Other VBA
functions can tell you if the contents are text or number or formula. Other methods or functions can tell you about background color, and font characteristics. -- Gary''s Student "achidsey" wrote: Excel, I believe it's possible to view the properties of an individual cell but I can't figure out how. In the VBE, I've opened the Properties window, but I can only see properties for the Workbook or Worksheet. How can I view the properties of an individual cell? Thanks, Alan -- achidsey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 file/properties to view created date/time how in 2007? | Excel Discussion (Misc queries) | |||
Unable to see Properties in Design View for controls | Excel Worksheet Functions | |||
MS Query, command View-Query Properties | Excel Discussion (Misc queries) | |||
Control Properties Not In View | Excel Programming | |||
how view a WS code/properties | Excel Programming |