VB Copy and Paste Column Address

[HProutt]

I am trying to take write VB code to help me facilitate a copy and paste. I want to copy information from EITHER Sheet 1: Column G or Column H to Sheet 2: Column B. I can copy it based on a double-click fine, but I want Sheet 2: Column B to know (when it gets copied) where it came from - either Column G or Column H and also copy over the cell coloring associated with the column/cell. I don't know how to write code that says essentially: this information was copied from Column G so bring over the information and colors associated with Column G. How do I identify the cell address? Any thoughts would be appreciated. Thanks.

 

[SkipVought]

Hi,

I assume this is Excel. Yes?

When you copy and paste a range, it copies the values and formats unless you instruct differently using some PasteSpecial parameter.

[i]SourceRange[/i].Copy Destination:=[i]DestinationCell[/i]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]