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 |
- How do I open Access database from Excel
- Dynamic Named Range count
- avoiding VBEopen when using CreateEventProc
- How to avoid re-initialisation when Unloading form
- Add and rename a worksheet
- Listing of Face Id's...
- Error after last object in the array when looping For...each
- using default excel screens
- How to build dialogue boxes into macros
- Programmatically switch off "Variable declaration reqiured" in VBE?
- Macro: If
- Excel and VB6
- Range object
- Speed up performance for very big array
- Random number generation from a set of non-sequencial values
- CurDir
- Ensuring a cell is copied in text format
- Problem
- newbie questions
- how can one obtain the current selected cell value
- Code Still Does Not Work
- combobox events
- General question about using "worksheet" when select from the VBA Editor?
- usings contains in var check
- How to create a dropdown list of dates with validation?
- Saving to the desktop w/ VBA
- How do I save to the desktop across OS's?
- ActiveWorkbook.SendMail Security Warning
- please help with FORMULAS
- link from one workbook to another workbook
- Print Orientation Toggle
- Re: Strange window behavior
- Run-time error 1004
- Double prompting of an over-write confirmation when saving a fileof the same name
- Default Page Breaks
- Will their be a fix for KB 818808 ?
- Using Multiple User Forms to pass info from one to the other
- Cell Reference to a location
- re-organising a table of data
- Copying over Rows Once
- please need help : collecting data from different places.
- Subscript out of Range Q
- Closing Other Workbooks
- Returning checked Nodes from Treeview form control
- Exiting Design Mode
- Intersection?
- Open event to call procedure ONLY on Monday
- macro attached to workbook: to be sent to other users
- Multiple Users
- Looking for eloquent solution: Determine of any control on a page of multipage has been altered (userform)
- Sum active range
- How to ungroup a set of controls?
- Listbox column headings
- Populate and refresh
- Not equal to?
- Command button on a protected worksheet
- how to lmport a text file and save it as an excel file using vb s.
- Web Queries - bypassing "no connection / data available" messages.
- how do I log events
- How do I log everytime an excel workbook is opened?
- How to "bypass" run-time error '91'????
- finding the first blank cell and then executing rest of macro
- disable listitem
- Macros not running
- this is about excel programing
- Date in an excel form
- How to clear a form from the screen
- Values from another workbook
- Excel closing event of a specific file
- Populate selected Cell with variable
- Database ready
- complie error
- Put a button in a cell
- Sheet Code Module: copying code to
- ?thisworkbook.VBComponents(5).Type returns 2
- FIFO: Share calculation in VBA?
- access from vba
- User Form
- Replacing Named Range Names By Cell References in Formulas
- Add Macros to Someone Else's Personal.xls
- Storing text in an array
- External Links Problem
- MSComm locking up Excel
- splitting worksheet into multiple workbooks
- Floating Toolbars
- Custom button, code placement
- Scripting Excel - EXCEL.EXE refuses to leave task manager after .Quit and =Nothing?
- Drop Down boxes
- Read image from excel file
- Return an array of values from a function
- Excel instance not shutting down
- Monitoring Changes
- Formula Help Again
- populating data from excel into access
- Formulas
- Command Bar with Number in Name
- Custom Toolbar
- Move an object not using increment property
- Re: Strange window behavior
- Excel object - save as csv from Word?
- Creating & Naming a New Worksheet
- Re: how to run other program's macro in excel?
- Re: Read about excel - word integration?
- Inserting Cell Contents into a header
- RE: how to run other program's macro in excel?
- Determine application language in Excel 97
- RE: Problem caused by Googels personal index software!
- RE: Strange window behavior
- RE: Extra projects in VBA editor?
- how to stop program in a big loop?
- Selecting AutoFilter Rows
- Picture
- Autofilter Properties
- How to Kill Excel application process
- Excel 2003 bug? VBA custom menu disappearing
- Get a workbook to import data when openeing and export when closi.
- getting back to excel
- Find Excel path
- weird saving of a document with macros resulting with macros being transfered to the copy
- Menu updates, Administrator VS limited account
- Saving the activecell range for later use
- OPening worksheet
- Locating Latest Workbook
- Last Workbook in A Folder
- Web query for pictures and maps
- Changing Workbook Property
- Calculate Individual Sheets
- Unable to Run Code on Specific workbook
- Code line not calculating correctly
- Late Binding to Outlook from Excel: Outlook modifies email body
- Problem with code
- setting an excel file to read-only
- Forgotten Password
- Changing color in palette
- Workbooks within a Folder - B-Lists
- VBA auto filter question
- Transform xsl file to xml file programmatically
- CXomparing Job Numbers
- Need assist with setting cell values from an addin subroutine
- Teaching VBA programming
- Line numbers
- Sum of value in cell range between 500,000 to 1,000,000
- wildcards in tab. names
- QueryTable OLE DB with Parameter
- Activating Custom Menu
- MACRO TO SELECT A PARTICULAR SHEET!
- Clearing Form
- VBA array - find largest element
- Run-Time Error
- Capturing deletion of a row
- Re: Searching an Entire Workbook
- Set Print Area
- run time error 1004 naming a sheet
- Problem with Dynamically Writing Event Procedure
- Looping
- Help with if statement
- Move cursor down, skipping hidden rows
- recording macro to paste a copied ws formula
- how to use the divisibility condition in excel with 'if' statemen.
- Button doesn't work
- Whorksheet Calculate Event Q
- Does Workbook need to be open to copy to..from vba
- Type mismatch?
- Summarising data
- Error Handling with Web Queries
- Declaring variables (Long, String, Integer) and interpretation spe
- Between dates table lookup.
- Check Boxes?
- How can I default to Paste Special?
- How do I make toggling shortcut keys for superscript and subscript?
- PageBreak Problems
- Excel XP: How to make a reference to a library persistent
- Web Query to database
- Points measurement problem
- Running excel as an application
- refresh application.caption
- No zero in a cell
- getting the sheet names present in a work book????
- Can someone give me a simple macro to sort a column?
- Make this paste_into_word code flexible to unknown office/word version >97?
- VBA WorksheetFunction problem
- Prevent Column adjustments?
- Option buttons in Excel to perform formulas in a several Absolute.
- Macro Secret Key Code/
- How to use Subtotal in VBA
- S Curves
- How do I add a reference to an object library using VBA?
- ADODB Recordset Function
- HOW TO send data to another program and get back results in Excel?
- How do i wrap text in a merged cell in excell?
- Background task
- Two Questions?
- Filters on Data Validation
- SaveAs and Hidden Workbooks
- Checkbox - Center Horizontally and Vertically
- I cannot use Assign macro in Excel. Could before but not now. A.
- VB Code Remains In Memory
- return used letters in a range function - an example
- Web Query running in backg. -how to know when data retrieval compl
- Opening 4 files with 1 button?
- Simple Thing
- How do I turn off macros when programmatically opening a workbook.
- Access 2000: Print Database name in Report footer
- analyzing poll data
- public sub
- VBA simple one..
- Characters bad when exporting asp.net datagrid to excel
- ActiveSheet.Paste error in XP
- Code Repeats Itself And Goes To Wrong Focus
- Solver
- password userform
- common functions:where to put them?
- Dynamically Assign Objects to Form Objects.
- VBA excel programming
- Highlighting the active row
- Count function for two specific items in vba
- WorkSheet Present
- SaveAs Concatenation
- Validation List Box Locked
- Compare Size of 2 files
- Populate combobox
- update independent column on pivot table
- Getting data from sheet stored on LAN
- Auto update function in VBA?
- Need help similar to a histogram
- Macro to combine cells
- Newbie at mixing ADO and Excel
- Can this be done
- IF Functions for Text in Excel 2000
- Sort More than 3 criteria
- Listboxes on worksheets
- Excel Problem
- Bulk-Delete All Custom Commandbars
- Re: Excel Problem
- Returning true if a number fits between a range
- Inconsistent error
- Excel page breaks
- automatic copy and paste from sheet to sheet in a workbook
- Dynamic naming of worksheets
- Use a variabel
- "If Not.." crashes
- When to use screenupdating?
- Solver32.dll missing
- Find first cell in column's used range
- Copying ThisWorkBook Events
- fatal error
- Application.Match Type mismatch error
- How to select range of cells
- Trap a find error
- get cell.address question
- Cursor Movement vs. Range Reference
- Delete "Cut" row on move...?
- printing pictures in excel with VB
- Calendar
- Searching for text or numbers in textbox
- Error Setting Excel's Application.Left Property
- Are Excel Macros Adversely Affected by inserting an Object in a ce
- Excel query object
- protect embeded object
- Writing a conditional formula to Search with number ranges
- Listbox Selection
- Wrong reference showing up as missing
- Is it possible to validate date in Visual Basic Editor? If so how.
- ComboBox properties---need to recognize comma's in numgers
- How can I prevent users from deleting an Excel toolbar from a work
- Need help with Treeview control ??
- merging worksheets onto one
- percent increase
- Listing Sheets
- date
- MkDir and Save As
- lock cells
- How do I set up a macro using relative cell reference?
- userform
- Compile error?
- Compile error?
- Odd problem with charts... narrow!
- Data Validation Range Question
- Change Cell automaticaly
- Collection methods
- Programmatic addition of form elements relative to a cell
- Personal XLA not appearing on Worksheet Menu bar after Excel Start
- Update Links Popup
- Check if form is open
- Compiler Error
- Importing to Excel from an Outlook Form
- VLookup Recalculating Every Time - Help
- Format
- Protect certain cells
- "Pick from list"
- Excel 97 shared file
- Switch() causes strange ADO result
- trying to populate a variable from a combo box
- Excel Export Script
- how can i turn functions written in VBA into an addin?
- XBRL in Excel 2003
- Personal Macro Workbook
- stuck on division
- Bring forward conditional formatted characteristics
- Copy worksheets without any code
- How do I print hyperlinked files when selected from a check box?
- Selecting Multiple Cells
- User input formula variable
- Debug VBA
- Add Checkbox programatically to form
- Copy data from excel into a web page.
- List Formula Macro Needs Enhancement
- macro ...if command, I suppose...
- Get the properties from a closed file
- Creating a recordset over a range
- Unique lists
- Excel Calculation Issue
- Find the occurrences of the particular word and appear one time
- Storing various data in .ID property
- No duplicates
- Stop on variable
- How do i find the last entry in a column where every cell is not .
- Excel taskbar
- Formula
- Delete row depending on size of Characters in cell
- Business Budget - screen Printing
- Filter between dates
- budget template, screen printer
- Code Module to Add In
- Multiple firing of macro from ListBox
- Combo Box
- Please help
- How to source data from multiple worksheets in a PivotTable?
- VLOOKUP cannot find numeric values
- Worksheets, Ranges & Unknowns
- Delete LOCAL named ranges
- Turning a Macro into an add-in for Excel?
- running-total formulas written from one spreadsheet to another
- excel macro inconsistency
- printing selected sheets
- Using Solver with VB6 Excel Object
- How do I register Grid32.ocx
- TODAY'S DATE PLUS "BUSINESS" DAYS
- Running a macro on mulitple files
- Subroutine works but can it be improved?
- Save sht as text file - problem
- Workbook_Open() will not run
- Links using XLODBC.XLA not working after upgrade to 2003
- using RANGE object in multiple-area range
- Contents of an array
- verifying data type
- Error when running macro
- How do I total data in a single column and then chart off of that
- Can't assign a textbox to object
- Can't assign a textbox to object
- FINDING LAST CELL IN A CALCUALTION
- Found Files
- how can I open a password protected document through vb?
- If Then Statement
- Variable Manipulation
- Adding tool tip to worksheet button
- Advances one Record when I tab...
- how do I subtract 2 date fields to get number of days elapsed?
- Cell Hyperlink - text, screen tip & link from other cells
- [Newbie question] Returning an array from a function
- Syntax for Range Reference
- Linking workbooks
- password protect vba code
- Calling a Private Sub
- Form development question
- Problem exporting as csv file
- Querytable refreshing on a protected spreadsheet
- Excel/Lotus Notes
- Recorded Macro to Set page breaks generates error.
- Macro
- Pivot table with form elements
- Mail Rounting, Need help quick!! I'm under the gun on this.
- Code to Save HTML table as xls file on click
- UserForm Value
- Userform for data pull
- Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend?
- Summing
- Excel Macro to edit and delete one character in a cell
- #Name
- UserInterfaceOnly on startup
- How to create Excel, Access and dbf output files from DataSet usin
- Inserting a function
- Move text after delete
- help on deleting several rows at once
- Compile error: Can't find project or library
- Setting chart series XValues in foreign language
- sum by currency
- DisplayAlerts = False fails
- How can read object order by useing writing?
- Array problem
- Closing excel with a macro
- "Clone" cell formats between sheets?
- How to action on Open Sheet
- Delaying until Recalcu code is done.
- How do I export excel data to an html file?
- Directory listing manipulation
- Want Excel Hyperlinks to reuse browser window
- Dynamic Arrays
- Identifying the Active Fill Color
- Problem copying a range to a different workbook
- autofill same number to end of file
- Populate 2-column ListBox with 2 non-contiguous columns
- Copying a cell one at a time
- Copy cells with certain info
- Recognizing a whole number instead of a decimal
- open password protected Excel doc
- Selecting rows
- help need on VBA code
- User Tools in Excel 2002 vs Excel 2000
- the sum of cells of many sheets
- E-Mailing Execl via Outlook Express
- VB code to make Excel open in a specific worksheet
- Switch from Office 2000 to Office 2003 error
- Importing from Outlook
- Importing from Outlook
- Updating records by status based on a formula.
- Using one subform to control another subform
- Unable to set the active cell from within a VBA procedure
- Macro to append onto and then sort a pre-existing list
- multipage tabs off?
- reformat contact data
- How do I hide a shell command called from VBA in Excel
- Can't resolve external reference on Excel 2000
- linking 3 rows into one
- setting up multiple timekeepers with multiple rates by period?
- find (exact match) ?
- Create a Named Range in Excel with VBA
- cell addresses selection for chart source
- Dynamic ComboBox
- Driving me nuts! Row Height, Cell Width
- HELP - Have two lists and #1 needs #2's contents subtracted from it
- Excel Code
- Mail merge does not show leading zero in Zip Code
- message property
- Write the result of a formula only once then lock it
- Reference to IE - but none found?
- End Of File - For use in Formulas
- Force standard chart size
- worksheet function?
- How can I compare a list of strings, allowing positive matching b.
- Log File CleanUp
- clearing memory /clipboard
- set variable once
- Help with Find
- Auotomating "Sort" in Excel
- Change Caption of Forms Command Button
- LOOKING AT THE FIRST PART OF A CELL
- numeric value
- How To Pull Access Query into Excel (2003): Reposting
- extracting certain text
- Can I set up a worksheet as read only for one user
- find last row of data
- Sorting Excel object?
- Convert Excel into a CSV file automatically
- Instance of Wizard excel add-in
- VB code in excell
- Selection vs Objects
- SIMULTANEOUSLY adding rows in two sheets
- Get VSTO code to run on every launch of Excel
- How to store additional attributes for a cell
- Macro Needed To Find Product Cost In Another Sheet
- Removing a link to another workbook
- Seamlessly regroup values for multi-sheet calculations?
- Determining Language Version of Excel
- Re: Project still in "project explorer" window after file closed down!
- Add Check Boxes to Many Cells
- Test if application running?
- Hide a sequence of rows
- Excel Version in which file was created
- how to average this?
- How do i save as a textfile in a macro?
- Conditional Product
- lock cells after save
- Path/File Access error: "VB3B.tmp
- thumbnail
- Array element
- Activecell Offset
- how to clear memory stored in the variables?
- Update fields?
- How to add more fill colors to Excel?
- Simple Table
- Variables not recognized
- Works if I single step
- hide columns based on header macro
- Not filtering by date
- Not filtering by date
- Additions&Removals
- Cannot set HorizontalAlignment Property of the Range Class
- Can't find Macro code
- How do I switch focus from a modeless user form back to the excel.
- How do I insert a page break before each change in the cell conten
- PivotTable Object - Unable to get the name property
- Cell formatting question
- VB code to open Print window
- Can I run an external program?
- Help Needed - VBA If statement!
- Determining and presenting unique entries?
- Need to save/write ranges to a workbook
- Help Authoring and Excel Conversion
- indirect addressing? a range of cells
- Help Needed - VBA If statement!
- looping through selected sheet tabs
- Clearing ClipBoard in EXCEL
- Help Needed - VBA If statement!
- HELP WITH CHART - COMPLEX ONE
- Delete Digital Certificates
- Help Needed - VBA If statement!
- Help Needed - VBA If statement!
- Help Needed - VBA If statement!
- Common Data in Add_In
- can take a look at my code?
- builtin dialog box and arguments
- row height
- Problem Dropping data in first Empty Cell and across the row
- can a userform pass an argument?
- Identify product not found
- changing the currenc setting of a cell or range
- make severaly workbooks 1
- make severaly workbooks 1
- Excel, VB.Net and shutdown
- cannot find code
- xlDialogs(xlDialogSaveAs)
- Macro Help
- I cant use englisch function names in a swedich version of excel
- how to simplify this process?
- Clearing Memory
- all caps to lower case
- Combine records from 2 tables whenever there are matching values .
- How can I create a spreadsheet...
- Unable to set NumberFormat property of the PivotField class
- Unable to set NumberFormat property of the PivotField class
- populating one list/combobox based on the results of another
- Order Form Template
- change tab color base on cell value
- how to do the conditional formatting for this?
- Open workbook object
- Use VBA to copy a chart from the internet?
- Re: Return a random letter
- Going down until the data stops....
- What's the Difference Q
- Opening Excel from Access
- Re: Processing non-contiguous row selections
- Named Range to Array Oddity
- RUN a macro based on a value selected in a drop down box in a shee
- How to Rename a Blank Sheet that a macro Creates
- Excluding cells in custom TREND function
- Mirror a workbook
- Combination of data out to two worksheets
- I need to find a macro to find data cut and paste to another colu.
- can anyone help me with this?? Thanks!
- Books on "how to" program macros in Excel using VBA
- Re: Find text numbers
- Project two - Diffrence Sheet
- Find text numbers
- Help with code
- probing the serial port for data
- Fomat change
- Problems with ADO from Excel
- SaveAs Question
- Save Workbook (Blist) as today's date
- Multi-Column Listbox properties
- Launch a VBA macro with opening a file
- Using multiple worksheets to keep track of changed values?
- Insert lines when x<> y
- Module update
- Wht is this Code not Working ?
- Wildcard for numeric characters in filename?
- fphover.class not displaying in Explorer 6.0 when XP SP2 is instal
- How does one return a specific cell in a web query?
- how to sort data this way??
- How do I set up a Conditional Alarm to ring a bell when a conditi.
- Copying Range from 1 sheet to next
- convert dates stored as text to dates
- How can I find the last time a custom function is called ?
- Can Paste-Special-Values be VBA programmed?
- Can "Home" key be VBA programmed?
- Automatic Lookup/Fill-in
- Macro to Copy Cells
- UserForm with ListBox
- How can I change size of the picture without changing chartobject?
- How do I Format a cell to make 1=$3.00 per cell then total?
- Insert word from dictionary
- just broke up with girl friend we had puter together
- How to check if an object has a certain property?
- Disable Save and Save As
- Selecting Menu Item by VBA Code
- How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation
- #NUM checking
- How can I involve in Rotary member of International?
- Command Button’s ‘back color’
- Can't find "stop recording" toolbar to use relative references
- Re: Change datalabel font size for all chartobjects in a row
- Name Check Box in code
- Add-ins and Reference library
- Perplexed
- Excel Copy and Paste into Outlook e-mail
- Re: Text Box Format
- Tell OS to refresh?
- Userform Code
- Importing text file
- How to specify a range in VBA based on values in cells
- How to increment number using vb script
- Re: Select Case syntax
- VBA VLOOKUP Question
- Function to return a previous cell value
- Excel crashes when using CreateEventProc towards CodeModule
- how do you insert a drop down calendar in excel
- Check Box
- combo box
- VBA Code issue
- VBA Project Explorer
- drop down menus and repeting
- ThisWorkbook.Protect
- Dynamic Ranges Q
- Disappearing Cursor - please help
- Excel Trend Calculation
- change existing values
- Input Date Error Message
- Re: Need help with Word macro
- Searching in Two Non-Continguous Columns
- Create new excel worksheet
- Create new excel work sheet by increment 2 on 3rd character
- What does 'Set rng = Range("Database")' do?
- Command Button Issue
- Re: #Ref! Returned
- seperate the character and number in formula
- How locate connection information for web query?
- Change .txt file to .xls
- New Excel Add-In for Analysis Services
- Beginner at VBA
- How to work around arrays...
- Find value, copy, compute, and more
- Copying formulas in a Macro
- Learning Visual Basic Books
- Check Box Show Hide
- Force recalc of formulas saved as text
- If Neg Number in a cell
- Auto Sum cell above a relevant reference cell
- Determining a combo box by code
- Where is the autosave function in Excel 2003?
- I need to split a name / last name cell into two different cell.
- VBA AddIn reference in Excel X for Mac
- function to calculate area under curve
- Copying data relevant to the position of a cell on another sheet
- choosing files using an excel list...
- Uniqe list
- I need to split first & last name cell into two different cells. .
- Reset Security Level with VBA?
- UserForm_Initialize()
- Performance problem with VB Macro in Excell XP
- Workbook_Open
- Newbie needs macro help please
- Can VSTO handle a Picture click event in Excel?
- Can I call my .Net functions from Excel Macros
- For/Next using Thing
- TypeLib Information Problem? Pass a Function's parameter names as string for parsing?
- Problem Text Format
- export chart - what controls exported chart width
- Convert text with special characters
- A loop to delete
- ListBox Prroblem
- Database connected Excel sheet on Web
- Locating a value anywhere in a row and copying that row to new she
- How to sort the data?
- Can VBA be used to clear the recently used file list?
- Re: printing a union of non-contiguous cells- help!
- Re: printing a union of non-contiguous cells- help!
- Design time events
- Clipboard
- Select Distinct Items in a Column
- Re: Fill down formula programmically
- Displaying form on startup?
- Re: Visual Basic Help
- Userform
- Re: Return a random letter
- Re: exporting to file (switching comma's and points)
- RE: Auto Refreshing - values
- Update function
- Modifying Chart Series Attributes Insights (Color, Marker Type, Et
- Weird Problem: Excel SaveAs--> document not saved
- "Do not send fonts to distiller" work around found!!!
- Updating Exclel imbedded in Word once for both documents
- Re: how to sort data?
- Database
- Check for open workbooks
- Run-time Error 40036 on ActiveSheet
- Lost Visual Basic Project and Invalid File Format errors
- VBA/VLOOKUP Error Message
- Formatting a cell calculated by a VBA function
- Workbook Open event does not fire
- Putting Cell contents into a TextBox?
- Too few parameters. Expected 1.
- Find first cell in range and expand range -VBA
- Checking for Duplicate Data in Worksheets
- Create filename based on cell contents
- List box multi
- How I can to Use False in Vlookup?
- Is there any way to reduce excel size which is 2.4 mb now?
- de-activating OLEObject
- using INDIRECT in array formulas
- Data format issue for Graph
- conditional formatting odd/even rows
- list boxes
- Saving Workbook with Variable
- setup a range based on a variable
- Need to write a program to open a filename...
- Macro to update based on format? (Currency)
- Copying and Pasting.
- Clearing Option Buttons
- Calculated Error Bars?
- Excel Formatting with VBA
- conditional counts across columns
- Print merge an Excel document with three worksheets to WORD Docume
- IRR
- OfficeLinks in XLXP?
- hyperlinks without screen tips
- Template won't open as a .xls in Excel 2000
- How to preserve state of View->Toolbars?
- CheckBox in userform
- Can VBA clear the Temporary Internet File folder?
- Determine current default fill color
- how do i freeze columns in excel 2000 ?
- Error message when opening file
- Summing top 8 marks + display
- Setting colors for Controls
- Grouped sorting
- How can I do it??? (OnAction with CommandButton)
- VBA Excel Autofilter Question
- Open Event
- Macro to run or not run a second Macro
- VBA - Disappearing custom menu and custom toolbar
- Call Not Working in Excel 97
- ADO to get data form closed Excel
- How to run a Macro depending on a result of a cell
- Cannot move nonblank cells off the sheet
- column insert error
- Excel 2003
- Find a value in the collumn and then in that row
- Auto Refreshing: data retreival from webpage
- Help Please
- fORMULA IN aUTO FILTER
- Enter VBA Code Password
- vLookUp. Works Manually but not by code.
- checkbox dilemma- need larger checkboxes
- RTD Getting The Focus
- use macro to append records to worksheet
- Problems with ChDrive and ChDir
- Checking for duplicates: VBA
- Excluding sheet from group of selected sheets
- printing the list of wroksheets in a workbook
- Multiple "if" criteria
- Adding ALL Digits in a Range
- Quick name deletion line required
- 3 cells are named together - how refere to them in one chart reference field (a seriescollection(1) )
- VAN et TRI sur excel (formule fi)
- Remove Automation class
- Deleting names with errors
- Duplicating worksheet by VBA
- Prompting 'Save As' in an Excel Macro
- VBA Newbie: Help with Do Loop code
- textbox.caption question
- Read only notification
- VBA - Syntax filename rangename for vlookup formula
- how do i calculate a running total in a single cell in excel
- Excel 2003 macro
- Need help with Transpose paste special
- Display Worksheet ASP page pop-up
- Permutations
- Follow a hyperlink
- Hide selected worksheet tabs
- open OQY file from http:// folder
- Microsoft Excel 97 Developer's Kit
- Some worksheet returns NULL for CodeName property. Why?
- Auto-Replacing Blank Fields
- Freezing sheet names
- Work around for limit on entering array formulas?
- Print Preview moves command buttons
- In Excel, how can I store and append to a cell value as inputs ch.
- Detect if a command bar is enabled in View->Toolbars
- Needing ideas on how to do this
- Problem sorting 2-D array
- File Object in Excel VBA
- Summing rows
- macro to operate in protected cells
- How query a disconnected ADO recordset - possible?
- Combo Box - Hide Combo Box w/Check Box
- Adding nodes to treeview
- Is this possible?....
- Mouse Over Graph, Capture Information on Click(Double Click)
- Code to insert data from another workbook
- Date ranges and advanced filter
- How do solve window explorer error
- Graph Data Range not fixed
- Access security and excel external data
- How to set up a formula that will give me both positive and neg. .
- How do I use environment variables in Excel?
- Find a variable
- protected worksheet
- protected worksheet
- convert IP address to XXX.XXX.XXX.XXX
- convert IP address to XXX.XXX.XXX.XXX
- can I use autofilter with an equation
- Excel SUMPRODUCT, but matching like COUNTIF
- Edit Macro for GOTO Part No.
- summing cells
- selecting and deleting a row based on a cell value
- Timing of automatic query refresh and macro pivot table refresh
- Excel launches in a separate window
- Two Problems
- List Tool Bar
- Unhide
- Closing Graph9 from vba
- Re: Not releasing workbook reference.
- Open Dialog Box to return Selected File Path and Not Open it.
- RefEdits and normal forms / forms in a DLL
- Goto a control element
- auto entry from one worksheet to another
- Change graph's source data via macro
- pivotcell
- Date
- Project Locked
- Hiding rows
- Select all cells NOT in a range
- VBA to Save a file to a different format but keep original
- Excel File Size
- VbOk not responding
- Quotation Template that gives options for each item
- Shell Command : Extremely Frustrated
- MS Query report
- how to synch VBA Moduals between PC's
- Simulating HTML frames inside a Excel application
- Rookie q
- Very special
- Simple For-Loop gives 1004 error using variable to EntireRow.Delete
- Transform macro
- Running Macro in Excel
- shell command running very slow
- AutoFilter
- Run-query error
- Trying to eliminate multiple copies of the SAME code within a UserForm
- DDE command for INSERTING ROW above a below a specifed row no.
- How do I specify an existing procedure to run from a control adde.
- Saving file with text and csv
- Interaction between worksheets
- For/Next with an If statement embedded
- Re: copy / paste formula to last row
- Re: protect worksheet against cutting
- Excel 2003 Menu Bar and ToolBars
- Loop down rows to first numerical character
- Show or hide rows when text is bold or italic
- Shell to different app then open file within
- entering data on another sheet
- Combobox change property
- Using SeriesCollection.Extend for a specific Chart Data Series
- how do I reuse c# code in excel VBA module?
- Worksheet.activate question
- Where can I find the preset color index numbers for Excel?
- sort problem
- Weirdness
- Can Excel tell me how many rows are populated via a functions?
- How to add a command button and on-click within vba
- Code help
- determine if a file is an excel file
- Validate a date
- Can I issue a File, Send To, Mail Recipient command in a macro?
- Using ADO to access another workbook
- Changing format commanbar
- listbox list
- Hiding Rows
- Using formula problem
- Opening a template .xls with VBA code
- Challenging project for you!
- Export specific cell data to txt delimited file
- Programmatically manage pivot table.
- Saving User Selections made on a Form
- import text file
- Filtering Values using a Combobox
- Can't select macro button after other button is pressed
- Query SQL Server
- Solver - won't run Macro in Step Thru - help
- command button
- Moving data from multiple columns
- optionbutton takes two clicks to change value
- Re: protect worksheet against cutting
- vlookup in VBA
- If Statement
- Export asp to excel Format number
- Weight Watchers Point Calculator script
- PivotItems.Count is 0 when items are visible on the sheet
- Convert text into Excel
- 462 The remote server machine does not exist?
- Addin opened but not loaded
- ChDir - Specify Folder
- why my date shows up as 12:00:00 AM?
- Code Problem
- UNSAVED: VBAProject
- Creating a counter for printing
- Challenging long ARRAY formula needed - Can this be done?
- list the sheets in a workbook
- UserForm including TextBox with date (UK format)
- [Interops] OutlineLevel and Hidden property
- Temporarily override sheet protection
- Open Workbook in current directory
- Start Excel and run a macro on a given filename?
- The Select Objects button
- Spreadsheat object
- rounding up for number not for decimal
- Help with Similar MOD Function Please
- Simple programming help for newbie
- Cell Colour
- How to auto response the dialog
- automated data entry to a s/s
- delete repeated rows
- using MS fingerprint reader with Excel
- Second search within primary "Find" gives error ?
- Using Excel for organising a seminar
- Newbie question - regarding function parameters
- Macro Similar to Mail Merge help/question
- Findcontrol for submenu item?
- Test to see if a cell is within a range
- Copying forumla into another Cell.
- Overwriting existing data in an Excel worksheet using ADO.Net
- manipulating Excel checkbox from VB based exe
- displaying ranges
- how do i find a Excel programer for hire in my area?
- (Today) function can you make it stick
- Overwriting existing data in an Excel worksheet using ADO.Net
- List Box
- Protect Worksheet
- Workbooks and worksheets.
- convert Excel to "Text Only"
- voice recording option on excel
- Double Listbox
- how can I do this without actually putting into cells
- Excel-Finance book coauthor
- Getting subsets of data
- spinbutton?
- Buy Programming Books
- Excell files showing "Read Only" access denied
- re-order worksheets by sheet name
- Compare cells using real time streaming data
- Userform CheckBoxes
- Help with Search and Replace
- Add-In Shortcut key
- cell movement
- Checking & installing references as part of on_open
- VBA Formula Syntax
- Macintosh and VB Scripts
- RE-End of Page
- import files
- Excel crashes on exit
- Accessing external test equipment using Excel
- Reading content of array formula
- Export CSV; first three rows contain record map
- Check Boxes and Conditional Formatting
- Conditional formatting
- Changing the default printer...
- Stepping through cells
- Event 1001 & 1004
- I need a spreadsheet to plan a for sale real estate develpment
- I need a spreadsheet to plan a for sale real estate develpment
- How to force current directory
- Check for empty cells in Print Area?
- Workbook Open event
- End of Page
- Superposition error in Dinamics Tables
- conditional formatting - for Expert and Gurus
- message box
- Web Queries Truncated
- Saving Workbook
- range * constant
- Need help using VBA in excel.
- Charts not showing or printing.
- vlookup problem
- relative address in validate
- How to change windows.arrange from xlTiled to xlHorizontal and back in one procedure
- Another Quit problem
- Leave the Cell unchanged
- waiting for click on the button
- Invalid Qualifier???
- Change text to date
- Saving Problem Excel 2000 with VBA code
- copying cells into different rows in different worksheets
- Saving a worksheet without empty rows
- VBA Hyperlink calling ASP page
- Secure excel spreadsheet
- SQL Query
- help - how to move cells into an array using criteria
- Duplicating a cell (EXACTLY)
- resequence worksheet index after deletion of worksheet
- Pivot Table Field's Item Listbox
- Programatically Creating a Hyperlink Using VB.Net ?
- Check if name exist in a list
- yyyymmdd date format
- Filling Blank Cells
- Display range of cells
- Workbook_BeforePrint > performs twice ?
- Union of Ranges Failed
- Problem with VBA code trying to query and access database
- vlookup function
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.