- MS Query parameter
- Macro for special Insert comment text
- Passing Public Variable into Sheet Sub Functions
- radio buttons to equal values
- Delete row with no data
- Macros do not run when spreadsheet is used on a different computer
- start macro
- using offset with FormulaR1C1
- Excel Macro Selection
- Say "yes" to "OK"
- Remove password from multiple workbooks?
- phantom link/macro
- Opening/Activate Multiple Workbooks - Help
- Excel 2003 hangs on save after creating pivot table
- array
- How do you stop online HELP in 2007
- Programming Min and Max
- Nexted For Statements don't execute fully
- Back Button Macro
- VBA Conditional Formatting to UsedRange on Worksheet
- take every other cell and put in new colume. No blank cells
- Scheduling
- Accessing Form's Values from Invoking Sub
- changing the fill color on a cell
- If And Statements
- Workbooks Array
- Variable file name in copy macro
- For Next Variable Not Being Passed Through For Second Sheet
- Help: Pivot Cache error using Range object containing cell with 255char
- Programatically Add Outline and Grouping with VBA
- Transpose heading array
- Dialog box in a macro
- function question??
- Hide / Unhide Columns in Password Protected w/s
- Dialog Box
- array inside for statement
- Size a Cell to a Picture
- How to deate Conditional statement for the header
- Range End(x1up) problems
- IF statements in Macros
- IF statements in Macros
- Automatically Populate Worksheet Depending on Team Name
- Creating Excel file that points to relative path .cub file
- Rearrange data for printing
- Macro code
- Page break issues
- Keydown Problem
- Enable/Disable Macro
- Sample a random calculated cell
- Pick List
- formula to save value of cell w/o copy- paste special-value
- macro code for XML Fill
- Macro code
- Macro code
- Condensing Task
- Change a range to Uppercase
- Remove _ inside of string
- vb programing match function
- Changing a formula to value only
- import package from
- Two VBA Questions
- auto move cursor
- URG: Saving an e-mail to be digitally signed
- Color Chart
- Formula to add a number
- CustomMenu.Controls.Add
- Open form from another workbook
- ODBC-coupling SQL questions
- CF sheet sub modifications
- Getting the LastRow in ExcelSheet from Word
- String vs LONG format
- how to refer to the files with regular names? (with formula)
- Delete Row and Auto Subtract
- Find row with the same data like in another row
- FindFormat.NumberFormat fails with some strings
- SUM of data from multiple sheets in the mastersheet
- make a data entry into hyperlink using vba?
- Adding new sheets to the right instead of the default left
- Sorting Data in group
- Copying OptionButtons
- vba to append to a text file
- VBA tweak to run faster? <--Rookie here
- Changing the stated output of OptionButtons
- Help for vba to control the PivotItem in specific Field in Pivot Table by choose in inputbox
- Help With VBA Copy Code
- what is the vba language to make hyperlink?
- matching 7 columns of data
- 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
- Delete text in a string marco help
- Size Picture to Cell
- Skipping textbox
- Macro with FOR - IF Loop
- Error with EXCEL macro transfering information to a form in WORD
- Marco that Delete Cells With Specific Text
- VBA to TRIM data <--Rookie here :o)
- Scheduling Macro run
- What am I doing wrong?
- embedded sheets in a Word doc
- Macro and chart help
- Macro handling "Insert comment"
- Send Email from VBA
- How to get the location of a Form Combo Box inside the assigned ma
- references to data sheets
- Training material for VBA for Excel 2007
- InputBox and For...Next Loop
- Date & Time Picker Properties Question
- Can't Undo Macro Command
- VBA: What does Redim Preserve do in term of memory
- Calendar question?
- Move Range with a date to a Matching Monthly Worksheet
- Automate IE to log into bank accounts?
- Excel workbook SaveAs question
- rtd server question
- Finding a floating point value
- Size of Spreadsheet Displayed - both in Cells and TWIPs
- Variables in Query Strings
- Range Question
- Range Question
- Indication that there is a # cell value in the range
- manipulate / perform math on cell location a=a+1
- Extract Whole Row If Q
- Copy-Past as Pictures
- On Got Focus, Clear Cells
- Error handling
- getting new workbook name from opened template
- Worksheet change: move to next cell
- Need macro to trim characters in column
- Identify blanks
- How to backup Excel using VBA?
- EXCEL Spreadsheet CELLS have data but load as NULL
- Managed code error handling from VBA
- Add data from several excel sheets into one
- Clean Up without reducing print window.
- Auto Copy from Sheet1 to Sheet2
- "Compile error in hidden module: Addition" what does it mean?!?!?
- Alter macro security level programmatically
- Macro question
- Microsoft Office Spreadsheet 11.0 Control
- Creating a macro
- Macro to accomplish Zoom and Fit to Simultaneously
- Appreciated!!!
- Accessing Message Editor Of Web Based Email
- Excel VBScript Forum
- Timer
- sending mails from excel...but mail body disappearing
- Create Menu Macro
- Copying cell border formatting, without shading.
- Numeric Value of Choice in Combobox
- count comments funtion
- Macros
- Combining multiple worksheets into a single master sheet
- Select Range
- Judge whether Excel has password without opening it
- LN in UDF
- Naming a range in a module
- UDF is not working
- Conditional formatting
- sorting unknown range
- Transparent button
- fetch the data from sheet2 & place it in sheet1 based on the locat
- What's wrong with this code?
- how to creat shortcut button to switching between worksheets?
- Changing the values of priorities on update
- Microsoft Excel Addin
- repetitive items in For each loop
- Foot-binding
- Losing certificate details on workbook save
- For..Next error 'End if without block if'
- Pivot table error
- Duplicate sheets by data count
- Application makes VBE crash. How do I troubleshoot?
- Initialization using Multipage Tab
- Send e-mail via macro
- toggle or command and how
- object button name
- Create Pie Chart that changes from one data table with differentyears
- Compatibility of Macros coded in 2007
- Programmatically changing values on grouped sheets
- Change Formula's to Values
- Conditional format on a chart series
- Compiled Application Crashes
- How do find text with sumproduct if possible
- Floating menu to navigate through worksheets
- Dynamic userform field names
- Slow Procedure
- Checkbox Background Color
- Selecting a Range with a variable in the ordered pair
- Is there a Folder Picker method that shows files too?
- copy a worksheet from a closed file?
- Send attachment via CDO
- Incentive Compound Formula Help!!!!
- Help with search and copy issue
- Worksheet_Change event
- cell select
- Listbox vs Combobox
- move columns to separate worksheets
- If then else, or select case is giving me a problem
- comment copy&past!
- sort from date, to date in list
- Avoiding Errors when Loading Large Number of Cell Addresses into R
- Convert Font.Color to System.Drawing.Color in C#
- Range Select
- HOW TO MOVE DATA FROM ONE COLUMN TO MULTI ROW - please help
- RE: User Form Input mask
- Trust Access to Visual Basic Project
- disabling chart export progress bar
- Repeated search on the same worksheet
- How to get Cell.Address from Hyperlink cell
- change the color of a cell as a function of the cell value
- Update created sheet?
- Automatically select correct range
- How to rewrite this code? (Second half)
- How to rewrite this code? (first half)
- help with 3 problems??
- Search for Change in a column.
- Calculate Time
- Dialog to set path
- Initializing Userform not working
- Check error cell in C#
- Formatting with Macros
- File size
- Column Possible
- TRIM Function gives Compiler Error!!!!
- furmula to add hours
- the value of a condition in a conditional format
- VBA question
- Same task for Multiple fields
- AND/OR in Macro
- Move to next cell
- Excel Macro - Extract data from website
- Changing a formula inside a textbox - Excel 2007
- Calling AutoFit using macro in XLCALL.h
- Extract rows to different sheets
- Save several worksheets into one file
- Merging
- Error Number: 91 object variable or With block Variable not set
- Running a macro from the spreadsheet
- C++ Excel Automation
- Run Macro from different files
- how to set pivotitem.visible property to true
- Selecting A Tab By Its Name
- Command button
- Consolidating Various Excel Files
- Sort WorkSheetName unknown
- Tip # 13 Make a style statement with worksheet tabs
- Listboxes
- excel+webcam
- Conditional Formating
- vb code to re-arrange data
- 2 line headers in excel 2003 spreadsheets
- Convert NumberFormat to System.Type
- Toolbars GONE!
- Specifying Cells To Copy Across Workbooks Not Working!
- Ribbon Image Size
- Missing relative reference icon
- Use Contents of a Cell to Create a Hyperlink
- Function instead of "Text to Column"
- auto start code when a sheet is looked at
- Deleting CommandBar("").Controls
- Page Header Macro?
- Single Row Count
- set print area to last occupied row
- Another lookup question
- Common Dialog Control Reference problem
- set print area to last occupied row
- Transposing/combining columns with 2 headers
- Pasting and organizing information from one sheet to another
- transpose address information for each customer number
- Data Validation Pop-downs
- Loop help Please
- Excel General Ledger Template
- html exported to excel when save as, defaults to web page
- RANGE
- how can i automate copying of tabs to a new workbook?
- user form and radio buttons
- Find and Replace Macro
- Calling AutoFit using C API's
- Last Real Cell
- VBA ReadyState basics
- ie Command to Wait for "File Download" and "Save As" windows
- Merge problem
- Updating Date Field in Pivot Table with VBA Help
- IF and ISBlank for a selected range of cells
- getting error message 3704 when running excel vba
- Macro on Current Row
- How to save a project independent of a spreadsheet
- Displaying Line #'s
- Using VBA: Conditional Formatting of Row Color
- Formatting a worksheet
- locad password protected MS Access table
- Highlighting Rows and Columns with Macro and VB
- Column List to Multiple Columns
- Change sheets within a read and write function...
- Slow tabstrip
- Column AutoFit C API
- Find next empty row & paste data
- FitToPagesWide
- ListView - ItemClick - How to know column number
- Macro to Edit Contents of Cell
- Time Calculation w/ Macro
- Export records into a text file based on criteria
- Creating a list box
- Get numbers from cell
- use of variable in Range("..,..") argument
- load list data
- ByRef argument type mismatch when passing dictionary object
- Vlookup to Return Cell Name Not Value?
- do loop until empty cell
- Overwrite conditional formatting
- Problem with IE
- Disable Ctrl- PAGEUP PAGEDWN
- Find value in sheet 1 and copy matching row from sheet 2
- Auto insert
- Version Issues
- Debugging Advice Wanted
- How do you x-late GetTextExtentPoint32's units into the real world?
- Can Search's default be changed to "By Columns"?
- nested for each or something else??
- Excel Add & Substract in One Cell
- Check for incorrect characters
- Extract Access records to new workbook using VBA in Excel
- Extensive file damage.
- Add data range to a specific tab based on "Sheet Name"
- Tabstrip Tabs Width
- Excel VBA functionality and SharePoint
- Trust Access to Visual Basic Project - Access to Excel and back
- Disabling SAVE AS Temporarily
- Sub to delete only all damaged defined ranges in book
- advanced lookup feature
- vba structure
- Conditionally format cells
- How do you hide .....
- Copy variable to clipboard
- exception in excel while writting to it
- reset a cell
- Re: Splitting up timeperiod
- Listbox help
- finding UsedRange with sparse data
- Outlook VB not working
- I protect sheet - Macro will not run now
- Excel 2007 ListBox missing last item
- Userform - 100 checkbox (10X10)
- Select Object Button
- stock the header items of a .dbf file into a vector
- Is 'IgnoreRemoteRequests' the same as....
- Making a [semi] Dictator Application: Hiding Main Command Bar?
- Sum variable ranges
- VBA...No Subroutine Code
- newbie - If a cell is blank
- Printing worksheets
- identifying multi-select items in a listbox
- Dynamically Change Cell Contents From VB
- Change Axis Title
- AutoFit function
- "next and "previous"button problem in vba
- Automatic Calculating & Autofil in Various Tabs
- loading another application from excel vba
- Count positive value
- import xml in excel workbok using VBA code
- Spreadsheet Component
- break apart pdf binder
- Blank cells & formula cells
- VBA to move and concatenate
- VBA to Update Pivot Table
- Importing Access to Excel
- data entry
- help with Run-time error '1004'
- Target.Cells.Count
- Need to know how data is grouped in PivotTables
- Bypassing the Security Warning when opening Excel file
- Font enlarge/reduce by 1 pt?
- Trouble with code that is broken over multiple lines (space_)
- Modify the IgnoreBlank property of the Validation object
- Difference between two dates
- Does a shape cover a cell ?
- Macro to Paste Unformatted Text Into Excel
- hard time with If InStr(1, ..
- clear contents on linked sheet
- Combo box the exludes blanks
- working with images
- How can i automate the response to a generated pop up?
- Parameter Driven Query
- Lots of similar buttons need to call a macro but need to find outwhich button was clicked
- read xml and fill valuesin excel form combobox
- Checking worksheet names
- Creating different worksheets from a main worksheet
- Clear entire rows below last row of data in col A except in 1st 3 sheets
- Loop Till the end of used Cell
- option button problem
- Why doesn't the FindNext work inside a function ?
- Forcing Move seelction to the right
- Filldown top cell to last row with data in adjacent col
- How can I see the Project Explorer and Code window together?
- How to specify charset for queried data?
- Get Lines Before and After Search Text
- Returning column letter
- excel multiple choice toggles
- Password Protecting/Unprotecting Worksheets using VBA code?
- Refreshing cell value
- clear contents
- variable not defined error
- VBE Help: How to get list of all string functions?
- text&formula coloring!
- How to generate a text file from Excel using a macro or script?
- How to generate a text file from Excel using a macro or script?
- Synchronizing worksheets
- How to validate path? --- bValidatePath ("") Then
- Activate one Book then another Book
- Problems adjusting column width
- Tip # 12 Stretch out: Insert a line break in a cell
- How to change the background colour on event?
- Excel VBA : Find Method
- Change rangre color with scroll bar
- How do I select an option button using code
- Rename active sheet
- Read text into Excel
- Repost of How to get Popup Text help to work
- Hot to Get a Column Number from a column letter
- hyperlink in Excel 2003
- error running macro from Ribbon button
- CONCATENATE preserving original formating
- How can I list values in a combo box?
- Series order vs Legend Order in Charts
- I NEED AN EXCEL TEMPLATE FOR ANNUAL BUDGET CONTROL OF SMALL BUSIN
- Worksheet Help
- Custom View: hide/unhide does not work when worksheet is protected
- Change UserForm font
- Enable Auto Refresh Message Box
- Turn AutoCalc before calc takes place
- Adding help to a user defined function
- read datas from XML to excel using VBAmacros
- 2008 federal payroll withholding tax
- Choosing no when asked to overwrite an existing file?
- check box help!
- creating hyperlink using the value of the cell
- Make active cell a variable, return there later
- CreateObject from Template
- Formula for Finding Retail
- Select first 5 visible rows
- Can I find out if & where "Freeze Panes" is set
- VBA function wont update in worksheet
- List Macros
- Select charts by "Chart Names"
- Change Event
- annunce: excelmailer 0.2
- ctrl-a
- excel temp file
- Exclude gray figures from sum
- TextBox mismatch ..... calculation
- Copy cell to empty cells below.
- Protects running from VBA, but not from hot key
- Hou would you optimize this code?
- writing screens to enter data
- How to find a matching row and Insert Data
- Insert Multiple rows with data
- 2008 federal payroll withholding tax
- About xml constructing
- how do i create a macro that will print and save my file to sharep
- How2 accept only numbers in userform textbox
- HELP!!
- Need user unable to unhide sheets
- User Defined Record Compile Error
- Disable auto-update
- Date Range Macro
- Populate Comment on the basis of Text Box Entry
- 2007 Ribbon dropdown
- Duplicate items in ComboBox
- merging cells using VB - Excel 2003
- How do I Create a Macro to run VB Code in Excel?
- Excel and Calendars
- Change text in Textbox on Chart?
- protected linked cell
- Macro problems: Waiting for site to load and commanding Save todownload prompt
- MACRO IS NOT COMPLETE
- Spread data and keep format
- checkbox
- Using VBA to send email to distribution list ... how to CC?
- name box
- programatically create new worksheet
- Apply code to Icon
- Find first blank cell
- use a range variable in advanced filter
- Last Empty Row in Range
- "Move or Copy" sheet
- Variable not Defined Compile error
- Selecting multiple areas
- Sheet Protection doesn't hold
- Shapes!
- Columns ranked by highest revenue
- Repost: Copy Range from one wbk to another
- Popup box appears based on cell value entered
- Copy range from one workbook to another
- Uninstall Add-ins when workbook closes
- Unhide Worksheet with Login UserForm
- Row Headings (cell number) on Rightside
- VBA multiple events
- Hide/Show Rows based on Cell Value with Data Validation
- Activate woorkbook
- reset pivot table name
- First blank cell
- Who last opened file?
- Iteration Error
- NEED ADDITION IN MACRO
- VBA to save a chart as a GIF
- Bug applying Borders to Range
- Input Box code help
- Help in vba
- How I can get color (RGB value) from .ThemeColor + .TintAndShade?
- Worksheet with some limits
- How do I set a range to the currently selected cells?
- Call function from other workbook.
- label to display multi rows and colums on a userform
- How to Refer to Another Excel Workbook
- Protected VBA vs RibbonX question
- How to get Popup Text help to work
- min function trouble
- How to enter a formula over 250 characters?
- Trying to create dropdowns in excel using vb.net
- What is the VBA function to return the greater of two integers?
- Value transfered to cell differs from value in record set
- Keep Losing VBAProject
- Amend sub to re-hide comment when activecell change to another
- Code not working since upgrade to 2007
- Application Maximise event
- HELP - Vlookup with referenced tab name
- On click event question
- Help with an IF Formula
- If B1=Level 1 then B2=10
- If b1 = 1, then b2 = Yellow
- Formlua Entry
- Using ADO to import Access table
- Conditional formatting cells with formulas = "DIV/0!"
- using the calendar on a userform
- Advanced transposing in Excel
- countif formula
- surpress leading and trail spaces
- Finding max value
- Loop Through Combo Boxes on Worksheet and in Workbook
- PT - list multiple page field selections
- exit sub if no data
- Usage of StockQuote.MSNStockQuote in excel vba code
- How to show zero values in conditional sums
- Add code on the fly to existing userforms
- writing to a table in wrod from excel
- PRINTING PAGES !
- Select or Enter into a TextBox on a UserForm
- Date format text conversion
- Linking to specific pages in a PDF
- removing comma in data string
- Help with code: Web query for security agreement
- Error for loop
- outlook and excel
- exit for loop
- copy access table in to cells comments
- Linking from a Combo box to another excel file's specific workshee
- userform
- Get parameters to create existing chart
- How do you do this?
- Creating Lookup User Form
- On Error GoTo .... error
- command button code needed
- Trouble changing Range destination
- Print Range
- Retrieving hyperlink from cell
- macro for mail merge automation
- ThisWorkbook.VBProject.References
- Excel Help
- Hover-over Function
- AllowEditRanges
- Attn: Barb Reinhardt
- VBA Tutorial problem
- Build DateSeries (?)
- ThisChart function similar to ThisWorkbook (XL2003)
- Excel and COM
- Updating tables in Access
- Document Manager Toolbar
- User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation?
- Excerise with Days Off
- Formula problem
- Please help...
- =SUMPRODUCT but need to break out Jan 07 and Jan 08 results
- ChangePivotCache
- dynamic print ranges ...
- Ping via VBA
- script to increase last number in cell entry for hyperlink
- Lookup variabel field in variabel sheet
- Copy paste different columns (ranges) to word
- Unable to disable macro
- Scalar Multiplying VBA Array
- userform and inputboxes
- Sheet sub to centralize comment display on mouse over
- Multi-threading in VBA
- Displays numbers as $ on a form
- auto filter based on color
- hiding excel
- Pivot Table Pivot Item Visible - Why so difficult
- find the matching and supply the quantity
- find the item and supply the required quantity
- Apply a macro to only one sheet
- cell list from access table
- adv: Designing reports in Excel
- Upon error close workbook
- Changed variable value
- multiple text files to multiple rows in excel
- Finding exact date
- using excel data to create multiple web pages
- Basic combobox question re setting values
- centering checkboxes vertical in cell
- Macro Looping Problem
- Loop or If then Question.
- Highlight text in Textbox
- Error data mismatch ??
- Problem with Public Variable value being changed.
- Vlookup Error
- Copy from 1 worksheet to multipule worksheets based upon worksheetname
- run access macro from excel pass parameter
- Total beginner
- Pausing Code
- Extract string from cells
- Insert Matched Value
- Data input and database record using macro's
- how to hve input box on msgbox
- copying formulae down a column
- Programmatically Open Locked VBAProject
- Area of freeform shapes
- Problem with Userform
- Shift-tab in keydown event
- Formula to count Month in Dates
- excel dates in sql procedures
- How to simulate Control (button) and Mouse Selection of cell
- How to count items depending on attributes in VBA
- How to print data in a text box
- out of range message
- automatically copy information to different sheet if certain condi
- Resize msgbox windows
- interactive message with mouse selection
- import access table to excel spreadsheet
- Weekly Totals
- Value between 2 values
- Item Count
- msg box 2 add and see data
- find the matching and allocate the required quantity
- sort using forms button - cycle thru 9 columns
- Code assistance
- Userforms Won't Close
- Can't Adjust the Screen Image
- Running an Excel AddIn from Access in Current WorkBook....Help!!!!
- Trimming Characters
- About Naming MSForm in VBE.
- Data Update Loops between Folders
- Stop Save as code
- Transfer flat file to a Shared folder.
- Update sheetname from cell, automatically
- Subtotal macro and delete original data
- Prevent duplicates in ListBox
- List files in Folder if Condition is Met
- UserForm not displaying
- Expert in Macro
- BLINK CELL COLOUR OR TEXT BY CONDITIONAL FORMATTING
- Disable custom menu item based on visible cells
- Help files
- Mandatory Cell check on multy page workbook
- Textbox for accepting TIME
- How Excel VBA corporate with MSN Alerts?
- Sheet name, creating dynamically to be used in formula....
- Link the ListCount to a Label automatically.
- Quick text key to format 2 cells
- msg box to display specials
- pop up msg box
- sub to delete all sheets other than x, y, z
- How to get back values in the excel bulidin dialogs ?
- Automated Forms issue
- PowerPoint export to Excel
- Protecting sheet in a macro doesn't work
- Data Link
- repeating formulas
- rows
- Pulling cell value into macro
- Showing large image in Excel ribbon UI
- Copy and Paste down the column
- Type Mismatch Help
- embedded Excel sheets in Word documents
- Linked Data Validation(s)
- Need help with Macro
- computer programming
- Unloading /Closing all userforms
- Convert Columns to Rows based upon a duplicate value
- Array formula acting as it shuld ... but
- Data Validation and a Clear Button
- COMBINE TWO MACROS INTO ONE
- Named Range Formula
- Searching online behind the scenes
- Ignore breakpoint when running a macro
- Specifying Row to Copy Across ?
- .formula property bug?
- HOW TO MIX TWO MACRO CODES
- Insert Date in correct cell
- use of variable in Range("..,..") argument
- toggle borders
- listbox remove item according to the value
- Run macro when file closes
- active sheet is 'slow' to be active
- dilemma with getting sql data
- Workable Scatter Plot Data Points
- grid on user form
- Split ActiveCell.Value and delete element if.........
- Dynamic Range
- Where to put code
- "UpdateLinks = 3" not working?
- can't select worksheet
- How to evaluate string form of numeric expression in VBA?
- assign macro to button programmatically
- Enable Excel Speech
- Problems with autofiltering and dates I think
- Don't want backup copy in XLSTART
- Endless Loop - Shortcut Key To Stop Code?
- Drop List
- Text Box Change Event
- recalling named ranges as must fill cell
- how to connect pictures from an excel sheet to a power point slide
- Drag-n-Drop_XLA_Install (VB Script)
- Drawing across Data from different workbook using long list.
- Importing Data - 2
- Importing data
- xl probs.
- Zoom to fit the page width
- check criteria and run macro
- go and check on spesific page and then run macro
- modules
- protect sheet with password
- Can not access MS Visual Basic Documentation
- Changing font color based on positive or negative number
- Formula / Football Pool / HELP
- Football Pool Fun HELP
- Match function in VBA
- color number list????
- Automated Build -- auto import of .BAS module into XLS or XLT?
- Having difficulty with scroll bar in VB
- code to choose tab color?
- IF Condition in Excel
- Function To Combine two 3-D arrays
- how to make a function(vb script) global (as in used from every w.
- Cell formating
- Opening explorer using VB
- Macros in Formulas
- Speed the macro works
- Updating time made by macro in excel
- Excel Form HELP
- how do I add vba reference to Microsoft Forms 2.0 Object Library?
- For Each Ctl In Me.Controls