Hi there,
I am having a "Subscription out of range error" on the last line of the below code snippet. Am i using the wrong syntax on that line ?
Thanks
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Usually I figure out vba stuff with help, but since it's missing and i don't have admin privelages, here goes:
Want to make a little 'macro' hooked on the change sheet procedure to change the co...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10314854.html
Zones:
Visual BasicDate Answered: 03/21/2000 Rating: 6.2 Views: 0
Hi experts,
I have an Excel spreadheet with this content in column A:
location Berlin
some text in this cell
<empty cell>
1. Joe Doe
2. Bill Gates
3. Michael Jordan
location New Yor...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_203...
Zones:
MS OfficeDate Answered: 06/20/2002 Rating: 6.2 Views: 0
Hi
I have a wish list for a particular macro hope soemone can help me
I need the macro to look at the area highlighted look in column F compare the name in this column to a sheet name with a co...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_206...
Zones:
MS OfficeDate Answered: 05/26/2003 Rating: 9.0 Views: 0
I have an excel spreadsheet. I would like to add a combo that will show the list from a column from my excel sheet. Example: When a user click on th ecombo box, I would like that combo box to show ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_206...
Zones:
MS OfficeDate Answered: 05/20/2003 Rating: 7.2 Views: 0
The question pretty much says it all. More detail : I have a spreadsheet that will house time critical info. I am running some macros automatically every two minutes to sort data and do color codei...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_208...
Zones:
MS OfficeDate Answered: 01/18/2004 Rating: 9.4 Views: 0
I have macro1, macro2 and macro3. I want to create a button to chain the execution of the 3 macros. Thanks.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 02/17/2006 Rating: 9.4 Views: 0
Product Name: Office Excel 2003 VBA Macro
OS: Windows 2000
I am attempting to create a function that confirms whether or not a range name exists. The problem is that the range name to be con...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/2000/Q_22637323.htm...
Hello all,
I am creating a Macro on Excel, that extracts the data from each tab and paste the data as text on a new Book. The problem I have is that when you run it VBA records the Book number ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_22686724.html
Hi experts,
i have a problem with a vba macro in excel! Some entries from column "A" and "B" shell be filtert and added to column "D" and "E"
In column "A" and "B" there are entries like this:
...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23174219.html
