There's some mistake here — two mistakes, in fact, I believe. First, if you're writing a VBA program (and this is after all the Excel Programming forum), what code are you using to generate that formula? Because we'd want to confirm, to start, that it is in fact generating that address rather than some other. And second, that isn't an indirect address. Or at least, when you said you're using an "indirect formula" I assumed you meant you're using the INDIRECT function to generate an address, and there's no INDIRECT function there.
Maybe you should try describing your problem again. If you're not writing a VBA program, describe it in the other forum, the one labeled merely "Excel". And if you're not sure what you mean by an "indirect formula", feel free to ask questions; maybe we can straighten this out with a little further discussion.
|