Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing formula to a particular Count
How do i set this formula so that rng2 only prints as many fields as
the count of rng1? Set rng1 = Sheets("Imported Budget Data").Range("A2:BX2") For Each cell In rng1 If cell.Value 0 Then Count = Count + 1 End If Next cell Set rng2 = Sheets("SandBox").Range("B6:B100") rng2.Formula = "=IF(Home!$B$5='Imported Budget Data'!BX2,'Imported Budget Data'!S2,)" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing formula to a particular Count
What exactly do you mean by print, formulae don't print.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ups.com... How do i set this formula so that rng2 only prints as many fields as the count of rng1? Set rng1 = Sheets("Imported Budget Data").Range("A2:BX2") For Each cell In rng1 If cell.Value 0 Then Count = Count + 1 End If Next cell Set rng2 = Sheets("SandBox").Range("B6:B100") rng2.Formula = "=IF(Home!$B$5='Imported Budget Data'!BX2,'Imported Budget Data'!S2,)" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing formula to a particular Count
By print I mean that the formula is written into cells B6:B100 but i
want the formula to be written in to only as many cells as that where counted in rng1. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing formula to a particular Count
OK, does this do it
Set rng1 = Sheets("Imported Budget Data").Range("A2:BX2") For Each cell In rng1 If cell.Value 0 Then Count = Count + 1 End If Next cell Set rng2 = Sheets("SandBox").Range("B6:B" & Count + 6) rng2.Formula = "=IF(Home!$B$5='Imported Budget Data'!BX2,'Imported Budget Data'!S2,)" BTW, best to avoid variable names like Count, it is a property of collections so may confuse or even fail in worst cases. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message oups.com... By print I mean that the formula is written into cells B6:B100 but i want the formula to be written in to only as many cells as that where counted in rng1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Formula - Count Ticks | Excel Discussion (Misc queries) | |||
Printing: page count exceeds pages in tab | Excel Discussion (Misc queries) | |||
Trying to construct a count count formula | Excel Discussion (Misc queries) | |||
Need Help on Formula For Printing | Excel Programming | |||
Printing a formula | Excel Worksheet Functions |