VBA code for comparing a range of cells

[Zimmerman]

I'm new to the VBA programming so does anaybody know to write a VBA code for a sheet ion a workbook that will compare a range od cells. I need to compare cells R59:R88 to cells BV59:BV88 and if the cells R59:R88 are a higher value than the BV59:BV88 then i want to display a warning message saying they do not have enough inventory.

The cells R59:R88 are the result of a sum of L59:Q59 and on down. The user will manually enter in these cells.

The cells BV59:BV88 are also a result of a sum of BP59:BU59 and on down again. The user will also manually enter data in these cells.

Windows XP
Excel 2003
Thanks

[Zimmerman]

How can you assaign a range and assign the range a value in VBA?

I have a range of R59 to R88 that i want to assign the value of each cell to then compare them with the range BV59 to BV88.

[davesexcel]

Obviously more detail is required.

Please Login or Register  to view this content.

[Zimmerman]

Well each cell will have a value in it that the user puts in, but i want to comapre the value in each cell to the value in the range of cells BV59:BV88. Which is also entered in manually by the user.

[davesexcel]

This code will compare the two cells

Please Login or Register  to view this content.