MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Should be simple


Posted by Duane Kennerson on November 01, 2001 1:12 PM

I have a number value contained in a cell. I want to write code that will take the number in the cell and combine it with a column to create a cell reference.

(i.e. cell aa7 contains the value 5. I want excel to paste information into lets say column ac. However, I want it to paste the information in the 5th row which it would get from cell aa7)

Make sense???

Thanks in advance


Posted by bob umlas on November 01, 2001 2:01 PM

Cells(Range("AA7").Value,29).Pastespecial
or
Range("AC" & Range("AA7").Value).PasteSpecial