LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Rob
 
Posts: n/a
Default Application prefix or not

when creating some code, via the record macro function I find that
sometimes, for it to run succesfully, I need to add "Application"
immediately before some of the lines.

eg. Range ("A1") would become Application.Range ("A1") for that line to be
accepted.
Can someone tell me why, and what the rule is here?

Rob


 
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
Adding a prefix to a cell by using a formula Audrey in OHIO Excel Discussion (Misc queries) 4 February 24th 05 04:49 PM
Convert excel spreadsheet application to a java or .Net Experience excel to java or .net Excel Discussion (Misc queries) 0 February 23rd 05 06:43 PM
Cannot start the source application for this object Excel General Questions Excel Discussion (Misc queries) 0 February 2nd 05 07:05 PM
Excel application as an ERP platform for medium size production plan Adi Excel Discussion (Misc queries) 2 December 28th 04 03:25 PM
Where can I find a template for application report specifications. James Excel Discussion (Misc queries) 0 December 10th 04 06:19 AM


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

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"