Closed Thread
Results 1 to 5 of 5

Please help me understand this lines

  1. #1
    Registered User
    Join Date
    07-08-2014
    Location
    Philippines
    MS-Off Ver
    MS office 2010
    Posts
    30

    Please help me understand this lines

    Hi guys!, I am new in Excel Macro. can you help me achieve my goal and explain the meaning of all highlighted text? Please see attached. Your help will be very much appreciated. Thanks a lot
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Please help me understand this lines

    this piece of code will copy contents of H2 cell from Test sheet and paste the contents as values only in Range A2 of test sheet.

    then sheet will be protected with test password
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Please help me understand this lines

    Hi, mikoski,

    please do not post the some question to several Sub-Forums here on Excelforum (http://www.excelforum.com/excel-prog...is-lines.html] but just to the relevant one. And maybe have a read at the http://www.excelforum.com/forum-rule...rum-rules.html about threaad titles.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Registered User
    Join Date
    07-08-2014
    Location
    Philippines
    MS-Off Ver
    MS office 2010
    Posts
    30

    Re: Please help me understand this lines

    Very much noted HaHoBe. Hemesh, I mean those higlighted in yellow =x1"etc." what does those all commands mean or what are they used for?

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Please help me understand this lines

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

    http://www.excelforum.com/excel-prog...his-lines.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to Understand VBA Code....
    By konquistador in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2009, 04:35 PM
  2. Replies: 1
    Last Post: 09-18-2007, 02:07 PM
  3. Don't understand the off-set
    By DaGo21 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-04-2006, 12:15 AM
  4. I just don't understand it!
    By datingservices2 in forum Excel General
    Replies: 3
    Last Post: 08-14-2006, 11:20 AM
  5. I don't Understand
    By elusiverunner in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-25-2005, 05:20 PM

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