Microsoft Office Forums - View Single Post - [Solved] HELP PLS: On Paste - Fire program to delete data below new records pasted

Thread: [Solved] HELP PLS: On Paste - Fire program to delete data below new records pasted

View Single Post

Old

07-12-2014, 12:09 PM

excelledsoftware excelledsoftware is offline

excelledsoftware is offline

excelledsoftware uses Windows 7 64bit

Windows 7 64bit excelledsoftware uses Office 2003

excelledsoftware uses Office 2003

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

Default

Hi Shila this can be easily done by adding the following right above the line that says ActiveSheet.paste

Code:

Range("A1").select

If you prefer the msgbox that can be done as well but probably isn't necessary.

Reply With Quote