How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask caraleneK Your Own Question

caraleneK
caraleneK, Office Engineer
Category: Microsoft Office
Satisfied Customers: 574
Experience:  Office assisters to you
75835320
Type Your Microsoft Office Question Here...
caraleneK is online now
A new question is answered every 9 seconds

Im still have an issue with this macro...its not working and

Customer Question

Hey Im still have an issue with this macro...its not working and i am getting a run time error 1004
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  caraleneK replied 1 year ago.

Hello. My name is***** will be providing an answer to your question today

Thank you very much for giving us an opportunity to help you. You will get this error if the Active worksheet is password ***** Or you can upload the macro for me to have a look at .Waiting your feedback

Please, Rate if you are SATISFIED with my help, as this is the only way the site will give me credit for my time. If you still need help, ASK FOR MORE HELP by replying to me.

Customer: replied 1 year ago.
Here is where the macro is located
http://wikisend.com/download/149956/Copy%20of%20Suzanne+Transactions_New2015ASO1FINAL-1-JA-Mod.xlsm
Expert:  caraleneK replied 1 year ago.

Thanks let me have a look

Expert:  caraleneK replied 1 year ago.

Can you please confirm the file name the error show on the file name

ile = Dir(d)
While (file <> "")
If file <> ThisWorkbook.Name Then
Set nwks = nwks.Workbooks.Open(file)
Set nwks = nwbk.Worksheets(1)
lrn = nwks.Cells(Rows.Count, "A").End(xlUp).Row
lra = awks.Cells(Rows.Count, "A").End(xlUp).Rownwbk
If (lra + lrn) >(###) ###-####Then
awks.Range("A1:P1").Copy

Customer: replied 1 year ago.
I tired to make the screenshot bigger but I can't see it.. I have 149 of this files...I attached they are all the same name except the number is ***** that is what you asking for..I am trying to combine all 149 files into one master worksheet.
Expert:  caraleneK replied 1 year ago.

Thanks let me have a look at it

Customer: replied 1 year ago.
The issue is resolved...thank u for your help
Expert:  caraleneK replied 1 year ago.

Pleasure take care please rate the service.