Search : in
By :

VB codes for excel

Last answer on Jul 3, 2009 2:06:29 pm BST Lewis.kelly, on Jul 3, 2009 8:05:49 am BST 
 Report this message to moderators

Hello,
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.

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « VB codes for excel » in :
Filter unique records using some value Show
Excel vb find blank cells replace with calc (Solved) Show
Connect a database (MDB) to excel Show [VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window¯ and select Freeze panes¯.
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Know the Hexadecimal code of a color ShowKnow the Hexadecimal code of a color What is a Hexadecimal code What is a Hexadecimal code In mathematical terms, a hexadecimal (hex) is a numeral system consisting of a base, of 16. It uses sixteen distinct symbols: Numeric symbols:...
Binary encoding ShowIntroduction to binary In the late 1930s, Claude Shannon showed that by using switches which were closed for "true" and open for "false," it was possible to carry out logical operations by assigning the number 1 to "true" and 0 for "false." This...
Lists in HTML ShowLists A list is a structured paragraph containing a series of items. HTML defines three types of lists: Ordered lists; Unordered lists; Definition lists. Ordered Lists Container Type of List Visual Effect item...
Ask your question Reply

1

 Trowa, on Jul 3, 2009 2:06:29 pm BST

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,
Trowa

   
Reply to Trowa
Ask your question Reply
They need your help