Moving a selected cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

C J - 15 Nov 2006 02:14 GMT

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

Reply to this Message

Dave Peterson - 15 Nov 2006 03:01 GMT

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

> 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

Signature

Dave Peterson

Reply to this Message

C J - 15 Nov 2006 22:41 GMT

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

> Use a macro that assigns the value to the second cell and clears contents
> of the
[quoted text clipped - 5 lines]
>> Thanks
>> CJ

Reply to this Message

Dave Peterson - 15 Nov 2006 22:54 GMT

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 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?
[quoted text clipped - 12 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 15 Nov 2006 22:59 GMT

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

fromcell.clearcontents

> Option Explicit
> Sub testme01()
[quoted text clipped - 39 lines]
>
> Dave Peterson

Signature

Dave Peterson

Reply to this Message

C J - 17 Nov 2006 20:02 GMT

Thanks so much for your help.
CJ

> And add one more line before the "End Sub" line:
>
[quoted text clipped - 45 lines]
>>
>> Dave Peterson

Reply to this Message