LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
FGM FGM is offline
external usenet poster
 
Posts: 35
Default APPLICATION.RANGE EXCEL

Microsoft XP Windows 2000

Have many macros using Range("B2") etc.

Of a sudden none of my macros will run giving me a wrong number of arguments
error. I am having to change put Application. infront of Range("B2")
Application.Range("B2")

Why would this quite taking Range("B2") without application in front?

Have many, many macros with many, many range("xx") lines in it .....

Any explanation?

Thanks in advance ....
 
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
Excel selected range not showing when Excel application not in focus ewolfman Excel Discussion (Misc queries) 0 January 9th 07 10:40 PM
Application.Selection Is Range? Jeff Higgins Excel Programming 4 February 2nd 05 03:25 PM
macro to close excel application other than application.quit mary Excel Programming 1 September 14th 04 03:43 PM
VBA application; Subscript Out of Range M J Excel Programming 8 December 30th 03 01:38 AM
Link Excel range to PowerPoint Application text box marina[_2_] Excel Programming 0 July 10th 03 08:23 PM


All times are GMT +1. The time now is 10:27 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"