If "P*" = activesheet("A:" & k) Then 1

[jhogie]

I am really tired and just can't figure this out

I am trying to do the following If statement, where k is a integer. I want the If statment to proceed if the contents of cell A:k start with a 'P'.


If "P*" = activesheet("A:" & k) Then

Thanks in advance for the help

- Hogie

 

[SkipVought]

Hi,

Begins with or ends with is easy, using either the Left or Right function...

If Left(activesheet.Range("A:" & k),1) = "P" Then

or...

If activesheet.Range("A:" & k) Like "P*" Then

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

I'd replace this:
Range("A:" & k)
with this:
Range("A" & k)

 

[jhogie]

Thanks guys! Once again, Tek-tips comes to the rescue!

- Hogie