Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone tell how or what i need to do with this code so that it will
start in Column B and compare with Column C and do this until the last row in column B Right now the code only compare's B5 with C5 and i need it to compare B6 with C6, B7 with C7 and so on till the last row in column B Thanks for any help! Option Explicit Sub priceComparison() Const priceCompSheetName = "Price Comparison" Const ourPriceCol = "B" Const alltelPriceCol = "C" Dim pcWS As Worksheet Set pcWS = Worksheets(priceCompSheetName) If pcWS.Range(ourPriceCol & "5").Value _ < pcWS.Range(alltelPriceCol & "5").Value Then pcWS.Range(ourPriceCol & "5").Value _ = pcWS.Range(alltelPriceCol & "5").Value End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
(Complex) Loop within loop to create worksheets | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming |