Hi.
Hope someone can help me with a problem?
I would like to write a VBA print button which selects all entered data from Column A1 to ED (Static), and the last Row with "1" in Column ED (the last row starts at ED15, and goes all the way down to ED515, and depending on the number of items I'm pricing for, can either be A1 to ED15, or A1 to ED515)
At present in ED I've got a formula which is =IF(ISTEXT(A15),1,0)), but when I use xlUp, it selects the last row with the formula, not the "1", or "0".
Is it possible to use VBA to "ignore" the formula, or instead of 1, can I use " "?
I'm sure the answer is simple, but I'm not an expert in VBA.
Thanks!
Bookmarks