Excel VBA

Get flash to fully experience Pearltrees

http://www.your-save-time-and-improve-quality-technologies-online-resource.com/vba_string_function.html

Using a VBA String Function

In the first column, Expression, is the variable called Result that we are "watching."

http://www.excelitems.com/2011/01/use-offset-function-dynamic-range.html

The OFFSET function is a kind of lookup function in Excel that allows us to find a value in a table based on a particular reference point.

How to use OFFSET Function? (with Examples)

Range is one of the most widely used objects in Excel VBA, as it allows the manipulation of a row, column, cell or a range of cells in a spreadsheet. There are many properties and methods that are shared between Range and Selection objects and below are some illustrations (my choice of commonly used identifiers):

Excel VBA - Free online reference guide (Range & Selection Objects)

http://www.excel-spreadsheet.com/vba/rangeselectionobjects.htm

Excel/VBA Golden Rules. These Should NOT Be Optional

http://www.decisionmodels.com/downloads.htm

This page contains the FastExcel example problems and Excel Add-In files I have written for Excel 97, Excel 2000 and Excel 2002 . The Add-Ins are contained in ZIP files to simplify the download. The FastExcel samples download is approximately 1.5MB (approximately 8 minutes at 28K).

Excel Downloads - Decision Models

VBA

Excel VBA Reference

The Debug.Print statement displays the values of variables, or cells, as they change during execution. The Immediate window is used to display output from Debug.Print.

http://www.mrexcel.com/forum/showthread.php?t=8276

I have a row of data,and wish to countif from the 1st entry to the nth where n is a variable dependent on other calculations. I can display the range as text but if I reference the tect in the formula it doesn't like it I have tried T(),Text(), Value() etc but it just doesn't want to know. FYI the formula for the range is ="B"&ROW()&":"&ADDRESS(ROW(),BJ4)where BJ4 is the value n (when n=9 this formula in row 4 gives B4:I4 my data is in Row 4 from B4 to ad4)

Excel, variable range for a countif() formula - MrExcel Message Board

BBC News - UK student wins Microsoft Excel World Championship

Rebecca Rickwood - "I couldn't believe it" "I heard my name read out in first place and I just couldn't believe it.

http://www.bbc.co.uk/news/technology-14401766

Back to: Excel VBA . Got any Excel/VBA Questions?

InputBox: Collect User Data/Input via Excel InputBox in VBA

Anatomy of a Good Thread Title

Announcements - EXCEL HELP

http://www.ozgrid.com/forum/announcement.php?f=8

http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm

Optimize Slow VBA Code. Speed Up Efficient VBA Code/Macros

Sub NoCalculations() Application.Calculation = xlCalculationManual 'Your code here. Application.Calculation = xlCalculationAutomatic End Sub

Excel VBA. FREE Excel VBA Code & Excel Macro Help

Excel VBA Frequently Asked Questions and Answers An ever growing list of popular questions and answers on both Excel, Excel macros and Excel VBA

Declaring Variables

VBA Select Case – Using VBA Select Case Statement in Excel | Excel & VBA – da Tab Is On

The VBA Select Case Statement is an important construct in the VBA language. The Select Case statement in VBA allows the program to execute one set of statements out of many based on what a given expressions evaluates to. In today’s post we will look at some basic and intermediate ways in which it can be used when writing VBA code.

Prevent Users Ctrl Break (ing) Your VBA Code During Execution | Excel & VBA – da Tab Is On

Anytime I write VBA code that runs for more than a split second, one of my worries remains that someone will ctrl + break it. You see, I am a very strong supporter of P.E.T.A. (People for Ethical Treatment of Algorithms) and believe that any code, no matter how long it takes (or in my case how badly written it is), must be allowed the dignity to complete.