ActiveCell = " < "

  • Thread starter Thread starter Ctech
  • Start date Start date
C

Ctech

Hi

Im trying to make a macro that if ActiveCell = "<"

How can I make the macro take all cells that contains the sign < :

so <5454> and Cake< will two examples:


how can I do this?
 
If you use a InStr comparison function you can resolve if the < is in there.

InStr(ActiveSheet.Cells(RowLocation, ColLocation).Text, "<")

Look in the help files to see what kind of returns you get, but you should
be able to evaluate it for existence of "<" from there.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ActiveCell on inactive sheet 8
Excel Applying Code to a Column 0
Establish if Offset RANGE contains text 11
vba dynamic 1
Compile Error: Expected:( 2
VBA code for for telnet 1
Populating a range of empty cells with usernames 4
copy the value of the activecell on sheet1 to the same address on sheet 2 2

Back
Top