Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Visual to automate formula
I am looking for a way to place a formula in h and I in the corosponding row
if there is data in A. These are my two formulas =A3-WEEKDAY(A3,2)+1 =A3-DAY(A3)+1 So if there is data in A3 the first formula will be placed in H3 and the second in I3. If there is no data in A3 there will be nothing in these cells. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate Formula script | Excel Discussion (Misc queries) | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Automate a formula in excel | Excel Discussion (Misc queries) | |||
automate formula | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |