Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set up macro in Excel to choose active row?
I have an Excel spreadsheet with multiple worksheets. I want to be able to
set up a macro within one of the worksheets that will allow me to do the following: Once I type in a barcode number in a cell (say b3 of worksheet 2) and click on the macro button it will: 1 open another worksheet in the file (worksheet 1) 2 find the number from the active cell (b3 of worksheet 2) 3 highlight the entire row in worksheet 1 where the barcode number was found 4 turn the text in that row green 5 save the worksheet 6 go back to worksheet 2 I don't know any visual basic code. I have in the past used macros to do generic steps, none that required it to find a number and do something with it. My problem is that it does the action only to the row the initial macro was recorded in. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Relative Ranges in excel macro | Excel Discussion (Misc queries) | |||
excel 4.0 macro removal tool | Excel Discussion (Misc queries) | |||
excel 4.0 macro remover tool | Excel Discussion (Misc queries) |