subroutines

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

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

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

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

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

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

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

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

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

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

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