| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula or VBA Code
Well, you seem to know that a formula cannot return a format, so that
means you would be seeking a VBA solution, as a formula can't do what you want to achieve. Pete On Apr 18, 11:30*am, jsenglish11 wrote: 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. -- jsenglish11 |
|
#3
|
|||
|
|||
|
Correct but I am not for sure how to create that VBA solution.
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setting excel formula from code | Excel Discussion (Misc queries) | |||
| Exchanging an Excel formula with some VB code | Excel Programming | |||
| VBA code to edit a formula in excel? | Excel Programming | |||
| Excel Formula/VBA Code Help | Excel Programming | |||
| Excel Formula or VBA code help needed | Excel Programming | |||
Linear Mode
