You could select the area containing the links, copy to the clipboard and then paste special back into the same area selecting the values option.
You could select the area containing the links, copy to the clipboard and then paste special back into the same area selecting the values option.
Thanks, That works but I dont get the row formating, maybe cause Im using Excel 2000
After using "Paste Special Values" use "Paste Special Formats" that
should restore your row formatting to the pasted results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks