Search:

Thanks - it works! I'd tried putting the #n/a in the original data, which worked but the customer didn't like. Forgot that I could do my link that way too.

A somewhat related question - I'm trying to graph some linked cells and I want the blanks in the original to show as blanks so they won't be plotted. I have a graph that changes as a user picks a...

Interesting - yours worked. Below is my code that didn't work. I changed it to the syntax you used and it worked ??!!
tr = "pos1"
Range("plink").Copy
Sheets("Report").Select
...

I have a macro that creates individual reports/files out of a large data set (it filters on a person, gets that person's data into a report "template" and saves it with a file name for the person). ...

One solution may be to "force" the cells to be numeric. I've recovered text (values, dates and times) this way many times: type a 1 in any cell; copy that cell; select the range to be fixed; from a...

Sorry I wasn't clear - the problem does occur only when I try to use the function in an update query (the error doesn't occur in a select query). But it only happens with one row of the 2000+ row...

If you create a report, then modify a Control Source for a text box, you often need to change the name of the text box. I just add a number or something to the end of the name of the text box in the...

I've written a user defined function to do some significance testing on 4 values (double) and return one value (integer). The function works just fine in a select query, but when I try to do an...