How to copy a cell and horizontally expand the paste along header

Michael (Micky) Avidan Michael (Micky) Avidan is offline

Junior Member

Location: ISRAEL

Posts: 2

Hi,

Although it is a very old thread - here is a Macro which will emulate a Horizontal double-click Fill-in:

Code:

Sub Fill_HorizontalRight()
    Set Rng = Range(Selection, Selection.Offset(-1).End(xlToRight).Offset(1))
    Rng.FillRight
End Sub

Michael (Micky) Avidan
“Microsoft®” MVP – Excel
ISRAEL

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
Copy column in Excel and paste horizontally in Word.	Confused	Excel Discussion (Misc queries)	6	March 7th 08 07:22 PM
want to cut data from vertical cells and paste them horizontally.	charter_SKR	Excel Discussion (Misc queries)	2	March 29th 06 04:42 PM
Macro to find copy "header" and paste	RunsWithKnives	Excel Discussion (Misc queries)	3	March 27th 06 05:55 AM
Excel: custom header - is it possible to paste into header?	Maureen D.	Excel Worksheet Functions	0	November 4th 05 03:07 PM
expanding the side margins in excel does not expand header	John Staerck	Excel Discussion (Misc queries)	1	October 6th 05 05:37 PM

All times are GMT +1. The time now is 01:50 PM.

About Us