Member Avatar for dfs3000my

Hi

I would like to read ActiveCell.Value as it is in my macro.

E.g. Even if i have #VALUE!, it will treat it as a string and read it.

Can this be done?

  • 2 Contributors
  • 1 Reply
  • 52 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by Yiannis_Sp
Member Avatar for Yiannis_Sp

ActiveCell.Text should do the trick. I vaguely seem to remember some length limitations on the property though, so you might want to check that before using.

Yiannis

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.