Posted to microsoft.public.excel.programming

Tim Childs[_10_] Tim Childs[_10_] is offline

external usenet poster

Posts: 9

Syntax for Cell type

Hi

In VBA I want to get the cell information on a cell e.g. in the
Application itself, I can put:
=CELL("type",A1)
in Cell B1
However, I would like to extract the same information about (multiple)
cells directly from VBA itself i.e. in a procedure, without entering a
formula into an Excel cell.
Please can you give me the VBA syntax for that.

Many thanks

Tim

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Syntax for AutoCad File Type *.dwg	Benjamin	Excel Programming	2	July 7th 09 09:10 PM
cell reference syntax	Fred	Excel Worksheet Functions	2	December 16th 08 04:01 PM
VBA Import Convert Data Type from Type 1 to Type 2	u473	Excel Programming	3	October 21st 08 08:22 PM
cell value syntax	miek	Excel Programming	2	August 12th 08 09:19 PM
Worksheet().Range(Cell(), Cell()) syntax?	Ouka[_6_]	Excel Programming	10	July 27th 05 12:50 AM

All times are GMT +1. The time now is 03:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us