Solved: rules form a sheet

C

cdkeito

Board Regular
Joined
Aug 26, 2005
Messages
95
Hi all

a little question for you:

Can a macro use a rule (a=0 and b<3 or c+5 = d) writen in the sheet?

I think it must be something like eval(CStr(rule)).

Grrraaaaaaaaaaaaaaazie!
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
Hi

I'm assuming that a,b and d are defined names. c will have to be something else as it is reserved (cc perhaps). Also you will have to change the "rule" to be in excel format so if

A6: OR(AND(a=0,b<3),cc+5 = d)

Code: 
rule = range("a6")
msgbox evaluate(rule)

HTH

Tony
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Solved
Copying Conditional Formatting with relative values
Replies
9
Views
480
weeksy
W
S
  • Question
RAG rating with percentages
Replies
7
Views
260
etaf
etaf
K
  • Question
Conditional Formating - Dynamic "not between"
Replies
3
Views
236
dreid1011
dreid1011
S
  • Question
Conditional Formatting - How to Properly Copy + Paste without Duplicating Rules
Replies
1
Views
1K
6StringJazzer
6StringJazzer
L
  • Solved
Conditional Formatting Date Ranges
2
Replies
13
Views
620
Joe4
Joe4

Forum statistics

Threads
1,214,422
Messages
6,119,396
Members
448,891
Latest member
tpierce

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top