Function to count differences between two columns

**mdoherty83** · 10-23-2012, 08:28 AM

Hi,

below i have a spreadsheet with several columns worth of data, i want to use the function below to show me if there have been any changes between the selected range and the cells immeadiatly to the right in the next column, when i use the below i get a "VALUE!" error,

any help appreciated.

Please Login or Register  to view this content.

**event21** · 10-23-2012, 09:01 AM

Hi -

what are the "m" and "d" variables?

Regards,
event

**mdoherty83** · 10-23-2012, 09:03 AM

aha i think i see where you are going, they're Letters and numbers, i.e C3, C2, C3A etc etc, will changing the DIM to varient help?

**mdoherty83** · 10-23-2012, 09:10 AM

Nope, my enthusiasm has been put in it place, its more then the "DIM a s long", I'm know thinking its something to do with the .value, because its "text" should i be using something different there instead?

thanks,

**event21** · 10-23-2012, 09:17 AM

Hi -

If that was long then should be numeric, if it is text then string.

but check your function to include what will happen after each loop on those variables?

Regards,
event