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

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.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:

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

#NamedRanges #ExcelVBA #ExcelTraining #ExcelTutorial #ExcelNamedRanges

[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!

[arlenegriffin]

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

[jaafarjazaerli]

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

[danp]

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

[teoxengineer]

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

[peterjames]

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

[keitamoussa]

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 !

[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🙏

[chaliascaldwell]

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

[behzadmohammadi]

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

[mosesfrancis]

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