Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default dynamic range counta error

Make sure calculation is set to automatic (I think) and then just add something
to the range (E6:E##).

wrote:

ok so its created it but do i have to do something for it to
autoupdate itself like an eventhandelr?

thanks


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Defind Dynamic named Range up to first error chg Excel Worksheet Functions 3 December 6th 09 09:32 PM
dynamic range counta error Bob Phillips Excel Programming 0 August 20th 07 12:18 PM
Trapping error with dynamic range ArthurJ Excel Programming 4 August 28th 05 08:44 PM
Dynamic Ranges that do not use COUNTA($A:$A) sebastienm Excel Programming 1 September 3rd 04 08:14 PM
Dynamic Ranges that do not use COUNTA($A:$A) Frank Kabel Excel Programming 0 September 3rd 04 07:08 PM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"