LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default Excel Formula or VBA Code

Ok so I am trying to figure out a code or formula that will copy certain cells from lets say Sheet 1 to Sheet Test and there are 31 Sheets one for each day of the month. But I want the value of the cell as will as the formatting of it. I can make up the formula to copy the value but i know there isnt a way to have a formula for the formatting. Also there will be one cell I change the number in which would be the day in it and it automatically changes the information.
 
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
setting excel formula from code Ralf Excel Discussion (Misc queries) 4 July 14th 09 10:31 PM
Exchanging an Excel formula with some VB code hshayh0rn Excel Programming 3 April 10th 06 06:59 PM
VBA code to edit a formula in excel? [email protected] Excel Programming 5 October 17th 05 05:41 AM
Excel Formula/VBA Code Help Tom Ogilvy Excel Programming 0 September 13th 03 02:50 PM
Excel Formula or VBA code help needed bruce taylor[_3_] Excel Programming 1 September 11th 03 02:34 PM


All times are GMT +1. The time now is 10:15 AM.

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

About Us

"It's about Microsoft Excel"