vba variables

  1. W

    variable variable based on other variables?!

    Hi All, If I wanted to state a variables value based on another variable, how could I do that? The two variables I current have in the script are Dim Red as Long Dim Green as Long Dim Amber as Long Green = Sheets("HURDLES").Range("C5").Value Red = Sheets("HURDLES").Range("E5").Value What I...
  2. H

    VBA how to clean Variables

    Hi I am writing VBA code to control powertpoint from Excel my code is Private ppt_2 As PowerPoint.Presentation my question is: How to clean\empty PPt_2 variable, set ppt_2 = nothing, closes power-point file and I don't want to close the file. Is there any other way to clean variable...
  3. A

    VBA, Defining the current workbook as a variable

    Hi All, I am writing a macro that starts in one workbook (who's file name will change weekly) and will also access a reference sheet on the network. The goal is to copy the reference sheet into the first workbook. In order to do this I'm using the following code, but I am not getting past...
  4. H

    Help with form variable user option

    Hello I am creating a time sheet workbook. I've figured out how to have the punches go to a table and a general journal, based on Start, go to break, back from break, go to lunch and back from lunch and go home. What I am wanting to do ... is have a seperate work sheet for each employee...
  5. B

    VBA global variable contents clear?

    I've inherited a large Excel application that cashes data retreived from an Access database in VBA global variable arrays when the application starts up. It then builds worksheets from scratch by adding a default sheet to the workbook and inserting all formating and data. All calculations are...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top