Syntax Question - Referencing a cell in another worksheet with variabl

[KBFINN]

Can anyone help with the syntax of this statement:


If Worksheets("Columns to Verify&quot.Range("&CellToCk&quot = "X" Then

The following statement works fine:

If Worksheets("Columns to Verify&quot.Range("G2&quot = "X" Then

How do I format the statement where I determine the value of CellToCk ?

I have tried all the combinations of Quotes (&quot and concatentation (&) that I can think of.

Thanks in advance for your help.

 

[xlbo]

Depends if cellToCk is defined as range or string. I'm guessing it's defined as string as you are specifying the worksheet:

If Worksheets("Columns to Verify&quot.Range(CellToCk) = "X" Then Rgds
~Geoff~

 

[BrainB]

Range argument is a string. So something like :-

Dim CellToCk As String
CellToCk = "G2"
If Worksheets("Columns to Verify&quot.Range(CellToCk).Value = "X" Then
Regards
BrianB
** Let us know if you get something that works !
================================

 

[KBFINN]

It worked. Thanks.