Marking columns/rows

Usually when I try to mark a row/column for future reference I code the following:

Please Login or Register  to view this content.

So in the code, strow and stcol are row and col markers respectively.
However, I now have to do this for 45 columns, therefore my way is far too intensive, is there an easier way to do this for a large no of cols. Thanks in advance.

so if I have one cell in a sheet called 'TBASIC Amount'
and I need to mark the column, can I use

Please Login or Register  to view this content.

This doesnt seem to work

Thanks,

I'll elaborate on my scenario, say I have raw data of 45 cols, with col names:

GBTAX
GBERP
GBPPP

etc.etc.

and I need to name these columns via a macro which I run, how do I code?

So inthe code below Im passing an array through a FIND statement and for each variable Im trying to create diff row & col names, not quite working, thank you in advance for any suggestions

Please Login or Register  to view this content.

Hi,

Im trying to create a number of variables:
GBTAXRow, GBTAXcol, GBERPRow, GBERPcol, GBPPPRow, GBPPPCol

The asterixed lines below are not working, thank you in advance,

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks for this Bob,

The attached should make things clear.

I want the code to return the variables (relating to the row and col numbers, see attached)

GBTAXrow = 4
GBTAXcol = 3
GBERProw = 4
GBERPcol = 4
GBPPProw = 4
GBPPPcol = 5

I can then refer to these variables later.
There will actually be 45 values within the array and could be positioned differently which is why I require this code.

Thank you in advance.

Okay, acknowledged, and many thanks for your help on this