User login

Support's blog


javascript open excel

Ok, Here is how you use Javascript to open Excel.

Try the following code and get it going.

======

Break Excel VBA Password

1. Create a new simple excel file.

How to enable grouping in protected sheet

Many in times we are faced with a situation where in we want to enable groups in protected sheets.

How to do vlookup Using VBA?

If you want to use any Excel function in VBA all that you need to is to use "worksheetfunction" statement follwed with the name of the function.

VBA function?

This is going to be a quick tutorial on how would you go about creating a VBA function.

Finding the Last row on Excel sheet with VBA Macro

Below is the quick VBA code which you can be used to return the last row on an Excel sheet.

How to find last row in an Excel sheet with Macro VBA

I am sure, many a times you want the VBA code to automatically find you the last row which is blank in a particular worksheet.

Loan Calculator excel sheet-calculate payments for upto 360 months

Please find attached your Loan Calculator sheet.

Learn How to use VBA uBound in Excel

Ok. Lets assume we have a variable called MyVariableTest which is of the data type string.

below is the code...

--------------
'Code starts below

Sub uBoundVBA()

Code to List All Named Ranges in a Worksheet

The following code will list down all the named ranges in an Excel Worksheet.

Code/Templates/Informaiton provided on this site are without any liabilities. Owner of this website in no event will be held reponsible to damages resulting by using the code/templates/applications/
Copyright © 2003 xlMacros.com - Learn Excel VBA
Microsoft Excel is a U.S. registered trademark of Microsoft Corporation

Excel for Dummies
Spreadsheets for Dummies