how to run a macro only if a cell contains a certain value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written a macro to divide a large spreadsheet into 5 smaller ones based on single character in one of the columns. One of the letters only appears on every other report which causes the macro to crash if it doesn't find the letter.
Is there any way to have Macro5 run only if the letter K is found in a cell in a specified column? I have tried and tried but cannot figure out how to get the macro to read a character in the cell - only a number.

Any help would be greatly appreciated!!!!!
 
Testing a letter is simple, something like

If Range("A1").Value = "K" Then
...

What code are you trying?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

KJ said:
I have written a macro to divide a large spreadsheet into 5 smaller ones
Click to expand...
based on single character in one of the columns. One of the letters only
appears on every other report which causes the macro to crash if it doesn't
find the letter.
Is there any way to have Macro5 run only if the letter K is found in a
Click to expand...
cell in a specified column? I have tried and tried but cannot figure out
how to get the macro to read a character in the cell - only a number.
 
One way

Place this code at the start of the Macro


Sub MyMacro()
'dim Statements

If LCase(Range("a1").Value) <> "K" Then
Exit Sub
End If

'your code here

End Sub
 
mudraker said:
One way

Place this code at the start of the Macro


Sub MyMacro()
'dim Statements

If LCase(Range("a1").Value) <> "K" Then
Exit Sub
End If

'your code here

End Sub
Click to expand...

Shouldn't it be UCase instead of LCase? otherwise the macro never continues.

Regards,
 
Back
Top