Hi Dev,
Your macro is more complex than necessary.
You don't have to unhide sheets, or select ranges to work on them.
The following 2 lines of code should do what you need.
Sub DoWhatDevNeeds()
Sheets("Dump").Cells.ClearContents
Sheets("Formula").Columns("A:B").ClearContents
End Sub
Hope this helps.
Regards - Dave.
Date: Tue, 21 Jul 2009 11:21:06 +0530
Subject: $$Excel-Macros$$ need help!!!!!
From: b.debapr...@gmail.com
To: excel-macros@googlegroups.com
Hi Guys,
I need a help on attached file.
The test.xls file contain 3 sheets. Rep, Dump1, Formula.But when you open the
file you will find only Rep because other 2 are hidden.
Now i want to write a macro which will do the following.step1
unhide Dump1 sheet & delete all the content
step2
hide Dump1 sheet and go back to Rep sheet
step3unhide Formula sheet and delete the content from A & B column
step4
hide the Formula sheet and go back to Rep sheet
the problem is, the macro which I have written that also deleting the content
of Rep sheet means the 1st sheet, which I dont want. I want dont want any
modification on Rep sheet.
Guys Pleaseeeeeeeeee help me with this...
--
*******sAy ChEeSe*******
(¨`·.·´¨)
`·.¸.·´
'' DeV ''......
_________________________________________________________________
View photos of singles in your area Click Here
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fdating%2Eninemsn%2Ecom%2Eau%2Fsearch%2Fsearch%2Easpx%3Fexec%3Dgo%26tp%3Dq%26gc%3D2%26tr%3D1%26lage%3D18%26uage%3D55%26cl%3D14%26sl%3D0%26dist%3D50%26po%3D1%26do%3D2%26trackingid%3D1046138%26r2s%3D1&_t=773166090&_r=Hotmail_Endtext&_m=EXT
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 5,000 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
