Hi guys,
I've written code that is using an IF statement to look at something in a range and then returning a certain value. This formula is then copied and pasted down for 250 rows. How do I then name this range where the values have been pasted? The code is...
Please Login or Register to view this content.
The range that has been filled in needs to be called REALCCY.
I don't want to name a fixed range as the report (REAL2) will have a different number of columns depending on when I run it.
Many thanks in advance for any assistance.
Dom.
Bookmarks