Hi,
I'm still a newbie!
Trying to copy a range of cells in a row (starting at 6 columns from the cursor thru to col. 11 - in same row) and pasting it in cell G45.
I keep getting compile error...":" is highlighted. See code below :
Range(ActiveCell.Offset(0,6):ActiveCell.Offset(0,11)).Copy Range("G45")
What ami doing wrong ...and what if i need to PasteSpecial instead of regualar paste (in need to transpose).