Moving a selected cell

[C J]

Without using Cut/Paste or Drag, is there another way to move the contents
of a selected cell to another cell on a worksheet?
Thanks
CJ

 

[Dave Peterson]

Use a macro that assigns the value to the second cell and clears contents of the
original cell???

 

[C J]

Dave thank you for your reply. I am somewhat new with Excel and do not know
how to setup macro. Would you give me the steps for this situation?
CJ

 

[Dave Peterson]

Option Explicit
Sub testme01()

dim FromCell as range
dim ToCell as range

with worksheets("sheet9999")
set fromcell = .range("a1")
end with

with worksheets("sheet8888")
set tocell = .range("x999")
end with

tocell.value = fromcell.value
'and maybe
tocell.numberformat = fromcell.numberformat

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Dave Peterson]

And add one more line before the "End Sub" line:

fromcell.clearcontents

 

[C J]

Thanks so much for your help.
CJ

And add one more line before the "End Sub" line:

fromcell.clearcontents