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 |
- insert rows
- Macro to increase cell value by 1 each time button clicked
- Buttons
- msgbox
- Creating a CommandBar - what's wrong?
- URGENT!! macro for moving data to different spreadsheet
- Finish this sentence
- Break monitoring workbook
- Userform - Populate Listbox2 based on selection in Listbox1
- List Box and Fonts
- Range.Select
- If statement in Auto_Open
- Got code?
- Protecting and Locking a Mail Merge List
- Automatically saving an Excel spreadsheet with today's date in the filename
- Border style of Excel forms
- Conditional cell reference
- Error 2015 from ConvertFormula
- Protected Workbook
- Date formatting
- Addition to code
- Re: Setting Toolbar height & width
- List Fill Range Property
- Having problems clearing a row.
- bullets
- Changing page orientation with pagesetup
- Wild card in if then statements
- Print Screen
- Multi-row data to single line data
- Error Trapping Options Change in Excel 1997
- Worksheet_Change problem
- Multiple If Formula
- Used Range
- Re: cant stop OnTime initiated macro, etc
- Updating VBA Modules and Forms in User Workbooks
- combobox exit event
- clinka32.dll
- Slow operation
- duplicate a user form?
- Minimize Excel When Running a Macro
- Selection object in Excel 2002
- drop down boxes and if then statements
- Code Reference Problem
- How to create Excel workbook from VB6?
- Hide a workbook
- How to enter a Range of TextBoxes?
- Using concatenate to create a multiline with references to cells
- Help - Deleting rows from data tables via a check box
- Best way to paste a variant array into a range?
- excel macro - macro initiation upon hitting the ener key
- Pass Parameter to Access Query
- Re: Can I use XML instead of an Excel Web Query?
- counting the number of ticks
- Conditional Formating
- Format Macro Message Box
- Query result and formula
- Random selection of items from a group (AQL sampling)
- Simple calculatation
- Need help w/ self-cert in XP
- excel formula
- How do I create a plain text email?
- Function variables
- Combo Box Fill Range
- Importing Data
- Validateing a txtbox from form
- VBA...How do you state a carriage return?
- last resort!!! please help
- ComboBox and Set Focus
- Control Source
- last resort!!! please help
- lIST dIRECTORY
- Code that retrieves values from a closed workbook
- Bit to Bit Compare of Files?
- Cell Reference in a Macro
- Printing? Worksheets not printing the same on multiple pc's!
- help moving info from one sheet to another automatically
- Trying to return Range from InputBox
- Re: excel defined name change event
- Shell command stopped working: is it part of Excel 95 , or Windows?
- vba for PowerPoint Charts
- Selecting consecutive rows in VBA
- Workbook Builtin Property - display in Windows Explorer?
- Re: excel defined name change event
- Excel. My Cell Must Contain An '@'
- Re: Attaching a buttom with an event on VBA
- Re: Add_in's Data & Forms
- Re: Attaching a buttom with an event on VBA
- How to prevent copying in Excel
- RE: Attaching a buttom with an event on VBA
- Code or formulas, not sure which
- Multiple Button Creation
- Checking for duplicate data
- Rescale the Chart Dynamically - I have briefed my situation.
- Placing a 'find'(ctrl+F) button in a UserForm
- Variable Cell Refs
- Querying Access through Excel
- User Form With Doc Word
- printing/importing problems
- Macro Loop, Find, and Total
- application/object defined error
- copy & paste from other worksheet - but not allow to cut
- carriage return macro
- Add-In...form call
- VBA to add a new chart into a PowerPoint presentation
- Deleting workbook names w/ VB
- Saveas with name of another file
- Importing Access mdb to Excel
- Re: Adding a text box to a toolbar
- saving file based on network login
- List Box
- WHere can I find a list of ColorIndex colors?
- If then .... else
- Hyperlink to open a common dialog on a msgbox
- Excel macro - Opening a sheet in accordance with the value in a particular cell
- Pivot Table Layout
- Help recording a macro to define print area
-   in Excel
- Function GetActiveWindow Lib "user32"
- Worksheet / Workbook Change Property
- formula not being put into new row
- Import data from a Outlook mail in excel
- Calculations
- Help with looking up mileage table
- Is not equal to... in VBA language???
- Excel/Text to HTML using ASP
- Macro to look for worksheet
- hide TASKBAR in Sub Workbook_open()
- Open Excel file on a remote server
- Can Vba Help With Auto-checking My Spreadsheep?
- Unhide sheets based on a cell value
- Macro for Excel / Outlook
- Displaying a message while a macro is running
- VBA Problem
- Which function is use?
- delete
- VBA and determining which sheet the code is running under
- Copy Sheets
- Question correction
- Calendar Add in
- Calendar
- copy rows
- Format Value Paste Button
- UserForm possition
- Printing Excel doc.
- Using add-in functions on a form
- Help: Macro to to sum across selected visible worksheets
- Disabling normal printing
- grouping sheets
- Accumulate data in pivottable
- File name
- Objects and Variables
- Left and Right function is not working
- Rescale the Chat using VBA
- check whether worksheet's there or not
- Error message
- Verify that the vbe is active when using sendkeys
- Turning off all the mac ros and code in an Excel Workbook
- urgent. looping thru all records and applynig formula to get new results
- Excel and Progress
- turning off unwanted warnings
- 2 sets of option buttons on one user form?
- Auto Close function in Excel
- Event proceedures
- reformat numbers
- copy named range
- find and replace macro need help
- Differentiate between cell colours
- Making a query from a web page using VBA.
- Adding worksheets
- Random Sample with proportions
- Browsing for a folder name?
- Auto-Click Save on Clipboard
- Entering Query Parameters by UserForm
- Error updating pivot table source data
- How to name a chart for referencing in VBA? And move it.
- group rows in a range based on criteria from another range (vba)
- VBA - graphics
- conditional format limit code
- how to supress clipboard notice?
- problem excel 2000
- How to use macro to rename worksheet with date +"text"
- tab in userform locks program
- #NUM!
- # added to number in function procedure
- referencing worksheet as a variable
- Macro selecting blank rows/columns
- Re: Printing Slow Down On VB Repetitive Use
- Loading images
- asp.net Office Automation - in or out of process
- Help on file and folders Please
- Print Macro - Printing out of Order - 2nd Post
- Call MS Word envelope printing routine?
- Looking up two entries in a listing.
- Read only
- How to make a button conditional
- Pivot Range Name
- Border VBA
- Userform Question
- Combobox ItemData
- Re: Verify Data Format via VB
- AutoFilter help VBA
- Change cell color if data present excel 2002
- Interrupting a loop
- Find Cell Value and Activate
- red Color for same value cells
- VB6 to VBA conversion. Form vs. UserForm differences. Object variable types
- Wrapping text in VBA Code
- Problems with User-defined Function
- Update filename
- Addd Net Connect Win98 vs W2K
- Querying sheet of unknown name
- Active workbook
- Re: formula to sum LAST five (5) values in column
- Deleting rows based on cell criteria
- Select Range of sheets
- ParamArray
- Sort Sheets Procedure
- Need Help creating multiple graphs through coding
- Syntax error.
- Repaint causes form to flicker
- Rundll32 & user error
- Re: copy-paste error
- lost double click ability to open files
- Help! need some adjustments!
- Re: Loop through open workbooks
- Re: formula to sum LAST five (5) values in column
- Error with For Next
- Buttonless MsgBox?
- Format Event Trigger (XL2002)
- Setting value of a public var from a form
- RE: Error Handling
- Using XMLMaps from VB(A)-Code
- Validation (Drop down list vs simple text length validation)
- Re: Validation (Drop down list vs simple text length validation)
- Re: Validation (Drop down list vs simple text length validation)
- Hide Row Based on cell value
- converting VBA into a com add-in
- Copy each control & rename
- Web Farming
- Naming a range with VBA...
- Copy Sheets
- display a set of data as a calendar
- web query w/login and password
- Clarification: using excel to send data to ethernet device over TCP/IP
- control a network device based on web data
- Which button was pressed?
- Help needed starting a macro
- QueryTables Error
- If integer is text???
- Filtering or linking Page Fields in an Excel Pivot Table
- Newbie: How to define the font size in the status bar window?
- Is there any method to remove...
- Re: Password protection of an Excel Add-In
- Refer to the cell in which a function is entered.
- Re: Password protection of an Excel Add-In
- saving file as personal.xls
- Re: Password protection of an Excel Add-In
- Trapping and preventing a form from being e-mailed before validation
- New Formular Needed
- Dynamic hyperlink reference
- Problems with date format in userforms
- Range help
- Not Enough Memory
- function help
- Macro : seeking max value after an Autofilter
- Last Cell
- Update Chart in Pivottable
- Protecting worksheet
- Multiple simultaneous macros and userforms
- RE: How tp query a spreadsheet table?
- Sending variable data to a web site to be computed then brought back to Excel
- Desktop Shortcut
- Saving data in an add-in
- Printing Multiple Worksheets
- Saving a very tricky code
- open work book to current date
- Changing what is displayed in an image control programatically
- Having trouble importing CSV files with a macro
- Average of 2nd/3rd/4th/5th/6th last cells
- Conditional macro execution
- Cell Formulas vs. VBA
- pls help
- Run time error 28: Out of stack space
- VBA Copy & Paste_Pt II
- Indirect not the correct solution???
- Save .csv with overwrite
- Code suddenly won't run on XL2002
- Protect cells
- Formula Assigned To Variable
- Commands at the line prompt using Shell
- Excel VBA - Solver conflict?
- Pulling Array from InputBox
- Complete a "helpsheet" code
- Need help with the Like Operator
- Re: Parameter Dialog Box
- Multiple Selection from COMBOX or ListBox
- Set smallest cell in row,col as BOLD
- Can't add a reference to specified file
- vba or formula help?
- PasteSpecial Error
- using code from an addin
- AutoFilter & UserForm
- UserForm Wont Load
- Manual Input During Macro Execution
- AutoFilter Values + DropDown Boxes VBA
- Pivot Table Grouping
- Pivot Table Grouping
- Detect macro's parent workbook or worksheet
- QueryTables Object Variable or With Block Variable Not Set
- "><" formula needed
- Copying spreadsheet out of excel with formulas (pressing)
- Min function
- Retry - Find and Replace Macro
- Problem with populating textboxes in relation to drop down list
- ColorIndex
- Exporting Graph
- Referencing a fixed cell in VBA using an IF statement
- Offset from new name based on what's checked in Userform
- automate 2500 cut/paste/format from internet to EXCEL worksheet
- Hide all images on userform
- Create a "helpsheet"
- Excel to Access question
- Problem with a defined variable
- Need new approach on forms I set up
- Help with perplexing form problem
- Code to halt a macro
- macro terminates with no error
- Capturing Print and Print Preview events
- Re: Userform Question
- UserForm | Incorporate a calendar
- Left Side of Excel Screen Turns Gray
- Finding Matching Pivot Datafield
- Increasing a range in a loop
- Finding cells and values
- Re: populating a multi-column Listbox
- Re: populating a multi-column Listbox
- Problem with Autofill Macro
- Re: Concatenate
- IF Statement
- Deleting multiple rows within a spreadsheet
- Tidy up data
- Extracting duplicate data from two lists
- Re: Concatenate
- Re: Concatenate
- TCP/IP
- Read Range Data into Array
- Simple Question
- ListBox Multiple Selection
- Wheres the bug
- Wheres the bug
- VBA Copy & Paste
- Undo with custom Paste function
- vba function
- vba function
- calling a function
- vba function
- What Is "Me.Worksheets(..."
- vba function
- Lookups in arrays
- Populate list or text box
- Workbook Formatting
- Listbox Index Problem
- storing an equation in a macro
- SheetSelectionChange
- lat long conversion
- Return MS Word word counts in Excel?
- Navigation Buttons
- run out of memort
- DIm Variables
- How to show a userform using excel macro in multipage
- an off topic question
- array of rows
- Text too long
- Desperate for help with VBA List Box
- Passwordchar Example
- Price look-up
- Multiline edit list box
- Items in a Listbox
- Temperature dependant variables - can excel do it?
- update access mdb ...
- Defining a Range
- How to avoid clearing undo stack after macro?
- is there a maximum size of parameter for a (Fortran)DLL call from VBA
- How to open a zip file from the code?
- Selecting rows in a spreadsheet
- Ranking 'off sheet'
- Concatenated Formula
- REPOST:Need help moving XL2K to XLXP, please
- Refresh
- processing message
- Comparing Spreadsheets to find information
- click event for changing cell color
- select X first/last columns of a pivot table with VBA
- Delete Sheets
- Copy before hidden sheet
- Halting the Worksheet_Change event
- Using Variable in RANGE
- Using Variable in RANGE
- Re: Comparing rows of data in two worksheets
- Turning off Active-X properties
- current row - VBA
- Re: Comparing rows of data in two worksheets
- Any Visual Basic Users Having Mouse Scrolling Problems?
- pdf to excel?
- References to ADO library for ACCESS connection
- Finding the Last Day in the month
- need formula to set value based on a date
- Getting Excel to update Outlook Calendar
- Macros
- unable to open excel file
- Why system asks me to save change even after I call save method(VB.NET)
- How to get last row used in sheet DATA
- deleting last 4 characters from file name
- Signed workbook depends on physical location of AddIn - Digital Signature Invalid - workaround?
- Validation lost on advanced filter copy
- Data Validation Criteria
- Macro to copy down specific number of rows
- array formula in Name Definition.
- Shared Addins
- AcitveX only runs with admin rights
- copying all formulas, except sum
- copy protection
- xls file size / memory errors
- Search a column for the last five cells?
- Saving with date in filename
- How to plot chart in VB program
- How to restrict the excel sheet containing Chart
- Copying Cell Using Macro
- UDF tooltip
- How to replace a macro with an addin??
- Undo change
- HTML HREF Opening in Browser
- Help with Workbook_Open
- Help with vba coding/userform....
- How to lookup hyperlinked cells
- Using Macro & offset to put in formulas
- making a userform work ,oops
- making a userform work
- Copying across VBE
- RE: Searching zip codes
- macro connect to Sage DSN
- Automation Code Problem from Access to Excel
- Re: how do you have one cell alter another cell
- Simple Macro
- Sort Orientation
- Adding up values of textbox in Userform
- Macro to save worksheet
- Control Toolbox grayed out in Excel Spreadsheet
- Date Change
- Thanks
- Importing Text File
- Selection and Areas
- Activate Chart
- Printout Code Problem
- I need some help here
- where is the workbook_open event handler???
- Tab go into the editing text box not next object
- multipage question
- userform
- Userform to spreadsheet
- verify open windows
- Excel macro problem cursor down
- Tab-key
- ([([([ Page Breaks Problem ])])])
- Variables not showing value
- Running a macro every half hour
- How Do I Expand A Set Range In The Match Command
- Auto Duplicating Worksheets and Insterting Data from Different Worksheet
- Macro to hide rows containing no data
- external reference
- Excel Version
- Golf Statkeeper
- Excel 2003
- Setting References in VBA
- Test
- Excel 2003
- Does CoGetInstanceFromFile work with worksheets?
- Opening A File From Excel VBA
- Executing a Macro From a Desktop Icon
- format a listbox
- Column
- Relative Macro Assignment
- userform macro button problemo
- Excel 2003
- Looping Text
- i have a really long problem,
- delete items from a column
- Problem with Office Developer XP in Excel 2003
- run time error
- preventing closure of active excel window
- Licence help wanted
- username
- hiding rows
- Excel VBA Beginners problem
- makes a new list
- Summation of cells tied to Checkboxes
- counting formatted cells in vba
- Excel end user reports and preventing changes to users excel settings?
- Protection options through VBA
- FTP FILE TRANSFER PROTOCOL FROM VBA?
- Functions
- **HELP** Can This Be Done
- Copy/Paste based on cell content.
- stillcheckbox remains a pain Frank
- Getting Windows user (Account) from a VBA routine
- Calling Access Program from Excel
- Formula to return Friday's date: m/d/yyyy
- Excel 97 vs. Excel 2003
- Excel 97 vs. Excel 2003
- userform data to spreadsheet
- vlookup, with more than 1 result
- Match & Indirect
- Clarification please...
- vba code to reboot
- Help: Profit margin
- test
- Automatically Assigning a Macro to a button
- Automatically Assigning a Macro to a button
- vba weird messages - "catastrophic failure"
- Open Event Code Bug
- Last cell
- INSTERING A ROW
- Macro command to open a file
- Variable with value before being assigned?
- Overflow when translating from C++ HELP!!
- Hide the DisplayPasteOptions
- Order in which add-ins load
- On error
- Can this procedure be made more efficient?
- Password protect data entry to cell
- Resizing a Range
- Ranges using offset
- Re: code doesnt work
- Opening new workbook
- UserForm Problemo
- Creating Macro's
- macro to email excel files
- Msg boxes
- Can a graph use array data instead of ranges?
- Help
- Re: code doesnt work
- opened workbook (not resolved question)
- changing a Word doc to Excel
- Formulas for...1. Counting unique cells 2. Display unique contents
- Re: code doesnt work
- Ignoring cells with no value
- Re: Clearing the contents of merged cells
- Copy Sheet
- RUN Time error 9
- GOTO another sheet
- User Form
- Print header change
- Excel VBA - Storing text in a variable, and "'Cells' of object _Global failed"
- excel VBA: input boxes
- Re: unable to hide the "ask a question box"
- macro
- Macro to search, compare, copy and delete
- Seperating Letters from words using character
- re:enter button in vb
- Change a positive value to a negative value
- How do I get a reference to a control on a sheet?
- Userform inside another userform
- Pivot Table Names
- RE: Making macros available on lan in Excel 2000
- If criteria not met then message box
- User form keeps getting smaller...what the ???
- Printing Marcos
- Attaching a similar forms to many templates
- RE: Selecting/Printing a Named Range via VBA
- Exporting Data Question
- Converting numbers to column letters
- data validation
- Excel - get address of cell
- Count days
- Need help with Macro
- Populate Column Header on ComboBox
- Custom paste macro
- Using vb to launch a shortcut
- HELP! XL2K to XP -what reference am I missing?
- Pad with leading zeros?
- recalculating advanced filter?
- Copying to another Workbook
- Worksheet Password Protection in VBA
- Mode Function
- VARIABLE SUBSTITUTION
- Name not recognised
- Date macro
- Aligning lists
- Copy and Paste hidden cells?
- inserting latest picture file
- Will Excel create a checkbox?
- File Conversion
- ActiveSheet.Printout or Page Setup?
- My problems with simple addition ...
- don't bother
- blank cells
- How tp query a spreadsheet table?
- Formatting part of Cell
- Exiting a VBA Macro by user intervention
- error on oXL.Workbooks.Open
- Excel VBA event trigger problem
- if function prob
- enter value, calculate, in same cell
- UserForms and Variables and Types of data
- Copy before sheet
- calculate the average of a column then move it to excel
- VBA to number worksheets?
- Re: When saving add automatically contents of a specified cell in document properties
- Can an advanced filter do this...??
- How does msgbox stop the OnTime event?
- Problem with SendKeys + active window
- Delete Multiple Worksheets
- Active Directory
- Add library in vba
- Complex Match problem
- Excel filename into cell
- Maximum length of a line?
- extracting part of string value
- Refresh Browser with vba
- wraptext is not updating when using references to another cell
- Variable scope
- Thanks, This works perfectly
- Help with e-mail macro
- Excel VBA - Last Author properties
- Loop code problems
- Excel in batch mode
- Sheet Name not accepts special characters
- Code for Case & Number format
- automatic text insertion in preformated spread sheets
- VBA question about Variables
- Hide zero column in Pivotreport
- A good book on using Powerpoint VBA to drive macros in Excel ?
- Excel Web Query
- Printing
- Printing
- openning spreadsheet
- Using the result of autofilter and performing tasks on each value
- Hiding sheets with macro disabled - with a big twist!
- for next with web query
- How To Copy Sum of Cell Values vs A Single Cell Value
- Non contiguous to contiguous
- How to disable Visual Basic Editor in Excel file
- Create a separator line using conditional formatting
- While reading excel file i am getting null values
- Macros to run in any workbook
- Highlighting only cells with data in them
- Highlighting only cells with data in them
- Pie charts in Macros
- Looping though *.xls files except for the main consolidation file
- New to VBA from VB6
- How to disable Ctrl+Break
- Select Cells with VBA
- Array Functions
- Spin Button...
- Problem on the ASP using the Excel.Application Object
- ssfHistory & ShellSpecialFolderConstants
- Run macro in Excel when new data is on the clipboard
- xlDialogActivate to Select Sheets?
- Getting "compile error" "method or data member not found" on reinstall
- Change from 2K to XP and Excel.xlb toolbars
- Powerpoint and Excel
- Intelimouse scroll wheel
- Control Box Option Buttons
- textbox options
- No debug box
- protect print_area?
- First empty row after last used row
- code to terminate access after certain time
- telling Excel to go down relatively
- Command Button
- LegendKey modification Error
- Changing backcolor of commandbutton
- Help with Menus
- Problem with setting Pivot Table data orientation
- How to make the "Save As" prompt appear with vba?
- Formula to search cell to see if it Contains a value.
- Programatically saving XML file as Excel spreadsheet
- Auto-Formatting in Excel: changing values
- Print Area when subtotals are on.
- Save at start of month
- User form
- Search Using Autofilter - Field
- else if code
- Virus Warning
- Easy one (I hope) Using Sheet Names to reference sheets in other Workbooks
- Conditional formatting & interior color
- Circular Reference Conundrum
- excel vba - spreadsheet code "apply to all" problems
- Pastespecial and cut
- Column Sort (VBA)
- Re: Active Cell
- Recall a variable referring to a worksheet name?
- Re: Active Cell
- Need program to ask me to save changes when closing
- Make "BeforeSave" event supply a default path and file name?
- Slow Macro on Page Margin Change for all sheets
- Solver
- Excel column widths change on different machines
- Finding Max Within 3 Columns
- Print Macro - Printing out of order
- If Range("C1") is in MyArray
- Custom Worksheet Function not updating
- dynamic subtotal %
- Add-in conflicts
- Control Properties Not In View
- Lock down a new instance of Excel App
- how do I create a checkbox?
- Does anyone know why this won't work?
- Using an Excel "object" with my VB DLL
- Problem- Recording macros for "file save" and "File open"
- Re: Executing an older excel 4.0 macro
- MyBar doesn't run automatically
- Re: Running Macro when value in spreadsheet is true
- Creating a action for a defined object
- Email distribution list
- Not found objects
- macro function is too slow!
- a round of applause to frank kabel
- Date Validation
- oh, and another thing
- Strange PrintOut Behavior
- Thanks!
- save conunderum
- Copy cells from other workbooks
- For Next & Hidden Sheets Issue
- remove reference via code
- 2D array lookups
- Find loop
- does textbox contain a number
- PRinting two many repeated lines
- Accessing selected cell from modal dialog
- lock customize bar
- Search form
- I want to protect a cell but allow formula values only
- Late Binding
- Using Add Method of QueryTables gives error
- Special Action on E-Mail Error Condition
- Try again: VBA to automatically install ODBC data source
- Obtain a Process ID
- Using For Next to reset Pge Brk Preview on all sheets
- hide a page on a multipage control
- Make an unsaved file copy in memory?
- User defined Spreasheet Functions - How to add "help/ assistance comments"
- CSV to TXT: how to
- While reading excel file i am getting null values
- VBA References - when is Office Object Library Reference set? Best practice re. Early/Late binding ...
- Return to Original File
- Restrict Population to MS Query by Cell Ref.
- BIFF8 Sample
- Object Variable or With Block Variable Not Set
- Getting sheet name
- Remove Close button
- How to check output folder has been created in the network path?using VBA programming
- Trying to run MS Excel 2000 macros on MS Excel 2002
- Loc and LOF functions
- error in sorting
- Cells.find restricted to a single range??
- Compare two ranges and display equals in list
- "Excel - Get Date"
- Clear Contents Of A Text Box In User Form
- Hide and printout area conditions
- Combox box question
- opening diff. worksheets in opened workbook
- getting external data
- select distinct row
- finding empty rows and deleting
- divide and conquer --- help!
- find next blank cell
- Suppressing Enable Macros QUestion
- Saving time
- Add sheet and rename with cell contents
- Userform w/ Multiple listboxes that link
- Vertical Entries for VBA.Array
- Can VBA log into SAMBA
- Copying data from different sheets
- Anybody want a job?
- Sort of Data
- Excel compile
- weird problem with PivotFields CurrentPage
- Conctenate
- Outlook from Excel
- Re-post of existing problem
- Compile Error: Procedure too long
- Finding first (end of range) empty cell
- Digital signature on workbook/addin invalid when files moved?
- HyperLink Windows
- Lookup and Select Row
- Referencing an Older Version of the Excel Library for Development
- Mouse drivers that work with VBA & horiz scrolling?
- sending a cell to a textbox?
- Copy Selection to new sheet
- if macro
- Referring to Microsoft Excel array in VBA
- change password
- Editing text within a cell
- Simulating a synchronous process
- Range selection not working
- need form to initialize without closing
- Find Help
- sortingproblem
- Copying unlimited range of data and closing the file
- Problems with Excel 2000 from 2002
- adding text for a specific range
- Time to learn to find the right folder *sigh*
- Capture scrolling event
- Delete Rows
- User Form/Input box problem
- Visual Basic
- Fill a ListBox with items using VBA
- Count Cells with text a specif color
- moving automatic vertical pagebreak
- Re: Help with VBA
- Cell size format
- recursion depth, 'Out of stack space' in Quicksort
- Message Box Question
- GetOpenFilename - How can you filter files starting with a letter...
- Excel filter range
- VBA - closing without saving changes
- Find and Replace HELP!
- Pivot Table PageField
- Get the GAL in excel
- Field in Access
- Mileage Chart (I'm a beginner)
- Download data from website
- Read a current footer value
- Using a "File-Open"-Window in a Excel Macro?
- Linking files together
- Creating and closing CSV file
- movable formula
- clinka32.dll
- make the parameters show up when you create your own functions
- Make toolbar buttons appear only in specific files?
- How play a wav file
- Finding unique sets of numbers that total 200
- Problems with Personal.xls
- find and insert missing values
- Shortcut Ket after the fact
- Argh...layering object problem in userform
- access sheets in another workbook
- Macros
- the "Procedure too large" error
- Not Enough Memory!
- Notification when Filter is selected
- Workbook Open event
- sub to create a sub
- Combobox Item Number
- Link Combo Box to Autofilter argument
- excel vba array problem
- Excel VBA-Personal Budget: Identifying text in a column...
- Beginner question (I hope)
- Excel2002 autoformats dates,
- Help please- user selectable image
- Excel VBA - Setting Print Area in VB
- subtracting ranges?
- Formulae In User Forms
- Save file, refer filename to cell and change directory
- Last Time Updated in Footer
- Status of sheets in a workbook
- Select rows after finding last cell
- Annual Percentage Rate & ARM
- How to Format a ListBox column
- monitor small/large font code
- Start excel from DOS?
- Restricting access to OLAP cube data
- Prorating calculations in Excel
- identifying which cell calls my VBA function.
- Excel AddIns VBA Locking v Unviewable
- Excel VBA Locking / Unviewable
- WorkbookOpen code not executing properly
- Re: Vision Objects as Controls?
- Re: sumif not working if using different rows
- RE: AddItem Method - Combobox value
- Using Outlook Object Libraries V8 & 9
- Concatenate a strings range.
- Certifying Macros in a Domain
- Printing
- Creating Custom Toolbars
- Inactivate message boxes
- Recognise value not formula
- AddItem Method
- Re: Tom Ogilvy
- Formulas not updating when add new inputs
- Re: Tom Ogilvy
- Save As
- Save As
- problem with buttons
- Streamline macro code.
- How can you determine if a cell is formatted as a percent?
- Changing Pivot Table Fields Programmatically
- Blank grey toolbar after code !
- Solver constraints not added
- Available serial numbers...
- Sheet construction on server security issue
- Prompt for new folder
- Formula for finding text
- import of txt list to Excel
- Help please, what Function?
- Count used cells, in a specific range...
- Strange borders
- Opening and closing a picture dialogue box
- RE: Anybody want a job?
- How Format a List Box
- Arrays
- suppress warnings
- Multipage & Spinbutton controls on a form
- Macro to remove all names from workbook
- Pass an argument to Excel workbook
- Find File doesn't work properly
- Help please!
- Ranges / Loops
- drag and drop cell group into textbox
- Getting value from closed workbook
- devide the whole column...
- Import file dialog
- VBA, Impersonating other user
- Outlook AutoSignature
- Prevent formatting Cells with Protection
- Copypicture method failed
- Open Access database(DAO) with password protected
- Printing using VBA
- Cell Transfer
- Qualifying sub names
- Moving a range between workbooks
- Funny function problem with add-ins...
- How to get a range of values into a combo placed on USERFORM?
- insert linked chart from excel to powerpoint
- Creation of a range with no specified address
- Hide subtotals of rowfields in a pivot table
- Sub checker
- Excel VBA- Error Accessing the system registry
- PrintOut_Method Outputs (Win 2000 Pro and XP Home)
- sumif with different rows won't work!?
- Copy Files
- RE: Toolbar
- storing global macros
- Insert into existing code
- Code Error - Run Time Error 5 (Disable Cut, Copy & Paste)
- Workbook crashes after renaming a worksheet - References problem?
- Array of OptionButtons ?
- Saving spreadsheets as delimited text files
- PrintOut_Method
- Paste button greyed out So I can Not not paste between Excel
- textbox ,problems?
- Re: Toolbar
- RE: Anybody want a job?
- Re: Cut & Paste
- Stored Procedure call and passing parameters
- Help Deciphering a Lotus Macro Snippet
- printing using vba; listbox/command button
- Re-Name a Worksheet..... with a Twist
- Selecting Distribution List when Mailing from Excel
- ChangingPivot Table programmatically
- Unserform with a varible
- Variable in a Formula
- RE: Tom Ogilvy
- fit to te left
- calling from one workbook the classes and functions in another
- VBA and Different Lotus Notes versions
- Re: GetOpenFilename returns a string rather than an array
- VBA MsgBox() Text
- How to know if a sort is finished sucessfully?
- Page Break Problem
- on what page a cell is located
- Lotus Macro Commands to VBA equivalents
- Excel 2003
- Column
- For..next.. help to fill listbox
- CheckBox in VBA
- Single Digit Entry
- Re: Inserting rows based on another cells value
- Print a number of rows per page
- Question On Formatting cells
- Inserting rows based on count
- divide multiline text cell across several rows
- Find item and delete rows
- Before Save as Event needed
- web query based on cell value
- Help WNetGetUniversalName ... in vba
- Re: How to find the position of last ":"
- Re: GetOpenFilename returns a string rather than an array
- Add a cc to this code
- Re: Macro Error Please help
- Need Code to Set Scaling Zoom in PageSetup in Auto_Open Sub
- Fast way to insert data from database
- Re: Named ranges
- File size increases by 300kb without any changes?
- Column width units
- Re: See who's quickest at solving this
- data extraction / cleansing a string column in a workbook
- E-MAIL
- Help with IF statement
- Comparing spreadsheets
- Compare two working files
- Copying text as a formula?
- Copy cells with unspecified values to new sheet
- Frank Kabel
- Calculating weekly avegage efficiencies on a weekly basis
- Directory Contents
- Re: Named ranges
- Re: Named ranges
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.