Post the code. You are not referencing the correct worksheet or you selected
cells are in a different place when you run the code togetther verses runn9ng
the code seperately.

"Madduck" wrote:

Hi team,

I have built a program in Excel and when I built it I tested each module
along the way..

Now when I combine all the modules to run on the button click I get a run
time error every time.

I'm not sure why....

it says

Run-time error '-2147417848 (80010108)

Method 'Value' of object 'Range' failed


I did have a different error..something about disconnected data??? but spil
the code to run in segments...

i.e press button one to run one half of the code..
press buton 2 to complete the rest of the code...

any ideas?