Select Range based off Active Cell

[joeshu26]

Hello I'm trying to Copy a Range based off an Active cell. I want to copy the Active Cell and 1 cell to the right of it and paste it into another area...any ideas?? thanks!

 

[HalfAce]

I assume you're wanting to use vba for this?
If so then try something like this.

Sub CopyTwoCells()
ActiveCell.Resize(, 2).Copy YourDestinationRangeGoesHere
End Sub

Is that what you're looking for?

 

[joeshu26]

yes, thank you!