changing the 9 to a variable, Microsoft Excel, newsgroup, help, assistance" /> changing the 9 to a variable Excel Worksheet Functions" /> Range("C9:V9").Select ==> changing the 9 to a variable - ExcelBanter

Menu

Range("C9:V9").Select ==> changing the 9 to a variable

Search this Thread

Prev

Previous Post

Next Post

Next

#9

Report Post

Don Guillett

Posts: n/a

Default

range(cells(mr,"c"),cells(mr,"v")).copy range("a2")

--
Don Guillett
SalesAid Software

"B. F." wrote in message
oups.com...
Thanks a lot for the precise and VERY fast replies.
My problem is solved in record time.
Replying to Don´s question: the next steps are copy & paste.
Best Regards, Jorge

Reply With Quote

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
Countif Formula with changing criteria	Stephen	Excel Discussion (Misc queries)	2	May 2nd 05 07:24 AM
Changing the format of an Excel output file made by Microsoft Access	Amir	Excel Discussion (Misc queries)	2	May 1st 05 12:57 AM
How do I stop excel automatically changing my date to 2005?	zoemcb	Excel Discussion (Misc queries)	6	April 30th 05 02:39 AM
changing page break in an excel file	ibs81	New Users to Excel	1	April 14th 05 07:03 PM
Changing the Direction of Data within a Column	Michael Parsons	Excel Worksheet Functions	1	January 27th 05 06:52 PM

All times are GMT +1. The time now is 04:30 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement