Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a sheet with 5,000 cells (a2:a5000) with numbers, and 5,000
cells(b2:b5000) with numbers, what I want to do is if a2 = b2 print "" and if they are different (else) print the Date, as I cant print 5000 times the folowing formula in VB: If Worksheets("Sheet3").[A11] = Worksheets("Sheet3").[b11] Then Worksheets("Sheet3").[c11] = "" Else Worksheets("Sheet3").[c11] = Date I need an other way to do what I want, Do you have any idea???? regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with formula structure | Excel Discussion (Misc queries) | |||
Please help me... with Case Structure | Excel Worksheet Functions | |||
Wacky Little IF Structure | Excel Discussion (Misc queries) | |||
Tree Structure | Excel Programming | |||
Structure of If...Else in VBA | Excel Programming |