HELP PLS: On Paste - Fire program to delete data below new records pasted

		Microsoft Office Forums > Microsoft Excel > Excel Programming
HELP PLS: On Paste - Fire program to delete data below new records pasted

07-12-2014, 12:09 PM

excelledsoftware excelledsoftware is offline

Windows 7 64bit HELP PLS: On Paste - Fire program to delete data below new records pasted

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fire drop down Macro on change	carlosriver24	Word	1	08-02-2012 07:18 PM
Conditional Formatting over copied and pasted data	kb3264	Excel	6	07-11-2012 07:12 AM
Stop underlining pasted data	LarryStroup	PowerPoint	5	01-11-2012 12:47 PM
why when we copy and paste the "text box" then the pasted doesn't go to where the cur	Jamal NUMAN	Word	1	04-11-2011 03:54 AM
Ungrouping an object pasted from another program	bracker	PowerPoint	0	01-28-2011 11:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:05 AM.