This is your time to ask me question as we go through this topic
In this video we will go over all the ways to find the last Row on a Sheet, in a Range or in a Table. We will explore xldown, xlup, current region and usedrange....
Hi All, I keep getting requests for help so I thought I would start doing some weekend workshops.
These will be an open forum for questions and challenges. We can go over VBA, Excel, Google Sheets. SQL, or anthing else that comes up
Using a For Next to count down, across, diagonal
strw = ActiveCell.Row
stcl = ActiveCell.Column
Num = ActiveCell.Value
For rw = strw To strw + Num - 1
Cells(rw, stcl) = Num
Num = Num - 1
In this Video we show how to hide columns and rows using a message box with some if statements and for loops.
rw = Selection.Cells(1, 1).Row
cl = Selection.Cells(1, 1).Column
rcnt = Selection.Rows.Count
ccnt = Selection.Columns.Coun...
In this video we learn about worksheet CodeName, Sheet Index, Sheet Name, and ActiveSheet
MsgBox Sheets("New Name").Index
In this Video we use the Sheet Name Property to rename a sheet using the Sheet Index, The sheet Name and we also take the sheet name and place it in a Cell (even though we didn't get it right the first time)...
What is a vlookup in Excel? Why are there errors? In this video, I wrote a VBA macro that shows visually what a vlookup actually does.
So if you are have wondered why your Vlookup isn't working or why you are getting an #n/a error this video will help....
In this Macro Monday Challenge copy a sheet and name the sheet while stripping out any characters that sheets don't like.
Name = InputBox("Enter Sheet Name", "Sheet Name")
Name = SheetString(...