Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Variable

Variable

ResolvedVersion 2003

Sun 26 Jul 2009, 12:23 Delegate Danielle said...

Danielle has attended:
Excel VBA Intro Intermediate course

Variable

Hi there

I am trying to create a macro and it keeps de-bugging at this point. I am trying to select the whole table of information. If I hover of the IntNumRows it says it = 0, do I need to change the value of the IntTargetRow from 2 to 1?

IntTargetRow = 2
IntNumRows = Sheets("JPY TRADES").Range("A2").CurrentRegion.Rows.Count

Please advise as soon as possible.

Thanks
Danielle

Mon 27 Jul 2009, 10:47 Trainer Anthony said...

RE: variable

Hi Danielle, please see my reply to your other query for some suggestions on this.

Anthony

Mon 3 Aug 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips

Variable

Variable

RE: variable

Access articles

Access tip:

Switchboard Startup