I've built a large macro by recording it step by step. It is currently assigned to "ctrl a." I'd like to add one more piece to it before it runs through the full code. I've pasted the top portion of my macro below. After I press ctrl a I'd like it to check to make sure 2 cells match before it runs through the rest of the code. If they match then I want it to continue. Otherwise, I want it to display a message box if the 2 cells do not match.
For example
If sheets/Template 1 cell CF31 = sheets/Template 1 cell CF32 then run the macro named Import_File. Otherwise, display a box that says "Share totals do not match."
Is this possible?
Here is how my current macro starts.
Sub Import_File()
'
' Import_File Macro
'
' Keyboard Shortcut: Ctrl+a
'
Sheets("Template 1").Select
ActiveWindow.SmallScroll Down:=-15
Range("A1").Select
ActiveWorkbook.Save
Sheets("Import File").Select
Range("A1").Select
'<Lots of code after this>
Thanks,
Steve
Bookmarks