VB codes for excel

 Trowa -
I'm trying to write a Macro that will search an excel spread sheet and display the adjacent cells. I have a series of increasing but not sequential numbers in column C and I want the macro to compare the input and find the first value that it is less than. Once it has found this value I then want it to display the numbers in Colum A and B in the same row.
I've tried a number of things but I’m not really getting anywhere
Any help would be greatly appreciated.

1 reply

Hi Lewis Kelly,

Can you give some examples of the data you have for colmumn A, B and C (nothing personal off course)?

This to help me get a better insight to your issue.

Best regards,