Colmembername(IAQ_OHSUM,0,54)

Resolved · High Priority · Version 2003

Fri 23 Oct 2009, 14:37 Delegate Linda said...

Linda has attended:
Excel Advanced course
PowerPoint Introduction course

Colmembername(IAQ_OHSUM,0,54)

The above formula is in a spreadsheet I have inherited.
Please can you explain what it is doing.

Fri 23 Oct 2009, 14:52 Trainer Amanda said...

RE: Colmembername(IAQ_OHSUM,0,54)

Hello Linda

Thank you for your question and welcome to the forum.

This is not a standard Excel function, nor does it appear to be a function that would be available if you installed any of the Excel Add-ins. It is most likely that it is a bespoke function which has been written using VBA code, in which case we unfortunately cannot shed any light on what it does - sorry.

Kind regards
Amanda

Fri 30 Oct 2009: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips