-
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.
lastrow1.value
-
Z
Filename.XLSM works but not Personal.xlsb
This is beginning part of a macro that worked fine in a xlsm file. To share the code saved it as a Personal Macro. Problem is it fails at the 3rd line. Line1 worked fine, so sheet is there. Run-time Error 9 subscript out of range error ActiveSheet.Name = "Not Quoted" Dim wsSummary As Worksheet...- Zab Trader
- Thread
- dim file lastrow1.value newfn set
- Replies: 3
- Forum: Excel Questions
-
Z
Use File Obtained From GetOpenFileName
Just added the top part of code to select file instead of having it hard coded. How do I go about adjusting the 2nd part so I can use it instead of the hard coded file. ChDrive "c:" NewFN = Application.GetOpenFilename(FileFilter:="Excel Files (*.xlsx), *.xlsx", Title:="Please select a file") If...- Zab Trader
- Thread
- dim file lastrow1.value set sfilename
- Replies: 1
- Forum: Excel Questions
-
P
Using Listbox selection to name worksheet
Hi All I'm hoping this is simple. I have a userform that I want to copy data from to two worksheets. The first worksheet if fixes, the second worksheet is chosen from a userform list box selection. The listbox is populated with the names of the worksheets automatically so I know the sheet...- paulsolar
- Thread
- lastrow.value lastrow1.value textbox3.text worksheet ws.rangea
- Replies: 1
- Forum: Excel Questions
