Re: $$Excel-Macros$$ Who to remove hyperlinks

2010-03-23 Thread Vikas Chouhan
hi Dear pls open this link. *http://www.tech-recipes.com/rx/1323/remove-all-hyperlinks-in-word-or-excel/ * On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram <06n...@gmail.com> wrote: > Hi Members, > > i have huge data with hyperlinks. > Is there any shortcut key or formula to remove all hy

Re: $$Excel-Macros$$ Who to remove hyperlinks

2010-03-23 Thread rf1234 rf1234
Dear All Please have a look on Delete all hyperlink workbook. Hope it Will Help Happy to Help :) Shyam On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram <06n...@gmail.com> wrote: > Hi Members, > > i have huge data with hyperlinks. > Is there any shortcut key or formula to remove all hyperlinks at

Re: $$Excel-Macros$$ Who to remove hyperlinks

2010-03-22 Thread ashish koul
sub a() selection.hyperlinks.delete end sub On Mon, Mar 22, 2010 at 10:22 PM, Sandeep Kumar Maurya < sandymau...@gmail.com> wrote: > Hi, > > write 1 in a blank cell and then copy it and use multiply option in 'paste > special'. > It also put 0 in blank selected cells. > > Regards > Sandeep >

Re: $$Excel-Macros$$ Who to remove hyperlinks

2010-03-22 Thread Sandeep Kumar Maurya
Hi, write 1 in a blank cell and then copy it and use multiply option in 'paste special'. It also put 0 in blank selected cells. Regards Sandeep On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram <06n...@gmail.com> wrote: > Hi Members, > > i have huge data with hyperlinks. > Is there any shortcut key or

$$Excel-Macros$$ Who to remove hyperlinks

2010-03-22 Thread Nani Ram
Hi Members, i have huge data with hyperlinks. Is there any shortcut key or formula to remove all hyperlinks at once. Thanks, Naniram -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tri