Unleash the power of VBA: Mastering cells & ranges + FREE TEMPLATE

āđāļŠāļĢāđŒ
āļāļąāļ‡
  • āđ€āļœāļĒāđāļžāļĢāđˆāđ€āļĄāļ·āđˆāļ­ 8 āļ.āļ„. 2024
  • 😎 BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! 👉 rebrand.ly/FreelancersAcademy...
    📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ▹ rebrand.ly/UDVL_YTDesc
    ðŸ”ĨGET 300 OF MY BEST TEMPLATES HERE▹ rebrand.ly/300Wkbks_YTDesc
    ðŸĪ–BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ▹ rebrand.ly/AIToolpack_YTDesc
    👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ▹ rebrand.ly/MentorshipProgram_...
    â–ķïļ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
    ðŸ‘Ļ‍💞BECOME AN EXPERT AT DASHBOARDS ▹ rebrand.ly/ExcelDashboard_YTDesc
    ðŸ“ĢSTART LEARNING VBA HERE ▹ rebrand.ly/VBAEFFDan_YTDesc
    🏝BECOME A SUCCESSFUL FREELANCER ▹ rebrand.ly/FreelancersAcademy...
    ⭐ïļJOIN TH-cam MEMBERS FOR UNRELEASED TRAININGS ▹ rebrand.ly/YTMembership_YTDesc
    In this week’s training, I will show you how to work with cells & ranges in VBA for those who are new to VBA or those who want a refresher. We go over every aspect on how to write data, customize cells and values from cells and ranges.
    ⮇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
    bit.ly/CellsAndRanges_WkbkDl
    ðŸĪ‘ START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
    EXCEL COURSES:
    ▹FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
    ▹MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
    ▹DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
    ▹BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
    ▹WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
    EXCEL PRODUCTS:
    ▹Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
    ▹Get 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_YTDesc
    ▹Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
    ▹The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
    ▹Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
    ▹1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
    🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
    Timestamps:
    0:00 - Introduction
    0:18 - Cell & Ranges
    0:46 - Reading and Writing From Cells
    2:45 - Write To Cell
    JOIN OUR COMMUNITY:
    ▹Facebook Group: rebrand.ly/EFF_Group
    ▹Facebook Fan Page: rebrand.ly/EFF_FanPage
    Follow me on my Social Media Accounts:
    ðŸĪĐTikTok: / excel4freelancers
    ðŸĶTwitter: / excel4freelance
    🌏Website: www.ExcelForFreelancers.com
    🔗LinkedIn: / excelforfreelancers
    ðŸ‘ĪFacebook: / excelforfreelancers
    ðŸ“ļ Instagram: / excelforfreelancers
    ðŸŽĨRumble: rumble.com/c/ExcelForFreelancers
    ✉Telegram: t.me/ExcelForFreelancers
    About Us:
    I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
    I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
    Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
    👉 / excelforfreelancers
    New Training Video Uploaded every Tuesday!
    Thank you very much for your continued support,
    Randy Austin
    #ExcelForFreelancers #cellsandranges #cells #ranges #vbaforbeginners #vbatutorial

āļ„āļ§āļēāļĄāļ„āļīāļ”āđ€āļŦāđ‡āļ™ • 41

  • @ExcelForFreelancers
    @ExcelForFreelancers  2 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    ðŸ”Ĩ Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ▹ bit.ly/FreelanceAcademyYtCom

  • @user-ol2yh6ob6j
    @user-ol2yh6ob6j āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    I learn VBA from you. Best teacher keep it up.

    • @ExcelForFreelancers
      @ExcelForFreelancers  āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Thank you so very much, I really appreciate that

  • @jaafarjazaerli1344
    @jaafarjazaerli1344 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    I would like to take a moment to thank your for your efforts in explaining VBA, I've learned a lot watching VBA for beginners series, it is really interesting and I'm looking forward more videos to come

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Thank you so very much, I really appreciate that

  • @Dexter101x
    @Dexter101x 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Clear and concise, thanks again

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

      Great, thanks so much. I am so glad you enjoyed it

  • @gaspumprepairservice7009
    @gaspumprepairservice7009 5 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Already subscribed .. watched many videos, but learned much more from this one because the “nuts & bolts” come together to make sense of the reasons your methods work. Great job, sir - thank you!
    < learning this at 60+ years .. who’d a-thought>

    • @ExcelForFreelancers
      @ExcelForFreelancers  5 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

      Thank you so very much, I really appreciate that and great to have you here

  • @christopherschembri7793
    @christopherschembri7793 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Amazing tutorial. Thanks a lot!

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

      Thanks so very much Christopher. I am so glad you enjoyed it

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Thanks Randy for this amazing video.

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      For sure, you are very welcome Syed.

  • @vinodrajeshkumar6025
    @vinodrajeshkumar6025 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Many Thanks. Really appreciate it!

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.

  • @abdulhamidalhaddadi2255
    @abdulhamidalhaddadi2255 2 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Thank you

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Thank you so very much, I really appreciate that

  • @nerenlakhraj5252
    @nerenlakhraj5252 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    The power of cell input values and how it can be manipulated in VBA to provide lightning fast results. Thank you Randy 😊

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Thank you so very much, I really appreciate that Neren :)

  • @RaphaelChikuka
    @RaphaelChikuka 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Thank you for your videos Randy. This channel has bee very helpful to me.

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      For sure, you are very welcome Raphael and I am very happy to help and share

  • @ashokanselliah9571
    @ashokanselliah9571 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Thank you very much Randy Sir, hugely helpful

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      For sure, you are very welcome and happy to help and share

  • @henkvinck888
    @henkvinck888 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Thank you again for your excellent explanation.Merry Christmas

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      For sure, you are very welcome and Merry Christmas to you as well

  • @watamote8694
    @watamote8694 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Thanks lot

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      For sure, you are very welcome

  • @alejguz1552
    @alejguz1552 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Very good

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Thanks so much. I am really glad you enjoyed it

  • @keitamoussa2229
    @keitamoussa2229 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Hope this serie also will continue for a long time.

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

      Hi Keita, yes thanks I will keep it going. Thanks for the continued feedbak

  • @TheNasy79
    @TheNasy79 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Lovely

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Thank you so very much, I really appreciate that

  • @kalidsherefuddin
    @kalidsherefuddin 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Thanks for

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      For sure, you are very welcome and happy to help and share

  • @ut8062
    @ut8062 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Great

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Thank you so very much, I really appreciate that

  • @petardzopalic3220
    @petardzopalic3220 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    HI Randy and thanks for Masterlass,
    If I have two workbooks, and I want to copy data from one to another, can I call worksheets via Code Name ?
    I dont want to use sheets (1) or worksheet.("name"), I want to refert to worksheets code name is it possible or not ?
    Thank you in advance

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Yes for sure you can use the code name when calling the worksheets, even with multiple workbooks, with the same method, such as :
      Workbooks("WorkbookName.xlsm").Sheet1.Range("A1").Value
      I hope this helps and thanks so much.

  • @sundramprajapati8551
    @sundramprajapati8551 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Hi

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Thank you for your Likes, Shares & Comments. It really helps.