Home ยป With statement
Learn
Excel Macro: Using Regular Expressions
Sometimes, Excel's built-in find-replace function doesn't meet our needs, and this time you can consider using regular expressions in Excel. To use […]
Learn
Excel Macro: Bulk Insert Pictures in Cells and Resize Them
Think you have a price list to send to your customers, you need to insert multiple product pictures in Excel, of course […]
ImageMso Office RibbonX Editor IRibbonUI.ActivateTab method LineFormat.Visible property FillFormat.UserPicture method Shapes.AddShape method IsEmpty function Shape.Name property Application.ScreenUpdating property Workbook.Path property For Each...Next statement With statement If...Then...Else statement Dir function
Learn
Using With statements
The With statement lets you specify an object or user-defined type once for an entire series of statements. With statements make your […]
Learn
Excel Macro: Limit The Number of Times a Workbook Can Be Used
Suppose you want to send a demo file for users to check, but you don't want it to be used more than […]
Workbook.FullName property Kill statement Workbook.ChangeFileAccess method DocumentProperties.Add method Choose function MsoDocProperties enumeration Workbook.CustomDocumentProperties property Workbook.BeforeSave event Workbook.RemovePersonalInformation property Workbook.Close method Workbook.Saved property Workbook.Open event Workbook.Save method With statement If...Then...Else statement On Error statement
Learn
Excel Macro: List All Files in Folders and Subfolders
This Excel macro can list files (include hidden files) in a specified folder and subfolders, or files with a specific extension. Get it now!
Docs
With statement
Executes a series of statements on a single object or a user-defined type. Syntax With object [ statements ] End With The […]
Learn
Reference cells and ranges
Programming with Excel VBA: The method of reference cells and ranges. Take this free course now!