Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a quick way to compare a block of cells in a row without doing
something like a = activecell.value B= activecell.offset(0,1).value c = activecell.offset(0,2).value Different worksheet. Range(A1).activate if activecell.value = a and activecell.offset(0,1).value = b and activecell.offset(0,2).value = c then 'code end if I ask because I need to compare two worksheets and there's about 8 columns to match and it just seems really cumbersome. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying Blocks of Cells | Excel Discussion (Misc queries) | |||
SUMIFs for particular cells in blocks of data | Excel Worksheet Functions | |||
Stop selecting blocks of cells | New Users to Excel | |||
Transposing blocks of cells | Excel Programming | |||
parsing blocks of cells for charts | Excel Programming |