Sometimes it is very necessary you get the last Column or last Row of your dataset in Excel This is a simple VBA code to get the Last Column and Last Row in your dataset
|
1 2 3 4 |
Sub lastRow1() lastRow2 = Cells(Rows.Count, 2).End(xlUp).Row End Sub |
What the above code does is that, we are using the Cells object which takes ROW and COLUMN
We can use Visual Basic codes to automate some reports in Excel. Below are some simple codes to do this. First this is a batch file to open our Excel report called “data report.xlsm”, assuming the report file is in the same folder as the batch file. You can schedule the time this batch file is
This is a simple guide to create and assign a “button” to your simple VBA code. Credit to WiseOwlTutorials. You can check him on Youtube Let’s create a simple VBA code in a module A simple code like this will do for our example
|
1 2 |
Sub NameIsNanaKofi() Worksheets.Add Range("A1").Value = "My Name is Nana Kofi"End Sub |
Now let’s create an object Click on the Developer Ribbon
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs
You can see how this popup was set up in our step-by-step guide: https://wppopupmaker.com/guides/auto-opening-announcement-popups/
