$$Excel-Macros$$ copy an Excel chart and paste (default) into PowerPoint embedded, rather than linked

2009-11-04 Thread kruijsdijk
In Office 2007 SP2, you can copy an Excel chart and paste (default) into PowerPoint. In PowerPoint, a Smart Tag appears next to the pasted chart that lets you choose from 3 paste options. The one I want is "Excel Chart (entire workbook)" so that the underlying data is included in the presentatio

$$Excel-Macros$$ Re: VBA code to select non continguous ranges based on column and row number of areas to select

2009-11-03 Thread kruijsdijk
Is there a way for me to attach an excel file to my posting, I can't see an possibility to attach files? On Nov 3, 2:47 pm, kruijsdijk wrote: > So I already know the row and column numbers > > row1 = 4 > row2 = 8 > row3 = 11 > > column1 = 2 > column2 = 4 > &

$$Excel-Macros$$ VBA code to select non continguous ranges based on column and row number of areas to select

2009-11-03 Thread kruijsdijk
So I already know the row and column numbers row1 = 4 row2 = 8 row3 = 11 column1 = 2 column2 = 4 So now I want to write VBA code based upon the row and column numbers available that corresponds with the selection Range("B4,B8:B11,D4,D8:D11").Select I have been trying to get this to work for a