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 |
- Assigning click event to OleObjects checkbox
- VB Macro
- Re: cell copying
- Re: Named ranges
- Customizing buttons VBA
- Macros i xla-files get incorrect path
- help.. want write a simple marco
- execute a text as a formula
- Excel VBA, VBS and Network Security Issues
- Make this the active workbook
- Please Help!!!
- User Defined Function: Format Output
- Label, Text and Form controls in Excel 97
- Anybody see anything wrong with this
- Macros and IF Functions
- ctrl/shift/enter thru VBA
- Need help with userform....please....
- Secondary Axis
- Macro shortcut keys not work properly
- HELP With search
- Return value from calendar to a label...
- Re: hide print box
- Excel Coding Problem
- Adding a macro to a button.
- Re: Userform w/ Multiple listboxes that link
- Re: copy data range
- Exclude cells from calculation?
- Problem in SQL Query
- Loop Through worksheets
- Lookin Property.
- Opening workbooks in sequence
- How to find out country-dependent Format Codes
- Copy a macro
- Error handling in vba function
- Problems integrating Excel VBA application with frontpage
- Bold Msg Box
- MsgBox With Multiple Lines?
- Re: Problem in ODBC Query
- Error 7
- Creating worksheets and auto listing them
- Excel ComboBox
- Merging duplicate data across multiple columns
- How to Insert MSchart picture into excel.
- MultiSelect ListBox in Excel
- Bob phillips??
- Whats wrong with this code
- 'Esc' handling
- Can RefEdit Contrl be Used on a Modeless Userform?
- To: Paul B and Brian B
- copying data from csv file
- Print sheets in a worbook.
- Using Excel and Query--copy workbook
- Re: Macro Error Please help
- MAPS + Excel
- Re: Hide password in the InputBox
- Help: Looking for the replacement of RefEdit control
- changing a text value to a number value in a textbox?
- opening multiple excel worksheets
- OnKey trapping SHIFT+ALT+Spacebar? Possible?
- Cell colour
- File size increases by 300kb
- Calling of simple function in Excel 97
- Excel VBA: Renaming a workbook
- RE: Excel macro error when opened in internet browser
- How to save the Current Excel file to FTP server
- Automatically Answer YES for Pop Up Msg Box
- How to load a PDF using Excel VBA
- Can the X to Close button on a workbook be disabled?
- Control name values.
- Is there a 'frequency' function??
- Re: Worksheet and workbook name question.
- A newbie question re: Forms - Input and Output from an Excel Worksheet
- Populating a userform 3 col listbox
- Problem with this code
- Excel Conditional statement
- Comparing 2 Columns for duplicate data
- Re: Worksheet and workbook name question.
- Comparing 2 rows for duplicate data
- relative reference
- Protect/unprotect sheet with password with VBA?
- Run Macro every 30 minutes
- Function to lookup Counties in another list
- resize worksheet
- Disabling refresh data changed PivotTable prompt
- User cannot print form object after worksheet sent not as attachment
- Statement works in one scenario, not in other
- Range won't Unlock
- Chart Labels
- changing cells from function
- Get a cell's previous value
- Getting task response
- excel extensions
- Parameter Query executed from a Macro
- specialcells method errors when criteria not found
- Charts in copied worksheets
- Tab order with "enter" key on a sheet form
- how to calcurate work hours? Please?
- Database question clarification
- Images off of a worksheet
- Recommend Book w/ Good OVerview of Obejct Model ?
- Can this be done???? Please help!!
- Lookup
- Web Query/Cell Reference
- Truncate
- Is it possible to set a reference to a library in another file using VBA in Excel?
- texttocolumns
- create module
- Null date in VBA variable
- linking Worksheets
- create module
- Avoiding duplicates
- Copy filtered rows to a new worksheet
- Count by the Text
- Select and move range throughout workbook
- XL2k: ActiveX Controls on sheets.
- Locking spreadsheet
- SheetActivate event
- Converting hours & minutes to whole minutes
- Macro to bring up Other Program
- Error
- Adding to AutoComplete programmatically
- disable save
- Use XL 2 Edit a .txt File?
- insert selected rows problem
- Re: Excel "If" function
- Using Hidden data for a chart
- sorting a #name?
- Change Key Mapping
- Re: Excel "If" function
- Roll Once
- how view a WS code/properties
- Connection Obect for Two Paths
- Pivot Charts
- Confirm deletion
- Formatting times
- Pivot Tables
- Automation from VB - slower than from Excel
- pop up menu
- Please help with AddItem method
- saving fcell contents in a separate list
- Jumping back to a cell
- Special string formatting
- command bars
- Activate Other Workbook
- How to use TrimMean as an agregation function
- Making some rows uneditable
- Selecting a row with a variable ?
- Last column in selection
- Excel VBA - loop columns named AA, AB..etc
- Eliminate formula Query
- How to clear the contents of COmboBox?
- Copy sheet from addin
- inserting row...but the formula is not affected
- Adding a Timer Control
- importing access mdb in to excel
- last occurence
- Allocating "Don't Move or size with cells" property in code
- A couple annoying VBA add-in things
- List Box and personal.xls
- calling cells from other sheets and listing
- Excel VBA - Updating of data problem
- Problem with .Background Query option of ODBC Query
- Unwanted Double Quotes produced by Excel
- Checking for the Existence of a Folder
- Alter existing code
- Build macro to draw lines between multiple points
- Cell highlight
- transfer cell range
- Change the 'Read-Only' Access for Non-Shared Files
- Switching from InputBox to UserForm?
- How to URL-ize a string
- One more step...
- last piece of the puzzle...controlsource in textbox
- Database question
- VBA input box MSG
- Checking Entry
- Rounding Error
- Archive Macro
- extracting a subset of an array with VBA.
- extracting a subset of an array with VBA.
- Calculating days of week
- Adjust a Scroll bar to fill in a range perfectly
- Names
- Finding missing links.
- Please Help!
- Excel Programming in VB
- Programming to search for a cell with certain value
- Problem with auto count...
- Re: Programming to search for a cell with certain value
- Set dropdown programatically
- a program is trying to automatically send e-mail
- Assigning names to a route
- Copy-Paste Special-linking problem
- Starting VBE at EXCEL Start
- Random with Number And Probability [very long]
- Excel VBA - Userform Textbox Manipulation
- Validate Textbox entry
- Change fonts of chart legend - different results on 2 computers
- User forms
- Edit DialogSheets
- User forms - blank fields
- Monthview AxtiveX
- PIVOT Table Display
- Allow only 12 entries in a column
- Evil virus-generator
- simple excel formula
- Named Range cell content getting deleted
- Manipulating PowerPoint Files from Excel
- Error 1004 in Excel 2000
- Re: Convert from WrapText
- Re: Application.DisplayAlerts in IE
- Convert from WrapText
- Excel/SQL Query Quandry
- Excel is an evil virus-generator
- Help with Uninstall Event
- Error not trapped - please help!!!
- Pivot DataRange BackColor
- Hide / Unhide Dialog Box
- Print dialog code trouble
- How to get the activecell of inactive worksheet ?
- Replace destination cells
- Registering an OCX with VBA
- Help with Textbox formatting
- formula or method needed
- TCP/IP and Excel
- Re: barcode printing
- Worksheet_SelectionChange
- Chart placement
- add worksheet to group
- Manipulating Charts with VBA
- question about the ControlSource of a ComboBox
- Print the results of the combo box
- class modules beginner
- re-enabling macro under menu item
- Pivot Tables and VBA
- Visual Studio Tools for Microsoft Office
- test
- Mouse scroll wheel doesn't work in VBA
- Months and Dates
- Opening the modem ?
- Copy Paste Special Value using Code over Several Worksheets
- Visual Studio Tools for Microsoft Office
- why did the macro stopped working?
- A searching query
- Help!
- Newbie VBA Question; Deleting minimum value row
- unprotecting sheets
- Determining the Name of a Caller Macro
- Fetching a VBA Macro's Name During Execution
- Visual Studio Tools for Microsoft Office
- Getting data into Access
- Links and Chdir
- Selecting dates from ListBoxes by using RefEdit Control
- Copy Value to a Row with Date that is specified Query
- Learning from the masters
- VBA - running scripting dictionary (error!)
- VBA question - Set reference to run Scripting.Dictionary
- counting weekends
- Macro for LOTO Drawing!
- CorruptLoad param of Workbooks.Open
- Reading an excel file in SPSS
- counting filters?
- Text Conversion
- Re: Code is working in one file but not in another.
- Activesheet protection
- VBA question - autofilter combobox
- Percent Totals by Dynamic groups
- Chart on Userform
- Percentages by dynamic groups
- Search for subtotals
- Business Objects: Fad or Lifesaver?
- File Information??
- Tracking changes issues
- VBA question - Type Mismatch
- msgbox data
- VBA question - Calling txt file from userform
- Activate macro1
- Min & Max w/o formula
- Textbox change event
- Ghost image
- Subtotal Macro weird actions
- Determining the Selection on a non-active Sheet?
- returning Excel sheet with ASP
- date and time questions
- More Toolbars questions - 2
- Maybe this isn't possible to match name and copy?
- More toolbar questions
- Pie Chart
- autofilling out a form by referencing a list
- Using the Lastrow variable in a Count/Countif formula
- vba error
- Something Challenging
- Command Button problems when printing
- Question about the .move option
- A better way
- Tab Order Code Problem
- Graphic object as a result of a formula
- Proper case code not working right
- Re: Excel cell Validation
- re: Format within a cell
- Range Names and hash maps.....
- More toolbars questions
- VBA question - Combo box showing result of filtering
- format within a cell
- VBA - Object Variable or With Block not set
- Undocumented Excel key-bindings.
- Run Time Error 75
- Re-bind built-in Excel functionality to new OnKey event.
- toolbars
- Control sizing problem
- getting runtime error when trying to delete records
- Importing multiple text files into one work book
- Custom Function-sum based on multiple criteria
- Out of Memory Problem
- Excel VBA - input box text display
- excel VBA making a program generate a graph
- Trying to F9 sum of random numbers until certain value is reached
- creating a drop down list of pricing
- Problems with dates entered via userform
- VBA question - Getting las active row number
- paste into filter criteria box running macro
- Macro to automatically install ODBC data source
- Programmatically determine if a control is .VISIBLE or not.
- Userform Can't seem to work right
- How to run a scheduled macro and Log Off system???
- Lookup Macro
- Excel Filename prgramatically
- merged cells
- If Then formula for excel
- Populating txtboxes
- Re: Format Cell
- Convert Macro into an Add-in file
- Use XL 2 Edit a .txt file?
- "Save As" cell reference in a macro
- Macro to open MSN Messenger
- Very simple
- Excel XP 2001 vs Excel XP 2002
- Excel Format Cell - first letter upper case
- Excel 2003 .net, sql server
- Code Problem
- DateDifference Question
- Command Button slides when sheet is redrawn
- Problem concerning working with an uncertain # of rows
- Select a random cell <> 1
- Screen updating
- Screen updating
- highlighting the text of a textbox
- Problem with using dates entered via UserForm
- Last Row
- Macros with AutoFiltering
- Excel button
- Deleting macros that are available in personal.xls!
- Re: Pivot Table - Object variable or with block variable not set?
- Not sure if I need a formula or some code....
- Cell Value
- Saving a workbook into the desktop
- checking if an access database is open from excel macro
- Open en close a workbook with password
- Template Save As retains existing name!!
- Question on custom formating cell
- Using SQL in Get External Data
- Re: Format Cell
- VBA SPLIT FUNCTION
- Graph Macro
- Re: Format Cell
- Type Mismatch Error
- ChangeLink
- Return cell address value
- path of workbook
- VB - turning cells specified colours
- Is there a diferent "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="
- Replace based on combobox value
- Re: Problem is adding options to ComboBox
- Importing Code into 'ThisWorkbook'
- Formula to figure average efficiency based on criteria
- I'm trying to integrate Sharepoint PS with Excel 2000
- Problem in adding item to a checkbox
- Refresh Data
- Problem with ODBC Query
- Open password protected workbook.
- Change the code to copy whole row
- Shape Marcro with Parameter
- Hiding a sheet
- user-defined fct/macro
- Rename sheet
- how they do that?
- Disabling Excel X Application Button
- How to interpret cell references from formula to vba?
- Hyperlink doesn't work - need a macro....
- Search a value in particular range
- Excel Formula
- Followup to "search range for duplicates"
- Find fastest way to do lookups
- Excel Chart Datalabels
- Re: Trig in degrees not radians
- Find records between two dates & check a box for each positive result
- Create appendix
- Follow up on this
- search range for duplicates
- How To: create a form for a user to enter data
- Copying Cells from Sheet2 to sheet1
- Save as .txt then close
- Windows 98 desktop icons disappearing
- Pasting on next empty cell
- Shared workbooks, advanced filters, and refreshing pivot tables
- How to make a timer in Excel 97
- Filtering from multiples and writing to new page
- Combobox Help
- Help on Macro
- Tricky AutoFormat problem
- Borders in Columns
- Help With loop macro??
- Difference between a Service Release and a Service Pack?
- Can't fill XL Formula in VBA
- VBA: How to detect whether two cells are currently merged
- Problem Creating a Date Range
- hidden VBA
- Easy Userform question
- SQL Query Quandry
- Open file dialogue box
- Login needed for open workbook and then run some VBA
- Refresh combobox after inserting new sheet
- custom Header-Automated
- Is it possible to copy a code module using VBA?
- Auto Insert Rows
- placing controls
- Edit Macro to work for other Workbooks
- Password protect macro
- Code to copy range vs Copy Entire Worksheet - can't figure it out
- users and DAO with access database
- Whopper If Statement and Formula to Long
- How to have macros enabled at start
- Combining 3 macros to 1
- programatically accessing Macros in worksheets
- Autofill
- macro not found
- History
- Re: Checkbox with OPtion buttons
- Divide data into portions
- Hard-Coding a File Location
- Importing Access data
- Edit MACRO for all SHEETS
- xlPasteValuesAndNumberFormats
- automatic refresh of formula that seeks data from an add-in
- If-Then in VBA
- Application.Displayalerts wont get me past this!
- copy a changing formula???
- Re: Referencing a sheetname to a combination of two cells
- Fill Label Text
- How many rows on a Worksheet
- error with user defined
- Enable toolbars at close
- Re: Adjusting for Different Display resolutions
- Saving a Workbook: Forcing User to Rename before Saving
- cant have a range of 30 different cells ?
- Date format in textbox
- Addin Not Installing
- wsNew.Name
- Formula for first three characters
- Preventing Duplicate Entries Across Sheets
- Excel Vba Problem - Validate Data in cell
- ComboBox Triggering Resourse Warning
- comparing two fields in an excel spreadsheet
- HasLeaderLines not working
- RE: Is it Possible to add a Wave file to VBA
- Go to lastrow using other column's lastrow
- Re: Is it Possible to add a Wave file to VBA
- please advice
- Re: Is it Possible to add a Wave file to VBA
- Deleting a read only file?
- continuing code on another line?
- Re: Is it Possible to add a Wave file to VBA
- xml to excel
- C# IMdcCheckBox.Value problem
- Locating lowest/highest cell value in an array
- ComboBox programming not working
- Lock access to a worksheet depending on user name
- Connect to Oracle Database through ODBC with VBA
- Counting Controls in a sheet
- WordWrap in textbox
- RE: Sync - Bob Phillips
- Is it possible to password protect an OLE object on a sheet?
- Copy Modified Worksheet 1 Data to Worksheet 2
- Can't get code to work properly. Please Help!
- Checkbox behaving strangely
- Automating the "Oval" Object
- Newbee help
- copy formula to the last used row
- Saving a Workbook
- Findjjing the range that triggered worksheet calculate
- Urgent
- changing range reference
- Xml
- Clearing Memory agter an update
- Copy ranges
- Count result output to other sheet
- How to Clickbuttons on internet Explorer pages with Excel VBA
- goto a particular cell
- VLookup
- Sendkeys VBA and command line
- Help required with Macros
- To protect the program
- Problem using outlines
- cannot copy formulas only
- when change value of cell
- Auto Expend Range Using Macro
- Lots of Frustration - Lots of Arrays, Dynamic Ranges Don't Work, Help With Options
- How to change row color when select a cell in this row?
- creating a e-mail macro
- How to put in a warning?
- Pivot table toolbar
- What to use other than .Select
- open two files with the same name concurrently
- How not to fixed cell address in Macros
- excel vba - COUNTIF syntax
- Show progress in a user form while code runs
- Cell shading won't show on screen
- delete columns with 0 in single row
- Reminder
- Rounding numbers to whole thousands
- Converting code to R1C1 format
- Trying to give a cell a formula
- Custom Addin, Excel Shutdown Problem
- hide sheet tab
- Easy one: absolute cell reference in VBA
- listbox works in form; not imbedded???
- VBA question - getting name of workbook
- Saving a file with todays date on the end
- Command button macro query
- sum cells
- Re: want several userforms to remain on screen
- Excel: Relative formula to new sheet?
- RE: ComboBoxes
- synchronize 2 combo boxes in Excel
- RE: CommandButton
- refer to a formula for use in a loop
- Making the minimized Excel window icon flash
- Invisible Contents
- Call/Start Macro
- Cant find project or library
- Please HELP !!! Converting .XLA to .XLS
- VBA question - Copying Sheet from Workbook to another
- VSTO Excel Addin
- Drop bown lists
- Protect My workbook, what's my computer's Finger Print name??? and how to access it, from vba!
- Pivot Tables and list boxes
- Disable Macro Option
- leading or trailing quotes
- Summation
- VBA question - calling Procedure from userform
- Sync Code
- Excel through SOAP to a webserver
- Combobox setting
- Opening Excel remotely
- CommandButton
- Re: runtime error '1004' delete Method of Range Class Failed
- Probably missing something simple in loop macro...Please help
- cannot copy formulas
- Function to cnvrt Phone to State w/out cell ref
- association of hot key with subroutine
- Re: Replacing formulas in Excel
- pivot table drop list
- Help (please, please) copying and pasting issue
- Create a Macro with Starting Cell as a Variable
- Re: Getting the Sheets Name
- Inserting Sheets and Naming
- UDF to give position of item If list was Alpabetic
- Searching In a Column
- Rename File from list
- MsgBox execution sends program into design mode
- Prompting a macro to run on change of cell content
- Excel Parameters
- inputbox msgbox error
- Copy address from one sheet to other sheets
- Copy Paired Info into Diff # of rows
- 3 range criteria for Loop
- How to detirmine the target row
- Controling the list in a combo box
- Newbie Excel User Needs Help!
- Password Boxes from xl95 to xl2000
- Re: Please help...I need a looping macro at a specific time
- Copy row
- Excel VBD DDEInitiate problem
- Counting files in a folder
- Case Statements
- selecting the last non blank row.
- Re: Replacing formulas in Excel
- Limits on Case Statements
- Re: Pop Up Screen
- Make a particular cell the active one
- How to get average with deviation
- Row and column header
- Grey out
- Re: Pop Up Screen
- OLDEDB alternatives for pulling data from Excel
- Totals
- Sum IF function - linked to external worksheets
- Summary of Multiple Date Ranges
- Arrays
- Data Tansfer Between Worksheets
- ToolBars and Custom Menus
- find the last row number
- Need Code to Populate Cell Range
- Thanks Bob!
- userform question
- Using reviewing tools in macros
- Object required when formatting
- Basic macro ? I'm new to this.
- Screen Updating
- pivot table question
- Centering Toolbars
- Macro to copy and past selected rows only...
- Counting Code
- LinkedCell Update does not always respond
- Path/File Access Error
- Quick Question
- Use the .NET Library in VBA?
- Search using Autofilter
- userform
- Delete Duplicate rows in a range
- UserForm Label & Format Problems
- HTML Tags in Excel sheet
- fill A1 when open xsl file
- What is maximum length of URL?
- run a macro in excel from an access vba
- IfThen
- disable formatting
- Place selected object names into array
- Filter 2 columns onto Sheet 2!!
- pivot table
- Excel Saving and No changes made!!
- Add a sheet using a template
- Help needed for ComboBox
- Documentation 4 Excel Web Component
- Restoring application settings at end of sub
- Problem with using formula
- Looping in Excel XP with C# -- Ranges and SpecialCells
- how to have a module to repeat itself at a certain time interval?
- Chart sizing inconsistant
- How to soft a selected range of data in Excel by using VB.Net
- Saving workbook
- Find values in table and return correpsonding data in array
- Why won't this code connect to ODBC
- Textbox in userform
- DLLs
- online course
- Choose Function Macro
- Re: Public variable usage!
- Looking for function similar to Access "Group By" queries
- Code to insert text
- Re: Working with ADO to connect to SQL database
- Re: Rnd (Random) in VBA
- Bad External Link
- Excel Timer with Sheet Toggle Help
- simple VBA question
- Cell protection
- From Sheet 1 to Sheet 2!!!!!!!
- Code
- Strip chr(13) from Comments
- Bug on macros!
- Copy Paired Info to Different number of Rows
- Loop a long formula through range
- Script or Tool to Update Excel Links
- getting a macro to run when a change is made to a specific row
- Add-in functions when starting Excel programmatically
- A unique ID for protection?
- Averageing a collection
- RE: Public variable usage!
- RE: Public variable usage!
- Display mail application either in Outlook, or Outlook express
- Returning to activecell
- Trying to get/set contents of embedded file using Excel OleObject
- Re: Searching for a unique charater in a string, vb
- Re: Public variable usage!
- Disable entire row delete on certain sheet
- UDF showing full Path of Worksheet or Worksheet Name?
- Button won't call macro
- Updating price of securities in Excel
- need help with a timer
- Newbie question about publishing VBA project to the web
- formula validation
- Text box in userform
- Rnd (Random) in VBA
- Excel Macro Help.....
- Error trap the renaming of a sheet to an existing one
- Dialog For Choosing A File as a string
- Query Data from a Sheet
- Query Data from a Sheet
- Sizing a Picture (a .gif) to fill a worksheet, for any resolution
- Delete a sheet
- ComboBox Population of Cell Range
- Preventing shortcut keys from working on disabled toolbars
- VBA Execel Macro & Check Box help
- App using OWC 2003 Deployment - How to ?
- Rename the sheet just added
- Put Excel data to text file????
- Re: Range("rng").calculate causing problems?
- Date ??
- unable to get original cell value from a "number stored as text"
- Looking for matches
- Printing Each Sheet
- using create object and sendkeys from excel to FTP
- Workbook reference error
- Open file from Cell
- Trim Blanks
- Saving it as read only?
- Global variable declaration!
- Application visibility
- textboxes
- Validation lists
- Call Function in Different Spreadsheet
- Open workbook with designated sheet
- Code is great, except for one thing ...
- SocketWrench
- Workbook file password protection - forgotten
- Help with randomn blank cell in my data
- Re: Range("rng").calculate causing problems?
- MS Excel Audit Trail Software
- Get points in a worksheet using mouse click
- opening an excel file from another excel file
- compile error
- Trouble recreating Pivot table changes in VBA
- Here is an interesting question
- Problem in VB help in Excel
- Combo Box font color
- Cell
- Problem with excel linking to Access query
- delete empty rows
- Getting a row number of the last row?
- Application.Run with multiple workbooks
- assign a clickable macro to a cell?
- shortcut macro keys
- Excel 2003 v Excel 2000 info please...
- Protection and filters?
- MsgBox
- FileCopy and read-only
- Help with Selection Property
- VBA problem, works fine as formula but not in VBA
- Reference Addin Module from sheet code
- Excel VBA - "IF Answer = Problem"
- AutoShape - Text Update
- Back button Macro?
- On Error GoTo : How to use multiple?
- Sheet msgbox
- Excel Encoding
- VBA question - Inputing data to txtbox in userform using short date formart
- Updating a Data List
- Worksheet Menu Bar
- help required with placing command buttons in Excel
- UDF: how to get value of the argument's adjacent cell?
- online course?
- Unsharing a workbook
- Date Selection Userform
- Strings that have quotes in them
- Activate Userform (run macro?) from cell value
- EXCEL VB Macro Run Time Error 1004 - Setting ColorIndex
- Moving XL Data over By one Column (*Same Row)
- searching a list box for a filename match...and highlighting the match
- concatenating strings to call a variable
- dll's and performance
- Excel Error Message when loading
- Change a chart's series using VBA...
- Class Modules
- Simple ?
- graph\spreadsheet on form
- Excel VBA - Changing a template in an Add-in
- Retrieving data with SQL from ODBC source
- Multiply All values by a cell
- ComboBoxes and Tabbing
- How to do a line break in a text formula
- Open file from vba
- opening and closing files in order with vba
- PASTE INTO JUST VISIBLES CELLS
- Same Results - which is better?
- Create and write a simple text file in Excel/VBA
- 12th root of two
- input box , msgbox, formula
- Error Trap Not Working
- Exporting to Notepad
- Declaring As Variant, Changing to Double?
- RefreshData Method in RTD Server
- Saving Changes
- protected cells
- XMLHTTP proxy settings.
- MsgBox help
- Import Queries instead of Tables (ADO)
- Changing Text into Numbers, using VBA
- Menu
- Import Queries instead of Tables (ADO)
- Intersection of records in two spreadsheets
- Programatically set ref to my DLL
- Counting in ranged intervals
- Worksheet_Change Event
- Enabling help on code
- Error when running macro in Excel
- Lock out a portion of spreadsheet based on a condition
- fastest hardware for excel
- Summation of last (DD) days
- Excel VBA question - showing userform when opening workbook
- Maximum Count
- Pass array from Project to Excel
- Public Variable
- Using VBA write a mail to some one and Send it
- Set the size of a chart object
- Sending Appointments via Outlook
- List/Combo Box Setup Problems
- linking multiple workbooks - UPDATED
- Pointer Color
- Get Average in Subtotals
- Chart Size
- value vs. formula
- ValueBox? or force TextBox to read/format value
- VBA question involving an InputBox
- Re: FINDing data only in one column
- VBA question involving an InputBox
- Re: FINDing data only in one column
- Re: FINDing data only in one column
- Array Type programming
- Execution Error due to file location
- linking multiple workbooks (VBA)
- excel vba : how to split characters in text file into cells?
- Loop Problem
- Transferring custom function
- Opens Workbook and not Query
- Not sure of what to call it accept (Un - concatenating)
- Indian comma style above 99 crores with -ve
- find across multiple sheets
- Disable Button
- Indian Coma Style
- Save TextBox Entry after WorkBook is closed
- Excel Probel
- automation
- Aborting from a "Before Print" Event
- Server
- Help with formulas (Sum)
- Excel: workbooks.open problem
- ASAP Utilities - free!!
- Updating from external file & keeping previous data static
- with selection speed
- Re: Edited Data Imported into Excel
- Edited Data Imported into Excel
- Processing all worksheets simultaneously
- Deleting a sheet
- Clearing Data ranges from Multiple Worksheets
- ATPVBAEN XLA [Number casual]
- XML Data Binding
- IF function with Array Formula
- excel graph with vba
- protecting the workbook through a macro
- Find generates error message
- Reading Textfile into a variable
- How to enable macro
- Excel VBA - Excel crashes when macro button re-assigned problem
- Open a log file
- Use of Command Buttons to Move Through Worksheets
- Is a file already open
- Save As issue
- sumif or countif based on font color
- Comparing values in two columns
- worksheet synchronisation and other one
- VBA Excel problem - including sheets in Add-in worksheet to link to
- valuta
- one-tenth of a second delay
- VBA digital sign
- UserForms
- Excel VBA - Multiple Issues for a newbie.
- Change minimumscale with the change event of a combobox
- transpose to matrix
- Error with code... ".Visible"
- Two questions
- Re: Print Row
- Sometimes macro does not run
- Print Row
- Where Macros Are Located
- Getting External Data
- excel VBA - for loop for several sheets
- Why does this fail with an invalid type error
- Deleting all HTML coding while keeping text
- Resizing a cell vertically to insert text
- excel VBA password
- Protecting all sheets in a workbook
- Running a .bat file via AppActivate
- Digitally Signed Excel Sheet - can someone send me one?
- Excel and web browser
- running a batch file
- using spaces instead of underscores
- Workbook Name question
- User defined data type
- Save Excel chart to file with given dimensions
- Returning control to form
- Shortcut Keys
- Excel VBA - deleting populated folder problem
- Quick Date entry revisited
- saving single worksheet
- Can't recreate A Macro
- ComboBox changes text when switching tabs
- VB msgbox exit
- Testing for Identical Cells
- Digitally Sign Macros
- conditional formatting
- Function
- RE: Hyperlink Code will not work in XL2002
- Object required - run time error 424.
- Object required.
- vba code to find ssn and move two columns
- restricting data when other cell is empty.
- Formating Data Labels
- Re: Need (perhaps non-existent) Formula Help
- showing current date as part of file name
- Subscript out of range
- Calculate time worked
- Change references ALL at once
- Row Select
- Disappearing Text in textbox
- ADO or DAO, or odbc query from xls sheet, to xl sheet?
- Findcontrol
- Fancy tricks in Listbox?
- pivot field size (column field)
- Excel Data Validation - copy command overwrites
- Absolute changes w/copy
- Export the worksheet background image as an image file - possible?
- Why doesn't this range work?
- How do you say "If, Or, Then, Else" in VBA
- Retrieving data with SQL and ODBC selected by key values in cells
- This drives me nuts
- Finding Procedure which generated error
- Program an autofill
- RE: Comparing worksheets (extra info)
- Re: Assign a name to worksheet tabs by code
- Re: Copy Value, but not Formula
- Scoll button in VBE editor; How make work?
- Need help
- WORKING DATES.
- PictureBox control in VBA Excel form?
- Find in a range
- Convert string to range?
- Word document from template
- Disable/Turn off
- Baffling, yet curious
- Re: Comparing rows of data in two worksheets
- referencing another sheet
- Delete records by comparision
- Returning Error from Functions
- Options when Protecting Worksheet
- Auto Run and Installation privileges
- Mailmerge in Excel?
- hiding formulas and defined names in a worksheet
- Excel VBA - Clearing Shapes and Cell Contents
- Excel VBA - Remove Shapes and Cell Contents
- Get user selected range into RefEdit
- Move to SELECTED Cells
- macro warning box
- Re: CopyFromRecordset Bug with Office XP
- Save As help
- RE: Increment a variable
- Pulling value from cell to complete path name
- Please help (need a code check)
- How to copy data from excel to power point screen by screen?
- expire workbook
- Late Binding question - newbie
- Converting time from hrs + muntes to whole minutes
- Strings
- Displaying XValues.
- Out of Memory Error on Excel XP
- run until mouse moves?
- Email Excel form
- Validating entered data as date
- Change Criteria in Code
- days, GUARANTEED- RETRACTION..PLEASE READ
- Wow can I switch to R1C1 mode?
- macro
- Multiple IF 's
- How do I do Auto_Activate Macro?
- don't let the user disable macro's in Excel
- VLOOKUP
- Solver reference problem
- Workbook_Open problem
- "Rounding" error
- Controlling Input
- Macro stops before beginning.
- Restrictions on Excel in-place activated in Browser?
- Getting Table data from HTML page
- Is there any onLoad kind of function for Excel
- Changing Pivot Table Range
- complex looping problem
- range problem
- setting the auto row height using vba
- Row split not working
- Special Formula
- send keys
- Adding file name and path to to footer of all workbooks in a folder.
- Question about Formulas
- Tom please respond..it works but but not completely
- Ideal Code deleting rows/based on bold text
- Remove rows with dates
- VBA- SeriesCollection(1).Value error
- output text
- Re: Solver in VBA
- Naming Worksheets With Leading Zeros
- Copy pages from one worksheet to another
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.