Need help with vbcode to get the correct value when running refresh button in excel.

I have this vb code that I neew help with

When opening file, I run a macro like this

Please Login or Register  to view this content.

So when I run refresh, it must give me new info B2 0.0000123 and not '0.000123.

any help on this

Why are you doing this? That code forces the number to become text, which it sounds like you're saying you do not want.

Please Login or Register  to view this content.

Also you do not need to Select to operate on cells, and do not need to use FormulaR1C1 to assign values, and do not want to put numbers in quotes. Do this:

Please Login or Register  to view this content.

Other than that I can't figure out what you want your code to do.

I think we are not communicating.

You have a line of code that explicitly finds every number and puts ' in front it it. If you do not want that to happen, why did you put that in the code?

I think I need to see your data. Can you attach your file?

I will give you the file

Ok

Why this code it there, I have just tried to get it to work, but has got it all wrong.

It is the sheet SHIB that is not working

Password for file is 6371

Like I said, your code explicitly does the opposite of what you said you wanted, and I pointed out where the problem is. Try this modification. Switch What and Replacement::

Please Login or Register  to view this content.