var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need help
Hi all. I would like to use VBA to check a column of values (Column A) for a value (Papaya) and replace a common value(Fruit) in another column which contains values already at the same row. Thanks.
Turn on the macro recorder and then record yourself performing these steps manually:
Then it's just a case of reviewing the code that the macro recorder has generated and tidying it up a little.
- Select column A
- Replace Tab
- Find What: Papaya Vegetable
- Replace With: Papaya Fruit
- Replace All
Let us know how you get on....