View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Excel MVP Don Guillett Excel MVP is offline
external usenet poster
 
Posts: 168
Default Conditionally copy cell from one column to another VBA

On Jan 23, 7:39*am, Isis wrote:
I want to loop through a column row by row, (at least I think I need to
loop ?)and then conditionally copy the value of that cell to a different
column (but the same row) after a mathmatical operation (times -1, or plus
.3 etc) on the value.

How would I do that ?

Can I adapt it so that the column can be 'set' when running ?

Thanks for any input


Hard to tell without seeing as your explanation is lacking
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."