-
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.
sheetcount
-
S
[VBA] Unable to sort tabs of selected sheets
Sub SortSelectedWorksheets() '--------------------- MTxt = MsgBox("- Sort Selected Worksheet(s) -" & vbNewLine & "---------------------" & vbNewLine & _ "Yes : Ascendingly" & vbNewLine & _ "No : Descendingly", vbYesNoCancel) '--------------------- SheetCount =...- smallxyz
- Thread
- case end sheetcount sort vbnewline
- Replies: 3
- Forum: Excel Questions
-
L
Runtime Error 1004 copy method of Worksheet class failed
Hey everyone! I have a workbook that keeps throwing the title error when attempting to copy a worksheet from one workbook to another. This error is so common that, in order to make sure I got it right in the thread title, I used Google's autocomplete. But whenever I look it up, the...- Legacy 433589
- Thread
- copy error mention sheetcount workbook
- Replies: 1
- Forum: Excel Questions
-
S
Insert 2 columns from 1 sheet to another using VBA
This is the code i have worked with. It is showing the error 1004 that the copy area and paste area are not in the same size. Please help me with the issue? Sheets("ESTemplate").Activate Sheets("ESTemplate").Columns("A:B").Select Selection.Copy Sheets("Effort_Summary").Activate For j = 2 To...- Sukanya
- Thread
- area excel macro to copy paste excel macro vba sheetcount sheets.count
- Replies: 3
- Forum: Excel Questions
