VBA If Then with multiple actions

**KarenaBena** · 06-15-2017, 05:40 PM

Hi! New to VBA. I've done this successfully with Formula in cell, but circumstances of normal use cause the formula to be erased. So, I'd like to use VBA to accomplish it. (OR, if someone knows how to write a formula in one cell that actually acts upon a different cell???)

I'm trying to write macro that will copy/paste several cells to others of the same size, ONLY IF an unrelated cell holds a certain content. I've tried as a single action:

Please Login or Register  to view this content.

And also as separate actions:

Please Login or Register  to view this content.

And listed them as cells:

Please Login or Register  to view this content.

Completely at a loss as to what's wrong. I'm not close enough for the debugger to tell me what I'm doing wrong. Any help would be greatly appreciated.

~Karena

**Winon** · 06-15-2017, 05:49 PM

Moderation removed.

**KarenaBena** · 06-16-2017, 02:02 PM

So sorry! Thanks for instruction

**cytop** · 06-16-2017, 02:16 PM

AFAIK you cannot copy irregular shaped ranges - so you'll have to copy twice

Please Login or Register  to view this content.

Your second sample should have worked...

I'm not close enough for the debugger to tell me what I'm doing wrong

You never did mention if it doesn't not work, doesn't work work as you expect or errors.

**Ed_Collins** · 06-16-2017, 04:18 PM

This format also should work:

Please Login or Register  to view this content.

**KarenaBena** · 06-16-2017, 07:59 PM

Thank you both, Ed and Cytop, for the input. Neither worked. I appreciate the instruction on irregular shaped ranges... hadn't thought of that, and I'm sure it was one of the problems. I don't get an error of any kind, it simply doesn't work.(neither of the formats, nor any that I had tried originally). Certainly perplexing. Is there a way to get this out of VBA, and apply a formula to a cell when it's written in a different cell? For example, where the code would be hidden in any unrelated cell, perhaps L18:

Please Login or Register  to view this content.

There would need to be something different at the beginning obviously, other than the "=IF(..." I have no idea how to do that, or whether it's even possible.

**KarenaBena** · 06-20-2017, 05:17 PM

Thanks so much for the attempts. So confused as to why none of this worked.... I'm sure it's something I'm doing. Anyway, I appreciate your time, both of you. Enjoy the rest of your week!

VBA If Then with multiple actions

LinkBack

Thread Tools

Rate This Thread

Display

VBA If Then with multiple actions

Re: VBA If Then with multiple actions

Re: VBA If Then with multiple actions

Re: VBA If Then with multiple actions

Re: VBA If Then with multiple actions

Re: VBA If Then with multiple actions

Re: VBA If Then with multiple actions

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If Not Is Nothing multiple actions

[SOLVED] Multiple Actions with an IF Statement

[SOLVED] If Then statements with multiple Then actions to take.

FORMULA Requiring Multiple Actions

VBA process for multiple actions

[SOLVED] perform multiple actions in an IF

[SOLVED] Performing actions on multiple worksheets

Bookmarks

Bookmarks

Posting Permissions