Consulting

Results 1 to 3 of 3

Thread: Adjust error calculation in VBA

  1. #1
    VBAX Tutor
    Joined
    Jan 2011
    Posts
    272
    Location

    Adjust error calculation in VBA

    Hi

    Why my macro creates 5 rows when my guide has only 2 rows?


    When I have data from A5 to A10 not the same thing happens.

    see the part in yellow

    Att
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,875
    lr = .Cells(.Rows.Count, "A").End(xlUp).Row - 4
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    VBAX Tutor
    Joined
    Jan 2011
    Posts
    272
    Location
    Hi p45cal, i like, very good!

    Thank you very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •