Find array value 2 positions away from a value in the array

[nigelog]

I need to reference column numbers so columns can be hidden for print setting. The area is controlled by Option Buttons .The function below gives me 2 variables firstly the column numbers of where all option buttons are (stored in myArr) and secondly the column number of the selected option button.

Please Login or Register  to view this content.

Because months are both 5 as well as 4 week I need the printed area to be "Selected Radio Button Column" ie variable shpCol and the corresponding column value which is 2 values back from the shpCol value in the array +1. The Option Buttons are positioned at the right extreme of the month worth of week columns.

I can provide workbook if requested.
any pointers appreciated

[Richard Buttrey]

Hi,

Working out where the option button is positioned seems an odd way of determining which column to hide seems a somewhat long winded way of doing that. I usually use a series of Excel IF functions across all relevant columns to determine whether a column should be hidden, flag the cell accordingly, and then process that range of cells with a macro to hide or unhide the column.

Uploading the workbook would help.

[nigelog]

Hi Richard, when it was restricted in size that was the obvious choice and I could set the ranges in minutes. They want this to roll on. The most likely reference point is either the month text or the button.

[nigelog]

Seems to do the trick

Please Login or Register  to view this content.

[Richard Buttrey]

Hi Richard, when it was restricted in size that was the obvious choice and I could set the ranges in minutes. They want this to roll on. The most likely reference point is either the month text or the button.

Without seeing the workbook I don't really understand the point you're making. However you seem to have a solution anyway.