Hey Guys, back again.
I have what I know is very simple but for some reason I am just drawing a blank today.
Basically I am tryiing to select a column range in a table based on the value of a cell in another sheet.
So I am trying to replace the value of "Replace-Me" in the code below to get the value of sheet OHR cell F2.
in other words if sheet OHR cell F2 value is miscellaneaus1 then the code would get that value as the table column to select
Thanks in advance, this is my favorite message board and yall are always so awesome.
I have what I know is very simple but for some reason I am just drawing a blank today.
Basically I am tryiing to select a column range in a table based on the value of a cell in another sheet.
So I am trying to replace the value of "Replace-Me" in the code below to get the value of sheet OHR cell F2.
VBA Code:
Range("BaseTable[REPLACE-ME]").Select
in other words if sheet OHR cell F2 value is miscellaneaus1 then the code would get that value as the table column to select
Thanks in advance, this is my favorite message board and yall are always so awesome.