Excel 2007 : Change value of selected range using VBA

[ramia1983]

How would i write the code?

I want to be able to select a range in a worksheet and then the vba code should check if that current value is <50 and then change it to -9999 if it is. also i wanted to activate it using a shortcut...ctrl-j or something

[Rblack40]

I have no clue on VBA either with custom functions.

[TMS]

@Rblack40: and your point is ... ?


Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

[tom1977]

theck this

Please Login or Register  to view this content.

[Rblack40]

I posted a thread under User Defined Functions and have no clue of the VBA code.

[TMS]

@Rblack40: again, your post does not comply with forum rules. It has nothing to do with the original question and adds no value. I trust that you are not just trying to up your post count.