-
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.
wsh
-
F
Save sheets named from cells that are in range. [VBA]
Hi pros I have been fighting with this day trying different solutions. I have 40 rows in column C on page 1Date. If the cell matches a sheet name inside this workbook it should save that sheet as external separate workbook as the value in the cell. Currently getting 1004 error, object does not...- fredhedge
- Thread
- dim end false workbook wsh
- Replies: 1
- Forum: Excel Questions
-
A
Excel VBA: Looping through Userform selected Listbox Values to Worksheet Cell
[CODE]Private Sub cmdPrint_Click() ''- ajay_gajree
- Thread
- cell dashboard dim worksheet wsh
- Replies: 3
- Forum: Excel Questions
-
S
split macro to run faster
i have macro for splitting excel sheets depending on column A for all the sheets , i have 20000 rows and 35 sheets to split in a workbook , it take around 1 to 2 hours for splitting, can it be faster Sub SplitData() Dim wbk As Workbook Dim wsh As Worksheet Dim r As Long Dim m...- sachin483
- Thread
- dim r.value sheets wsh wsh.rangea
- Replies: 9
- Forum: Excel Questions
-
L
Seeking help from a VBScript guru
Can someone post code for the following? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Seeking program (script) that would: · Open each Excel file (.xlsb) in a designated folder · Save each · Close each Note: Needs to work even as folder content change...- Legacy 205744
- Thread
- filesystemobject fso gui script wsh
- Replies: 0
- Forum: Excel Questions
