Getting Run Time Error 424 object required

can you tell me what line your get the error on?

Opps ! ... so sorry ...

the line is

Please Login or Register  to view this content.

Thank you in advance

Arv

wb is not set. maybe you meant wbNormal or mb900.

wb is not set. maybe you meant wbNormal or mb900.

That is not the case as this code is designed to exportt records from one wb into 2 other wb's (Normal records and 900 records)

Try putting Option Explicit as the first line of the module, and see what happens.

When I tried this i started to recieve a Compile Error: Variable not set....

Disregard the last post .... I'm an idiot!

I forgot to type

QUOTE]Option Explicit

Public wb As Workbook[[/QUOTE]

I resolved that issue .... but now I need can't transfer my records to the other wb's....

make sure that you are addressing the right wb when you are transferring the data.

Hi Blane245,

Thank you ...and yes I am ... the issue is with the offsets.....I see data going into the wb's ...but not the right data

I may be poking around a bit, but note that .Offset is zero-based. Are you picking up the the right rows from rFind?

I may be poking around a bit, but note that .Offset is zero-based. Are you picking up the the right rows from rFind?

Yes.... well I believe so

Currently... the only right thing...or data that is being transfered is the date .....

I don't think the looping is correct. Check to see if it ever executes.

...I think you're right....

Here is the revised code .... and I have attached a copy of the "Normal Records" wb .... to show the output ......

Please Login or Register  to view this content.

It might be more straightforward to loop through all of the rows looking for the "CIC" and then doing the processing on those that match your criteria. The loop would start something like

For rg in wb.Sheets(1).UsedRange.Rows

I wish it could be that easy my friend .....

here's the issue .....

I have to split the records based on "Service type" ...so, if the "service type" is "reg" or blank ...the records should into the Normal records wb ... and the "Service Type" of "900" should only go into the 900 records wb.....

I can't wait until that rhum and coke tonite .....

Hope you had one for me, too! How about looping twice - once for Normal and once for 900?

Hello,

Maybe

Please Login or Register  to view this content.

Best regards.

PMO
Patrick Morange

For clairity reasons... I am marking this thread as "solved" .... as the original issue of "Run Time Error 424 object required " is solved. I will open a new thread to cover the new issue.

Cheers to all that have helped me with this ....