I'm trying to use a macro to determine the length of a specific range of cells in a different worksheet and have it display only if the value is greater than 10.
I used the following:
Sheets("Raw").Range("F" & LastWorked + 1 & ":F" & LastRow).FormulaR1C1 = _
This basically goes into the 'Raw' worksheet, sets the range of cells ranging from say F12-F20 and add the following formula to it.
For some reason, this seems to return an error message..
When I enter it directly into the Cell myself, =IF(LEN(FlashReport!H78)<10,FlashReport!H78,"")
it seems to work.. is the macro formula i'm trying to use different somehow that it won't take the column and cell value properly and translate? I've used a similar one to fill the range of cells with a different formula, "=IF(ISBLANK('FlashReport'!RC),"""",'FlashReport'!RC)" to return the value if it's not blank, but my LEN one doesn't seem to want to work..
If anyone has any insight on what I'm doing wrong, it'd be appreciated.