Posted to microsoft.public.excel.programming

Mike Fogleman Mike Fogleman is offline

external usenet poster

Posts: 1,092

Syntax help!

I am trying to put a calculated value in a cell without putting the formula
in the cell. VB will calculate and put result.
The syntax is killing me. What is it for this:

Range("I18").Value =
Application.WorksheetFunction.CountA('Sheet1:Sheet (Sheets.Count-2)'!A13:A100)

Mike F

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
The NOW() syntax	Tom	Excel Discussion (Misc queries)	3	January 4th 08 04:10 PM
Syntax Help	Dmorri254	Excel Worksheet Functions	2	March 2nd 05 02:51 PM
Syntax	James Bronsan	Excel Programming	1	August 12th 04 09:09 PM
Help with VBA syntax	jacqui[_2_]	Excel Programming	3	January 13th 04 02:29 PM
syntax	Don[_13_]	Excel Programming	2	November 16th 03 03:30 AM

All times are GMT +1. The time now is 01:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us