Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default vba code problem

"John Green" skrev i melding
...
Remove the parentheses that are around the argument list in the call to

the subs.
(or you use Call).


My vote goes to "Call", I find that easier to read and maintain (but I know
I'm in the minority):

Sub alterSheet()
Call Hide_Cells (Range("C22:L28"))
End Sub

Sub alterSheet2()
Call Reveal_Cells (3,Range("C21:L28"))
End Sub

Best wishes Harald
Followup to newsgroup only please


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
Problem with code kk Excel Discussion (Misc queries) 0 March 15th 08 03:01 PM
VB Code Problem Stan Excel Discussion (Misc queries) 6 April 25th 07 01:48 AM
XLS to CSV Code Problem carl Excel Worksheet Functions 0 March 28th 07 01:21 AM
Code problem Rick[_11_] Excel Programming 1 August 8th 03 04:25 AM
Code Problem ! Mike R Excel Programming 5 August 5th 03 03:35 PM


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