Results 1 to 9 of 9

Thread: suggest the mistake in this macro part

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    Jun 2012
    Posts
    39
    Rep Power
    0

    suggest the mistake in this macro part

    This part of the macro is for pasting in a different sheet. I have the heading in row b3 of sheet named "i".. there is error in the line after the else command.


    Code:
    Sheets("i").Activate
        Range("B3").Select
        If Range("b3").Offset(1, 0) = "" Then
        Selection.Offset(1, 0).Select
        Else
        Selection.Range(xlDown).Offset(1, 0).Select
        End If
        ActiveSheet.paste
    Last edited by Excel Fox; 04-02-2013 at 11:07 PM. Reason: Code tag added

Similar Threads

  1. Suggest the mistake in the formula
    By Safal Shrestha in forum Excel Help
    Replies: 2
    Last Post: 04-21-2013, 09:42 AM
  2. Replies: 2
    Last Post: 04-16-2013, 01:36 PM

Posting Permissions

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