Posted to microsoft.public.excel.programming

L. Howard

external usenet poster

Posts: 852

Change_Event target either of two cells

I'm up for the easiest solution here...

Set wksTarget = Sheets(Format(Date(),"mmm")) 'Jan,Feb...

OR

Set wksTarget = Sheets(Format(Date(),"mmmm")) 'full name

..depending on what you prefer.

So if the sheet name is Feb 14 this would work with the space after "mmm "?

Set wksTarget = Sheets(Format(Date, "mmm " & 14)) 'Feb 14

or

Set wksTarget = Sheets(Format(Date, "mmm" & " " & 14)) 'Feb 14

Howard

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Change_Event not responding to change made by formula.	L. Howard	Excel Programming	11	January 18th 14 07:40 PM
Change_Event troubles, no error & no work.	L. Howard	Excel Programming	6	January 15th 14 05:21 PM
No response to change_event	Howard	Excel Programming	4	October 26th 13 11:25 AM
Combobox Change_Event	JimRWR	Excel Programming	10	April 23rd 07 08:58 PM
Change_Event	Hawk	Excel Programming	4	October 16th 03 04:06 PM

All times are GMT +1. The time now is 03:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us