View Full Version : Excel Programming
Pages :
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
31 |
32 |
33 |
34 |
35 |
36 |
37 |
38 |
39 |
40 |
41 |
42 |
43 |
44 |
45 |
46 |
47 |
48 |
49 |
50 |
51 |
52 |
53 |
54 |
55 |
56 |
57 |
58 |
59 |
60 |
61 |
62 |
63 |
64 |
65 |
66 |
67 |
68 |
69 |
70 |
71 |
72 |
73 |
74 |
75 |
76 |
77 |
78 |
79 |
80 |
81 |
82 |
83 |
84 |
85 |
86 |
87 |
88 |
89 |
90 |
91 |
92 |
93 |
94 |
95 |
96 |
97 |
98 |
99 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
112 |
113 |
114 |
115 |
116 |
117 |
118 |
119 |
120 |
121 |
122 |
123 |
124 |
125 |
126 |
127 |
128 |
129 |
130 |
131 |
132 |
133 |
134 |
135 |
136 |
137 |
138 |
139 |
140 |
141 |
142 |
143 |
144 |
145 |
146 |
147 |
148 |
149 |
150 |
151 |
152 |
153 |
154 |
155 |
156 |
157 |
158 |
159 |
160 |
161 |
162 |
163 |
164 |
165 |
166 |
167 |
168 |
169 |
170 |
[
171]
172 |
173 |
174 |
175 |
- Opening excel attachment
- Range selection problem
- How can I avoid form destruction??
- Copying Problem
- Protect a few sheets
- How to disable Keyboard shortcut
- Efficient Search / Find
- Out of memory error.
- Out of memory error.
- Out of memory error.
- Wrong data format in columns ... What's going on?
- How to use Microsoft Calendar Control 9.0 on a Userform
- how to determine which checkboxes are checked
- SUM Formula using code
- Re: Linking cells in two separate sheets
- Re: Linking cells in two separate sheets
- VBA "Save As Text" Routine?
- Re: Find a Value and not a Formula
- transpose absolute references
- VBA -- procedures as arguments?
- saving
- Re: For loop for Checkbox
- Re: For loop for Checkbox
- Re: Programing a macro to pause while running for data entry
- Excel Automation - Chart Performance
- Virus Warning
- Newbie VBA Help Needed!
- password VBA and need for Macro
- Multiple ComboBox linked to Outlook and Interlinked
- Inserting A Row Into A Data Table
- Writing an Excel Spreadsheet via a program's output
- Multi-User Access to a worksheet
- Macro search replace question
- Simple textbox question
- Excel skip some lines of VBA code
- excel web component get data from spreadsheet for post
- Determining Row Number
- Set Excel to not automatically convert text to date
- formula is to long error
- Find/search function/example request.
- Finding a Duplicate using Vb
- excel
- Excel formula in macro
- change page margins at word through excel
- Macro that controlls duplicate values
- attach to email
- Re: insufficient resources
- Re: File save as
- Distributed Spreadsheets
- Add control to commandbar
- Canceling a UserForm
- Insert rows
- Re: Excel conversion
- visual basic command in a cell??
- Re: can't read KB articles (font)
- IsEmpty and Is Nothinq problems
- log files
- Tracking down functions in use (Excel 97)
- Re: VLOOKUP in VBA
- Command Button vs Form Button
- Advanced Filters - improve performance ?
- Returning the "You replied to this email on.." property from Outlook
- passing strings
- Re: call a sub with arguments from Worksheet_FollowHyperlink event
- Re: ComboBox List
- Re: ComboBox List
- PASSING A STRING VALUE
- Macro-Run-time error '6'
- how to set scroll area
- Excel 2K Com Addin DLL in Excel 97?
- Re: Splitting a Procedure
- Re: VLOOKUP in VBA
- Re: Setting a Solver constraint using vba?
- Read embedded word document by VBA
- Re: Setting Print Area, includes text, numbers, charts & graphs
- Re: Splitting a Procedure
- Updating Pivot Tables
- Splitting Procedures
- Run method for subroutines
- Problem Using an Object Variable in a Class Definition
- Problem with Multi-Dimensional Array
- Re: How to insert Excel Worksheet Name using Automation in VB Dot Net??
- Re: Changing Option Button Value
- call function
- syntax of changing file attributes
- Bold (an easy one)
- Conditional Max value
- Re: can't read KB articles (font)
- Modifying Relative Addressing
- Providing for Applicaiton Update
- Re: Calendar in UserForm
- Re: Can VLookup refer to a cell with a range name?
- VBA help doesn't work: Stuck with resize cursor
- Re: Can VLookup refer to a cell with a range name?
- Re: SaveAs needed if new
- changing a cell value in a different sheet from several sheets
- Re: SaveAs needed if new
- typing in a number and converting it something else
- offset
- Re: popup message window
- Re: Problems with german excel version
- variable cell into range
- Finding latest transaction and seeing if it is over a year old.
- Add controls to UserForm
- How to provide sample workbook?
- Re: Make tools button grey
- Problem - Workbook_BeforePrint
- Could this code be faster?
- put a calendar on an excel sheet
- Accessing the values of form controls on worksheets in Excel 2000
- Application Installation ! Urgent
- Re: Problems with german excel version
- Excel Remains Active in Windows Task Manager
- Automatic Date
- Re: Hide & Copy
- VB Excel Automation Error
- Passing Data to Outlook
- Minimum time per interval
- Re: How to hide sheets and VBA code in my Excel workbook?
- VBS script for Pocket PC
- How to hide sheets and VBA code in my Excel workbook?
- Re: print listbox contents
- how to add code programmatically to a macro for a button
- Set Print Area = Image??
- Re: Scanning & .chk extensions
- Function to Find Duplicates
- Rookie VBA'er seeks help!
- Automate open file, update links, run macro, close and save file
- Excel version compatibilities
- How do I set the value of a textbox on a userform to the value in a named cell?
- Re: Call a macro or sub based on the name of a cell?
- Simple goal seek macro
- Re: Sorting in a ComboBox
- Networking problems...
- Re: userform question
- Re: Autofill Indefinite Range in VBA/Macros
- Excel Workbook opened twice with dotnet interop
- Re: Excel crashes with createEventProc for a button
- Autofill Indefinite Range in VBA/Macros
- add to two dimensional array
- Date Formulas
- join location string with variable
- Text following an Outlook field insertion
- Manipulate Excel
- Re: Call a macro or sub based on the name of a cell?
- Excel in SourceSafe ???
- Temporarily delete ALL CommandBars?
- Rounding parts of a number while maintaining the Total
- Make Spreadsheet Time out
- Excel's Hyperlinl
- macro needed
- Array Help
- MS Query
- Automating Excel on a Server
- =clean(a1)
- deleting the rows depending on the result of a condition involving two columns.
- Re: VBA and Passwords?
- Object Variable or With Block variable not set?
- Re: SendKeys
- Re: example
- Print dialog
- Re: strange problem For Each loop in Treeview
- Workbook.SaveAs
- Set variable equal to a cell value & more
- Excel Macros
- Re: strange problem For Each loop in Treeview
- userform question
- userform question
- Excel VBA misbehaves on web???
- REQ: Simplest way to parse (read) HTML formatted data in via Excel VBA (or VB6)
- Inconsistent code
- Re: Excel crashes with createEventProc for a button
- Re: Subroutine call without file reference
- Cut and Paste after Auto FIlter
- concatenate a date
- import text-file - strings contain cr-lf
- Re: XP comments
- Re: XP comments
- Re: Make tools button grey
- Macro to Sort Automatically Based on Contents of Drop-down Box
- Open Folder
- Copy Data
- Re: Copy data
- Re: Open Folder
- Command buttons not available
- Second instance of Excel
- Synax for two IF conditions in VBA
- Remove password
- Excel 97 "Find" metod
- Generic Command Button Response
- macro use of "find" command
- How to get the active cell address?
- Find finds nothing, and errors
- Opening Multiple Workbooks
- Database refresh crash
- concatenate
- Displaying info
- Open excel workbook in access
- Code to not display delete sheet alerts
- Re: Excel crashes with createEventProc for a button
- Method 'Range' of object '_Global' failed
- VBA Keywords
- Data Validation
- SaveSetting/GetSetting: not high-overhead?
- Popup message window with name
- Automating email using Lotus Notes
- Macro which adds new spreadsheets
- Search by Date
- Project Elements as One List
- Bringing Excel to the front
- Renaming VBA module
- Code in ThisWorkbook crashes Excel
- Re: Copying rows from one file and pasting into a new file
- Re: Paste special problem
- Re: Memory Issues
- Macro For Filtering on Multiple Sheets
- sheet.range.sort with ordercustom
- new to VBA
- VBA to read spreadsheet's filename?
- Run time error '9' Subscript out of range
- Re: new line at sheet textbox
- Why won't this Excel 2000 code work for Excel '97?
- Basic Email Help Excel 2000 Req!
- Using data from Fomulafind dialog in Find Method
- VB6, Excel, Win Version conflicts????
- XL Query. Urgent Please help.
- Re: VBA - Application-defined or object-defined error
- Can Range.Find search a Cells' Text property?
- Subtracting times.
- Sorting/Adding certian cells
- faster macro
- Re: VBA - Application-defined or object-defined error
- Linking cells to another worksheet
- Visual Basic Range variable
- Disable update links dialog box
- VBA - Excel issues
- Using Application.WorksheetFunction.Ln(...) in VBA
- Need to Find End Value of a Column with Unknown End Range
- Re: mail
- Another Newby question about selecting and what it can do [longish]
- Excel 97 File Name is Saved as a Number?
- Re: Charting Problem VBA
- Dialog Box Confirmation Selection
- Hiding print dialog box within macro
- Excel
- HasComment?
- Help with some code please
- Scanning for Duplicate Data in a Column, Merging Data and Finally Removing All Duplicates...?
- Help for formulas/layout?
- List variables in worksheet
- Listbox/Form question
- Pulling and Pushing web page data
- excel 97
- Yet another Newby question about selecting
- Re: Copying rows from one file and pasting into a new file
- Sorting a list of names for updates
- Easy question: macro to move cursor one to the right
- Summing a variable sized range programmatically
- Execute a macro when the contents of A1 changes
- Personal.xls in the startup folder must stay open for recording
- Extreme Interview with Anand Bhatt kyuVzL
- formula for days in month - days left???
- userform
- 64kb limit to module code
- Why does this formatting macro not work?
- Menu entry with check?
- Create a Databse using VBA
- Case statement in variable range
- Printing and Document Name
- Traverse treeview bottom to top
- Personal.xls Question
- Enable/Disable Macros
- Comparing Values for Sorting
- Advanced Filter
- not pulling down formulas
- month to number
- Flatfile.xla
- ComboBox and select item
- Popup Massage Windows
- Prompt User to Enter Data with a macro
- Re: Create a formula into a String then assign string to a cell
- How to Save Custom Icons?
- Simple way to input dates
- Macro changes the format of dates
- Re: File from an Informix database to import into Excel
- Excel Web Query - SSL 128 Bit
- Re: insert picture into worksheet cell
- Exiting Excel without being prompted
- Re: Exiting Excel without being prompted
- Input variables on Sheet1 being called by a VB program on Sheet 2
- Excel VBA Code Execution Excel XP Vs Excel Office 2000
- SIMPLE MACRO!!!
- OnTime running 2 subs
- Hyperlink Bug
- From my Addin, referring to activeworkbook's sheets by their codenames
- Object not supporting property or method
- problem using ActiveSheet in VB sub
- Automatically runing a macro
- Re: VBA Calls
- Enter text in cell Code
- Personal.xls
- Formatting
- Pass Variables into Form's code
- Memory Leak using ADO 2.6
- Finding spaces cells
- Re: problem editing Word document with VBA from Excel
- checking if workbook is open before accessing
- Minimize a form
- Find method example
- Protecting VBA Code
- Copying into new spreadsheet
- Wow
- Error message
- Hiding null sums
- Read embedded word document
- Re: SUMPRODUCT Problem
- Saving a File Generates a Sequential Number Name
- Userform-List box help
- Re: Changing security level
- Re: Screen Refresh after minimize
- Re: Changing security level
- Re: Changing security level
- Creating HTML files in VBA
- VLOOKUP
- For chip about scroll
- Re: Is there a way to ReName a Sheet Using a Drop Down Menu?
- Template Wizard w/ Data Tracking 97-->XP
- Combobox list source
- Date update on data update
- Active X not updating properties on Excel Sheet
- XL 2000 Template Wizard - help
- Setting Decimal in code
- Re: SUMPRODUCT Formula
- Automating entry using validation
- Pivot table filter list doesn't refresh
- Excel to Word Font Size
- Multiple users running macro from personal.xls
- Shapes.AddPicture run-time error
- Codename equivalent for Series
- Excel 2002 Compile Error ?
- Re: deleting rows in a non-continous range
- Hiding VBA code
- Dates
- Progress Indicators for Dummies
- Lookup formula with date test
- Wildcards
- Compiling Multiple Spreadsheets to One
- Re: ScreenUpdating automatically resets to True
- copy/paste VBA
- Re: HOWTO Replace from Row
- Re: Customizing print preview window
- Cursor Location
- Re: Assign Macro not showing up
- Problem width width-property
- Re: HOWTO Replace from Row
- Application error 1004 with a twist.
- Changing Save As Type in Save as dialog box
- Re: Charts & Graphs on Userforms.
- Opening Excel files in cascade through VBa
- Re: Delete row from range using key column
- Re: Create and Array formula using range names
- Code that runs each time AFTER a sheet is cut off the book
- HasComment ?!?
- Re: Error about ExcelApp.Workbooks.Add
- Re: Send Keys
- Choose diagram
- Run time error '1004'
- RE: Word Document that shows Excel Chart
- Problem with TAB key and Textbox controls
- date time picker error
- Combining Cell into One
- Re: Assign Macro not showing up
- HTML in Excel VBA
- VBA read/write registry setting
- VBA read/write registry setting
- Re: Type Mistmatch Error
- Re: Automating Excel Cell Drag and Drop
- Re: Intersecting addresses from two sheets
- Re: Keyboard Macros
- VBA to Element Based XML
- Re: deleting rows in a non-continous range
- Re: checkboxes lose value in Excel
- Re: Can I find what ver of IE is running via VBA ?
- Re: Test to see if a worksheet exists thanks, Chip
- Macro error why?
- Re: month to number
- Re: month to number
- Regex Question
- Open program with Application.Quit?
- Un-usable Icons
- macro written in Excel 2000 not working in Excel 2002
- copmapre and rank cells
- Task scheduler question
- window control
- Subtract 7:00 pm from 7:30 pm
- Open a text file and get the info
- Re: User form with a listbox
- Subtract 7:00 pm from 7:30 pm
- Re: Subtract 7:00 pm from 7:30 pm
- Re: Retaining Defaults in an InputBox # 3
- Re: Subtract 7:00 pm from 7:30 pm
- Attaching Macros to Custom Buttons
- Programming Ideas
- File Location code
- Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report"
- calculating averages
- how to send e-mail from excel
- Is there more efficient formula?
- Adding Data from EXCEL to a TEXT file
- Print Macro
- Re: An error on the error :)
- control scroll position
- Re: combobox change
- Re: month to number
- Re: Protect UserInterfaceOnly in Shared Workbook
- Re: Protect UserInterfaceOnly in Shared Workbook
- Re: message box program flow
- Method ~ of Object ~ Failed.
- Evaluating new project idea
- Re: Link macro to a toolbar?
- Re: How to check if SHEET has QUERYTABLE property ?
- Re: month to number
- Counting entries
- Re: iterating through all properties of an object
- Re: Send Keys
- Re: month to number
- Coding to check for a sheet name and add it if it's not there
- Re: Cascading Deletes across multiple sheets
- a lot of "ExternalData" Named Ranges
- Re: Protecting Macro's
- Re: Protecting Macro's
- Re: Intersecting addresses from two sheets
- Re: Send Keys
- Is there a floppy disk in Drive A?
- DAO objects with late binding in Excel?
- Outlook and Excel Integration for Contacts
- Re: how to make a help hint for my function made by myself.
- Re: Excel functions/formulas
- Workbooks.Open closes other workbooks
- How to present User with Print Options
- Re: Numerical accuracy in Form Text-boxes
- Range COPY function - how to copy VALUES and not formulas
- Saving a Workbook without code
- Position of Message Box on screen
- Figuring out what the Shape Indexes are.
- Re: Automatically Determine last row and column
- Re: Macro to edit cell
- sort method frustration
- Re: sum (column 2 of namedrange)
- Automatic Numbering of Sorts
- Is there "SourceSafe" for Excel VB Macros?
- Re: Cancatenate string
- Adding TrendLine
- Re: Writing to 2nd worksheet in workbook
- Finding cells and summing variable cells
- Cancatenate string
- Re: placing dialog box for showform
- How do I create a Worksheets object
- Toolbar Button
- Comparing 2 worksheet
- Read Value fom Closed CSV file
- Keep userform visible, but return control to calling routine
- VBA read/write registry
- HOw do you save a file using a macro?
- Re: Another ISERROR question...
- Autocomplete; and other
- Prevent user from disabling macros
- Re: Another ISERROR question...
- Stripping dashes from a number
- Re: Searching text
- Excel VB sub
- VBA union of two ranges
- Re: MyOval = ActiveSheet.DrawingObjects.Name
- Cell F14 F16 Required if F22 or F23 is checked
- Merge Imported Files for Output???
- HOW TO PROGRAM EXCEL SO THAT THE TITLES ON GRAPHS ARE AUTOMATICALLY CHANGED
- Program cell to delete other cell values
- Re: abc ANAYLYSIS
- NEED HELP PROGRAMMING EXCEL TO AUTHENTICATE EXCEL USER ID AND LICENSE NUMBER WHEN TEMPLATES ARE USED
- Can't see my worksheet in excel
- Re: Keyboard Macros
- ComboBox Default items Not Showing
- Update Links/Trust Macros?
- LEFT Function in Macro
- combine cells and preserve formatting of individual characters
- Re: macro to edit formula
- Store Value after Calculation
- Outlook and Excel Integration
- Re: Determining Active Row Number
- Properties Page is blank for check box Control, other controls
- Re: Code for Buttons (repost)
- Re: Input box question
- MS Graph - PowerPoint
- Field Required if another field is checked
- MDI Forms in Excel 2002 XP
- Re: worksheet protection
- Re: Text Box - Setting Values
- search for values to define range
- Determining Active Row Number
- Speed up password cracker in Excel ?
- Import Data from Access Database in a Workgroup
- Making cells so users can select them
- Calculating the first day of the week for the month
- subtotal function
- CONDITIONAL OUTLINE
- Listbox question
- User Form textbox formatting
- speeding up a macro
- wildcard character replacement help
- Search and find
- Excel 2002 - Multiplication
- Calculated value based on current line selection
- Combo box in excel
- Re: Macro or ActiveX for buttons
- Re: Exception HResult: 0x8007FA08 (VB.net)
- self-installing add-in?
- self-installing add-in?
- Re: Trim like worksheet Trim
- Re: Declare Multidimensional Arrays
- Copying Text vs. Numerical Values
- Re: Declare Multidimensional Arrays
- abc ANAYLYSIS
- Re: worksheet protection
- worksheet protection
- Re: Formatting a range based on contents of column/row heading
- automatic sort
- How to average up rows in Excel using VB6
- VLooking Reference in Combo Box
- Worksheet gets update from DDE server
- Sum & IF condition
- Re: Setting a required cell
- Setting a required cell
- Re: Setting a required cell
- ?
- List an object?
- macro to edit formula
- Re: Making Databases
- Re: Traversing Rows
- Updating .tag in Userform Control in VBA
- Re: Open Excel files in a folder
- Re: Open Excel files in a folder
- Macro in different books
- Separating Data
- Populatnig cells from an addin
- Re: Hiding worksheets based on user permissions
- Formatting a range based on contents of column/row heading
- Summing unknown number of rows
- With Sheets("Data_Assembly"
- Calculate No. of Objects on Floor Plan
- Search Problem
- Re: Clearing cell contents automatically
- Automatically Insert Rows
- How to make the drop down for comboBox visible in toolbar
- Change event for multiple checkboxes
- Re: Proper case
- paste selection??
- Re: Proper case
- Referencing one workbook in other???
- vb6 and Excel 97
- Re: Opening a spreadsheet using VB
- If;than (macro)
- merge data from multiple excel sheets into a workbook
- Opening a spreadsheet using VB
- Problem with closing the excel application
- Re: Opening a spreadsheet using VB
- range offset
- web query format
- Renaming within VBA
- SendMail error
- How to program a three dimentional table in excel
- Displaying CSV file with HTML tags in Excel 2002
- Re: Upper/Lower case problem
- Macro recording
- Re: Login Box help
- Starting Date of the Month
- Validating Excel
- F4 Repeat Default Restate
- Skipping protected cells
- importing data using a macro
- Re: Control Tip Text For Pictures
- Selecting Filtered Items from Named range
- Visual Basic problem
- Re: Looping Through A Recordset
- Re: Selective read data from ascii file
- Excel VBA Conversion
- Code and data part deux
- Unactivating
- Re: TextBox Coding Help
- Getting the formula of a cell as text
- VBA occur error - kernel32.dll
- Copying Formatting Without Selecting
- Drawing in Excel
- Re: UserForm with RefEdit Modality Issue
- TextBox Coding Help
- looping cells though a named range
- Code for Buttons
- Caption on Menus
- Problems with worksheet containing ActiveX controls
- Importing csv into excel and not retrieving all data
- Re: VBA TextPager / Email
- Use of IIF
- VB Editor doesn't "recognize" open workbooks
- Re: enable/disable macro's dialog?
- Web Query in Macro
- If Then Else Statements
- Re: message box program flow
- Import data from Access Data Base
- Detect Excel Version
- XL2000 VBA code to ACCESS 2000
- Adding text to a cell
- Column width in pixels how?
- The .xlb File That Wouldn't Die!
- message boxes and buttons
- Using the "Find"
- Mid$ Function
- Re: Look up number
- If/ then question
- Re: Get rid of this file contains macros box
- Access to Excel
- Re: Hide code from user
- Re: Using Workbooks.OpenText to read a tab-delimited file into a worksheet
- Save As command
- Can Excel VBA work outside Excel?
- How to limit the Number of rows in Excel sheet
- AutoComplete? Drop Down List? Please Advise
- read-only error
- Re: VBA TextPager / Email
- Picture with Macrto Assigned causes problem
- Re: Allowing formatting in lower versions of EXCEL
- Increase letter by one
- Listing all external links within a file
- SQL Statement Attaching to SQL Server
- Changing to Network Directory
- Re: Tricky Conversion Problem.
- Re: Contents of a file
- Re: How to copy text from a TextBox in a ActiveSheet to a variable
- Selecting the other open workbook
- Re: How to copy text from a TextBox in a ActiveSheet to a variable
- Saving combo box list when closed?
- Inefficient Calculation of User Defined Functions in Excel 2000
- Re: Can i set a reference programmatically?
- Re: remove close button
- Formula Returns #N/A
- Macro that hide or unhide and not calculate or calculate
- Re: remove close button
- Determine last col with data
- Re: remove close button
- Re: Hide code from user
- Re: Carriage Return
- Formatting zero results from a formula
- Re: Opening a UserForm
- Setting the Send to Value xlDialogSendMail
- Help with some code please
- How to copy worksheets with a user defined variable
- Re: Looping Through A Recordset
- Finding a range for Copying & Pasting
- r1c1
- Re: Visual basic for scrollbar feature
- Re: Populating a VBA UserForm
- Help! Inserting Rows
- VB Application for Advanced filter Macro
- Recognising '0.00'
- Re: Named Range
- error with setting "Items.Visible = True"
- Re: Named Range
- HELP
- Quick question - is there an easy way to find which row is the last with data?
- Enabling Add-In closes current sheet
- Visual basic for scrollbar feature
- Re: Converting VBA app to VB.net project
- Strange variable declarations
- Why wouldn't calling the Activate sub for a sheet automatically call that sheet's Worksheet_Activate() sub?
- Re: how to save the input of the controls in a form
- Need for performance boost
- Re: Dates
- Enable Macros with No Prompt
- VBA Excel Checking whether an XL file is already open elsewhere
- how to protect a sheet
- vb.net and excel xp
- Re: Data Validation Error!
- auto turn off macro virus protection
- Re: Converting VBA app to VB.net project
- for each cell
- get a sheet of a Excel file
- Inputing data ranges
- Addin in read-only mode problem
- Controlling random rows
- Advise, please, how to get the following macros working:
- Data Validation Error!
- Page Setup
- Date string question
- XL97 watch window hangs
- Help! Trying to recover macros from a file
- Converting VBA app to VB.net project
- Creating an XL Range on the fly
- How do I get a cell's row number
- Re: splitting text in two lines
- Hacking open password
- Re : Excel – Width of a Column and PointsToScreenPixelsX
- Summing a Range
- Conditional email sending
- Using VB to unhide hidden rows based on user response
- Excel & Outlook Integration - Urgent!
- Coping values to the next empty row
- Excel 2002 / XP - Running .XLS with Macros via Task Scheduler
- Re: Excel query creates named range
- help...too much copying and pasting
- attach macro to hyperlink
- Selection.End(xlDown) with Rows selected
- Re: Importing Userform in Excel 2002
- excel office templates
- Re: Unhiding Rows
- Selection.End(xlDown) with Rows selected
- Excel Range to Access Table
- change default for sort ?
- PATH Update; VBA problems
- Adding buttons and connect macro
- raw speed for excel worksheet functions? - xll -or com addin?
- Trap Excel events from VB
- Auto Close
- Mail multiple charts instead of multi. sheets
- Clearing list from all form commandboxes
- Find top of worksheet
- Re: Sheet Name Change Event?
- Re: Sheet Name Change Event?
- Can I use a login to let users see different worksheets?
- how do I create a login for a spread sheet
- How To Keep DropDown From Printing?
- DsoFile ActiveX component can't create object on other computers
- Re: Adding New Records To Excel Database..
- VBA update data from Internet Explorer and copy to Excel?
- ?
- log the values of a single cell
- How do I unprotect cells when using OpenText function?
- DAO query/recordset returns with field names
- Re: Adding New Records To Excel Database..
- Do I need programming for this?
- Popup Progress Indicator
- Re: 2 Dimensional Array
- Re: Triggering click event of a menu in vba
- Re: to Tom Ogilvy: re Macros in excel
- Re: Triggering click event of a menu in vba
- Re: 2 Dimensional Array
- Spinbutton Linked to Textbox
- SUMPRODUCT
- Hiding selected Row
- Vlookup Error handling
- Re: Accessing a "veryhidden" sheet
- deleting certain parts of a cell
- Web links in Excel closing workbook
- Re: Offset function
- Re: What are the System Tables named "Print Area" & "Print Titles"?
- Re: Unattended Macro
- Re: Run-time error 40036
- Re: comments
- Can't dynamically add withevents OptionButton to worksheet
- Limiting return on Excel Web Query ...
- How do I get series of files to open from same folder
- Re: Excel query creates named range
- Re: dates in a combo box
- Re: Enabling macros
- Re: Method 'ActivePrinter' of object '_Application' failed
- VBE calls Mathcad 8 in Excel97
- Excel Function
- Scheduling a Macro
- How can I open a named Word doc from an Excel macro
- Re: Colums and Rows to repeat in Printing
- Re: How to Limit No of Records in a Validation List
- Paste Special won't work in VBA
- Toggling one column of AutoFiltering
- Parametrized Macros preventing other macros
- Repost: How to Limit No of Records in a Validation List
- Formated date thru Input box
- VB Forms
- Data import
- Why doesn't it work?
- Simple VBA devision problem
- Worksheet name length
- Checking the last character is in a list
- Adding a additional column in to a sum range
- Userforms
- Create and Array formula using range names
- Retaining the default in an input box - again
- Switch to Access
- Excel VBA Macro
- Polynomial least squares fit
- Login Screen
- startup file
- Deleting/Replacing Values in a Range
- HIGHLIGHTING ROWS & COLUMNS
- Re: setting complex print area
- "Select Column method or property not available because some/all of object doesn't refer to table"
- [help] asp & pivotchart
- Footer (Update Date)
- Re: setting complex print area
- closing instatiated apps
- Re: PasteValue Without Selecting
- Re: PasteValue Without Selecting
- How do I convert a user defined selection into an array?
- Conditional compilation
- Re: Locking cells
- SQL Server 2000 - Pivot Table
- Code to put contents of A1 and B1 in header
- Reference? Question
- VBA & Excel memory usage
- value of a cell based upon column letter and variable for row#
- Re: Passing an Array of User-Defined Type to an Argument of a Function
- Re: Goal Seek (in VBA)
- Passing arrays to a subroutine
- Links
- Copying a block of data
- Listbox problem
- Sum Dynamic data
- Problem with copying variable(s) to cell(s) and converting strings to mixed case
- Returning data to excel from msquery
- Re: Return Col for best alphabetical fit
- Copy form and code question
- Football League Standing
- Scope of variable includes all Form _and_ Code modules??
- "Backing" up a Workbook Sheet
- The object invoked has disconnected from its clinets
- Exporting Text File
- Re: Copying formulas to new cell
- persist properties
- Re: web hosting for up to 10 domain names 7.00
- What does the me. preface do?
- file format
- unable to control screenupdating
- BuiltinDocumentProperties
- strange command buttons in fax preview
- A couple of questions
- COUNT SEPARATE PERIODS IN COLUMN
- Type mismatch error
- sorting in Pivot tables
- ThisWorkbook Macros
- Cross-Post vs MultiPost
- Need final code tweak
- Re: How do I return the values of a chart's data range?
- Re: step into process
- Entering a 30 digit number
- Merging 3 Columns in an Excel Spreadsheet (Keeping Data Intact)...2nd Post
- Annual % Increase - Formula
- SQL in Excel?
- Date Format
- please help
- Re: selecting multiple charts
- Re: Locking other Excel sheets from intermingling with my Excel App
- Re: Charts in cmyk/pantone colors ?
- [how to] VBA catching close/print in printpreview
- Earn $500 to $700 per Week Downloading FREE Software
- The path for any given Excel spreadsheet ???
- Re: Keyboard shortcut to insert a checkmark
- run excel macro
- Re: Shared file - macro error
- Pass file name from Spreadsheet Range
- Re: Checking for non-numerical content in a cell
- Chart creation ceiling in Excel 2002 via Chart.Add ?
- Scheduling by seniority
- Prevent dialog - Prevents Sending Excel File From Outlook
- Re: Working with a WK1 format...
- Downloading stock prices
- drop down menu
- Errors when copying a sheet
- EXCEL REPORT
- Re: Dropdown control as multiline
- Clearing a Column range in Multiple Workbooks
- changing sort for pivot table fields
- Re: Inserting Long Text in a Cell Problem
- Comments on this code to FTP save, please?
- vb.net vs studio.net
- placing dialog box for showform
- Custom Format
- Re: Keyboard shortcut to insert a checkmark
- Re: Opening questions
- Re: Keyboard shortcut to insert a checkmark
- Re: Exiting a workbook
- Method 'Run' of object '_Global' failed when changing OS and Office versions
- Disable Clipboard Dialog Box during Macro
- Re: Exiting a workbook
- Re: Logon to Worksheet
- opening and writing into notepad
- For Loop in Sub Detailloop
- Calulating the last sayurday of a week using vba
- CreateObject produces error
- Copy Formulas
- Detect whether a row is completely empty
- checking multiple sheets.
- Re: xlClipboard Clear Contents
- Do I need Excel installed to use excel objects from VB6?
- Re: Need specific values
- Retaining a default in an input box
- Automatic screenshot in Excel
- Re: Changing Excel Chart Size
- Keep running total of mult. inputs
- Re: API call to check other program is idle
- Question about sorting & subtotaling
- Determining cellcontents
- How do I get Pivot filter change event to fire?
- Re: How to change relative chart/pivotTabe ?
- Re: Inserting Long Text in a Cell Problem
- Re: Loop ends early
- Good code not working???
- alfabetical order in array
- Open XL2K without executing Macros
- Turning off all screen updates during a Solver routine
- Re: Sharing Variable Values Between Workbooks??? Any ideas?
- Re: Code to tell if workbook is opened in browser
- Array Size
- Programming Undo
- ComboBox Hell!!!
- VBA Function Version Comparison
- Beginner question about selecting a range
- Selecting or Activating a cell.
- Re: Closing Excel in VBA
- Excel's Marco Convert data to Access
- Re: Cannot Delete an ActiveX Control
- Rejected Safe Mode action : Microsoft Excel.
- OLE embedment of Mathcad 8 in Excel97
- Autofilter.Selection - After Change Event???
- Excel return error code
- Best Excel 2002 books?
- Re: Cannot Delete an ActiveX Control
- Can the user "Choose" the path via a VBA command?
- unactive workbook name
- VBA code or formula needed to identify certain records in a database
- Re: Quitting a User Form
- Re: VB.Net
- Range object failed - random error
- Permanent Variable?
- Worksheet unhide
- saving a ss
- Create an .xls file by script
- Re: excel/asp interaction - HELP!
- Re: Macro/Paste Special
- Re: Macro/Paste Special
- trapping click events on shapes
- Absolute reference in R1C1 notation
- Re: convert a string of into a date format
- quotes in formulas using vba
- Re: links to several xls with same named ranges
- rate of change vba
- Source Data Code Cleanup Help
- Finding Machine Identifiers
- Re: Inputing Data
- COUNTIF() data type problems
- Re: Modifying Locked Cells... :-)
- Re: Modifying Locked Cells... :-)
- web query
- Trouble to sort an array in Excel using VBA
- Moving Data from one sheet to another
- Re: VBA does not open workbook
- Counter
- VLOOKUP and table_array link
- Can you Copy Objects from a Worksheet to a Userform
- Re: sumif ...
- OnTime method only runs 1 time
- Within Range?
- Re: Can't get out of loop at the right point
- Re: Can't get out of loop at the right point
- Vb.net - excel 97 automation
- Use XL as packet sniffer & log?
- Re: sumif ...
- Command to jump to last row in list not working
- Workbooks.Open for FtpFileSpec.xls with Password
- Getting the systems username
- Re: sumif ...
- Re: Command to jump to last row in list not working
- Auto Fill in Formula Per New Line
- force upate to datbase using save as
- Re: Selection Change question
- password char in input box
- Help with Sort
- Re: Merging or Adding two .csv files
- ungroup worksheets
- Re: Merging or Adding two .csv files
- Re: compile error in hidden module: Dialogs
- Re: Editing the VBcritical logo
- Searching for a words in a column from a list of words.
- compile error in hidden module: Dialogs
- Catch Update Linked Cells Event
- Disabling Toolbar buttons and CommandBar items
- Group Commandbutton?
- month calendar
- animation and message
- animation and message
- Excel causing
- Re: Comment Import
- Worksheet version of VBA JOIN
- Disable auto editor formatting
- Re: getting excel to recalculate on format
- Re: Save an image from a worksheet to a file
- Urgent Help! Excel's Marco Convert to Access's db
- Return value of excel when exit
- Selecting a constant changing Range
- Re: Copying formulas to new cell
- Why the DataValidation Code not working?
- SUMIF
- Re: Copying formulas to new cell
- Updating xlusrgal.xls on other PCs
- Re: Copying formulas to new cell
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.