ami3
06-06-2008, 07:19 AM
Hi,
Please write a macro seeing the attached excel sheet,i want to find for what value in BE column could equate the corresponding values in both BB Column and AX column.
i.e for what value in BE,
BB=AX
i tried to write a macro like below:
Sub guess()
Dim BE As ListColumns
Dim AXAs ListColumns
Dim BBAs ListColumns
For Each ep In d1
Set adj = d1
Next
End Sub
but it didnot work.It will be highly appriciated for writing a macro for this case.Thanks
Please write a macro seeing the attached excel sheet,i want to find for what value in BE column could equate the corresponding values in both BB Column and AX column.
i.e for what value in BE,
BB=AX
i tried to write a macro like below:
Sub guess()
Dim BE As ListColumns
Dim AXAs ListColumns
Dim BBAs ListColumns
For Each ep In d1
Set adj = d1
Next
End Sub
but it didnot work.It will be highly appriciated for writing a macro for this case.Thanks