| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code
Hello from Steved
Column G1 The Month Of Column G2 ='Summary Report'!F3 in VBA please how do I have the above please The reason is I screen dump a new file and then I have to Type G1 and G2 everytime. Thankyou. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Code
Range("G1").Value = "The Month Of"
Range("G2").Formula = "='Summary Report'!F3" -- Steve "Steved" wrote in message ... Hello from Steved Column G1 The Month Of Column G2 ='Summary Report'!F3 in VBA please how do I have the above please The reason is I screen dump a new file and then I have to Type G1 and G2 everytime. Thankyou. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Code
Hello AltaEgo
Thankyou Steved "AltaEgo" wrote: Range("G1").Value = "The Month Of" Range("G2").Formula = "='Summary Report'!F3" -- Steve "Steved" wrote in message ... Hello from Steved Column G1 The Month Of Column G2 ='Summary Report'!F3 in VBA please how do I have the above please The reason is I screen dump a new file and then I have to Type G1 and G2 everytime. Thankyou. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Code
My pleasure. Thank you for the feedback.
-- Steve "Steved" wrote in message ... Hello AltaEgo Thankyou Steved "AltaEgo" wrote: Range("G1").Value = "The Month Of" Range("G2").Formula = "='Summary Report'!F3" -- Steve "Steved" wrote in message ... Hello from Steved Column G1 The Month Of Column G2 ='Summary Report'!F3 in VBA please how do I have the above please The reason is I screen dump a new file and then I have to Type G1 and G2 everytime. Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? | Excel Programming | |||
| Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
| Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
| Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
Linear Mode
