-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
code error
-
VBA Code won't run correctly if sheet hidden
Hi, I have the following module VBA code which saves a report located on a different sheet (sheet80) to a PDF file. I would like to have sheet80 hidden as it's all formulated and the report does not need editing. However, when I run the code on a different sheet, it only works correctly if...- tlc53
- Thread
- code error dim file hidden sheet vba & excel 2010
- Replies: 5
- Forum: Excel Questions
-
A
Macro deleting all my data
<tbody> Hi, I am having trouble with a Macro I created for the purpose of formatting a report. The issue is that when the Macro is executed it eventually deletes everything. The code is the following: Range("B3:B5").Select Selection.Cut Range("A3").Select ActiveSheet.Paste...- Accntgtemp4
- Thread
- code error false macro step into vba & excel
- Replies: 3
- Forum: Excel Questions
-
B
Macro to Clear Data in selected cells
Getting Errors when I run the code below. If i different data in the cells from when I recorded the macro I get errors. Sub Clear_Sheet() ' ' Clear_Sheet Macro ' ' Range("A5:A39,C5:H39,K5:P39,T5:AA39,K1:O1,F1:I1,F2:I2,Z2").Select Range("Z2").Activate ActiveWindow.SmallScroll...- bamaisgreat
- Thread
- activecell.formular1c1 activewindow.smallscroll code error macro selection.clearcontents
- Replies: 5
- Forum: Excel Questions
