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 |
- Not changing from "City" to "1-City"
- Programing help
- Moving to next row below a selected range
- filling a simple combobox
- VBA runs very slow on a Apple Computer
- How do i select yes or no in a system didlogue box.
- Simple Copy & Paste..Confusing??
- Another way to suppress print besides Cancel = True?
- Help.. need to change sheet name to whats in a cell?
- Determining hard drive space remaining
- Series Trending
- rounding off numbers with excel
- Capital letters in names written by lower case
- How to create graph from data in Access tables
- Add a label at runtime
- automatically insert new row
- printing on 3 x 5 cards
- How show value of variable by mouse-over in debug single step mode
- Select range & copy
- Expand All Column Widths
- Scroller Incrementation
- How to count number of items(cells) in range?
- Searching formular
- Wish List--Messages on Images
- How to Do this Test in VBA?
- Syntax Question
- Dynamic variables in .WebTables
- upload excel file into sql server
- X-axis trouble
- Copy with ComboBox
- Trouble with "target.value" when cancelling...
- formulas
- write email subject
- Multiple If Arguments with Multiple Conditions
- syntax for to upper case letters?
- Calendar Control
- Loop Code
- Converting column letters to numbers
- Macro that shows a cell address when pressing the down or up key
- Locking all cells
- VBE Options: Disabling Debug Option on All Errors
- Unprotecting Sheets with VBA and IRM
- Locking cells
- Display text and use a formula in 1 box
- Get Macro to work on MAC
- Terminate Excel with a Macro???
- complicated sum formula question
- Checkbox control on userform
- Showing a userform
- VBA date errors
- How to fetch rows of data across sheets dynamically
- Formula for counting customers waiting to be served
- Need Help
- run a macro automatically upon opening an XLS file???
- Delete named ranges beginning with a string
- Data Validation between open Workbooks
- vlookup question
- identifying errors
- Syntax for multiple if statement
- Change a cell's color based on return value of a formula
- Removing section of a string in VBA
- Change Event Endless loop :-(
- an excellent time waster
- Automatically Format Range of Cells
- If statement syntax to see if Worksheet_Activate code exists
- How to read from a closed workbook?
- show and hide a picture
- Formula Set Up Needed
- lookup klient address
- User Form Initialize Event Issues
- Selecting the Second largest number
- What am I missing here
- Re: Autofill datasheet using filter
- Reduce picture file size, KB's, with VBA
- Change Routing Message...impossible to figure this one out
- How can I make the print icon trigger customized macro?
- sql query in excel
- How can I speed up my VBA simulation??
- Does VSTO 2005 support mailmerge?
- To find empty cell
- RE: I am looking for a date add-in using a calendar
- ADODB Connection Problem
- is there a way to save pictures in worksheet as graphic filse elsewhere?
- How do I make a macro call on different macros
- Changing VBE WS-component name in code craches excel 97
- Import Text Issues
- VBA Apllication.run and macros when spreadsheet name changes
- TextBox and Time
- Run a sheet's activate code when entering it's workbook
- Conditional select and paste
- Disable Cut, Paste, Drag & Drop in Protected Workbook
- Prime Numbers
- How to move records from one folder (tab) to another
- Last Selection from MultiSelect Listbox
- checkbox on form reset from checkbox on sheet
- excel presentation template that has company info, financials etc
- Adding a "1" in front of everything in column A
- Count duplicates in an array?
- VBA - Formula Update Assistance
- VBA - Formula Update Assistance
- i want to add up numbers from different pages
- InputBox to capture user selected sheet names?
- Left Function in VB
- Delete rows from a protected sheet (write macro)
- Wierd variable values problem
- Determine whether a character is Upper or Lower case
- Forecasting/Estimation using arrays
- counts rows in data
- Calling workbook and worksheet
- Name a cell as a number in Excel
- OLEObjects.ADD causes excel vba project to stop / reset / go dead
- If a cell value is today's date, than increace cell value by one
- slecting data???
- A Faster Way to Write Values
- Saving a template as a worksheet
- Copy to different workbook without opening it
- Create a new Worksheet
- On Click Event
- Covert UTC date
- Confusing Macro and references....
- User Form and Database Queries
- Set PivotItem using counter
- Daily new data input
- UserVal default value
- Code somewhat works. Please help?
- Trouble formatting Row Height while using a Copy/Paste Macro
- Sub ConvertCellFormulaToUseOffWorksheetNames()
- Retrieve Data from SQL database Programatically using Excel VBA
- Input box
- textbox on user form
- Setting Background Color RGB (Always goes to closest index color)
- Write formated excel values into text file
- Error “This operation requires the merged cells to be identically
- Email Copy and File Not Found Message
- date problem using .xls in Access2003 via OLE DB connection
- Subscript out of range
- Similar to VLOOKUP?
- Transfering data from sheet1 to sheet2
- Unwanted duplicate styles created
- application.wait help
- Macro for Changing Cell Background Color
- Appending to fields
- range calculations
- Search Excel files for text and keywords?
- Sorting Named Range
- Excel as an email client
- Get text from clipboard
- macro for all open worksheets?
- Change event occurs
- group rows
- workbook searching
- Simple on/off swith to turn macro on/off?
- Excel and ODBC
- VBA How do I set a value in a cell?
- File signature
- Macro to update contents of cell
- Working with ActiveX DLL
- Inserting new column between the columns
- simple help with comparing dates in excel
- transfer data between sheets
- Excel XP and WorkbookBeforeSave
- visual studio
- Speed up Excel execution
- create file for excel format and api needed for it
- create file format using vc++
- Columnbound?
- How can Excel vba detect if Caps Lock or Num Lock is on?
- Append Records to a Text File
- Public variables and scope
- needs to run faster
- Insert row here ... or not
- Functon to fill cell with color
- Time tracking
- Excel color palette on user form?
- Fetching rows across sheets dynamically
- adding formula in empty row
- another combobox question
- how can i export information from an omniform database to excel?
- wildcards in replace
- Convert to number
- Type mismatch using rnge as Range with Type 8 Input Box
- vlookup in combobox
- Creating multiple sheets - new to programming
- How do I set a number cap for a cell?
- a on_doubleclick statement is not working
- Autofilter macro
- How to insert a page break in Excel VBA
- compact MS Access while list box connected to database in spreadsheet
- Copy form field value to another form (calendar)
- Convert text to hex
- userform question
- E-mail Multiple Attachments
- If Statement
- Automation Error when upgrading from 2000 to Office XP
- Command line switches.
- add a formula to one cell by entering text in another cell.
- Copying range to variable number of rows
- How do I send a xl-sheet as a mail using a VBA-script?
- Copy & Past from multiple sheets to one
- Find variable cell text in another range
- Pivottable Qtr's
- Provider Issue with Version Change?
- Locate Excel files by searching for key words?
- Inserting a list of numbers then retrieving an output
- Please Help with this Macro.. Urgent...
- import data from close excel file
- Cell formatting through VBA
- Runtime error 424 object required on Set Statement
- Assistance with variables defined outside of macro
- Setting values by row color
- Web Access
- combo box help
- Comparing ranges
- List box to data list
- Would like to select more than one item in a list
- Add Comment Problem
- how can I execute stored procedure to download data
- lookup
- DAO recordset Call to SQL Stored Proc
- Autofilter in a userform
- How to get Excel to retrieve aggregate data from Access
- Range Name in Data Validation
- Column Restrictions
- Export to Access
- How do i translate OLE error messages in Excel to Access?
- Format when sending a range as parameter to a custom function
- Macro Special Paste - Value
- named range problem
- convert a List from a range to a single text cell
- IF formula with subtraction
- Help with taking formula to vba code
- Could you tell me the AdvanceFilter where is error?
- Add data to comment more than one time
- Coping Contents of one Sheet into Another Workbook
- IF Function - formula creation
- Controllling Display Updating
- Populate combobox from external source
- Home or Ctrl-Home
- how can I force excel to insert row after with my macro
- Sort and Copying
- Need formula to calculate lenght of a roll. I have all info.
- Run Macro On Multiple Closed Workbooks
- Help with this macrosheet
- Selection type
- Paste into opened notepad file
- Help with creating a formula
- refresh data from a intermediate excel data file (not opened)
- 500m, 500b, 500t, function?
- Macro Command
- VBA Formula Question
- Simple cell reference not blank
- My VBA Function Won't Recalculate
- Problem With this macro table
- moving State Data
- Copying records from sheet1 to sheet2??
- Programming Keyboard Commands in VBA
- Delete rows between two dates
- Automatically moving rows
- Importing Data from Access
- How to Disable the Design mode of EXcel Sheet....
- Moving Files
- Need advice : consolidating data from multiple CSV files in Excel - External data handling
- Capturing Formatting from an Excel Template--Can It Be Done?
- Autofilter - =string in selected cell
- Can the title of columns be stationary?
- array questions
- Questions on passng data between UserForm, Module
- file append & opposite #2
- Excel crashes when program changes VBComponent name: Excel bug or what?
- Replacing part of a cell text
- VBA, SQL, and multiple versions of Excel
- Importing data from multiple closed workbooks
- writing a formula
- Excel VBA - Compressing a Workbook
- AppActivate - workaround if app's title bar not known 100%
- How to change the value in different rows using the same cell to e
- Copy Workbook
- How do I display a description in the function wizard for custom .
- Any Help with a Simple Function?
- Workbook Open/BeforeClose Problem
- Final Value, For / Next Loop
- how do i maintain named range addressing after deleting row?
- Can I start a macro based on cell input value
- Filling a WS from a UserForm
- How can you split an Excel file
- Creating event procedure on worksheet
- Creating event procedure on worksheet
- Printers
- Cycle through data validation field and print
- Re: How to retain collection in function?
- Offset based on column heading
- Edit Query
- Template for 40-year quarterly cash flow mixed with some monthly flows
- Help with macro!
- linking spreadsheets
- Re: Date Calculation from a Due Date
- SAP BW Report - Putting the Unit of Measure or Currency in another Cell based on Format Cell
- Any parameterized queries for Access from Excel VBA examples available???
- Do Loop Until
- How to Calculate Peak and Off Peak Hours
- Re: Macro sends Excel file by Outlook - works in debug - not realt
- Error handling.
- RE: Date Calculation from a Due Date
- excel 2003 having problems pulling top table from web query
- use the contents of a cell in a function ... ??
- Error “This operation requires the merged cells to be identically
- conditional formatting:highlight row based on blank or non-blank c
- An easy one: Help with some VB funct about list and filter
- Password - hyperlink or macro?
- Validating cells left blank
- d
- calendar control 10.0
- incorrect displaying of "alt-enter"
- VBA for Clearing data from the worksheet
- Listbox value return from search
- Any way to get new instance of Excel on double-click?
- Do I have to use VSTO to program Excel2003?
- How do I create a new table below the last one
- Return Cells With Border Only
- Hide or unhide one or two autoshapes
- mutiple formulas .
- Selecting Columns by Title
- loop through autofilter dropdown
- Update Adobe form from Excel
- loop through autofilter dropdown
- how to get a list of entries onto a form listbox
- Organizational charts
- userform validation?
- Pivot Grand total on Selected columns only
- Auto Open Macro
- Error Handling
- unable to get the Interior property of the range class
- How do I copy a table from Excel to Word or a chart to Ppt in a ma
- Initialize an array
- Multilevel Ranges
- Add-in with Solver Reference Issues
- Need VB Code Help
- C# programming - Getting number of last non-blank cell (column) in a row.
- Creating Column Headings from XML Categories When Linking Data Wit
- Help with Macro
- RE: Transferring Excel Spreadsheets into Access
- Is there a way to find all the XPaths in an XML file?
- Problem setting Charttitle in VB
- Get cell string to text file
- Remove blanks from text
- Quick Form for updating a range?
- Calculate the total amount by date
- Tab name into a cell...
- SaveAs with special conditions
- Saving a workbook within VBA without executing events
- RE: Copy a Range from sheet and paste the next blank line in anoth
- RS232 probs, help needed!
- Named ranges wont expand after sort??
- date and time entered when a cell contains data
- How to view the dimension of an open array in VBA ?
- Coding a splash screen to require macros enabled
- Display large amount of text in form
- Dictionary object: Error assigning user defined data type to item
- Multiple change events on same sheet
- Unprotected cells becoming protected
- Excel Dropbox Help
- select Range Code
- Save File with the current date and time.
- syntax to go to a named range
- Run a macro at a cretin time of day
- Macro to Print several worksheets
- chart secondary axis crossing with x axis
- Adding times
- VB code help
- last entry from selected area
- Stopping formula computations during entering data...
- Update PivotCache
- Database problem
- How to know which user is having permissions on the different system folder.
- Creating Page Break in Print Statement
- Index/Lookup problems
- Pivot bloat?
- Problem following hyperlinks
- How to Protect my code without anybody seeing
- Re: Command Button Macro Sheet>New Workbook
- Month View control to disabled specific days
- Fetching row data across sheets dynamically
- File Append & Opposite
- Windows API to get network username of person with file open
- Windows API to get network username of person with file open
- using EVALUATE to change text to uppercase
- Fill cells with x's between 2 specific columns
- Importing macro during run time
- Insert Textbox values to seperate rows/columns
- unable to get the excel app event trigger for for window resize
- Break apart in long excel spreed sheet
- How to trim a character from a cell ?
- simple copy column works but ERROR!
- Re: updating a list
- Conditional Formatting?
- Excel 4 macros to VBA?
- Syntax for Select Case
- Set color of data in unprotected cells to blue
- Calculate
- RE: macro code for grouping adjacent cells into one multi-line cel
- PivotField select all
- RE: macro code for grouping adjacent cells into one multi-line cel
- hnjk
- Using excel to insert autocad blocks?
- Re: Transferring Excel Spreadsheets into Access
- Re: VBA cell ref problem
- VBA Code to query Access DB
- Re: Error 448 - OOps ... herewith the code
- references
- transfering from Excel to Access
- having probelms getting my loop to terminate on an array value read from an empty cell
- select columns by variable
- Using condition to extract data by matching values from 2 different Excel files
- Forecasting with arrays
- Max size of variable?
- Basic question for blank column
- Problem: Excel drops significant digits in copy value function...
- spreadsheet range selection
- Looping Question
- Range text vs Range value
- Select filled cells/rows in a spreadsheet
- Conditional Addition
- Conditional Addition
- stop running code
- multipage - option buttons disappear from frame in Excel 2003
- 2000/03 Compatability Problem
- edit the contents of a cell using a macro
- Can someone help w/a simple macro?
- Replace using Do loop
- Excel 2003 file opend in Excel 2000 - Compile error in hidden modu
- pivot table field dropdown list
- macro to open a cash register drawer
- Activate workbook
- VBA for Data Validation
- Verify Active Cell
- Minimum Scale on Chart
- "Unable to Record" error
- Ending a macro?
- array problem
- Statusbar messages stop updating
- Create my own Class Object for Ranges, having trouble assigning name property
- Ping Server Excel Macro
- Entering Data on each Sheet in Workbook
- Printing a sheet with macros..
- Excel in Visual Basic
- 2D variable array
- Selection of Range Class Failed??
- 2000 / 2003 Compatibility
- Named range not expanding with insertions after sort??
- If then statement causing value issues in Macros
- Excel with ASP Error
- do ... until loop issue
- Simple Copy-Paste logic not working
- combobox in a menu
- saving a sheet in a new workbook
- Multiple Listboxes - Listbox2.value doesn't get set
- Multiple change events on same sheet
- Importing spreadsheets
- Launch Acrobat from Excel?
- pass an excel cell value to a web query
- removing unwanted VBAProject
- Applying a Workbook's Names to Another Workbook
- Web Screen Scraping
- Distributing a UDF
- No screen updating in Workbook_BeforeSave event after ActiveWorkbook.Save
- Using VB to type something into a cell
- Systematically Importing Data to Excel
- file removal before Excel closing
- Print Macro in excel
- How do I compare data in 2 workbooks
- "File Error: data may have been Lost"
- Opening a Word and/or PDF document from Excel
- Searching for Boolean Cells
- QUERY: auto clean VB code editor?
- Deleting a workbook from Disk
- TextBox Font
- Help with writting macro
- CTRL +BREAK
- Pivots
- inputbox info = filename
- Do anyone know to validating rule for checking the Hong Kong Identity Card no
- Vlookup
- Text to Columns with multi-character delimiters
- How do I ignore a character in a cell?
- Spell Checking a String
- Zoom in out - Increment 10%
- Averaging Error
- comboboxes, userforms and class modules
- Copy enabled / Pasted disabled
- Access Cell name in VBA code
- Buttons and Sheet Protection?
- How to use VBA read entries from a Wrod file into Excel
- scrolling panes to the right
- Macro to open *.dat files and save as .txt (comma delimited text files)
- Sending an email from Excel attaching the workbook they are in
- Office 2003 Compatability Problem (I think)
- Sql Query
- download web content into excel
- how do I create event-activated macros that check every cell?
- Compatability Problem with Office 2003
- RE: Get path of open workbook
- two things at once?
- How to get x,y coordinates of point from scatter chart in VBA
- Format Cell Colour/Font with VBA
- Display tips in function wizard
- XP problem
- What's wrong with this
- Macro Problem
- remove beginning of data
- Error send mail with CDO
- Macro to copy into Comments pop-up
- Write a Listbox list to a dynamic range
- PDF TYPE DOC INTO EXCEL
- live link
- Excel 2000: VB code for changing caseof text
- skip some code
- Copy/Rename XLS and Macro References
- Printing-But not showing the page
- Error on submitting an Excel Sheet using Outlook
- Filter problem
- rounding
- References in VBA (Tools - References)
- VBA to name worksheet
- Error 91
- How to remove the row totals in pivot table?
- Updating links display
- syntax question
- How can I read a gif file?
- hiding sheets
- organizing procedures
- In Excel 2002 macro, go to cell in current row.
- vba code protection
- filisystem again
- amortization schedule with mo. pmts, but interest calc daily
- sort problem
- new excel vba functionality
- What has changed?
- Opening Powerpoint file from Excel
- How to disable a button picked from the Forms list.
- smtp server
- Replacing Text in a Cell Reference
- Macro for new column
- Copy worksheet values and formats into another workbook
- Declaring variables
- Read Only Notify Option
- Choose two numbers
- Updating Function
- Add message box to confirm run macro
- How to disable annoying "Enable Macro" popup
- Macro to edit text string data input
- Macro to find a range that varies.
- Visual Basic New Project dialog box
- Function is not available on a protected worksheet
- use the current time to return a value
- Pass variable to macro
- Code to see if Comment Exists
- Remove Blank Lines
- Speed up pivot table VBA code, avoid multiple recalculations
- Can it compress to be equal size?
- Importing Data Via A Macro
- Assistance with LASTROW function in VB
- excel.exe is not terminating from task manager
- error code while opening a workbook
- Conditional Calculation
- Loop in sheets
- Count Value And Blank Cells Value.
- [Excel, VB6] Encode text before sending to Linux server
- Cell Charecter Limit
- need an income statement forecasting worksheet for future years
- where does it go wrong?
- Can I import a calendar into excel 2002
- Excel Columns Autofix
- macro read xml file
- clear column
- highlighting cell
- Message - Selection contains empty cells
- code an input field that asks for current date
- VBA - Worksheet Subtraction
- WANT TO CHANGE EXCEL
- About form messsage
- How show value of variable in single step debug mode?
- Match font color works ... but
- Late Binding to Outlook Web Apps 2003 from Excel 2000
- Data Query Problem - PLEASE HELP!
- Excel VBA via ADO connection
- what is microsoft-excel
- cell adressing
- Check if a worksheet exists
- Much help needed on conversion!
- General Protection Fault
- macro to send excel sheet to specific email address
- Print Function
- Newbie question!
- Date format issue
- Constructing a path to open file
- Single or Multiple Cell Selection
- Global Variable
- VBA Printing
- Commandbutton
- Simple DDE from Word to Excel
- Loop through specific worksheets
- Not the right place for this Question
- Opening a CHM file
- Date and time entry
- New to VBA - Multiple sheets
- Modify to ignore the first row.
- For Each not workig correctly
- Posting Data To Excel Spreadsheet
- if cell value matches then copy another cell
- vba - output Selections from worksheets
- Excel 2000 - Microsoft Investor Stock Quotes.iqy no longer works?
- Global Variables
- Error Message in Loop
- VBA - Hex Number Thinks Its Scientific
- Lock Project for Viewing..HELP ME
- VBA - xl Prefix
- Placing data on worksheet
- digital signature parameters
- Obtaining Checkbox Name
- Custom function does not fire
- Data Entry-Cell selection
- Data Entry -Cell selection
- Data Entry Form : Cell selection
- Find second blank row
- Hiding tabs and menus, toolbars, etc.
- Data Entry Form
- Excel QuickBooks workBook
- data entry - cell selection
- Selecting a cell
- Data Entry form
- Asigning a variable to the Name of a Label in a UserForm
- How to limit access to sheets ?? HELP ME
- XLS - HOW Do I use the results of a formula to create NAME to vlookup
- How to get the last cell within a selection range?
- Can I identify a number from text in a list?
- NEWBIE QUESTION
- VB code gone missing
- input box date type mismatch
- remote reference update
- copy values from one column to another with criteria
- Sort Problem
- vba language
- Search based on TextBox
- Excel QuickBooks workBook
- immediate window
- Can I automatically select the number of pages to print?
- Pasting TextBox values
- How to find date in a range?
- Calendar Control
- Date last modified macro
- Late binding issues with Excel and Outlook
- Whether unknown does VBA achieve?
- Month and year programmatically in a cell?
- Formula in only one of many cells not updated when row programmatically inserted above
- Lookup & return data from ascii text file
- microsoft query formula for date
- check if file with generic name already open
- OnAction problem
- Validation add method fail when programming Excel with VBA
- Excel macro
- Is this possible??
- web query in excel
- Nth_Occurence User Defined Formula
- Combobox
- Disable selection on a new workbook remotely?
- Ideas" to convert Horizontal to Vertical
- How to:
- Macro in Excel 2003
- Retrieve value using vb6 from an excel workbook - precision question
- Variables
- Application level events
- Counting
- Finding a value and copying the formula from an adjacent cell
- can you help me set up a macro
- Run-Time error 462
- chart your data automatically
- Inventory Cards
- getting access data base into cells of excel
- Across application pastespecial
- Interop and VS Behavior
- pasting to sheet without actually going to the sheet
- Date Format....more questions from a beginner
- Autofill Macro
- Creating hyperlinks to network files
- How can I change the type of data
- Convert a UDF to it's value when copy sheet
- help file?
- How to Eliminate the first 2 digit out of 10 digit number
- If cell = cell +/- 1.5
- How to add one digit "0" in the front of a number
- XML Function
- How to know Autofilter is on
- VBA - Timing A Block Of Lines
- Worksheet_KeyPress event ??????
- Location of Add-in's
- Please help a beginner....
- Event procedure on program restore
- macro over range, deleting blanks
- Private modules and global variables
- VB.Net and Excel Object
- select cell rather selecting entire row
- Moving changing data
- How do you run macro automatically each time workbook is saved?
- GoTo from a form button to a macro
- Excel 2002 test please
- Validating in VBA
- How to automatically change number of pages to print?
- Re: Sorting the order of sheets by the name
- Sorting the order of sheets by the name
- Date Formatting
- Delete rows based on Cell name
- XL2003 Macro Visibility
- Textbox date
- Help with userform
- Problem saving to network drive
- How to display =x/y result in a user form
- Merging files
- How to start a VB6 program form Excel VBA macro code ?
- Excel crash - bug macro?
- The RPC Server is unavailable.
- Code runs in wrong workbook?
- Modify Paste Special to choose absolute or relative references
- Increase Fotter Caracters
- Advanced Filtering
- Format text - Event
- Implementing Binary Comparisions for a class objects
- Optionbutton help
- selective sheet formating
- is there any function to convert the numeric number to words
- If Value in Range then Delete Column
- pivot chart suppress zero value
- pivot chart
- Sum of value if column contain specific value
- all user defined cell format del using macro
- Importing Text to Excel
- Help With Range Names Please
- all user defined cell format del using macro
- Email Workbook w/o MS Outlook
- position() in XmlDataQuery
- Using position() in XmlDataQuery
- From Column D to D:G
- Don't want date to update
- sETTING A SPECIAL FORMAT
- Calculating 30 hours in a day.
- Create meeting in outlook from Excel vba
- can do it with vba?
- Stopping blank cells with formulae in from printing
- Immediately jump to next cell?
- Problem displaying a calculation result in a user form
- RPC Server Unavailable
- programatically selecting columns
- Write code to Write Code
- How to Past an Image from Excel 2000 into MS Outlook 2000
- Eliminating Cut-Copy/Paste Options
- Language accents
- Can any one help me out vbeditor for excel
- purge all names
- Error with OLEObjects
- Exit an entire task ?
- assigning values to array
- Works as Macro but not in code
- assigning values to an array
- Selecting a number of rows based on the content
- what is happening whit my controls
- Getting a List of File Names
- Help needed with macro: Writing contents of two cells to two new columns
- To run marco at a specific time in the day
- Excel.exe is not Closing
- Could this be done??
- Cell Tabulation
- Display Goto Special Dialog
- Convert time to running pace per mile
- comparing data
- Moving Changing Data to New worksheets
- Macro taking out all external references
- Code only runs once
- Web Component Scrollbars
- Grrrrr
- ListView Question
- compare delete and copy lines
- Userdefined Function and recalculatiing XL 2k3
- Hiding specific column on all worksheets
- Separating Business Logic from User Interaction (Userforms)
- Add attendees from excel vba
- Migration from Excel 2000 to 2003
- Control the Series Sorting of 10 bar charts?
- save automatically 1st sheet only
- Coulmn Fields delete.
- Hyperion Essbase add-in macro
- autoupdatesavechanges doesn't work
- Input box fields
- prevent warning message from appearing
- How do I create list validation from code without the text being converted into date format?
- lastcell in thiscolumn function error
- share + macro
- Using Tab-Stop in between textbox components
- Insert row on change of field - with input selection - not whole column
- Find last row in column D then Sum
- Find next without activating First cell Address
- Selecting a cell based on a criteria
- Run-time error '1004'; Method 'Export' of object'_Chart' failed
- Rename Sheet Event
- Moving data from SQL Server to Excel
- VBA visible property
- macro to enter variable in combobox
- Excel 4.0 parser
- Using position() in XmlDataQuery
- Set curser to Same position on open
- Data Tables
- Why doesn't ths VBA Code work?
- Write Listbox selection to Multiple cells
- Checking/Setting a reference on open
- If Then not working
- Paste if criteria met
- Updating Name References in Sheet
- .Foundfiles Question
- Data navigation macro
- copy worksheet to a different workbook
- How do I code a print module to duplex?
- Worksheet_Change even code will not run
- DLL c++
- VBA: move to the next cell down from anywhere in the sheet
- Run time error on Userform Show
- How to count the number of cell changed since yesterday?
- Error opening files from a list in a spreadsheet
- Printing 3 sheets with VB and new to this
- Add-in recommendations please
- Moving Data to new tabs within a workbook
- Merging Two Codes Into one code
- Help with a Macro
- Auto cursor advancement in Excell after numerical entries - acros
- Need advice - creating html pages
- Using an Excel 2003 Macro on Excel 2000
- Syntax to define sheet name to use in VBA
- selecting a column in XL
- Data series and LegendEntries order reversed in clustered bar chart
- Remove Duplicate Array Items
- data validation?
- How can I change sheet tab color based on cell value in sheet?
- Capture Pivot table filter count
- GetOpenFilename ERROR
- copy sheets in workbook to new workbook
- =INDEX(on Range Name,match1,match2)
- playing a sound in a macro
- Prevent user from customizing menus in Excel.
- HELP: compile error message
- Disable Save under Excel 2000
- Set the security level to high
- HELP! run-time error 424
- modify without unprotecting the sheet, Unsolved question
- delete and shift up
- determining datatype
- IF-THEN to skip portion of macro
- Clean Up Phone and Fax Numbers
- Identifying the Selected Cell
- Auto Select from Data Validation but allow override
- End Macro If Cell Formula produces "#VALUE!"
- TOGGLE BUTTON on userform problem
- Help with ComboBox
- How to use VBA to set "update changes" automatically every 5 min on a shared file?
- Advice on Approach to Convert List of Dates into a Calender format
- Moving the cursor position
- Deleting code at run time
- Uploading data from Excel to Access
- Forms menu button question
- Excel error when updating a workbook.
- SUMPRODUCT - NO SUMPRODUCT!
- Entering formulas via VBA
- VLookups data updating before WorkBook_Open event.
- Error -2147417851 - Excel 97 - Windows XP
- Accessing data on Excel Spreadsheet
- Textboxes
- Visual basic excel application
- Don't open Personal, but keep macros available?
- Formula to return initials of a name
- Automatic Numbering of Job Card, Insertion of Date and Time into Selected Cells
- HowTo add a period to front of EVERY text cell in a Excel column
- Find in another sheet
- Accessing same cell in multiple worksbooks
- Problem with Evaluate
- Break up strings into separate cells
- Finding values
- opening files with vba
- Putting a space in an R1C1 formula
- Excel Name object bug
- Sporadic errors when saving to network drive
- Event Macro
- Searching for a string and then performing an action if present
- vb code - automatic transfer of data from one sheet to another
- Auto Serial Number Using VBA
- complicated... not for the faint hearted
- Send a fax from VBA
- I want to place excel file in some other domain.
- Searching Cells in Excel
- Deploying a application which uses Excel primary interop assemblie
- Listbox Headings
- Printing
- ListBox display bug
- Import structured data from Word
- Problem with matching pasted cells
- Remove Defined Names
- Geodetic functions with English documentation
- List files in a folder
- Strange problem with formulas...
- cant add a column in vb code
- Call Sub from Function?
- Lunar or Chinese Calendar
- Counter in Excel template
- sumproduct or sumif in vba
- checking file already open status
- Auto Populating/ formating Fields
- I am looking for a good golf tournament program for excel
- Transferring Word table data to Excel sheet
- Problems using Add-in
- How can I include a cell's value in a worksheet header?
- How to clear clipboard content programatically
- Copy entire row if....
- Macro - Set Print Area for Changing Data Area
- Getting error 1004 trying to write formula in cell
- Last row - Selected Column
- Method 'OPEN' error on some PCs
- Excel and Works should add hours and minutes over 24, no seconds
- Can you instantiate classes without hard-coding class names??
- Change Sheet Name
- Counting checkbox values
- Can I get the inserted picture's original filename.
- Email VBA Code
- Retrieving Cut/Copy Border Address
- Password Crackdown
- Problem with Msgbox Code
- Macro If statement to go to a specific cell in another worksheet
- Checkbox from toolbox
- .AddDataField: is there a similar "replace" data field?
- How to end loop after two loops?
- Forum for C++
- Input data in an excel table
- using =month(c2) if c2 is blank returns a 1, which messes up data
- modify without unprotecting the sheet, array with wrong format
- Print out a "Help" sheet included in an addin
- Error when entering a formula
- Workbook protection and Pivot table on the fly
- Books for learning VBA
- Creating an Excel Add-In
- Using forms to store data
- Exporting Excel
- Setting a sum formula
- Making and Outline
- Page Break Macro
- Page break Macro
- Copying multiple sheets to another workbook
- macro to create a pivot table
- how to get my button on a for mto change color
- modify without unprotecting the sheet, array with wrong format
- Excel to Access SQL problem
- New at VB, need help implementing simple commands...
- blinking button
- Want Help Converting Excel Links to Named Cells (i.e. 1 cell Ranges)
- VB protection problem
- Separate Variable Range of Data into Different Worksheets
- Pivot Auto Refresh Help Needed
- database in excel problem
- Save range from one workbook to a new workbook
- Load anther microsoft application from excel
- VBA for deleting a sheet
- Open an Excel file automatically
- Trim Function... does not work?
- Drop-down list triggering the wrong routine
- Converting excel currently in english to spanish
- SQL Millisecond date to usable excel timestamp
- Sort a Range in a Hidden sheet
- Move data from rows to columns in Excel
- powerpoint into excel
- Cannot show, import, export userform: error &H80004005 / component is not corretly installed
- Add or Delete row as per enter
- Recordset's RowID as part of Recordset
- Type Mismatch Error when using InputBox Method
- trendline equations inserted directly to a cell
- create master worksheet
- retrieve text from table in .doc file
- calendar control for excel 2002
- Delete Rows - Must be dynamic
- Need More Help for Searching Textboxes
- How do I move values from excel to the word equation editor?
- Excel/VBA: cannot import, show, export userforms
- To Check Errors for a range of cells
- Web query.............query
- Function Question
- How do I prompt a user with a dialog box
- I have a formula challenge
- Define worksheet as variable, then call in macro
- save data in another workbook
- Checking for named ranges in a workbook
- Using Named Range to Set DataSource in Chart
- Variable that retains value after closing excel
- VBA is odd function
- Searching Textboxes on worksheets
- VBA Code execution delay
- Help with this formula
- hyperlinks in drop down menu
- workbook.saved property
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.