Search:

Type: Posts; User: AnyOldName; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: How to Use a Variable to Control the Number of New Rows Inserted

    Yes, that works, thanks.
  2. Re: How to Use a Variable to Control the Number of New Rows Inserted

    The variable value will be read in from a cell value
  3. How to Use a Variable to Control the Number of New Rows Inserted

    I'm using this line of code to add 12 empty rows at the top of a worksheet

    Var_RawData_Worksheet.Rows("1:12").Insert shift:=xlShiftDown


    I'd like to use a variable to control the number...
  4. Single or Multiple Variables to Populate Message Boxes in Different Subs

    I normally use a string variable (Var_MsgText) as an input to message boxes but I'm currently writing my biggest piece of code to date that has multiple subs that all use message boxes. I don't want...
  5. Re: Public Variables -Can They be Referred to by Subs in Multiple Modules?

    Thanks, I thought I had already checked for that but I'd forgotten that I had some old code in a now unused module. It hadn't created a problem until I tried to use the variable in multiple modules.
  6. Public Variables -Can They be Referred to by Subs in Multiple Modules?

    I had hoped to be able to declare a variable as public in one module, assign a value to it then refer to it in other modules but as soon as I try to use it in a different module I'm getting "Compile...
  7. Re: Setting a Workbook Variable's Value from Another Variable

    Thanks for the welcome and the reply, that little section is working perfectly now. I'm pretty sure I'd already tried it this way as I had that exact line of code for setting the variable in my sub...
  8. Setting a Workbook Variable's Value from Another Variable

    Is there a way toset the value of a workbook variable from another variable that holds a string?

    I already have oneaction that does this by using ActiveWorkbook ,as shown below, but I have...
Results 1 to 8 of 8