Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Leon Hansen   on Dec 14 In MS Office Category.

  
Question Answered By: Ella Brown   on Dec 14

Your Option Explicit should be the very first line of the module. It can't
go inside a subroutine or function. However, none of that code  should have
been put  inside a subroutine or function, so I suspect your copy/paste
missed.

Consider Option Explicit as absolutely essential for VBA development -
particularly if you plan to ask questions on Excel groups - it reduces the
possibility of typos causing obscure problems.

Looks as though "y" was defined but never used.

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Simple Macro to Format All Sheets in a Workbook? Or get search suggestion and latest updates.


Tagged: