Shortcut key to copy to left

[Icechips]

I want to create a shortcut (or macro) to copy to the left. There's a
shortcut to copy to the right (ctl+R) and copy down (Ctl+D), but nothing to
go right to left.

I tried doing a macro, but it just took specific cells to specific sells. I
wanted to do copy to left of highlited cell.

Please email me at (e-mail address removed) if anyone thinks of a solution.

Thank you

 

[Frank Kabel]

Hi
try the following macro:
sub foo()
on error resume next
with activecell
.offset(0,-1).value=.value
end with
end sub

 

[Paul B]

Icechips, you could use this and assign it to a shortcut key

Selection.FillLeft

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **