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: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.Please Login or Register to view this content.
Thanks for thinking about it and helping me!
Bookmarks