Jan 26, 2015
5:35:22pm
5:35:22pm
How about changing the order?
This may not be the exact code to run. But how about changing the order of operation to be more like the below?
- add code to save the activeworkbook here first
Set wbNew = ActiveWorkbook
wbNew.SaveAs "C:\Users\dholmoe\desktop"
Worksheets("Input").Copy
With ActiveSheet.UsedRange
.Value = .Value
End With
wbNew.Close True
- add code to save the activeworkbook here first
Set wbNew = ActiveWorkbook
wbNew.SaveAs "C:\Users\dholmoe\desktop"
Worksheets("Input").Copy
With ActiveSheet.UsedRange
.Value = .Value
End With
wbNew.Close True
Originally posted on Jan 26, 2015 at 5:35:22pm
Message modified by Cougar8Duck on Jan 26, 2015 at 5:36:20pm
- New username
- Mr Salad
- Bio page
- Cougar8Duck
- Joined
- Jul 2, 2010
- Last login
- Oct 28, 2023
- Total posts
- 0 (0 FO)
