Posted to microsoft.public.excel.programming

IgorM[_2_] IgorM[_2_] is offline

external usenet poster

Posts: 41

Runtime error 1004

Hi

When my macro tries to run the line below if the selected cell has no
formulas i get a runtime error 1004 - no cells were found. How to get around
this?

Selection.DirectPrecedents.Select

Kind regards
Igor

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
runtime error '1004' application or object defined error	Janis	Excel Programming	4	November 18th 09 03:01 PM
runtime error '1004' application or object defined error. Please help	deej	Excel Programming	0	August 1st 07 09:26 AM
Runtime Error 1004	Lizz45ie[_10_]	Excel Programming	4	November 8th 05 10:51 PM
Excel 2003 Macro Error - Runtime error 1004	Cow	Excel Discussion (Misc queries)	2	June 7th 05 01:40 PM
What is RunTime Error '1004'?	Ed	Excel Programming	3	November 18th 04 07:09 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us