Found a workaround

Found a workaround

Post by Norma » Thu, 26 Jun 2008 23:19:26

I have also been struggling with macros for some time and found a workaround. It takes a few steps, but it worked and I am happy enough.

Load your excel spreadsheet in Compatability Mode, or save it to begin with as an Excel 2003 file.

If you have a large file and are not sure if there are hyperlinks or other hypertext in them, copy the spreadsheet.

Open a new spreadsheet, click on Paste Special... under the paste icon.

In the popup box, click the "Paste Link" button inthe lower left-hand corner.

This will paste the sheet in a plain text, unformatted environment, similar to the previous post using Notepad, but you can stay in Excel to do this.

My Macros work beautifully as before.


1. lookup only finds #n/a's

2. Finding the Value (of text and numbers) between N/A's

Howdie all :)

Problem...My data is of two types

Type I - Numbers or #N/A - these are in cells a1,c1,e1,g1
Type II - Text or #N/A - these are in cells b1,d1,f1,h1

For Type 1
I need to put in cell I1 the first (or any) instance of a number - The
number if picked up in a1,c1,e1,g1 will always be the same, ie only two
options - the number or a N/A. I want the formulae in I1 to look at
a1,c1,e1,g1 and tell me what the number in the range is.

For Type II
Same as above but I need to display in J1 the result of the first
instance of text (text will always be the same - could either be text
(eg ABC234) or NA that could be in b1,d1,e1,g1..



*** Sent via Developersdex ***

3. WORKAROUND FOUND: Application Cannot Find Its Libraries

4. Found Workaround

5. It seems, I have found a workaround.

6. svchost.exe + LSP (was: I found a workaround but I don't know the reason...)

7. workaround found

8. smtp connector fails to my ISP's smtp server - found a workaround

9. FP and Excel: Any Workarounds Found?

10. "Scanner not found" workaround.

11. Trying to find a workaround for PR47034


13. printable fraction symbols - sheesh, VERY hard to find, any workarounds?

14. WAProcessMonitor>>critical:ifError workaround found

15. single user can't login to OWA - workaround found