Posted to microsoft.public.excel.programming

[email protected] hamad.fatima@gmail.com is offline

external usenet poster

Posts: 19

Delete the contents of columns if the month changes

I have a reference cell A1= current month like ( jan, feb , mar etc)
I have 12 columns JAN- Dec
if A1= FEB, i want a macro to delete the contents in JAN and FEB
columns and hide them .
if A1= MAR , then hide JAN & FEB & MAR and delete the contents in them
.. And so on.

Please help me write this macro.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
keep formula delete contents	carspjcars	Excel Worksheet Functions	4	May 4th 10 04:46 PM
Delete the contents of columns if the month changes	[email protected]	Excel Programming	0	August 22nd 06 04:44 PM
Delete contents of cells	mikespeck	Excel Worksheet Functions	3	July 27th 06 03:16 PM
Delete Contents of Cells	ir26121973	Excel Programming	9	April 5th 06 07:10 PM
How to Delete Contents of D2 if B2 = "SD"	StarBoy2000	New Users to Excel	5	July 21st 05 06:46 PM

All times are GMT +1. The time now is 08:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us