Autosave Code Problem

[excellearnerz]

Good day,

I scrounged up a code I dont fully understand, but it seems to work. The goal of the code is that when there are any changes in the cell range I defined, the spreadsheet will autosave/export as a pdf file. However, I want that when another set of changes are submitted to the spreadsheet, it will save again with a sequential file name, and not overwrite the old save.

Here is the code:

Private Sub Worksheet_Change(ByVal Target As Range)
'Step 1: Does the changed range intersect?
If Intersect(Target, Range("A1:AT55")) Is Nothing Then
'Step 2: If there is no intersection, exit procedure
Exit Sub
'Step 3: If there is an intersection, save the workbook
Else
Sheet4.ExportAsFixedFormat xlTypePDF, "C:\Users\Office-PC\Desktop\Destiny\INRToday.pdf"
'Step 4: Close out the If statement
End If
End Sub

Any help will be greatly appreciated.

 

[excellearnerz]

yes but there was a range that was set through dim

 

[Joe4]

yes but there was a range that was set through dim

That does not make it work like the Worksheet_Change event procedure does. In the Worksheet_Change procedure, the Target is the range of cells that were just changed to trigger the code to run. That is inherent to how Worksheet_Change works, the user/programmer does not affect it.

There is no way to make Worksheet_Calculate behave the same way. It simply runs whenever there is re-calculation done anywhere on the sheet. It does not tell you what cell changed.
All that declaring Target with a Dim statement does is create a new range variable like any other user declared range variable. Naming it "Target" will NOT make it work the way "Target" does in a Worksheet_Change event procedure.

 

[excellearnerz]

so it means this program is now useless, okay ill delete it then

 

[excellearnerz]

leaving this here if anyone has an idea...

 

[mole999]

@excellearnerz it is never a good idea to name a range with a keyword from excel so creating Target can create even more problems

 

[excellearnerz]

sir, I am just frankensteining this code, I know little to nothing about coding. pls..