1. D

    passing sheet address to subroutine

    what is a correct way to access a open workbook.sheet that is currently open when linking to a subroutine or a function? ie.. i open two workbooks in the main routine and the based on a condition in the main routine i link to a subroutine. I can't figure out how to read a value on the open...
  2. A

    How save/use Subs from central storage

    Hi, I want to save my different subroutines which I use in some tools at a central place, so when I update them I have to update only the subs in this workbook. I put them in a workbook and add this workbook in the VBA ****pit under references. No I have access to the scripts in this central...
  3. O

    Excel Limitations for Large Macros

    Hi All, I'll try to make this as brief as possible, but please let me know if I haven't supplied enough info. I have a project with approximately 19,000 lines of code (I'm assuming that's large but have no frame of reference). It has multiple buttons that launch subroutines to find specific...
  4. P

    Passing 2-dimensional arrays between subroutines

    I cannot seem to get this to work. I want to pass a 2D-array from a subroutine to other subroutines in which a data manipulation should take place. I am calling below subroutine from a command button on Sheet1. In Module1 I have declared the variables as public. Inside the subroutine...
  5. M

    output vba sub names

    Hi, I have a vba program. How can I create a routine to output the names of all the subroutines into the excel worksheet? Thanks
  6. S

    Executing a Subroutine on a cyclical basis using time as a condition for execution

    Greetings, I am interested in building a subroutine that imports external data from using a web query on a cyclical basis, one day, one week, one month, or one quarter. I would like to know if anyone has experience in doing this and if so how might be best to structure the block of code that...
  7. S

    UserForm General Structure

    Greetings, I am somewhat new to userform objects and how best to structure elements within the userform etc to allow for smooth operations. I have many textboxes, listboxes, a few buttons and whole lot of variables. Let me describe the structure I am trying to build... First, I have a...
  8. S

    UserForm and VBA Subroutine Integration Brainstorm

    Greetings, I am trying something new and wanted to share my ideas and get some feedback and potential resources that could improve results before I jump into construction of userforms and subroutines. I would like to build a tool that is GUI friendly using Excel Userforms and VBA subroutines...
  9. B

    Debugging my formatting module

    So I don't know what's going wrong with my code, it's just designed to automate a formatting task that I repeat often at work. I've put comments in for all the subroutines to explain them but basically it finds the used range, borders it, formats the headers, uses select case to find specific...
  10. H

    Extracting and sorting data from a strand in VBA

    I'm trying to take a strand, extract some data (connector type), and sort that data to determine which comes first. For example, given the strands VS IM SC LC SM DPX PVC 2LBL and 5m FDDI ST 62/125 MULTIMODE FIBER I want to write "SC" AND "FDDI" into a column called "ConA" and "LC" and "ST" into...
  11. S

    Parsing variables between subroutines

    I'm doing something which is probably foolish - namely taking some vba that i've written that works and trying to make it more technically correct by using subroutines. It doesn't need it as it is fast enough as it is but i'm a perfectionist and if it ain't broke don't fix it is about to become...

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
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 "".
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