Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 07-12-2014, 04:00 PM
excelledsoftware excelledsoftware is offline HELP PLS: On Paste - Fire program to delete data below new records pasted 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
excelledsoftware will become famous soon enough
Default

Shila, First off you are very welcome. It helps me learn coding better to help when I can. The finalrow is where the data will never go past. The reason I set this up is because in Excel 2003 (I have not tested it in newer version) when you delete huge sets of data it has a tendency to move the file size up. I had one file that went from 23kb all the way to 23 mbs! This may be just with formatting but I wanted to make sure. You could leave it at 30,000 and watch if the file size goes way up. If it dosnt then kewl. But if it does you have the ability to control it with this variable.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP PLS: On Paste - Fire program to delete data below new records pasted Fire drop down Macro on change carlosriver24 Word 1 08-02-2012 07:18 PM
HELP PLS: On Paste - Fire program to delete data below new records pasted Conditional Formatting over copied and pasted data kb3264 Excel 6 07-11-2012 07:12 AM
HELP PLS: On Paste - Fire program to delete data below new records pasted Stop underlining pasted data LarryStroup PowerPoint 5 01-11-2012 12:47 PM
HELP PLS: On Paste - Fire program to delete data below new records pasted 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 02:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft