Hi
not sure about the 'How would I enter these keystrokes into a cell so that
when pasted ..' bit of your question, but if you're looking at how to
incorporate a line in your code that mimics the user pressing Shift & F3
then check out "sendkeys statement" in VBA help (alt & f11 to get to the vbe
window and use the help from in there).
--
Cheers
JulieD
check out
www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Stricky" wrote in message
...
I am trying to design a very simple macro where by data can be copied and
pasted to another computer programme from excel. The problem I have is
that
the other software programe uses the keystroke shiftF3 to clear a field
and I
cannot replicate this keystroke in excel. How would I enter these
keystrokes
into a cell so that when pasted they would perform the function in the
other
programme rather than trying to data enter it?