Loop Column, write to another

**kerl** · 06-20-2007, 12:01 PM

I need to loop through a column (lets say column D), check the cell value

- if the value is > 0, I need to put 40 in the corresponding cell in Column B
- and if the value is < 0, I need to put 50 in the corresponding cell in Column B
- and just ignore the blank cells

Can someone help me here? Thanks !!!!

**Paul** · 06-20-2007, 12:45 PM

Something like this should work in the sheet's code module:

Please Login or Register  to view this content.

**VBA Noob** · 06-20-2007, 12:51 PM

or using select case

Please Login or Register  to view this content.

VBA Noob

**kerl** · 06-20-2007, 02:16 PM

Thanks both of you!

For some reason it is not writing the values to column B. Am I missing anything here?

**Paul** · 06-20-2007, 06:39 PM

You realize that those examples were not automated macros that occurs as you enter data, right? You have to manually run either of the macros provided by going to Tools -> Macros -> Macros, selecting the macro name and click Run.

If you want something that happens automatically as you type in values, you can try something like this:

Please Login or Register  to view this content.

Put that in the worksheet's code window. Anytime you change a value in Column D, it will check and set column B's value to the appropriate number.

Loop Column, write to another

LinkBack

Thread Tools

Rate This Thread

Display

Loop Column, write to another

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions