VBA to test if a cell is contained in a specific named column in a named table?

That kind of says it all...

I have a command button that initiates a routine to get the contents of the cell to the active cell's immediate right using offset(0,1). I wish to verify that the cell that it is looking at (The final cell as located by the offset) is in a column named [Number] in a table named tbleMainInput, aka:

Please Login or Register  to view this content.

I want to do this much like getting the address of a cell and seeing if it is in, for instance, column "F" on the worksheet, but instead I rather know if it is in column [Number] of table tblMainInput so if I insert or delete a column before the target column the code will all still run properly.

Thanks for thinking about it and helping me!

Thank-you, folks, very much, and I apologize for I must have described what I was attempting with half the explanation still in my head. Allow me to try to add something else -

I want the code to return a value of "True" if the selected cell is in column [Number] and "False" if it isn't. I should have written that in the first place.

As I also have a section that I need the same return simply if the cell is in the specified table, I suspect it would be dang near the same...

My thanks!

Oooooooooooooooooooooooooooooo! THANK-YOU!