Results 1 to 9 of 9

Thread: suggest the mistake in this macro part

Threaded View

Safal Shrestha suggest the mistake in this... 04-02-2013, 11:04 AM
Rick Rothstein I am guessing that you meant... 04-02-2013, 12:19 PM
Safal Shrestha I am a newbie in vba. I am... 04-02-2013, 01:02 PM
Safal Shrestha Below is the vba code for... 04-02-2013, 01:13 PM
Excel Fox There are quite a few... 04-02-2013, 07:26 PM
Excel Fox Try this.. Sub Macro1()... 04-02-2013, 06:40 PM
snb this will suffice: Sub... 04-02-2013, 07:20 PM
snb I know, but as long as the TS... 04-02-2013, 09:03 PM
Safal Shrestha Thanks a lot guys. I am... 04-03-2013, 11:57 AM
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
  •