I'm having trouble getting this formula to work.

=IRR(INDIRECT(("B26:"&D12&"26"&",BS26")),0.01)

Cell D12 contains the column letter that changes based on a user inputted
hold period. The actual formula =IRR((B26:V26,BS26),0.01) works fine which is
the same forumla that shows when stepping through the function using the
error check.

Any help appreciated.