Does not transfer the words on storage and printing

NoSparks · #1 08-07-2017, 06:58 AM

Both require knowing what cell(s) you've used the =TextNumber(...) formula in.

#1-- store the value of those cells in variables before copying the sheet to the new workbook then write those values to the same cells in the new workbook before saving. Try something along the lines of this in your original macro

Code:

Sub SaveInvWithNewName()

    Dim NewFN
    Dim variable1
    
With ActiveSheet
    variable1 = .Range("G40").Value
    .Copy
End With

'the newly created sheet automatically becomes the active sheet

With ActiveSheet
    .Range("G40").Value = variable1
End With

'
' rest of your code here
'
End Sub

#2-- much more complex

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Self Created OneNote page drops words when printing	AR_RonK	OneNote	4	03-14-2018 08:12 AM
Printing AutoCorrect words list.	TDeVore	Word	1	01-18-2017 09:06 PM
Spaces between words when printing	Captain	Word	2	06-24-2016 09:10 AM
Outlook Storage	dpslusser	Outlook	1	08-23-2012 11:48 AM
email storage by job	sgk18	Outlook	0	03-26-2012 06:23 PM