Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 119
Default Weird Macro Happenings

Check under tools-options editor tab require variable declaration

I would bet that it is checked on the coworker's pc and not on yours. I
personally always dim everything.

Peter Richardson

"Tsunami3169" wrote:

Thanks for the help. I did move the comma and still received the same
error on my coworkers pc.
But without moving the comma and adding Dim wee1 As String my coworker
was able to get the wee1 msgbox to work. But on my pc I don't need the
dim statement.


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
strange happenings with move/copy worksheet Don Excel Worksheet Functions 1 May 3rd 08 07:26 PM
weird macro SteveDB1 Excel Programming 16 September 5th 07 02:36 AM
Wierd VBA happenings... LT Excel Discussion (Misc queries) 4 March 15th 07 02:10 PM
Strange Happenings Alan Excel Discussion (Misc queries) 7 June 20th 06 08:15 PM
Macro is weird! toolroomman Excel Programming 4 August 29th 05 09:49 PM


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