VBA test to determine if cell has a formula or value

**welchs101** · 12-28-2008, 07:16 AM

Hi,

I need to take a specific action when a cell has an actual formula in it versus when it just has a "value". Is there a procedure or command which will allow me to identify if a certain cell has a "formula" (like =sum(a1: a5) ) or just a value.

**Richard Buttrey** · 12-28-2008, 07:37 AM

Hi,

The VBA instruction

Please Login or Register  to view this content.

will return whatever's in A1, and hence you could use an IF instruction to test the first character. i.e.

Please Login or Register  to view this content.

HTH

**se1429** · 12-28-2008, 07:38 AM

Hi,

Check for HasFormula property, for example:

Please Login or Register  to view this content.

Regards.

**welchs101** · 12-28-2008, 07:40 AM

Thanks Richard and SE ........both of these are good inputs. Thanks!

VBA test to determine if cell has a formula or value

LinkBack

Thread Tools

Rate This Thread

Display

VBA test to determine if cell has a formula or value

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions