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 |
- Looking for Userform examples - site on web, download examples
- VBA to return how many Excel instances are open
- How do I select multiple worksheets for print preview?
- Writing data table to user form
- execte stored proc
- Printing from a macro
- HIDING A BUTTON
- Excel 2002 and VB Macro
- sheet tabs are gone (screen resolution)
- Help on formatting using NumberFormat
- Chart Resizing Problems
- test
- Why 2 clicks on a command button
- A bit of help with Names, please?
- How to reference in sheet module value on another sheet?
- macros
- delete chartobjects!
- Re: How do I put a "date & time saved" stamp inside an Excel Wksht?
- compare and find added or deleted rows
- How do I put a "date & time saved" stamp inside an Excel Wksht?
- Creating a user interface in VBA
- Can I use CreateObject for Windows Explorer?
- VBA equivalent of MATCH()
- Chart to worksheet programmatically -- coordinates?
- ReDim Object array as parameter of Variant array
- Protecting & Unprotecting Sheets
- Picture Too Big and Will Be Cut?
- Coding best practice question
- Running Animation
- See code enclosed - Convert to formulas with absolute reference inculding the sheet references!
- Excel startup settings
- MultiPage - How to set MutiRow property?
- Finding text and replacing in VBA
- Calculations with different date formats
- Protection in VB
- Application.EnableEvents = False not working
- Creating first ever userform but not going how I wanted
- Importing XML into Excel 2000 without writing code
- More Efficient code than this
- grouping of cells in protected sheets
- Further Information
- Named ranges
- how do i do something for every spreadsheet i open?
- Using VBA to Unlock Cells
- Help with faceid and button images
- Excel Newbie Question Please Help
- BUTTONS
- BUTTONS
- Loop Macro?
- Translating English-Spanish on cells
- Linking
- AutoFit Madness
- Validation Dropdown List
- VBA save an object
- Trying to develop a shipping calculator to compare courier rates
- SQL statement in VBA
- skip worksheet
- newline in a msgbox
- CREATING NEW WORKBOOK FILE EVERY MONTH AND NEW WORKSHEET EVERY DATE
- Simple form question
- array
- Quick question on Error Trapping
- Chanagin buttons images
- Create a macro to move info from one column to another
- EXCEL Visual Basic Questions
- Filename as Data
- How to protect a sheet with pasword
- set print to pdf filename
- Dynamic Entries
- opening files
- How to remove an add-in that doesn't show up in the add-in list
- Using Excel Solver multiple times with macros
- Placing values in a range on a non-active sheet
- How to get rid of VBA-reference??
- List Box Moving
- Add row after various groups of numbers.
- Pivot Table Query
- how to match up cells in different columns in Excel 2003
- Outlinelevel event ?!?
- Validation question
- selection of several worksheeets
- Can a dipendancy list "Auto Competle"?
- how to program a button...
- Language portability problems when setting LeftHeader text from external app (=non-VBA)
- Workbook-level public variables
- Error in Code
- coinitialize
- PROBLEM DISPLAYING USERFORM
- on error
- Remove extension
- newbie question
- Paste function without affect locked cells
- disable form movement
- change value on a form
- Extracting part of a spredsheet based on the date
- Audit function needed
- Select entire columns in worksheet and place into combobox
- LIST BOX ON USERFORMS
- Insert Values into combo box
- Format Individual Characters in a Cell
- Updating closed excel files
- Excel 2002 UDF screen tips
- Hide / Unhide Columns with checkbox
- File list
- baht
- Checking Options in UserForms Collection
- Re: Check if workbook is waiting to calculate
- checkbook register template
- Is worksheet 100% refreshed
- VLOOKUP
- Email
- Protection not working for data validation lists
- Send E-mail from Excel VBA without Security Warning
- hjf
- Send e-mail from Excel VBA without Security Warning?
- Workbook link help needed
- sum if
- Excel VBA Code to hide dark black selector box?
- league table
- Creating absolute references including active sheet name in the formula
- Replacing blank cells with zeros
- Simple Form questions
- How control where the CommandBar will be placed?
- DELETING DATA FROM USERFORM
- vba script help
- finding data within a range
- Creating folders using VBA
- How do I reference a cell that has a colored background?
- What function will give me a random full number from 1 to 6
- How avoid errors when you Copy chartobjects paste in powerpoint
- How store PageBrakes locations - Coded pagebrakes are deleted in Workbook_BeforePrint
- Generate random password
- Automate defining names
- Programme Printing of Several Sheets
- ones more the same question
- How to get a UDF to ignore all sheets but its own?
- Macro to highlight cells that are 5 business days from trade date
- How do I enter $1225 as $12.25 without typeing the decmial?
- Setting CommandText property of PivotCache fails if cache has >1 PivotTable
- Lookup Functions
- Get rid of bar from the top
- error 70 - Permission denied
- Copy and pasting specific sheet data to a master worksheet
- Initialize Option Buttons
- how to change cell sign and values
- Sheet Tabs
- Slow Function
- Locate and length functions
- Global Variables
- Excel Returns Blank
- In Excel If then with multiple possibilities
- VBA msgbox function
- If Then
- transferring multiline text from userform to worksheet - line break problem
- AutoFillDown
- FollowHyperlink meathod closes workbook (Add-in) in 2003 and not 9
- Select a chart without the handles appearing?
- Setting Worksheet Name
- Mouse Wheel & Mouse Drivers
- Unreachable public variables
- Help me in writing macro
- Check Box and range selection
- Basic question - modules and class modules - what's the difference?
- Help with named ranges
- Box Characters in a form
- copy sheets
- Countif
- Excel Autofilter
- Only CreateObject Syntax works.
- A couple RTD related questions, plus VBA timer object
- Textbox Query
- Detecting a another workbook has opended
- what row a value is in?
- random pairings
- How to open UTF-8 files with Workbooks.OpenText
- Trouble with Formula
- Open, allow link updates, and Save
- Adding a sheets name to the worksheets that are copied over from an addin file to the activeworkbook
- Question re incrementing Dates by one month
- Why use VB over VBA?
- Broken macro in Excel 2003: part II
- Autofill and programming -- I'm SO confused -- please help!
- Variables and arrays
- query only returns numeric - can I get characters ... ?
- proximity position test for character(s) function - an example
- Re: How do I set up incremental numbering of Invoices in Excel?
- Excel loses email field data when upgrading from XP to 2003
- Retrieve Value from a PageField
- Search for a string sequence in a cell
- VLOOKUP in a Macro
- VB Editor complains of undefined variable for VBE
- Excel already open test
- Recalculating single cell
- User type not defined
- Re: Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good
- hidden folders
- How to Remove Non-Contiguous Columns from Worksheet
- Worksheet in VB COMPONENT
- Counting times a value occurs
- reducing a fraction
- RE: Adding Sheet Invalidates Digital Signature
- Easier way?
- Using an input box to enter information into the header section of page setup
- Macro help
- Workbook.Save not saving the updates
- Add bookmarks to an abobe doc from excel?
- Problems with path to XLA file
- Error when setting chart Axis value
- Include headers/footers when saving as HTML?
- Clearing Contents
- Need WebBrowser programming help
- Worksheet_chage (from Excel 2000 to 2003)
- Naming new workbook
- Empty Pivot Chart
- DDE and MS Office Language Settings
- Dataforms
- stopping or closing exe files from excel
- Macro to cut rows into another worksheet if a cell contains a specific word
- Superformula required for looking up Duplicates in a range
- Allowing only blank or cell with "X" in it?
- Macro Programming in Excel 2003
- Fetch list of table names in access to a record set
- Distribute Excel Macro
- AutoComplete in Pivot Table
- Testing to see if a specific name has been already assigned to cellor range.
- EXCEL & OUTLOOK 2003
- Attension MVP's
- multipage form
- Fixed Decimal in Text Box
- How do I do this?
- How to stop automatic calculation
- Macro help required
- XML Data Island in Excel Workbook?
- Setting Relative Conditional Formatting via Macro
- Stoplight indicators in Excel
- Can't Seem to find problem with this VBA Code
- Create Folder If It Doesn't Exist
- How to determine the parent directory
- UserForm and TextBox Arithmetic
- perform multiple actions in an IF
- VBA CODE to Subtract two cells
- Where can I download (buy) Excel 97? thanks.
- Button assignament and translation in cells
- List Box Resizing
- Re: Automatically Defining Ranges
- Not allowing users to enter data into certain cells if another cell is empty
- SELFCERT, a step further
- Use a button to create a table in excel without overwriting cells
- working with decimal remainder
- Copy partial cell character format(s) from one cell to another - an example
- Using ADO Find
- problem with autofilter and question about menu bar buttons
- Forms>button question
- How to exclude all letter using find and replace function?
- find data in one column and use data in the next column over Exce
- Macro problem - help please
- Trouble calling macro
- Hover over variable?
- LDAP Query Not working For All Groups
- Include headers/footers when saving as HTML
- macro won't run macro
- ADO recordset closed, cannot read
- Operator Question
- Macro or Formula needed to search data in cells
- How to compare one column to another?
- Can I copy the odc files and will they still work?
- Disabling macros is not an option!
- RE: Why do identical formulas sometimes act differently?
- Where can I find documentation on Excel macro statements?
- Column Counting
- Checking for Changes in File's Cell Layout
- Re: Adding Sheet Invalidates Digital Signature
- Filename Variable?
- Linked Cell Updating
- RE: Adding Sheet Invalidates Digital Signature
- animation
- control toolbox objects and formulas
- Random Generation
- Retrieving data from a password protected web site
- Can't edit module? How do i change this?
- Formula
- Column Delete
- WHAT COMBINATION OF A SET OF NUMBERS COMES CLOSEST TO A FIXED NUMB
- Re: Broken macro in Excel 2003
- executing action only when cell has changed
- updatefromfile in Excel VBA
- Re: Copy & paste image from UserForm
- Knowledge from this forum
- Re: Help Dialog Box
- Excel v10. Extra lines printing to Text file
- Pasting after last record
- Adding a row with macro
- RE: Help Dialog Box
- Error handler help
- Re: Automatically Defining Ranges
- Re: Visual Basic Editor Question???
- Re: Visual Basic Editor Question???
- Re: Application Title
- Pivot Table: Calculated Fields
- setting up drop down combo box with VBA
- RE: Why do identical formulas sometimes act differently?
- RE: autofilter and vba problem - FIGURED IT OUT
- RE: Broken macro in Excel 2003
- RE: Automatically Defining Ranges
- Completed Excel Program Request
- I need help, sorting and changing
- any idea
- Class Module for setting Automatic Calc
- Need help
- determening sheet number
- Trying to automate
- Worksheet Selection
- Backup to specific folder if workbook names begins with "NSR" or "MAC"
- Deleting garbage
- Month Additions
- how Do I save a customized Toolbar
- Changing a QueryTable data source
- How to save a menu bar
- Run-time error '424' in VBA event handler on XL shutdown
- How do I compute a sum based on two columns
- Chart source data automatically fill in
- Macro to copy and paste between two workbooks
- Check if filename exists.
- Delete ascii character 127
- =ColorCell(Color)
- unable to open file
- Run Time Error 1004 Copy method of Worksheet class failed
- Mass Change Hyperlinks
- run an exe file as a screensaver in excel
- Event sometimes stops firing?
- Get a value out off a chart just by a mouse click
- Excel question
- populating list box with contacts
- Truoble Opening CSV file in Excel from IE
- Question??
- tst
- add-ins gone
- Row deletion based on matches
- make a custom menu available to other users of
- Emailing From Excel
- Input box - Select a chart during macor
- Is BEEP all there is??
- add-ins don't work
- Numerous OR criteria in a Filtered Macro
- External data - change cell color
- Insert object into worksheet
- How to download into Excel from web?
- Graph in form
- running a command button from a program
- Formating
- Personal file slows navigation
- How do I make a formula that recalculates itself every 24 hours?
- Duplicate date from cell above
- Increase Speed
- Open find file dialog multiple files
- pageheader size
- Display text based on a numeric range
- Userform
- Programming in VBA, use XLS or XLA as source??
- Need to look at vba code in a file but excel locks up each time I
- Matching selections on pivot tables
- Determine memory usage of objects (like Dictionary)
- Combined VBA line syntax
- User asked for VBA project password
- ActiveSheet.ShowDataForm !!
- Excel and VB6 Questions
- Passing the Name of a Control Between Macros
- VBA code to count colors/shapes?
- Rich Textbox
- Worksheet_Change Event (Excel 2000 to 2003)
- Centralised error handler
- Calender Help
- Please help about SQL in Excel...
- How do I post values from source workbook to destination workbook
- Import macro from another workbook by macro
- AddressOf in Excel 2002 VBA?
- Excel
- How to disable a sheet's x(close) button?
- I'm Confused........................................
- pocket pc expense report
- How to do this in VBA?
- Excel addin from C# - Trap excel events
- applcation.run
- Avoiding a circular reference or value error while trying to calculate commission - a challange for me!
- SecSvr32 Operation exception
- VBA | Individual Iterations faster than Loop Statement
- formula for programing end dates
- Automation Error
- DialogSheet - Reference for someone who never used Excel 95?
- ADO Weirdness: Changes dots to #'s in FieldNames
- Charting - Cells and Range - Error 1004
- Combining Macros into One Command
- Label the Groups
- Text Highlight
- Macro to Synchronize workbooks
- How can my macro select an option in a pull down menu?
- Putting a formula in place one time for the entire spreadsheet
- Is it possible to insert a calendar control object in excel?
- Preventing VBA editor from Popping up
- Weird Sorting Behavior
- Hosting Excel in a WinForms application
- Create copy of sheet using VB with columns in different order
- "object-defined error" when Run but okay when Stepping
- With and End With issue
- Disappearing Shapes
- Need help with offset sort function
- Programmatically alter the Project Explorer
- Commandbutton enable/disabling
- unable to read file
- Activating userform and filling it with data form row where userform is activate
- Watermark
- Hide, not close, one workbook
- Cell switching
- Import/Export Cells
- How do I pull data from multiple files and copy into one file
- Password protect hidden cells
- Problem with loop
- Template questions
- Make columns
- sum of textboxes
- Strange problem running Word from Excel
- pasting pictures into Excel
- Using wildcard in VBA comparison? need a hint please.
- merge cell and padding
- Quick Books interface
- Does Cell contain Formula or Hard Number?
- Betting Pool for Kentucky Derby
- set up prices for a drop down list?
- Detecting user idle time
- SourceSafeTypeLib help
- I need help with QueryTable Events (AfterRefresh)
- Accessing Excel from VB
- move part of cell to new column
- Problme with Macro in one ?Unique? system
- Interrupted sheet copying causes phantom Book2
- New to programming VB in Excel
- Reference Dropdown Menu Items in Macro
- Text Box
- Unable to set the xvalues (or values) property of the series class
- Efficient Frontier/Mean-Variance Optimization
- What is a Conditional pull down menu?
- How to assign macro to menu button?
- Pictures in Spreadsheet
- Cell Contents
- Select sort key from drop down box
- inserting cells to multiple sheets
- Problem with find function in VBA
- Sub folder lList
- VBA Code for IF B1 <> "" then C1="FILLED"
- save as different filename
- bimodal problem
- Calling excel-macros from script?
- Dynamically highlight the cell under the Mouse Pointer !
- Email to from Excel
- Filtering Records Help Please
- Delete Column
- overwrite all files
- problem with custom menu
- Close Workbook
- problem with custom menu
- Cancelling the Sheet calculate Event !
- Controlling IE from Excel
- Is this an Excel / VBA Bug (XL 2000) ?
- VBA Help
- Can I use a variable as a sort key in VB?
- Can this be done ?
- Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit
- Excel Add-in for SQL Server Analysis Services - refresh problem
- Excel Add-in for SQL Server Analysis Services - refresh ør
- Excel Add-in for SQL Server Analysis services - refresh problem
- Excel Add-in for SQL Server Analysis Services - refresh problem
- Put a checkbox beside each chtobj's and then export selected to powerpoint
- Help with Opening with deleing end of File
- Command Button to Hyperlink to a Different worksheet
- BOM and Unicode CSV's
- How do I obtain the drive serial number in EXCEL spreadsheet
- W2K Scheduler and Excel sheet from ABWR Syskoplan
- Read unicode (Asian Languages) from Excel spreadsheet
- Hiding a column in a multicolumn combobox
- Getting column width of a hidden column?
- VBA for plotting charts: Question re-worded
- Inserting and copying
- Digital Signature
- Run time error 1004
- Comparing data in columns and delete if not equal
- How Do I Reference Individual Dropdown Menu Items in VBA?
- Referencing Dropdown Menu in macro
- Keep original wkbk open after SaveAs?
- Creating a Macro to Chart two columns
- Multiple Frames on a userform
- Query the User for Cell Location
- Need help - Filesaving - need to increment filename
- Sequence Question Again (Please Help)
- Excel Scenarios
- IFELSE question, as it applies to multiple cells
- How to prevent Worksheet_Change loop?
- Program formula Add On
- VBA ComboBox SetItemData type feature?
- ActiveX dll with progress feedback to Excel .xla
- cycling through columns?
- Correcting a cell formula via a patch
- Important please read this Thank you `°º·...·º°`°º·...·º°`°º·.†..·º°`°º·...·º°`°º·..·º° ` `°º·...·º°`°º·...·º°`°º·.†..·º°`°º·...·º°`°º·..·º° ` `°º·...·º°`°º·...·º°`°º·.†..·º°`°º·...·º°`°º·..·º° ` `°º·...·º°`°º·...·º°`°º·.†..·º°`°º·...·º°`°º·..·º° ` `°º·.
- Next in the sequence
- Uninstall Excel Addin
- Fill Default/Fill Copy
- Mock AVERAGEIF statement not working
- Macro to only change specific cells
- add-ins don't work
- test
- Unprotecting and reprotecting within a macro
- maximum number of fonts exceeded
- Pivot Table Selecting Items
- Type Mismatch
- Hide Rows based on Time Selection in timesheet.
- CharacterLimit
- negative numbers
- Connect to com port
- test
- Macro Help Please
- ActiveSheet.PageSetup.PrintArea variable ?
- Copy range and formats to new Workbook
- Correct way to call active worksheet?
- document control number
- attach file as icon in a worksheet (hope it's not so tricky)
- Bimodal data
- Date Format
- Update a DB (Access)
- Import Excel Data in dotNet dataset with oledb
- sum variable # of rows
- Help - now really stuck! File transfer problem
- Macros on workbook close and save
- Function parameter description
- Clearing the Clipboard task pane in XL ( XP ) !!!
- Dynamic Range with another workbook
- folderexists code no longer works after moving to excel 2003
- Workbook Switching Strategy
- Help with macro opening 2nd sheet
- The Dialogs collection
- using worksheet functions INDEX and MATCH within a macro
- Pull Current Month's Data Out of List - Repost
- Complex Sorting Problem
- Hand cursor/icon like with Internet Explorer hyperlink
- Mouse over effect on chart - anyone know how to do this?
- Saving the clipboard
- Macro that deletes certain rows and not others
- Macro&SplitScreenProblem
- multilanguage custom menus
- Next Number in Sequence
- Recal problems
- Change Listbox Sheet reorder code
- Tracking changed cells in two identical worksheets
- How get data into IE6 as "Favorites"?
- Copy Sheet in another workbook
- URGENT: sumproduct variation question
- Conditional formatting alternatives?
- Array Formulas and Last Cell
- Macro, or excel program to "Close All' while in a workspace
- Sharing data with Java?
- Macro, or excel program to "Close All' while in a workspace
- Charts Range Setting
- Cancel OnTime
- message box
- CF in VB Code - Simple Request
- User Defined Functions Behaving Weird
- shortcut key help pls
- Still needing help with last date attendend.. :(
- empty vs. "" vs. Null vs. Nothing vs. not Used vs. Argggh
- insert/names/apply - how to "select all" ?
- Subclassing Excel !!! So frustrating !!
- Subclassing in Excel ! ...So frustrating !
- Page Break Preview Page Number
- Range collection
- CopyFromRecordset
- Automated deletion of decimals
- run an add-in from a macro
- Displaying Timer
- Why wont this code work?
- Intercept protection message
- Rich Text Box
- Setting VBA Project Password
- Change hardcode to ....?
- Start sub in Col B
- using listboxes as input
- Create button code stops working
- Restrict Worksheet_Calculate() to its original worksheet !!!
- Determine if cell was modified by Enter , Paste or Delete
- Calling a macro from ActiveX Script.
- Multiple Listbox? Population
- vlookup, index-match
- No subject was specified.
- Unwanted bar appears at the top of the sheet
- Explain to a user the meaning of a control
- Selecting a Directory
- xl97 userform combobox time
- non english custom menu
- HOW I SET WORLDS AS MATCHING THE FIGERS IN EEXEL
- Simple Function question
- "if" statement within a macro
- SUMIF Question
- smart button
- Accessing previous page
- Printing problem
- add button syntax
- Command Button text changes size
- Persistent Data in a Combo Box
- call up a calendar
- Weird behavior of VLOOKUP
- Digital Signaure required?
- How to add code module to Excel programmatically
- Can .FindNext return Nothing??
- In-Line Subtotal Madness
- How to save excel spreadsheet and word doc with one save
- Talking about difficult things¡¡¡¡
- A little help with SaveAs Method please
- Code to Insert Formula in Cell
- Help! Query table refresh hangs excel
- Saving workbook from VB
- Can you have a macro always running on a sheet waiting for data
- How do I code a button to filter on worksheet2
- If Then Help
- Need to export file name to users sheet to the next row
- page break after
- Navigating Excel Sheets with C++?
- custom function
- Identify Current Row for ActiveCell
- Hide "Excel" when running VB
- Window Event
- presence of SOMETHING in a range of cells
- RTD Problem
- Keypress for enter in text box
- shapes caption on chart
- Appending Data from one sheet to a master sheet
- Function to automatically fill in an array of cells
- How can I report all new customers that have booked training?
- Unclear Error Message
- Auto move a row
- IsEmpty() Returns False in empty cells
- IF THEN ELSEIF - newbie needs help
- HOW DO I SETUP ELAPSED PRODUCTION TIME?
- objects (buttons, dropdown list) move after print
- Need Macro to print a sheet conatining drop down menu
- Trap whether it was TAB or arrow keys etc
- VBA Runs fine on my PC but errors on other PC's
- Re : Excel Sorting a 2-Dimensional Array
- abort macro dialog box
- user defined type not defined ??
- Returning Column of active cell
- What is the difference beyween "Sheets" and WorkSheets" in subrout
- Please help
- How to Set ListFillRange to Another Sheet
- abort macro dialog box
- How to refresh a Excel workbook with pivot & ADO query report in batch mode
- how to detect added or deleted rows in compare
- Excel2000: Reading values from range, passed to function as parameter using an expression
- DisplayAlerts
- Data Validation twist
- Copying Sheets to New workbooks
- VBA SumIF
- Radomising rows in a spreadsheet
- Adding a tab to Tools->Options dialog of MS Excel
- sort function vba
- Changing format of column from "general" to "currency"
- Rename file based on current date
- Choose Invoice# fills Userform again
- Scheduled Macros in Excel
- veryhidden sheet make restrictions ?!
- Database Access
- add-in on W2K SP4
- text driver problem
- Copy Sheets to New WB Without Linking?
- I need Code to open DBF file in an excel worksheet
- Leading 0s and Col Formatting
- Formatting column
- Problems sorting from VB when some rows include Borders property
- VB Code Refactoring
- Error '1004' - the specified value is out of range.
- Combobox Add Item
- Print multiple files withour opening
- VBA Program error...???
- Need an assist with existing code
- Need a macro to compare values in a workbook
- Help with McGimpsey's Seq No Function, please?
- How can I print flash cards in excel, word or other ms products.
- Elusive Problem with Arrays
- embeddable object
- XSL FO from Excel
- Open all files, ignore some
- Arrows on Keyboard working weird IN Excel
- Create a hyperlink with querystring from cell
- removing #DIV/0! in VBA in a calculated field in a pivot table
- How can I select / deselect columns for printing
- Deleting non numeric characters.
- Use command button to send email
- Run formatting macro if filename has a particular substring in it
- Where to place Code question
- copyfromrecordset fails after upgrade to XP and Excel 2003
- macros
- Auto / Timed Closure
- Using vbCritical, vbQuestion, etc icon in custom dialogs
- Selection Change Event
- Turn OFF Autosave just for a particular workbook?
- Status Bar Display Problem
- Reading Web site based combo box type values
- Fire Event only when Cell Change?
- Moving to Excel 2003 from Excel 97
- Office VBE SourceSafe Integration Improvement?
- How can I pull and format an SAP aging report into Excel?
- Case Statement using a Range of Conditions
- Areas, rows and colums
- Dim MyArray() as Long, Dim MyArray() as String, etc.
- Copy disable
- How to make error handle for mis-typed variable?
- Class stops working
- How do you create a calendar drop down in excel?
- Bind datatable to excel worksheet
- Can Excel Do This For Me????
- VBA Help with changing shape color for selected shapes only
- Re : Excel Formulation of 2-Dimensional Array
- parsing a string
- Problem with Excel 2003 and VBA to Open Doc
- code to delete a file
- remove code from behind worksheet
- Code to Open a dbf4 file in a Worksheet
- group of rows and element
- Entire Column Delete
- Problem in graph automation in excel.
- Working out first and last column and row in a range
- Problem with save some code
- textboxes problem?
- What's wrong with this picture
- Standalone Macro
- Module problem
- re:Check for dated sheet
- error traping
- Cell coloring problem
- Sheets added by VBA invalidates digitally signed VBA project
- Choose Invoice# fills userform
- Using date in cell as variable
- how can I hide macro list from user?
- Date Transfer to userform
- MsgBox Code Error
- Filling Formula down???
- Opening a DBF4 file in Excel
- personal macro workbook error
- Excel application title bar
- VBA Range select
- updating a chart series automatically
- Creating an excel function
- How do I retrieve my personal macro workbook?
- How do I view the value of a variable in my code?
- Check a user-input value against a list of values?
- Clearing a date vaiable
- Problems with the buttons language
- VBA + add multiple cells in code.
- Number format and decimal positions
- Excel range into a vb.net dataset....
- shopping cart like application help please
- Formulas
- Conditional Validation !
- VB Slows to Crawl when Deleting Rows
- RE: VBA + add multiple cells in code.
- Relative Reference and AutoFill- Macro
- VBA code translation - compile error
- Append data to a separate workbook
- Custom Form Coding
- PLACING PIC IN WORKSHEET USING MACRO
- PLACING PIC IN WORKSHEET USING MACRO
- Selection Change Event
- RE: Problems with the buttons language
- Relative Value Macros
- "relative reference"
- Out of Memory: Array Transpose
- RE: Clearing a date vaiable
- RE: How do I view the value of a variable in my code?
- Determine Last Cell
- convert to value
- VBA code for making a pivot table
- Array to copy from one workbook to another
- Printing hidden worksheets?
- Best way to implement "refreshable" reports
- how to open workbooks with different names
- RE: Formulas
- Returning a date value from combo box
- Copy Button & Code question
- Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you
- Macro to set header
- VSTO removin formulas and email
- Urgent help!! How to automatically resize all the charts? Thank you!
- Re Large Concatenate - (RP)
- Office Assistant ...
- Screentips ...
- Prompt to save changes
- SubTotals or Outlines to the left? / on Top ?
- Move Row based on dates
- SendKeys with DOS program
- dde
- Array Check
- form size and protection
- Checking Before Updating Template
- Sheet Refs in Add-In
- Worksheet Navigation
- Refresh to Multiple Files
- Excel Autofilter options (version)?
- Memory Leak Excel 2003 vs 2000 using linked pictures
- Formulas using multiple { }
- Adding files to a print queue
- Looping through controls
- Numbers of minutes in Verizon Wireless phone bill
- Help with Open and Read txt file, please?
- Error Message "Select method of worksheet class failed"
- export record from excel...
- Redundant data increasing file size?
- VB Code stops working
- Detecting when user deselects an add-in
- Unprotecting/Reprotecting
- Working with range
- Adding up #s in Excel
- No of Records returned by a Query
- If then Macro in Excel
- Multi Selection in a ListBox
- Count nullstrings in pivot table (databodyrange)
- Workbook window setup
- Template Functionality
- how do i append 4 differnt worksheets in a new master work sheets
- Filter & clear cells
- Usersform in VBA for Excel
- Re: How to program a spreadsheet to do this?
- Difficulty with MOD operator when using Mod 1
- Macro Excel
- Excel2000: How to check for Optional parameter=Nothing
- Excel VBA to send email using Lotus Notes
- Combo help?
- Saving a xls as a xlt
- Macro help on Cell Selection
- Updating source data while in Pivot Table
- Help please! Loops? For Each? Variables?
- Set the value of a combobox
- random numbers
- Forms that are modal in 97 are not modal in 2003
- dell w/XP what do i need 2 open & open excel
- SetFocus from ComboBox to Calendar gives Run-time error
- sequential numbers on invoices
- need help with a If=then situation.
- merging cells and then deleting rows and duplicate entry
- Dynamic Percentages Using Subtotals???
- Macro Help
- Date + Filename using save copy as
- Validate Combobox entry
- How to know what caused SheetChange event..
- Combo Box easy question?
- CountA Problems
- show date modified in a cell
- Large Concatenate - (RP)
- Searching Powerpoint from excel
- select method of range class fails
- Displaying the Highest Value in a user-variable range of cells
- comparison of data
- Autofit ?
- Problem using ASP with XML to Generate Multisheet Excel file
- Transferring information from textbox to new spreadsheet/document
- Unable to get the Open property of the Workbooks class
- Find and Replace on all worksheets on all files in a folder
- copy a sheet with all formats - column widths, etc?
- Excel CheckBox on UserForm Event Loops
- Using it twice AGAIN!!!
- Excel to word
- using "or" twice
- Address of Cell that lost focus?
- Need code for transfering cell value to text box.
- Deleting Duplicate Rows
- Passwrods
- Moving data from one cell to another
- help with macro
- CSV files
- Dependant Combobox
- help with code please
- How do I turn off macro warnings?
- RE: Automatic Refresh for Pivot Table
- TextBox and KeyCode
- Always keep the same 4 PivotItems visible
- FORMULA COPY AGAIN!!!
- Email using Lotus Notes & FollowHyperlink
- AND/OR Formula
- How to import a matrix of size 2057x2057
- Intersect Operator vs Explicit Cell References and the Dependency
- Re: EXCEL VBA
- File size mystery
- End if w/o if?
- Formula Copy
- Worksheet Form
- Re: automatically running a macro
- Excel form scrolling
- macro
- Helpful userform tricky to program
- ActiveSheet.Shapes
- How do i create a tennis ladder?
- Run time error '1004': Generaol ODBC error
- SUMPRODUCT WITH AN "OR" MAYBE????
- Change File DATE created & modified
- Shell can open an application, can it close an app too?
- CheckBox Change Event
- Micro
- string compare with wildcards
- Excel 97 - VB question
- sorting in pivot table
- How to trap delete row event and hide column event?
- Is it worthwhile to upgrade Office 2000 to Office 2003?
- Re:User form Yeah!!!!
- Can I send results of a formula to multiple cells?
- List box
- Architectural guidance, please
- vba is converting text to values!
- referring to a named range on another worksheet
- Protecting Hidden Areas
- Automatically Installing Add-Ins?
- Querytables parameters
- SUMPRODUCT OR SUMIF
- Invisible cells in VBA
- lost ability to see worksheets
- Making Address function & references as links to external files ??
- How to Write a sub to execute the following
- VBA to copy sheets (as values) that begin with the same sheet name
- request macro to save file to multiple, separate locations
- printing labels
- rounding to .5 in VBA
- Hyperlinks / server / cd
- Delete Row Based on Listbox Selection
- Re: Reading registry with Excel
- Reading registry with Excel
- Formatting Textbox
- Cells(col,row) keep moving to lower case and I can not ref. a cells in a differnet sheet
- Restrict Macro Availibility
- Excel file very large in size?
- excel solver
- Help with macro
- variable not set error?
- Over 29 args in a UDF with double parens
- How do I repeat key strokes in Excel?
- How do I sort nulls within date field in Excel
- Macro to force cell entry before running
- Sheets.Add using other worksheet as "template"
- switch rows & columns?
- subtotaling becomes slow
- Macro Copy Active Cell to Range Name, loop
- Reading data from a filtered list
- Userform - Entering Time
- Variable in a Search and Replace macro
- MOVE/COPY GROUP OF RECORDS TO OTHER WORKSHEET
- .wait for 1/2 a second
- How do I format a document?
- Array
- automating macro
- Bold some of the cell contents
- Control on Sheet - Drop Down 1
- INSERTING A PICTURE ON WORKSHEET
- Creating a unique ID number based on date and time
- Multisheet IF Function
- OnTimer Event
- Two Userforms
- My workbook filename
- Show what options are in custom function?
- VBE References Missing from Exported File
- how do I insert an ' in front of many rows of numbers?
- Updating VB Code
- calling a stored access query from excel vba
- Copying in VBA
- Excluding NULL values in an Excel List
- If/Or/VLookup Formula
- Record macro to export xml
- visual studio tools for office
- Workbook_SheetChange
- Excel and VBA.
- How do I set up an error bar in Excel and a vertical line together
- I need a macro to grab specific data and transfer it to a now worksheet
- VBA questions
- I was Asked an Interesting Question
- Adding Sound to Program Revisited
- Opening Forms error with Workbook_open
- Adding Sound to Program Revisited
- Excel2000: Declaring function parameter as an array
- LoadBehavior problem
- How to sum using vba
- how to tracking function run time
- question about Excel file writing and reading
- Open an Excel file in a new Excel session
- Print Area
- Send Email (Active Sheet)
- Copy data into cells until changes trigger new copy
- Using Autofill knowing row and column number
- Ok try agian. User form LastRow
- Listbox - Text Field
- Coloring cells
- excel on multiple computers
- Difference Escape and Ctrl + Break to interrupt code
- stringing macros together
- adding rows to spreadsheet after macro is written
- Pop up a Form when Clicking a Cell
- Placement question
- Type Mismatch error
- shape object on a userform?
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.