Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use a range name in VB with IF Then Else statement
Thanks for looking at this one..... when writing a macro in visual basic, how would you write code to do something like this: IF "Named Range 1" is not equal to "Named Range 2" THEN (do a simple cut/copy/paste which I've allready figured out) ELSE END IF I can do this with range as cell address ("A2") but don,t know how to reference the Named Range. Thanks.... Spydor -- spydor ------------------------------------------------------------------------ spydor's Profile: http://www.excelforum.com/member.php...o&userid=28438 View this thread: http://www.excelforum.com/showthread...hreadid=498554 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use a range name in VB with IF Then Else statement
I like something like:
if worksheets("sheet1").range("NamedRange1").value _ = worksheets("sheet2").range("NamedRange2").value then 'do nothing else worksheets("sheet1").range("namedrange1").value _ = worksheets("sheet2").range("namedrange2").value end if This actually just assigns the value from namedrange2 to namedrange1. === But I think I'd just set the values equal and get rid of the check, well, if the situation fit. spydor wrote: Thanks for looking at this one..... when writing a macro in visual basic, how would you write code to do something like this: IF "Named Range 1" is not equal to "Named Range 2" THEN (do a simple cut/copy/paste which I've allready figured out) ELSE END IF I can do this with range as cell address ("A2") but don,t know how to reference the Named Range. Thanks.... Spydor -- spydor ------------------------------------------------------------------------ spydor's Profile: http://www.excelforum.com/member.php...o&userid=28438 View this thread: http://www.excelforum.com/showthread...hreadid=498554 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel |