range shift
thank,
But I would like to do it without adding the 1 shift.
is there a way to do range in this range ?
somehow?
"Jacob Skaria" wrote in message
...
Do you mean column number with reference to the table
With Worksheets("Test1")
MsgBox .Range("MyCColumn").Column - .Range("MyTable").Column + 1
End With
If this post helps click Yes
---------------
Jacob Skaria
"greg" wrote:
Hello,
I have a strange question.
I have a sheet. call it test1
I have a range of a table. lets say B4 to G20. named "MyTable"
I have a range in the column C named "myCcolumn"
If I do this
Set TempRange = Worksheets("test1").Range("MyCColumn")
level_number = TempRange.Column
then level_number = 3. because its C
If I loop rows through the table. If I want to read the level_number
column, I will be off.
Because I am getting the column based on the sheet. not based on the
table.
I tried to get the column number like this
Worksheets("test1").range("MyTable").Range("MyCCol umn")
but excel does not like this.
Is there a way to get the column based on the MyTable area?
thank for any help.
|