- Tom Ogilvy - More help please
- Problems targeting any version of Excel
- Countif a Name occures in a column
- number of lines of wrapped text
- Macro button on one sheet only
- Getting chunks of 200 items for stock query
- linear graphical method programming
- auto count possible?
- removing (All) from Pivot Table
- a simple macro
- Run only part of a macro for testing
- accessing controls
- Multiple formula entry
- Formatting cell
- Where to Place Public Subs and Functions
- Using ADO to Query Excel
- Compile error, variable not defined
- How can I delete a macro in excel?
- VBA to find a value in a list
- Digital Certificate
- Not Enough System Resources
- Crash attempting to open Excel Add-in using .dll file comprised of VB6 code
- What did I do? (Select Method of Range Class Failed )
- Need hlp capturing a certain pattrern from a column
- Excel forgets Custom VBA Function (#Name error)
- Delete/clear a cell based on another cells contents
- exporting Excel data to Word using Bookmarks
- Can an Array formula count unique values and report no. of times for each?
- SQL statement slower when refering to cells.
- listbox problem
- exporting data to appear at Bookmarks in a Word Document
- Error accessing the system registry
- default date in Excel
- Insert Column
- Trouble with select statement
- "delete method of range class failed
- Enter formula and fill down
- Sum Formula
- How to Save As Variable File Name
- Cursor gone beserk, apparent overdose of steroids!
- macro to write other macros?
- RE: How do I use Excel for a Univ. level course scheduling tool?
- Color lines of a combobox
- How do I use Excel for a Univ. level course scheduling tool?
- formatting question
- Removing Digital Certificates
- read serial data
- Question about XML compatibility in Excel 2000/XP
- How to create a Text File ?
- Error in large file import macro
- merge excel and word
- Copy/Paste Formulas Without Linking Books
- HOW TO FIND SOMETHING IN ANOTHER FILE, WITCH IS NOT OPEN?? HELP ME
- Select Method of Sheets
- Is this possible ?
- Opening a Workbook in the Background
- Long Excel Formula in VBA gives error
- Debra Dalgleish: Pivot Table problem
- How do I change a cell's background color randomly, continually?
- QueryTable Questions
- BeforeClose VBA Question??
- How to update a control without screen flashing
- Custom Menus Error at Close
- Skip Autocomplete if need be
- ScreenUpdating "peephole"
- Get names from Access table
- Saving a Worksheet Shape as a Graphic File !
- How To Fill 2D Arrays Easily
- Make macro-button sheet reference relative
- Saving a Worksheet Shape to disc !
- How can I disable Subtotals?
- Set Column width
- Combine row insert subs
- Detect when a UDF is being edited in the Function Wizard
- How to stop UDF firing when sheets(n).calculate
- Making hidden graphs visible or removing
- how to avoid merging when pasting multiple ranges
- Excel 2003 graphics are invisible after loading xla
- Determine the size of a range
- Sequential barcodes
- Using a variable in a range
- Auto-generation of pivot table from XSL stylesheet
- Purge Data Based on Cell Color and Time
- Filter & clear cells
- Type Mismatch Problem
- LEFT embedded in SUMPRODUCT
- Re: Compile error: Procedure too large
- Printing Problem
- Not programming , but chart help
- How can we return to default values?
- Opening workbook with OpenEvent
- Creating a listbox from a column
- Re: Autofill method of range class failed - sometimes
- Add lookup to for next
- Re: Autofill method of range class failed - sometimes
- external data from multiple sources
- RE: macro to find and enter
- macro to find and enter
- Forcing autocomplete to lookup from a range of cells
- GetSaveAsFilename Command Maximixes Window
- Add Procedure To Module Via VBA
- Assigning backgroundcolor to button on form
- Excel Graph Click Problem
- what a help document in Excel VBA! Should be revised for the sake
- Batch Modification of Ranges (Optimization)
- CreateNewDocument : an small but interesting discovery from office
- OLE text runs together
- Why does this bring up VB?
- Lookup function
- Sequence Part Two
- Excel Add-In with Command Button Controls
- conditional if then's
- VBA codes for macro to continue
- Line of code hanging up on one machine???
- Choosing from 2 formulas for one cell
- Microsoft Common Dialog Control
- Common Dialog Control not properly licensed
- Common Dialog Control not properly licensed
- Common Dialog Control not properly licensed
- excel to pdf
- Working application - Now generates error
- add event to controls added in runtime
- Missing WrapText from range object in Office Web Components
- Trim Data in a Query
- How to Stop ReEntry
- Building Forms (like a command button) into a cell
- Versions and compatability question
- Formatting a cell to display varying decimal places.
- Formula NOT working
- How do you sort 9 digit zip codes in Excel?
- Macro for IDE
- Timetables - next departure how to find relative to system time
- How do I insert symbols using VBA?
- excel 2003
- Finding Data
- Putting plain text string into clipboard in VBA?
- Copying a line
- Bordering
- timer
- Getting cell address from input box
- can we color a cell content partly?
- Count of FIRST Digit
- Cells.Find , why it DOESN'T search ? help
- worksheet tab position--possible to modify it?
- how change date format in range?
- having the same name for a lst, on multiple sheets
- how to identify built-in Names
- Msgbox to make a choice
- import tekst >65536 rows
- add-ins & events
- Problem adding charts using Do-Loop Until loop
- Activate Form using a macro
- Excel formatting and Acrobat Distiller
- Having trouble getting sort to work in a macro
- No Subject
- No Subject
- Hyperlink dialog
- Dynamic Web Query from VBA
- find word in a cell then change cell format
- iterating over a filtered list
- How to run a macro every March
- Help on printing comments
- savin from excel sheet to MSAccess
- input of text longer than 5 rows
- Macro no longer runs
- Do within an If statement
- Convert Normal formula to array formula
- Use MS Query in VBA to only get a SQL statement
- Calling the Print Form
- Dataforms
- Data Adjustment
- Change cell colour for a cell or range within a predefined range
- Count Number of full rows
- Runtime error 1004
- Assign macro to a button problems
- How do i reduce the thickness of Border in Excel?
- UDF parameter description
- Protected worksheet and Outlines
- Another save as question
- Linking Combo Boxes
- finding the right file
- customised sheet
- triple state button question
- Mouse pointer position, excel2002
- Programatically control picture property of Image control
- Non embedded chart location
- command bar problem
- creating pivot charts from multiple pages
- RE: macro to transfer info
- trying to be clever
- macro to transfer info
- Formula vs data
- Hide/Unhide rows
- Pivot Table Drop Down.
- disappearing ActiveX controls
- Deleting Worksheets in VBA
- Maintaining links to cells for database query ranges
- Shortcut Key to insert an em-dash?
- Pass variable from user form to macro
- Excel cell format
- VBA Reference Library ADO 2.7
- Hidden workbook properties/methods
- For Each Next woes
- Using CodeName when Selecting Multi-Tabs
- Excel, Macros, Database
- Extracting Modules to Compressed Windows Folders
- Differences in the way a .xls file is opened
- Overlapping conditional formats
- VBA macro in Excel toolbars
- PIA distribution
- Free Tool (Add-In) for Improving Your Data Processing Efficiency
- interface with other applications
- Understanding Templates
- Date formatting
- sequential Shell commands?
- Can PrintTitleRows method be restricted to a region instead of the whole worksheet ?
- identify active sheet
- Forms? Want floating user-option menu in worksheet.
- what I need is a first-if formula
- Can't hide/unhide rows under worksheet change event?
- Merge Two Spreadsheets into 1 new sheet...
- Mouse over message
- Batch file to start multiple excel files with auto_open() macro. Delay code needed
- SaveAs macro: How do I specify "Replace existing file?"
- Excel ActiveX causes lost Class Module reference
- Corrupt file, please help ??
- day of year/week of year script
- Advice on formula Please
- How to find next empty cell within a column?
- Look for a string in filenames in a folder?
- Help with Macro or VBA script - Insert current Time/Date for different records
- Row Number
- Prevent PageDown
- menu bar keyboard shortcuts intermittent.
- Simple Macro Question
- Macro to export a worksheet and save as new file
- Auto-Open procedure
- is better excel or acess for visual basic
- Is there a conditional formula to hide and unhide columns?
- Automatic total of more than one invoices
- Place Shortcut On Desktop
- How to cancel a calculation in VBA
- Deleting a 'workbook' macro
- comboboxes
- Spawning worksheets and a summary per worksheet
- Re: Convert Number to Words (Indian Format)
- How can I run solver add-in in a macro?
- Hi Bob
- Re: How can I "set" a checkbox name like i Set a worksheet?
- Check columns for data match...
- Inputting a filename into a cell
- Stop Formatting text as DATES???
- Copy Past with macro
- Mental Block! - Event Change Conditional Formatting
- Data is on several sheets, i want it on one...?
- SaveAs with a twist
- determining a price based on 700 combinations
- external data
- SAP / Excel
- Error Handling problem
- Print dialog - force it to show up?
- Sort order for graph and not spreadsheet (dynamic)
- Find first occurence of specific data in a column.
- Inserting Rows into a worksheet
- Allow user input into VBA Module?
- Incremental Numbering in a Column w/ Specified Text
- How to stop the user from seeing what's going on
- Find numerical values in one cell,within another cell- is it possi
- Convert SQL query Sub to Function
- share excel macros
- Save Excel file as HTML - with headers/footers
- Script out of range error
- updating pivot charts with vba
- Add VBA code to multiple WorkSheets
- SelfCert and other Cert authorities
- How do you get rid of a link that doesn't exist anymore?
- How to Check if a Process is Running
- Auto Running a macro on open
- faulting module vba332.dll
- Excel Date Time to Unix Time
- Drawing Arcs
- A function that separates hours worked in work shifts that overlap
- DisplayAlerts & ScreenUpdating Properties Changing Unexpectedly
- Workbook_Open event not firing
- Worksheet Change event
- Address List
- Page Setup not selecting
- Writing Variable to Cell
- Creating XL links in VBA code
- how do i append from several excel tab to another?
- Conditional Formating
- Range problem
- Password Protecting Macros
- Backward compatibility for VB6 COM Excel Add-In
- How do I
- Simple Userform
- Copying a userform into a new workbook
- How do I get the column of a cell?
- BCP Insert Into Excel
- Autofilter problem
- Creating Custom Face IDs for Add-In Buttons
- TextBox Location
- pivot table comparison
- adding cell data into a macro to allow specified information filte
- Show form based on file type
- top/left cell borders don't show
- How to Insert Dashes
- How do I Address A Worksheet From A Cell Reference?
- sorting time in a column
- Howcan I delete blank rows efficiently
- Conditional Numerical Formatting
- ActiveSheet.Protect
- Macro runs on certain worksheets, not on others
- Best way to set up worksheets
- Selecting Sheets based on Cell Criteria.
- STARTUP
- Data base Book
- Re: How to put a button made through Control Toolbox
- The Form option
- get current value of cell containing formula
- Re: get current value of cell containing formula
- Variables Between Workbooks
- accesing controls in for each loop
- Extract rows with specific text in a column
- Assigning Macros to Toolbar buttons
- Print problem
- coloums comparison in excel
- creating folders on hard drive from name field
- EXCEL
- variable length more than 1024 - how to show string complete in excel?
- How To Loop From File0001.xls To File0150.xls
- Macro to update pivot table data range
- Manipulating Access database using Excel Userforms
- Find String Excel VBA
- adding values in column D where cell in column A contains certain
- PublishObject.Publish Error
- Copy text to specific cell.
- Stepping through an autofiltered list
- time/timing/breakpoint
- using Excel with c#
- Macro to strip out certain rows
- protect/unprotect a VBA Project
- Upperbound of Selected Range
- Forms
- Re: protect/unprotect a VBA Project
- Error in this code.
- File Linking Problem
- How do I write a macro that hides a row based on data in Excel?
- Re: Isolating New Entries
- Don't show sheet switches when running macro
- Format of Variable
- Re: Files won't open after running a macro
- How to hide a column once any cell of that col. is not active any
- Combining Data in Multiple Cells
- Ensure Addin is loaded properly by user - no double clicking
- group data
- freeze cells
- array for email attachments?
- How to avoid Update Links notification?
- Hiding the macro
- Corrupted Excel file - but on only one machine?
- Private Sub Worksheet_Change(ByVal Target As Range)
- Worksheet copy speed
- Issue with parsing text file into worksheet
- suppress the replace-messagebox
- Convert Range To JPG (Resized)
- Checkbox to hide/unhide named range
- Custom Function in Array Formula
- concatenating phone number "segments"
- Opening an add-in hangs when run from scheduled task
- Installing .xla add-in via the registry
- Re: Sheet Protection
- Data Validation
- Access Recordset Rows to Excel
- Need help with macro to move cell data
- Formula
- Simple Division??
- dropdown list to activate Macro
- Array max formula?
- Dates
- Application.VBE.Version on Excel XP
- Dialog Boxes: PC and Mac
- Code to Test Condition and Save Record to Excel
- Make more info appear when mouse moves over a macro command button
- Cell Reference
- web interface for excel
- Macro help on dynamic sheet
- Modeless userform OLEObject Add problem
- SaveAs causes 0x800A03EC error
- ADO connection/SQL query in Excel function
- Programmatically scrolling to top
- how do I prevent a file from opening if user has disabled macros?
- Importing a large amount of data using Basic
- ComboBox,Array and Index numbers
- VBA Proper Case Code
- SendMail
- Turn Calculations On without Calculation when Turned on
- Write to One Worksheet Only ?
- updating a workbook based on previous values
- Private Sub Worksheet_Change(ByVal Target As Excel.Range)
- Impossible??? or you can????
- testing for #NA with VBA
- excel VBA for auto open PowerPoint
- Transposing a column to several rows
- Searching for a root directoty
- What needs to be installed on the server for excel automation?
- Msgbox prompt and tabbing
- Newbie Question
- Hiding macros
- Context menu on userform
- Character Set 032 vs 160
- missing buttons
- how to avoid excels run the antivirus
- hide rows from checkbox
- Range R1C1 notation & the problem with my Macro
- If A is poplated, so must B
- Opening a browse and load file box in a macro
- Database access, pluggins and custom menu bar
- vba routine to print a list of documents/worksheets
- how to extract XML info with VBA?
- Button to open excel file
- Can I "park" a UserForm?
- Re: Custom Function in Array Formula
- VBA function , IsDate() not available
- "Could not locate some objects...."
- Open Non-Excel file
- prompt for password only once
- implicit activation
- Shared Workbook - Print Settings?
- Format & ControlSource
- Checking for missing references
- How to capture user ID in Excel macro?
- payroll record help
- Dynamic Cell Names
- Hide show blanks
- VBA help
- Absolute/Relative Referencing & Buttons!
- Database output page --> Excel
- control other applications
- MS Access Query
- Do..Loop in multi sheets
- Disable All Cmd Buttons Except Those Meeting Criteria
- VBA with Matlab using Excel Link but not Excel Builder
- raltive cell ref conundrum
- How to copy a range with same format !!
- Updating Links
- Find ranges of rows that contain 1
- Sumproduct in UDF
- time/timing/breakpoint (2)
- Combo Box
- rationalizing date format in column
- Unable to call external program/dll
- Macro Errors
- currency and textbox.
- Re: currency and textbox.
- Code assistance
- Re: currency and textbox.
- Re: currency and textbox.
- Re: currency and textbox.
- Re: currency and textbox.
- TEXTBOX DROPDOWN
- copying pivot table results to a new sheet.
- Create cell formula from a relative position
- Syntax Problem : Grouping Buttons On A Multipage
- hide rows with macro
- CommandBarButton click vs. double click
- Difference between 2 times and dates
- Refresh Pivot Table from other worksheet cell entry
- Update Website from Excel ??!!??
- entering data to table
- graphs' source data macro
- worksheet limit
- how to save to Access
- Can macro create another macro?
- What is the maximum length of a URL in a web query?
- Relative File Link in Macro
- Macro Problems
- Copying 2nd Sheet
- specfic number formating
- Macro Revision needed
- Allow entry only once
- Copy on visible cells only ...
- Application defined error
- Code assistance needed
- Re: Copying 2nd Sheet
- Excel 4.0 Syntax Conversion
- Move Folders on the Server vs. Local Machine
- VBA for sending workbook via Outlook
- hiding rows with checkbox
- How to detect "F2 key" event
- Hide/unhide sheet macro based on cell calculation
- Help eliminating a space in concatenate formula
- sendmail to variable
- Trouble getting the value of a cell
- CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = Fals
- trouble with commandbarbutton.state
- Subject: Macro- Copy same rows into own worksheets
- scollable listbox
- Easiest Way to have access functionality in Excel or vice-versa?
- scroll listbox with mouse wheel
- drop down menu
- Problems with same macro diferent place
- how to preserve data?
- URGENT!!!! creating records in a shared workbook
- Reading from comma seperated List
- Control Tools
- AutoRun Excel Macros
- Excel Macro will not allow references
- Selecting Rows with Macro
- Parameter Query not refreshing.
- Insert a key function in VBA script
- Why does Outlook.Application.GetNamespace("MAPI") Fail?
- Make dynamic reports available over internet?
- Close program
- Documentation/Reference guide
- ChangeFileAccess
- transfer data between worksheets
- Workbooks.OpenText does not work on XP. HELP !!!
- RE: transfer data between worksheets
- Re: Problems with same macro diferent place
- Re: ChangeFileAccess
- Re: ChangeFileAccess
- How do I open an Access file with a macro in Excel?
- VBA code to select data from table into combobox
- TextBox Format/Editing Problem
- Randomlly pick number
- LEN
- get a sequence number from . . . ?
- msgbox based on cell entry
- workbook or worksheets
- Auto Filterning with HTML
- VBA code using Find to locate text and display the Cell Range.
- PivotItem positioning...
- clearing the contents of specified cells
- Macro to cut/paste to last cell
- Help With Missing References
- Time Format in VBA doesn't match Excel display
- Viewing UserForm code in Notepad
- Userform Help
- Referencing multidimensional array
- How to put this formula using VBA
- How to clear a batch of VBA projects' passwords
- Excel Application for Business Modelling
- I desperately need to know which autoshape is clicked, programmatically
- Excel CSV format
- checking VBA code
- AutoFilter removal
- static automatic date
- Excel Communication
- And...
- Navigate in sheet with a button
- Printing question
- ?? MultiPage Cancel/Next/Previous/Finish Command Buttons ??
- How can cells be filled in to show quantities?
- delete info via userform ?
- Add-in problem
- working with cells numbers
- Is there an excel, public domain, rough cut capacity template?
- Problem With Date and Time Picker Control 6.0
- Random Ltters and Numbers
- Access connection works in Macro, not in user-defined Function
- Range syntax
- find changes in a cell range, copy changes to another workbook
- Problem with a search
- Moving a disk file with VBA
- Excel and Powerpoint
- how to install macro?
- Copying the Editing in one file to Another opened XLS file
- hide / unhide names
- Bypass worksheet_change event
- Checking cell for 2 conditions
- Custom functions using arguments with same name
- Copy/Paste Values
- Change number property for cell on another sheet
- copy table or graph and paste into powerpoint
- I have question.. I have problem with Cells.find
- How do I move data based on a conditional column search?
- read excel worksheet
- Naming a Sheet with a function
- UDF, Change Event and Dropdown boxes
- Setting the Width of a column
- Encountered another Check Cell Problem
- Storing Excel Data in System Memory
- Unable to format font after creating sheet
- Populate QueryTable Using SQL Server -> Connection Problem
- How do i get only whole numbers for a formula result?
- change column format
- Re: Encountered another Check Cell Problem
- How do I get the percentage of total for a large data set
- Please Test
- Code runs without error but doesn't print output
- General Message Box Question
- macro to sum special to new sheets.
- Coding for Userforms
- Listbox
- Copying Rows of data
- Web Queries
- Import Data macro
- Saving over a read only file
- Rename existing tabs
- read only
- Using a ComboBox for Data Entry into a Cell
- Run-time error '1004'
- Button Shortcut / Key Stroke
- Functions to get range properties
- macros for end users
- Excel DIR
- Macro to change value 2 cols over from search
- Words Equal Numbers Question
- Sheet1$A1:A1 vs Sheet1$
- Changing specific Listbox value
- Selecting a listbox item event
- Program calling up Excel - Not running Macro
- Is it possible to ensure Calendar date is in range
- Userforms - tabbed pages
- Capture Col number
- RE: Help with ThisWorkbook
- RE: Help with ThisWorkbook
- Help with ThisWorkbook
- RE: Moving down one cell
- Lotus Notes Stationery
- dialog boxes interrupt macros
- RE: How do I call a method in VB from Excel with JUST code?
- Modify Pivot Table Page Field
- Add "BeginGroup" to customized shortcut menus
- RE: Moving down one cell
- Can't figure out how to merge columns
- How do I call a method in VB from Excel with JUST code?
- RE: Moving down one cell
- Moving down one cell
- removing old data
- workbooks.open and error handling
- From excel connect to SQl
- Start Macro every X Minutes
- locating and copying
- PageSetup
- Help Text for Add-in
- Reading link in VBA?
- Determining if workbook is already opened by someone else?
- Macro working in background ie not on activesheet
- Iterate through controls
- Userform question
- Sheets or Worksheets
- Conditionally Allow input or fill in data for a week.
- How can i import multiple .csv files into Excel for analysis?
- How can I set a range can't be selected!
- insert formula in last cell
- If Statement problem
- My VBA code in excel does not work on another PC
- Re - If Statement Problem
- Re: SaveAs Method changes Worksheet Name
- charting in vb.net
- Re: If Statement Problem
- Reference the last 13 rows of data
- Server date stamp
- Selective Viewing
- Excel 2003 Macro Certificate Failure - Help!
- Table of Contents - Data from unhidden sheets only
- dif Ubound for member array when debugging
- Value ina listbox from sql
- Anyone know why this doesn't work
- copy and paste multiple selection
- Worksheet Deactivation Event
- Add rows
- Adding and Reading a ListBox Item
- How to write a macro to print a dir on my c drive
- email a worksheet
- Convert a formula in a cell to it's result
- FileDateTime for Internet web page
- Different Color
- Data filter brings in too much data
- help with random numbers
- looping through specific worksheets
- emailing a sheet
- Tfr data from one sheet to another
- How to start a macro when openning Excel
- Is there a way to sort columns
- Cell Color Code Website
- Shared workbook problem!!!!
- Editing worksheet while running macros
- sending email using macros
- SQL statement in vba
- Blinking text in Excel !
- chart.add gives compile error
- cut to matching sheet problem
- TurnOff Form Events ?
- Open a closed workbook with VBA
- Re: Open a closed workbook with VBA
- Copying From Master
- Concatented Numbers Display as Scientific Notation
- I'm sure this has been asked before....
- Input box
- Shift columns each click of the button
- Shape Selection Event !!
- Copying and Pasting
- Setting a Windows Scheduler Task via VB !
- Excel Workbook - Simultaneous Use
- How add events to a sheet in run-time?
- Charts in forms
- #VALUE error in Excel using Visual C++ DLL
- Compiler says "Invalid qualifier" when using Application object
- tips for organizing code for distribution
- tips for initializing/reusing dynamic arrays
- Subscript Error
- Message that opens when file is opened
- Re: How can i assign a marco to a command button
- Populating Rows
- Naming list of non blank cells
- re:Macro or VBA
- Set active worksheet on startup
- Excel Formulas
- Excel GGVT To Save but not be Saved
- Remove unwanted tabs
- 'Encounters serious error' on opening with user-defined add-in
- running two separate commands in same Shell
- Copy to cells based on Row/Column labels in another workbook
- How to copy a worksheep in the same workbook?
- Pivot Table No Formula Results on Total
- re-ordering areas
- Does a password exist...?
- Appending filename with date
- VBA for excel 2000 It seems a Microsoft problem?
- Need to hide date
- comparing 2 columns
- Using Excel 2003 SP1 - Removing a VBA module closes Excel
- Programming with msquery
- microsoft internet transfer control
- default names
- Userform - where is the cursor ?
- System Error &H8000FFFF (-2147418113). Catastrophic Failure
- Automating a report
- Help with lists
- Need to read number of PrintTitleRows currently set
- Re: Filter by Value
- Insert Picture in Pivot Table with code VB
- subtracting from total multiple sheets (inventory) help.
- webquery with login first
- Transfer Value to another sheet with Macro
- Copying labels to Userform at runtime.
- how read value from last selected cell? It is possible? how get adress last selected cell?
- Add string occurences
- FTP
- Edge Sequence Color
- Assign Macro to Command Button doesn't work
- XML in XL
- Shapes, Userform and Visible
- Programatic Reference to Libraries
- Reading Writing Data from One WorkBook to Another
- RGB Colors of "Fill Color"
- Subtotal(s) range in Pivot Tables. Is it Missing?