Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Copy a workbook with all sheets except formulas???
The problem was solved by putting "Application.Calculation = xlCalculationManual" as the very first line of code and the corresponding for setting back to automatic as the very last line of code. It was waiting for values to load and this apparently copied the not-yet filled cells. cheers and...- MrBullitt
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copy a workbook with all sheets except formulas???
The issue has been resolved. Thanks to all inputs I got here!- MrBullitt
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copy a workbook with all sheets except formulas???
Combo: yes every cell which was supposed to have a number in it just displays #VALUE! formats, formatting, background colour have been copied. this is last piece of the puzzle...- MrBullitt
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copy a workbook with all sheets except formulas???
Thanks for the input. It does copy and create and new workbook - however - the values are missing and the cells just show #VALUE! - what went wrong here? :-(- MrBullitt
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copy a workbook with all sheets except formulas???
Hi guys! I am trying to make my very first Excel macro and I have hit a snag. My background is Java, and this my first venture into anything VB or VB like... I have a workbook with multiple sheets. I need to copy it all to a new workbook with exception of the excel formulas - just the values...- MrBullitt
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
