copy range from left to right

Andy D 2002 · May 14th, 2002, 08:18 AM

hi
i use a macro "paste-special-transpose" info into cells, starting from, say b5

if theres only 5 cells pasted obviously the range will end F5, if there's 10 then will end K5 etc (basically i don't know how long the range will be)

question: i have a header called "header" in cell A5, how can i copy this from left to right so starts at A5 at ends F4 ot K4 etc - wherever my paste has ended

i think is an offset i need. sorry for the "waffly" post any help appreciated
Andy

Nimrod · May 14th, 2002, 10:23 AM

Could you send a sample of the code that does the paste

May 14th, 2002, 08:18 AM	#1
Andy D 2002 Board Regular Join Date: Apr 2002 Location: Andy Devine Posts: 106	hi i use a macro "paste-special-transpose" info into cells, starting from, say b5 if theres only 5 cells pasted obviously the range will end F5, if there's 10 then will end K5 etc (basically i don't know how long the range will be) question: i have a header called "header" in cell A5, how can i copy this from left to right so starts at A5 at ends F4 ot K4 etc - wherever my paste has ended i think is an offset i need. sorry for the "waffly" post any help appreciated Andy __________________ Andy Devine

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 10:23 AM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Could you send a sample of the code that does the paste