Excel Named Ranges: Everything You Need To Know In Less Than 30 Minutes

🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_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 KZbin MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this masterclass, I will share with you every aspect of Named Ranges within Excel & VBA. After this training, you will be able to immediately use your new skills to build impressive applications using named ranges in Excel.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/NamedRangesMstrclass_Wk...
🤑 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 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_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
5:07 - Create Named Range
8:07 - Static Named Range
18:58 - Next Cust ID
21:40 - Referring To Named Ranges
22:30 - Delete Named Range
23:48 - Hide Named Ranges
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
#NamedRanges #ExcelVBA #ExcelTraining #ExcelTutorial #ExcelNamedRanges

[@ExcelForFreelancers]

🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom

[@eloise_ae]

Hi looking forward to this to see if i can learn more. Range is what I have the most issues with - hoping this will help with my issue raised after your change undo log where I need to add further ranges to the log to note a secondary drop down selection! Thanks for the great tutorials Randy!

[@ExcelForFreelancers]

For sure, you are very welcome and I hope you have enjoyed this training. Make sure to download the free template as well. Thank you for your Likes, Shares & Comments. It really helps.

[@arlenegriffin4523]

GREAT VIDEO AND VERY UNDERSTANDABLE. THANK YOU SO MUCH. LOVE YOU TRAINING.

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much

[@SyedMuzammilMahasanShahi]

Thanks Randy for this amazing video.

[@ExcelForFreelancers]

For sure, you are very welcome Syed, and thank you for your continued support

[@DigitalFinance-xv6ql]

you are realy a professional !

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@NigerExcelNE]

Bien-sûr 🎉

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@ndhdhdh]

I really appreciate your work! You are a great teacher, and i have a question, i'm training now in a company as a purchasing manager and i want to make an excel data base for suppliers so i can search for the product or service and the name of the company/companise appear. Your help please🙏

[@ExcelForFreelancers]

Hi and thanks very much. I show you how to do this in the Ultimate ERP application here: kzbin.info/www/bejne/fnaQmGV4dqhogdU I hope this helps and thanks so much.

[@henkvinck888]

THNX Randy

[@ExcelForFreelancers]

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

[@alializadeh8195]

Thanks

[@ExcelForFreelancers]

For sure, you are very welcome

[@jaafarjazaerli1344]

Thank you randy for this great tutorial, you're really shifting excel to a new level. Regarding the hidden named ranges how to utilize it in a spread sheet? I mean that the named range is hidden but the values of cells that refer to it still exists

[@ExcelForFreelancers]

Hi and thanks very much. The hidden named ranges can be used like any other named ranges, and they can be used in VBA or in formulas. The only difference is that the hidden named ranges are not visible in the Name Manager. I hope this helps and thanks so much.

[@teoxengineer]

Great explanation Thank you. And, I wanna learn that how can we remove all range in workbook or selected worksheets by using VBA?

[@ExcelForFreelancers]

Hi and thanks so much. You can run a loop through the workbook or worksheet with a variable such as Dim NamRng as name For each NamRng in Thisworkbook NamRng.Delete Next NamRng (something like that however I have not tested the code) I hope this helps and thanks so much.

[@sabryzein7327]

good job

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@peterjames8046]

Great training, one question, how do you create an auto number for your invoice

[@ExcelForFreelancers]

Hi and thanks so much. To create an auto-invoice you can use the Max formula as long as all invoice #'s are numerical such as =Iferrror(Max(Inv_Numb)+1,1) If there is no data, this will revert 1 as your starting Invoice #. I hope this helps and thanks so much.

[@behzadmohammadi1636]

Hi, is there any video for access to a shared database(excel) for multiple user at same time ? Same as what MS.access dose

[@ExcelForFreelancers]

Hi and thanks. Yes i have that. To share and sync your macro-enabled Excel workbook, please watch this training: kzbin.info/www/bejne/nJCUeaaIbphja6s

[@keitamoussa2229]

Shout out 🎉 to you Mr AUSTIN !!! By the way would mind making a tutorial about importing a csv file into an excel file without loosing data and make it look like as on the csv file. Thanks !

[@ExcelForFreelancers]

Hi Keita, thanks for your idea. This would be a good video for our basic series. I have written the idea down and will get to it in the near future. Thanks so much for your continued support

[@keitamoussa2229]

@@ExcelForFreelancers Thanks so much

[@chaliascaldwell5898]

Can we make a named range with cells from multiple sheets or would that be too messy

[@ExcelForFreelancers]

HI and thanks you would want to make sure the range of cells are next to each other and on the same sheet when naming a range. I hope this helps and thanks so much.

[@mosesfrancis4976]

I have family details in excel. I want to take print report as pdf file. Which software is good for it?

[@ExcelForFreelancers]

HI and thanks you can try this one: kzbin.info/www/bejne/rXqZn3mipp52iZo I hope this helps and thanks so much.

[@danp6101]

Hey Randy you can make Named Ranges like this in VBA I know you don't have to use arrays. This is just an example Sub NameRange() Dim xAdds(1 To 4) As String, xNames(1 To 4) As String xAdds(1) = "C3" xAdds(2) = "C4" xAdds(3) = "C5" xAdds(4) = "C8:C11" xNames(1) = "ChargeTax" xNames(2) = "TaxName" xNames(3) = "TaxRate" xNames(4) = "Locations" For x = 1 To 4 Sheet1.Range(xAdds(x)).Name = xNames(x) Next x End Sub

[@ExcelForFreelancers]

Hi and thanks very much. Certainly many ways to create named ranges. If you have a lot of them to name, via VBA and they are in specific rows or columns, then a For/Next loop is a great idea. Thank you for your Likes, Shares & Comments. It really helps.

[@danp6101]

@@ExcelForFreelancers You can also use a loop With the find and findnext in vba Based on cell values and or font color. Interior color. Plus the cells don't have to be next to each other. You would have to separate the cells with a coma though. Sub CreateRanges() Dim xCell As Object Dim RangeAdd As String Dim X As Integer, Y As Integer Dim RngAdd As String Dim C As Range Dim firstAddress As String, SaveRng As String Dim q As Integer, NumCnt As Integer ' Example.. Freelance range is "B2:N15" consist of number from 1 to 81 ' You want to find all the cells that have the same number in that range For X = 1 To 81 xRng = "": RangeAdd = "" ' The NumCnt is used to skip if a number is not present NumCnt = WorksheetFunction.CountIf(Range("Freelance"), X) If NumCnt > 0 Then With Sheet1.Range("Freelance") ' The Reason why after:=Sheet1.Range("N15") is used is so the find method will start at the beginning of the Freelance range Set C = .find(X, after:=Sheet1.Range("N15"), Lookat:=xlWhole, SearchOrder:=xlByRows) If Not C Is Nothing Then firstAddress = C.Address Do ' xRng = xRng & C.Address & "," Set C = .FindNext(C) Loop While C.Address firstAddress ' this step is used to remove the coma at the end of the saved cells addresses xRng = Left(xRng, Len(xRng) - 1) RangeAdd = RangeAdd & xRng q = q + 1 Sheet1.Range(RangeAdd).Name = "NUMBER" & q ' This names the ranges as NUMBER1 etc q is a counter End If End With Else ' do nothing End If Next X End Sub

[@ExcelForFreelancers]

Great! Thanks so much for sharing