LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default Trouble with Sheet programming

One way would be to use SaveAs and save the file with a new name
whenever you want to start fresh, then just clear any existing data so
the formatting remains intact. With VBA, this could be automated!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble with Code to change sheet name JOUIOUI Excel Programming 3 July 6th 06 04:15 PM
Have payroll sheet and having trouble subtracting 1AM from 5PM Tammy Excel Worksheet Functions 1 June 3rd 06 02:17 AM
Time Sheet for my org Im still having trouble Jesse_Norris Excel Discussion (Misc queries) 4 July 30th 05 06:28 AM
Trouble Programming from DotNet Against Multiple Excel Versions Michael Kellogg Excel Programming 8 January 25th 05 07:15 PM
I have trouble in the hidden sheet range kvenku[_22_] Excel Programming 3 June 23rd 04 05:24 AM


All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"