- Excel not adding proplerly... - sample.xls (0/1)
- HOW TO CONVERT A FIGURE INTO TEXT (EQUATION USED IN EXCEL)
- find all instances of text in string
- Determining File Size
- error 2015 performing vlookup
- final answer to run macro at certain time
- With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project.
- Need help with loop
- on click change cells color and increase a number..
- Consolidate data in an 2-dimension array in VBA
- All Subdirectories
- Clipboard Clear API error
- Database
- Re: Clipboard Clear API function Error
- Newbie: Help with workbooks
- User defined functions
- Object variable or withblock variable not set
- Weird Cell Behaviour
- Object Defined error
- Doesn't recognize worksheet
- Error trapping
- Userform locks up Excel
- Exporting Access Queries to sepcific ranges in an Excel workbook
- Send a query and receive data through a Comm Port
- Format Series in Pivot Chart
- Exporting Access Queries to sepcific ranges in an Excel workbook
- email several attachments (change to ron's macro?)
- Setting wks name in Project Explorer (Bullen,Bovey,Green)
- HELP !!!
- Workbook to Web
- using a multi-select listbox to pull data
- Thanks Tom
- Adding a control to a User Form
- Macro only working on 1 row
- Unable to set FormulaArray property of the Range class
- duplicate data, if command in VBA
- How do I handle #Value in VBA?
- DDE Commands
- Delete 2 rows skip 1 delete 2 more
- Format Data Series in Pivot Chart
- Code compatibility issue
- how shell open AcroReader w/command line filename?
- How to round down to nearest 5 minutes, time calc?
- VBA to control the Mouse
- How can I use the worksheet function FIND in VBA or is there a FIN
- Autorun.inf
- Problem with Code --- Please help
- Automating Solver in loop
- File or function not found error
- Can't get OptionButton choice result from form?!!
- Adding a column with reference to another
- Usinf cells for filename
- GroupName for OptionButton
- Which runs first, Workbook_Open() or external query refresh?
- Macro to Update Charts
- which event/method should be used to handle sheet refresh in VBA
- Help declaring array limit with variable?
- RE: which event/method should be used to handle sheet refresh in VBA
- Automatic filtering keystroke
- Copy Paste Special Values
- Moving objects
- Changing the size of Comment Shapes
- Help wih complex formula or macro or solution
- Text wildcards
- using cell info in an equation... Very frusterated
- Null to Zero from External Data
- Number rounding within a formula
- Custom graphical cell contents
- Sheet Reference in vlookup
- macro abouut solver
- Late Binding
- Calling a Sub with a Command_Click
- selecting a cell based on lookup with VBA
- private macro and shortcut key
- Trigger macro when nr of sheets changes
- Workbook_BeforeClose doesn't work!!!
- Do something to each file in a folder
- Graph Ranges
- Code to hide row
- Find Column heading and then Delete entire column
- Copying a variable range
- VBA Code to copy values &formats to the next worksheet
- Make textbox1.value default
- Function Used?
- Locking components BUT Still allowing to change settings via VBA
- Populating a database with a template
- Find last word in cell
- Too many different format cell
- sending e-mail it is ok from VBA not from Excel it-self
- UserForm - Storing user's choices
- Sheet Listing
- Progressbar
- VBA help to replace if formula
- VBA Help to replace If formula
- Which sheet will be printed?
- digital certificate
- array question
- application.dialogs(xlDialogPrint) - arguments
- copying data from text file to excel sheet
- Display of arabic-type fonts in Excel VBA forms
- copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro
- Delete words in cell if that word is in red
- How do I Clear ALL unprotected data entry fields in a protected sh
- VBA copy from single to merged cell.
- RETURN TO C
- Copy and paste values for particular column
- Before print
- VBA code to edit a formula in excel?
- First-time Use Code
- password protection popup
- Excel 2003 protect not working in Excel 97
- Move to a set cell if
- Data Validation with additional input
- Changing the active workbook
- copy line nased 2 button on userform...
- Assessing whether any checkboxes are checked within frame
- Validation, how to see "today" date on top of the drop down list?
- Test for for sheets existance
- Followhyperlink using specific web browser
- Userform Textbox multiline Vs format in worksheet
- Help on cleaning / speeding up code
- Disable Option in Como Box
- Need offset range for loop
- Microsoft Query using Excel
- Using a variable in a formula
- Pivot Table - display filtered data
- import text file
- Hyperlink Code only works when file saved on desktop
- Autofilter method of range class failed
- Menu item deletion
- Last row in spreadseet
- excel2000
- accounting software template in excel 2000?
- get HelpContextID's or Tags of all userforms
- word automation
- Error Handling to mitigate "Run Time Erorr 13 Type Mismatch"
- One sheet e-mail
- Dynamically name MultiPage Pages
- ado command timeout property
- MouseDown()-MouseUp()
- Please help!
- Template
- Automatic Border along Pagebreak
- macro in excel 2000 vs excel 2002
- Adding Sheets to a combo Box
- ranking cells in excel
- Why can't you use brackets, braces like parenthesis in Excel?
- help extending formula to range
- How to set the value of a cell using its row and column numbers?
- Parse out answers from a column
- Range of averages
- Code problem
- Re: Subtotal - copy to other worksheet
- Data sorting with a twist
- Reading a text file line by line
- how to retrieve properties of a file in VBA
- Export UNIQUE rows to access with ADO
- Reference to another workbook
- Subtotal - copy to other worksheet
- Anything New with the Too Many Cell Formats Issue?
- transfering data
- Worksheet Sizing
- Excel won't quit from VB.NET
- Loop problem
- Repeated Multiple Find
- Numbering
- Display of Record Set
- The formula to determine if with 3 separate if conditions.
- Accounts payable projection and tracking
- comparsions of columns and deletion
- Manual sequence to add a combobox/dropdown/listbox to toolbar
- Move cell info from one worksheet to another buy click a checkmark
- Delete excel file after copy
- Delta
- Getting text data from textbox
- disable events does not work
- Macro to view 'Print' dialog box
- Before Print and UnDo
- VBE PROTECTION
- Programmers available
- date problem
- Trouble calling Add-In Macros
- ActiveWindow.VisibleRange.Width - Is this the correct code
- Re: find question
- find question
- Change cell value when right-clicked/double-clicked
- Print VBA code in Editor format colors
- Good chalenge on header/footer
- Return of position on page in excel
- ActiveX control error -
- URGENT !! Drawing Programme in excel
- Re: How to get value of CheckBox in VBA?
- Screen updating
- user form error 9
- Check if cell value is found in a seperate range of values
- TEXT() function problem in Excel 2002
- Array formula returning #N/A when inserting new rows.
- Next w/o For?
- Mathematical Time Conversion Formula
- Help with complex formula or macro or solution
- Fill-in Range from UserForm
- Code execution interrupted on PrintPreview close
- Controlling Monarch through VBA
- Linking Multiple Workbooks
- Access Question
- Color text macro
- How to fill an internet field using VBA
- Add-Ins ???
- Text color in listbox
- Can I make an alert box with with a yes/no question?
- Color Text Macro
- Macro to synch three pivottables based on same data
- Paste event
- Array contents in module page?
- VB to protect cells not working in Excel 2003?
- OT: Word VBA question
- How to fill an internet field using VBA
- Creating and Destroying Excel Objects from VB
- Interfacing EXCEL wir an RS232 serial device
- If Cells.Find finds something
- Vlookup
- how to protect VBA source codes
- Merge consecutive cells using conditional formatting.
- Change zoom to fit different resolutions
- Mutli-dimensional Array to Single-Dimension Array
- Hiding Rows
- Sort collection string keys
- List in cell
- Maintaining Class State During Multiple Events
- Forms, Range Control
- if statments using text
- Disable Form Events From Being Triggered
- Add Current workbook as an attachment
- user defined function receiving a range as parameter
- Counting Digits in a string
- using vba to copy user-defined chart type
- Re: naming charts
- Using picture files
- Resizing Picture
- copy line with 2 condition....
- using input from user to select wk1 to wk52
- Adding shapes to xy scatter charts
- Copy line based a click into userform...
- First New Post
- less than 0.5 but more than -0.5
- VB code in Excel
- filling userform textboxes
- Locale problem
- External table/range reference trouble
- Flashing message in cell (alternate font and background colors)
- VBA and SQL
- Re: Connecting To a Excel Database
- Excel/Access ODBC
- Use Macro to copy part of text in cell
- Using VBA to access files in a list in EXCEL
- Alarm, Play wav file
- select cells in red only
- Display Word, PDF files within Excel
- vb exe crashing
- Choosing multiple Criteria to populate a textbox.
- run vba code dynamically of another add-in workbook
- MsgBox Position
- Find the nearest point to 1000 rows where "amounts" balance and apply special formatting to that row
- .offset() function
- Variant
- Is Nothing
- Deleting a chart using VBA
- Disabling Security Messages (Macros)
- Change Process Priority
- AppActivate
- Combo Box Sorting Update Problem
- OLE Error
- How can I call Fourier Analysis from a Visual Basic macro?
- Why does this not work
- copy column
- Timecalculations : How ?
- How to show messge box text in Excell work sheet
- Selecting part text in a textbox
- Scroll name in about-form for credit
- Ok IM REALLY LOST.. PLEASE HELP
- If Not equal to statements
- Date returning value or day of week
- Two columns whit same value
- hide columns
- Check box
- Lock to copy/ modification data
- How can I make For-Next loop with date?
- Worksheet
- Hlookup Problem
- getting extra excel instance when controlling from access VBA
- Run Macro & Rename Sheet upon creating copy from blank.
- Convert Excel 4 Macros
- RE: How can I make For-Next loop with date?
- How to make a function change other cells in worksheet
- Is there a Template for Church Business and Reports?
- Copy method failed
- Re: InsertLines crashes Excel
- Urgent help on floating segmented bar chart
- RE: Urgent help on floating segmented bar chart
- Disabling and re-enabling the AutoFilter from VBA
- Late Binding or Late Anything
- source location and error message 400
- Code looping until machine freezes!!?
- Help with word object
- Dynamic Hyperlink
- Help with Vlookup
- Need to Add References
- how to close active ie browser using a macro
- SKIPPING A COLUMN
- GetOpenFilename - Error
- User defined type not defined
- copyFromRecordset - vs - getRows
- Check for previous entry
- find values and combine in one cell
- find values and combine in one cell
- possibly array formula for depletion
- AddIn functions in code?
- Cell formatting
- Selecting a row relative to the position of a button
- Filter copy incl more than it should
- Populate Combo Box with Text file
- List all worksheets (and Document Names)
- Media Player versus Windows Media Player
- Macro Required - to process data
- UDF Raising an error
- Autofill
- Find latest date for each row
- DropDownBox?
- dropdown.fontsize ??
- Transfer rows with varying criteria
- Project: Assignment letter
- long list into printable view
- Transferring rows with variable criteria
- load local htm help file with HelpContextID
- Path name in title bar-READ ONLY prob
- Checking accuracy
- Input box Type:= 8 not working
- Selecting a range using a column number reference
- Cells.Find for text w/ line break
- No active cell
- Removing items from listbox
- Problems changing Embedded Chart Name
- Re: VBA Question: User Form and input masks
- VBA Question: User Form and input masks
- Email body with a script and a table
- Interesting performance "black hole"
- Error message
- simultaneous pairings
- Why it is not pasting it to the correct place?
- Copy to PDF
- export range as picture
- Rogue Admins
- spin button code
- Forms and scrolling
- Sum (IF
- Auto fill
- How to detect if a workbook is hidden through VBA
- Need help with odd behavior of worksheet rows
- Code with query goes from greyhound to turtle speed
- A new excel challenge
- Dynamic Find and Replace String Within Functions Based on Column Values
- protect and unprotect
- protect and unprotect
- Move Part of Cell String
- Imported file Date formats unrecognisable/unconvertable
- How do I program telnet using exel through dos?
- Security discussion - how to effectively distribute an Excel file
- VSTO Date Evaluation
- OPen excel workbook...
- Copy Down Formulae
- problems w solution 4 enable AutoFilter for a protected worksheet
- How can I copy data from one workbook to my own workbook?
- printing the project
- How can I copy data from one workbook to my own workbook?
- too many combos
- i need help
- Problem with AppActivate.
- to update or not to update
- Allow user input, but not format changes
- How to see columns from which values were not returned by HLOOKUP functions?
- Count Numerous Matches Only Once
- Variable Acting Like a Constant?
- CubeFields
- Address Property
- Determine if an excel file is already open
- Download from SAP too big
- Passing an index to a second workbook
- Data sorting a crosstab table
- Filtering and coping w/combobox
- Chart Objects Error
- Find a value in a column
- Selecting multiple criteria HELP!!! :(
- Excel 2003, paste special menu
- opening a .csv file via VB
- Row Reference
- Golf League Help
- Entering subtotals quickly in several columns
- Same value in cel
- Text alignment within a listbox
- Copying sheets form other workbooks
- Sort Data Automatically
- How do i can countinuously update time?
- Smart Application.Path
- emailing in Lotus Notes
- Compile error: Can't find project or library
- Excel strange (erroneous?) decimal behaviour
- closing excel
- Search Google from Textbox
- how to check if folder exists
- Find part of string & delete row
- Changing the text color of a complete row ...
- Macro when Inserting Line
- Sending Mail from VBA
- How to replace a function with its resulting reference in a formula?
- Activex control button problem
- Select a varying range of text and paste into a cell
- what is mean by ^ in formual
- Insert calculation with VBA is slow
- Paste Method failed (Activesheet.Paste)
- comparing data in two similar format reports
- Dos Directory
- Personal.xls
- How to Clean up exported Userform.frx?
- userform problem
- How to replace a function with its result or resulting reference in a formula?
- showing / hiding gridlines through VB code
- filter using VBA
- VB-macro - Copy from another workook
- Chart problem.
- Quick question - quick answer about assigning shortcut keys
- Loop through cells meeting conditions
- CustomDocumentProperties problem...
- MatchEntry for combobox added during runtime
- Activate and Display a Workbook in Internet Explrorer
- Printing Help
- How can I copy the data of sheet 1 to sheet 2 with modify?
- Copy Cell to Same Cell on Multiple Sheets
- Saving file using data from worksheet
- Highlighting entire row
- VBA ".Find"
- Convert code rows to columns
- repost: Need Help With Steaming Data Macro
- Excel opens All files in Default file location
- customize calendar (some dates in red color) in excel
- Importing csv data into worksheet from the web
- How do I Sum variables
- .Net Excel Add-in missing Images in ListView
- Paste method fails in VBA
- Relative Ranges in excel macro
- One custom menu copies
- Linking access records in to excel
- Disable "Select Multiple Items" in Pivot Table
- Display contents of (Multiple Items) from Pivot Table
- reset the data range...
- Exported Date Format is Changed by Ecxcel
- Excel VBA to click 'submit' on form
- how do I add paramters / criteria in the excel query?
- Userform/Module
- Select Case help
- ColorIndex and Caps Change too slow
- Macros with the VBE
- Add the specified number of work days to the a date.
- convert to a number
- Writing data to SQL server
- Last Row of Selection
- change font color whenever click a page of multipage control
- Copy filterto workbook
- Custom Number Format
- Maintain focus on one worksheet while collecting data in others
- Application.Calculation gives run time error
- Stumped on Array
- before mail
- Form Close Button
- Pivot Table - 3 columns turn-around-times
- How to find the rows existing in one column but not the other?
- OLEOBJECTS IN WORKSHEET ARE WACKED
- Identifying Objects (again)
- File name in Vlookup
- Get the list from Autofilter after filter some criteria
- Conditional formatting two rows at a time
- cannot shift objects off sheet
- IF THEN-HIDDEN ROWS
- Finding cell address for minimum number
- How to define tab key settings?
- VBA does not recognize Excel worksheet function "indirect"
- One macro to rule them all
- Re: What is wrong with this code?
- Moving cells to another sheet
- Refencing a Microsoft WORD Library in EXCEL VBA
- HELP with this code!
- Verify the format of the content of a textbox included in a frame
- Removing Cells from an Excel Range
- How to clear items on a form?
- What is wrong with this code?
- Selected Cells Menu
- Create floating button based on button click in menu
- Want macro to select current cell
- Using Wildcard on Workbooks.Open
- Validation Question
- Color Rows
- Help on Vlookup for Undetermined Range
- Returning Columns to a List Box for a Holiday LookUp Table
- Follow on to: Determine if a workbook is already open
- what is stdole reference in excel vba library
- Formatting text in Commments to cells
- Advanced Formatting [2]
- VBA
- Adding Excel charts to PowerPoint presentation in Office 2003
- Copy tab delimited string to worksheet row - VB6 application
- Excel and Vba questions
- Open an existing workbook and reference it
- error in XValues
- Use VBA to format paint cell(s)
- using VB to filter
- Formulas in Pathnames
- Restricting Characters in a cell.
- Is this wrong?
- How can I upload a file to my webfolder?
- Halt all code while macro runs
- Can't close e-mail
- Userform from a Userform Problem
- Read Binary
- Variable table array name in VLOOKUP
- New Job
- working with large text files
- Excel: I can't see the worksheet tabs on my screen anymore. HELP!
- How to display data in Combobox with no dups
- Accidentally Protecting Sheets
- Retrieving range string from named range
- "ByVal Cancel As MSForms.ReturnBoolean"
- Attaching sheet to e-mail
- Validation inputmessage multilines
- How to transpose an excel worksheet having more than 10000 rows into a text file, may by tab delimit
- Too narrow columns
- Save workbook with 10 different names
- Change "Properties" of files
- Problem Pasting entire row.
- How's this verification done?
- Advanced Formatting
- How to force Excel to NOT update hyperlink paths?
- Add double quotes to each field
- Worksheet reference vs Worksheet("").Activate
- Consuming a web service in Excel 2003 that requires a certificate
- Creating a back up copy.
- Refering to Public Variables in Functions
- Find & Delete Duplicates across two Excel Worksheets
- Fill an individual report with values from a team report?
- How do I copy a worksheet form a workbook in my workbook
- Run Time Error 13 Type Mismatch
- Select Case, Less and Greater than?
- Excel VBA: Browse For Folder - Cancel Button
- Preventing automatic upgrade of references to ADO
- Cancel RefEdit
- VBA to Merge Cells
- LIKE in Excel VBA?
- How to activate add-ins for particular files??
- Force a Message Box to close unanswered
- copy userform input to cells
- #NA error using vlookup in vba
- Sorting Data.... Help!!!!
- Locate cell name using variable and looping
- -1^2+1 vs 1-1^2
- event with commandbar button right-click?
- From excel to word
- Trouble with web services in excel 2003
- Rank items in VBA Array?
- how to write a macro for solver function
- copy paste special values
- Chart on a Userform
- Dropdown Sub Menu
- dialog box to pick path & file
- Easy solution need for find problem
- time stamp a cell that doesn,t change when time stamping another
- type "cheese" in a1. Click cheese and get picture?
- data entered on multiple sheets also added to summary sheet
- Automated data entry
- New Sheets for hyperlinked files
- time sheet help
- Macro sheet by sheet error
- Distributing Macro's and Personal.Dot files
- Retrieving data from work sheet to USER FORM
- Form creates new workbook and pulls data
- IF THEN FORMULA
- Can this be condensed
- applying a macro for a specific field to a range of fields
- Data input macro
- Data Field in Pivot Table
- Identifying Objects
- workbook open query
- UDF for opening most recent file added
- Prevent User from Going Past a Certain Cell
- I want to make one loop
- How to hide a textbox
- VBA Beginner: Help with Checkboxes on created User Form
- Userform searching and update
- filter a combobox
- Determine if a workbook is already open
- Search & Extract various strings from many files to one excel file
- List Box Multiselect Form
- please help
- please help
- Re: Set as read only based on user name.
- Select last worksheet in workbook
- Searching multiple columns
- Set as read only based on user name.
- Add data to different worksheets in same workbook
- Data Entry Form (similar to default Excel Data>Form)
- Arranging data
- List box: Populate with Range Names
- Using Excel VBA to close IE
- How do I count cells in spreadsheet that are not empty?
- Pathname reference
- MaxLength Property issues
- Clearing Ranges from Multiple workbooks.
- vb code help with date format
- Run an External .exe
- VBA in Excel - Public variables & VB 6.0 vs version 6.3 in Office
- VB executable
- Group date into Year and Quarters
- why am I getting a 3010 error?
- using a range in a custom function
- Get File Size (Number of Bytes) of Active Workbook
- access closed workbook
- Can't Trigger Event Procedure from a Checkbox created on the Fly.
- Link Checkboxes and Grey out the Check
- IF ... and... HELP ... :)
- check if worksheet is empty
- Concatenate to a text file
- InStr GRRRRRRRR!!!!!!!!
- How do I create a range with all values in a sheet?
- Assign Macro 2 a Button....confusion
- Long running macro and screen update
- Creating a varying UserForm using cells from a hidden worksheet
- Wrong number of arguments - Help
- Private Sub Workbook Open() - question
- VBA Coding - any ideas why this UDFs not working?
- Conditional symbols
- How to check if Software is loaded on a users C: drive
- nested if loop with logical OR/AND
- search for string within a string
- Large documents and Java
- highlighting duplicates
- Advanced filter in VBA - criteria in non-adjacent ranges
- Sorting multiple columns as one
- Pass Excel User License to Variable
- manipulate string
- I'm looking for VB/VBA job
- How to write an average formula from VBA- SHOULD BE SIMPLE!
- building a reporting sheet which reports by date and shows values of another sheet
- How to store current row into variable
- Auto run Addin code
- SaveAs FileFormat:=xlHtml and size of resulting bitmap
- Collapse item in subtotal by using VBA
- Adding multiple series to a dynamic chart
- How to check if an Excel cell is a list(combo box)?
- what exactly evaluate functoin returns?
- Help with VBA Mail Merge
- Launch a macro when you open a page in worksheet
- SAP BEX
- Problem creating excel add-in
- Randomize
- Fix error message '1004'
- VSTO: Inherit from OfficeCodeBehind Class
- Copy row if....
- Row reference relative to Button on Spreadsheet
- Working with Rich Text Format
- Write variables from a loop, once only
- After VLOOKUP!
- Advanced filter: criteria in non-adjacent ranges?
- newbie help - code need correcting
- Find first empty row
- RowsToColumn
- Using XLA to load VBA program
- Dynamic calculations according to user input
- Sum
- Linking to external workbook
- subtotal question
- Linked sheet design theory
- to click on a cell and go to named local HTML file
- Capturing Steaming Data Macro problem?
- Countif declaration problem with ""word""
- VBA, Excel Date Problem
- Need Help with Macro Code
- Simple Question
- Watch to Trap Protected Sheet (Repost)
- Run Time Error 1004
- Excel Templates
- [VBA] Creating sheets based on criteria
- Looping through a group of checkboxes
- pastespecial question
- Protecting Sheet by accident
- send email with email addresses in a range of cells
- Pasting Values of range to another range
- Just the numbers please...........
- save as from combo box list
- Accessing Microsoft Access Tables
- Do not know to how reference another sheet in my formual - embarrasingly simple I hope
- COMBOBOX
- Microsoft Discussions Page Layout
- Disabling Menus
- Dim
- resize question
- hiding a workbook
- How do I "conditionally" change font size based on text length?
- Find Duplicates and Append
- Send button in Excel
- transposing and creating new rows
- Macro with Drive-change?
- Supress screen update while writiing to another sheet
- Macro to Change Font Color
- Opens directory
- Optimization question: how to bypass copy and paste
- Sheet1.Activate vs Sheet1.Select
- automating a procedure
- Error 1004: Calculate Method of Range Class Failed
- Random Sequence with no Duplication
- formula
- Sizing of copied columns
- Data > Table
- TreeView
- Add Sheets
- Macro
- Error Handling issues
- wrong reference after dragging down a formula
- General Loop question
- VSTO Cell Alignment Enumeration
- Question regarding "INDIRECT" and Charts
- Range select
- Extracting column number of max value
- ? activate a commandbutton in code ?
- Repeating macro procedure on several worksheets
- Continuous Range
- Loop through Combinations and Keep a Count
- today() bug
- VB code needed as this is way beyond a novice like me!
- Run several macros in a row
- Help with Object variable error
- Automation between Iseries and Excel
- Deployment of Microsoft Office Xp Primary Interop Assembly
- Which control caused the macro to run?
- making a formula over varying ranges
- Control Face ID's
- Automating to generate the next Invoice No.
- Editable combo. Elaborate code example wanted.
- HyperLink
- Naive question on Range naming but please answer
- Re: Save workbook, in .zip
- Save workbook, in .zip
- Strange conditional copying of spread sheet??
- Paste Special