Macro causes a cell with a vlookup to delete vlookup and replace with a named cell

Hi All,

I created a tool with a save reports option. The SAVE DISTRICT choice goes through schools in a district (hidden in columns N-S) and unfortunately creates a minor problem....

I would like to ask a troubleshooting question with the macro… I will message the file to you if you message me.

You will notice on both tabs that I have added a “Print District” option. It works, but upon saving a district’s files, it deletes the formula in C3 and reverts the school name to the top selected school.

Can you assist in fixing this macro text?
Thanks,
Jonathan


MACRO

Please Login or Register  to view this content.

Problem again is that upon completing the printing, it replaces my vlookup with the FirstSchoolD value.

You can see the last line of code does exactly what you don't want:

Please Login or Register  to view this content.

So, take that out?

I didn't point to the NEXT R line of code to be removed, only the line above it. In your post #1 I highlighted just that one line as well, that's the only part to take out, nothing above or below that line, just that line.