(Msg. 2) Posted: Thu Oct 23, 2008 11:21 am
Post subject: Re: Macro for 'Paste Special' Archived from groups: per prev. post (more info?)
On Oct 23, 2:03 pm, Jeremy Leonard
wrote:
> Is there a way to set a macro up so that perform a 'paste special'
> into whatever cell is currently highlited?
>
> Thanks in advance.
(Msg. 3) Posted: Thu Oct 23, 2008 11:54 pm
Post subject: RE: Macro for 'Paste Special' Archived from groups: per prev. post (more info?)
Hi,
Why bother with a macro, in most cases you can put a button on the toolbar
to do whatever Paste Special command you want: Value, Formulas, Links,
Transpose, No Borders, or Paste Special itself. >> Stay informed about: Macro for 'Paste Special'
(Msg. 4) Posted: Fri Oct 24, 2008 1:33 pm
Post subject: Re: Macro for 'Paste Special' Archived from groups: per prev. post (more info?)
I set it up as a macro because I know how to assign a keyboard
shortcut for a macro.
On Oct 24, 2:54 am, ShaneDevenshire
wrote:
> Hi,
>
> Why bother with a macro, in most cases you can put a button on the toolbar
> to do whatever Paste Special command you want: Value, Formulas, Links,
> Transpose, No Borders, or Paste Special itself.
> >> Stay informed about: Macro for 'Paste Special'
EXCEL 2003 paste special and go to specil misfunction - Hello to everybody, I noticed that if I use the "paste special - values" function to, say, paste three cells with a formula behind and just one value displaying, your result would be to obtain two blank cells and a cell with a value on it. Th...
copy/paste macro - I am trying to create a macro that will copy a range of data; however, the number of rows to copy will vary each time the macro is run. Is there a way that I could creat parameter fields that the macro cuold read? Thanks, Micki
Excel 2007 - Paste picture link does not print - I have a 2003 spreadsheet with a pasted picture link on one worksheet showing data from another worksheet. Trying this same setup in excel 2007 - the print preview and print does not print the pasted link picture. I have used the camera tool, paste as....
Excel Macro Problem - I have a database with 98 sheets. One sheet for each bus in our fleet. I need to updated the links for each sheet from xls to xlsm without changing the bus number in the link. I used to be able to create a macro to make a change in a few sheets in....
macro security settings - I would like a way to set macro security thru GPO for Excel 2007 SP1 to allow only macro from the startup folder and not from any other files this is actually a group policy question but as this is rather excel specific I was hoping to find the answer...
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
