We help IT Professionals succeed at work.

Simple Paste Macro

sandramac
sandramac asked
on
I need a code that will select ai20 and paste that data into the active cell.  Thanks
Comment
Watch Question

Commented:
In excel

Function test()
Dim acCell
acCell = Range("ai20")
ActiveWindow.ActiveCell.Value = acCell
End Function
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
dim rng as range

set rng =activewindow.activecell
rng.value = range("AI20").value

Commented:
Do I have something in my profile that says "Please repeat my answer and claim it as your own" ?


Not last time I looked.......!!!!
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
?

Explore More ContentExplore courses, solutions, and other research materials related to this topic.