+ Reply to Thread
Results 1 to 2 of 2

Second line of code do not work!!!

  1. #1
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Thumbs down Second line of code do not work!!!

    Hi dear gurus and contributors again
    I need your help to find out why error in secind line occurs?!

    Please Login or Register  to view this content.
    This code is running when I press OK buttun in UserForm2.
    The first line searches "Issue Description" column label within active sheet. It is hidden one. After finding column label I get its' column number and use this as ColumnIndex to insert desired text through userform.

    But the problem is that second line do not work at all even if it uses the same technique. Even more. When I replace the 1st line with second one, thw working first line in the seconf line do not work... So In short, the code doesn't care what is in second line, it runs only first one.
    The sheet is protected, but I wrote a macro that unprotect it first, the protect this again. I just didn't include these lines here.

    Thanks in advance

    I didn't know how name the thread, so apologize...
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Second line of code do not work!!!

    It's only a matter of commas:

    Please Login or Register  to view this content.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1