- Passing Variables to a UserForm
- Formating a form
- Upload data from excel to sql server
- Julian (dddy) to Date
- Executing On 'Return' or 'Enter'
- Conditional Formatting & VBA Code
- After printing ,the macro works very slow
- VBA for Automation
- .NumberFormat
- Gathering information from a networked drive Workbook
- On Filter Multiple Condition
- Fill next row
- Delete Entire Column If
- Saving Text Files Without Quotes
- 26657 Rows
- Get info from a DLL
- Next Without For
- Q. Shortcut key to execute an event procedure
- link to macro from text in VBA Code
- Drop down list box query
- how to insert a single cell
- changing dir for GetOpenFile
- Using 'FInd FUnction in a Macro
- Programmatically populating combobox cell
- Sorting
- Max number of item in a form (in a ListView)
- Open All xls files in a folder
- custom toolbar
- vba/macro
- VB IF statement using a Variable
- How to show a msgbox whilst processing
- How to print special characters
- Distributing macros
- Need help shortering my code with a loop
- Speed up macro
- Nested "If" formula on a Dynamic Range
- Determining the same row in different columns
- Autonumber when cells contain data - decimals
- Reading a conditionally formatted cell
- copy from txt file
- Search Date within Date Range
- If statement to move data to another worksheet
- Pausing Macro
- Checking for a sheet
- Worksheet_change executing selectively
- Defining a program to replicate
- Copy formula to column in vba
- Not the typical "find, delete" row issue --need urgent help please!
- macro and loops
- macro code to input date in pivot table
- Converting a table of data to a list
- Countif And If
- Multiple Ifs
- Vlookup in Various Sheets
- One worksheet how to print/collate three views of same sheet?
- Iterate thru sheets in workbook; take action based on text (string) value in cell
- Pivot Table Refresh problem
- Determining if next cell is empty
- Macro for naming all cells in region
- Label on a Trendline??
- macro to copy and paste data to end of data in second column
- Creating an automatic range updater
- Is there any VBA code to let Excel select a user-defined option from a pop-up window
- Combing data from worksheets in a directory.
- Conditional formating 5 Values by offset
- Extract Bold Text from cell
- Pasting into a new line
- Importing Data From Phpmyadmin
- copy range when vaule is true?
- how to get a macro to run when a sheet opens
- Adding more than 3 conditional formatting options using VBA
- Excel 2003 XLODBC addin convert to ADO
- Updating Multiple Chart Options (e.g. Title)
- Grouping sheets
- Search Function
- text wrap to next row
- Multi Line Comments
- combobox populating
- Countdown Timer
- Excel Form Generating File
- Clearing "zero" from cells with a Macro
- Find Statement not coded correctly
- Extract Values and percentages from text string
- Selecting an area of sheet and removing all pictures
- New Workbook
- userform system modal?
- hiding rows
- Unhide Rows
- Insert Image in Access DB
- Drop-Down List
- Variable = a sum
- Macro to put names into a column
- Searching Specified Sheets
- Formula with textbox
- Unprotect/protect when worksheet is protected
- copy cell data from worksheet to worksheet
- hiding multiple columns using VB
- How to add a Minimize/Maximize Button to a autorun UserForm
- copying from excel to word document
- ComboBox values from Access DB Table
- Passing aCell Value(Yes/No) into a function?
- Grouping Pivot Table Data
- Sumproduct with last used cell
- refresh unhide row when chosing from a dropdown list.
- Adapting macro to International Version?
- Referring to Named Cells in VB
- Save As Deletes Cell Contents
- Pictures.Insert property not working in Excel 2007?
- doesn't recognize the variable
- validation lists using vba
- User form textbox message for input error
- Workbooks(). command
- Create worksheet with specified range
- Combobox Text Align left not working
- Trying to pull data from 1 spreadsheetin into another.
- Date span calculation
- Cell properties & Arrays
- Programming a calculation button
- Discount Function in macro
- Version disputes
- How Can i decompile an Excel file
- Sql spool to Excel
- Range Selection
- macro for charting
- How to copy the value of the cell??
- Filtering data for dropdown box
- Printing based on criteria
- Writing smarter code to show multiple input boxes
- Loop through Checkboxes in a UserForm
- "Compile error: Method or data member not found", code needs fix
- Work Schedule sign-in sheet formula
- AutoCalc Question
- User Form
- This should be an option in excel's fraction options.
- List all Sheet Names
- Copy a range from worksheets in folder to master workbook
- query the system for Path
- Macro for Appending Data without Header to a database with header
- Import and reformat text file
- How to call on other macros
- remembering variable from one macro to another
- Replace based on a value in a cell
- reading data from merged cells in excel using a macro
- Can't record Macro
- Macro problem, after inserting new row, paste special
- Runtime Error 1004
- Selecting the Toolbar components.
- UDF issue with date format
- Cross post >> Error on extracting datas from Pivottable with VBA
- VBA - mailling a .xls attachment and cell A1 = "subject"
- Inserting List in IF function
- Clearing clipboard with VBA
- terminating whole excel application with a button
- Removing bold text from cell
- Can someone explain this macro to me?
- Setting print area
- TextBox on UserForm to display the last entry
- Variable Range
- Lost VBA Project?
- Microsoft Error In Excel Occassionally When Running This Macro...
- Do Loop error
- Outputting data that is constantly overwritten
- Next and Previous Sheet Code...?
- Find and Delete Row
- RowSource
- How to determine Length
- Error when selecting a range
- Results of 'Enhance VB Project Security' post
- Web Query macro runs w/o Query installed?
- CSV separator
- On Error Problem...
- Problem with VBA when Debugging
- Paste autofilter results to specific region
- Calling Custom Properties in VBA
- Forcing links to update
- Auto Filter Macro
- Conditional Programming 5 options: Highlighting the whole row using Select Statement
- Bypassing file load/save prompts
- run IF function in a macro
- Loop through sheets until tab colour is green
- Selection Problem
- Paste Special Column Width
- Placing range into variable from function
- add comments to all cells in a range
- automatically jump to next cell
- Insert Row and Formulas automatically drag down
- Kill method
- Setting Print Area across multiple sheets?
- trying to understand Select Case...
- Manipulating String Data
- Launch Visual FoxPro with Excel.VBA code
- Renaming a file
- run a macro to Force Calcuation for a range in another workbook
- Multi Page
- Date format in VBA code
- Txt data to excel sheets beyond 256 column limitation
- Looping through sheets and dating
- Worksheet.Range(Cells(r,c),Cells(r,c)) & error 1004
- Sending attached file using lotus notes
- Allow use of filters with sheet protection?
- Write and Read Data in a text box !
- Looping through sheets and Pasting
- Import mutiple CVS files
- Working with ranges
- Use solver add-in via VBA
- Listbox
- Automatically create chart sheets from data table
- Reset a Check Box
- Working with ranges
- Macro for copying into a new sheet using flag
- Number Length
- Unhide rows - macro not working
- Starting a Macro mid-way
- Named Range referring to Old Workbook
- Call Same Cell in Athr Wks during Loop
- VB code using wildcard
- Incremental Numbering
- delete duplicate rows..
- Excel 2000 VBA Compatible with Newer Versions?
- Protecting a sheet from deletion
- Timing a macro to execute
- Is this workbook 'read only'?
- Connecting to MS Access via VBA
- sumif condition in macro
- copy a whole folder
- Entering Day after date
- Copy excel contents to word
- Run Macro Template with variable links
- Code That will Automatically convert a cell's text to Capital...
- Renaming files using excel
- Data Validation not to be cleared
- Formatting Group Box
- Move to next column after sort
- Change and Save Default Userform Properties
- Create calculated field in OLAP cube
- Define name for range of cells
- User Form to dispaly last record in WorkSheet
- Formula For String
- clearing cell content in a macro
- R1C1 vs A1 in recorder
- average and sumproduct formula
- Enhance VB Project Security
- Input Box
- Get Last Directory Name from Dir Path
- unprotect worksheet w/o using password
- Absolute pathnames to files in VB
- autofill problems
- Global Range
- Code not working --- Y?
- highlight characters