| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter Formula via VBA
Greetings
I have a file that is imported daily and it varies as to the number of lines in the file each day. Using a macro I woud like find the next available row and enter the following formula in ColH:ColAE (24 Cols) =SUMPRODUCT(--($F$3:$F$66="Cat"),--($G$3:$G$66="Bird"),-- ($C$3:$C$66<"Black"),--($C$3:$C$66<"White"),H3:H66) The example file had 66 rows of data and this is the part that could change each day. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| When I enter a formula it shows the formula not the result | Excel Discussion (Misc queries) | |||
| can you wrap formula results via a formula eg. Alt Enter | Excel Discussion (Misc queries) | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| Cannot enter formula in a cell after removing a circular formula | Excel Worksheet Functions | |||
Threaded Mode
