not sure why my code isn't doing anything... no bugs though!!!

I have the following code that does not come up with any errors when it is run, but it also doesn't do what I want it to...

I have multiple sheets and will be adding more as time goes on, they are all in a similar format other than some of them start a bit further down but the bit that I need is over 20 rows hence the start and endline dims to find this range, then I want to copy the row (10 columns long) to the data sheet where the button is that activates this.

I can't figure out why it isn't working...

the code is as follows

Please Login or Register  to view this content.

help is greatly appreciated

A list of cells with dates in

Please Login or Register  to view this content.

...?

Does the data start in Row 3, or does cell A3 contain a value that specifies where the data starts?

cell A3 contains a value that specifies where the data starts,

Thank you,

I have changed it but it still doesn't work

i have changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and now i get an error "Run time error '91': object variable or With block not set"

not sure why that is happening :O

Then StartLine (and EndLine) need to be declared as Longs - not Range

No mention of changing the declarations...

whoopsie, I have changed it now,

the code doesn't have any bugs now but it still doesnt do anything,

current version as follows

Please Login or Register  to view this content.

Now the issue is this line.

Please Login or Register  to view this content.

'Empty' is a tricky thing to use, the actual syntax should be

Please Login or Register  to view this content.

I think that's the last issue...

woohoooooo!!! thank you so much!!!

for anyone interested or also stuck I had to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

As mentioned in post #7.

i thiought as I referenced the ws in the

Please Login or Register  to view this content.

that I wouldn't need it in the other parts

works a charm! thank you so much!