Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro ignore formulas
Hi, is there any way this macro ignore formulas?
In column "I" i have this formula that retrieve numbers. (=IF(G2<"",H2*G2,"")). If there are no numbers to retrieve, then the formula doesn't display anything. But the macro keep seeing the formula. The formula goes till row 50, and because of that, the macro is selecting the cell in row 50. I need this macro to see only the results of formula. Macro: Columns("I:I").Select Range("I1").End(xlDown).Select ActiveCell.Offset(1, 0).Select Can this be done? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro ignore formulas
If column G is what's important, why not have the macro look there?
Range("G1").End(xlDown).Select 'Offset 2 columns now to make up difference ActiveCell.Offset(1, 2).Select -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "puiuluipui" wrote: Hi, is there any way this macro ignore formulas? In column "I" i have this formula that retrieve numbers. (=IF(G2<"",H2*G2,"")). If there are no numbers to retrieve, then the formula doesn't display anything. But the macro keep seeing the formula. The formula goes till row 50, and because of that, the macro is selecting the cell in row 50. I need this macro to see only the results of formula. Macro: Columns("I:I").Select Range("I1").End(xlDown).Select ActiveCell.Offset(1, 0).Select Can this be done? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro ignore formulas
try like this
If Not ActiveCell.HasFormula Then code goes here ........ On Oct 20, 12:46*am, puiuluipui wrote: Hi, is there any way this macro ignore formulas? In column "I" i have this formula that retrieve numbers. (=IF(G2<"",H2*G2,"")). If there are no numbers to retrieve, then the formula doesn't display anything. But the macro keep seeing the formula. The formula goes till row 50, and because of that, the macro is selecting the cell in row 50. I need this macro to see only the results of formula. Macro: * * *Columns("I:I").Select Range("I1").End(xlDown).Select * * * *ActiveCell.Offset(1, 0).Select Can this be done? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro ignore formulas
This was really good. I hope you can help me with the other tread.
Thanks! "Luke M" wrote: If column G is what's important, why not have the macro look there? Range("G1").End(xlDown).Select 'Offset 2 columns now to make up difference ActiveCell.Offset(1, 2).Select -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "puiuluipui" wrote: Hi, is there any way this macro ignore formulas? In column "I" i have this formula that retrieve numbers. (=IF(G2<"",H2*G2,"")). If there are no numbers to retrieve, then the formula doesn't display anything. But the macro keep seeing the formula. The formula goes till row 50, and because of that, the macro is selecting the cell in row 50. I need this macro to see only the results of formula. Macro: Columns("I:I").Select Range("I1").End(xlDown).Select ActiveCell.Offset(1, 0).Select Can this be done? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting formulas to ignore text | Excel Discussion (Misc queries) | |||
ignore formulas in dynamic range | Excel Discussion (Misc queries) | |||
how do i get excel to ignore a value when using formulas | Excel Discussion (Misc queries) | |||
how do I get excel to ignore blank cells in formulas | Excel Worksheet Functions | |||
how do you ignore blank cells in formulas | Excel Discussion (Misc queries) |