Posted to microsoft.public.excel.programming

-[::::Shamran::::]- -[::::Shamran::::]- is offline

external usenet poster

Posts: 22

Making a copying macro from cursor position ?

"NickHK" wrote in message
...
Jesper,
Something like:
With ActiveCell
Range(Cells(.Row, 1), Cells(.Row, .Column)).Copy
End With

Sheets("Sheet2").Range("C1").PasteSpecial Paste:=xlAll, Transpose:=True

NickHK

Thank you very much NickHK....saved my day have you ;-)

Shamran

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cursor position	MarkT	Excel Discussion (Misc queries)	5	February 7th 07 01:25 PM
How do you set cursor position at current date in macro?	Tom Robertson	Excel Worksheet Functions	1	May 28th 06 03:50 PM
Cursor position	saziz	Excel Discussion (Misc queries)	2	August 9th 05 08:19 PM
Position Cursor to A1	Dennis Damsgaard	Excel Programming	3	June 8th 04 10:30 PM
cursor position	NTL	Excel Programming	1	January 18th 04 08:23 PM

All times are GMT +1. The time now is 11:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us