- Pop MsgBox if cell input not a certain format
- Workbook_Open
- HELP :( Search a range of cells from contents of another
- use a v-Lookup or conditional formating to insert images
- Pivot Table Totals Sort
- Macro to define name range based on user input
- Using more than one table in a parameter query
- Variable to be used by multiple workbooks
- Auto insert Text into empty row
- Looking for some direction with a macro
- Searching for sheet by sheet name
- Simple data rearrangement - hard to code
- rng.row code giving funny numbers
- Macro to create a shortcut to insert any file into current excel workbook?
- vba disabling saving
- making Add-in macros available
- Find the best trend line as data is entered
- Help Creating A Macro....
- List Box With Separate Description Box
- Conditional formatting variation
- cell finding
- Clearing all unlocked cells in entire workbook
- Using a string-variable in an excel formula
- Complex ComboBox/AutoFilter Code
- Error 1004 Unable to set the Hidden Property of the Range Class
- Macro to Retreive Parent / Child
- Macro error
- copying data from one workbook and appending it to another
- Naming/Deleting workbooks
- Apply Color Coding to Dates based on conditioning
- Selection Replace
- Auto Hide Tabs on Save
- Web Automation
- Need help with Transposing/Macros
- Class modules with OLEObject kill own instances
- protection macro
- In VBA how to talk to Com1
- View multiple sheets at once
- Lookup Formula
- Macro editing multiple workbooks
- how to save with new filename
- Form Load/Unload Display Issues
- Copying/Moving Cells when highlighting
- Extract Email Addresses From Excel
- annoying date format
- how to keep value from active cell!
- How to move data from userform to userform and save?
- array equal to a range of cells?
- Statistical Analysis using VBA
- Linking Access Queries to Drop-down Menu in Excel
- UserForm Printing
- Click yes/no to close workbook
- Prevent a user from closing a userform
- Vlookup function
- Reversible Coloring Macro
- Cut and paste on new sheet macro
- Audit report
- E-mail from Excel
- Controlling other windows applications
- Excel crash on Workbook_BeforeClose
- Putting Excel into the Foreground
- Preventing symbols being used in input box...
- Transfer percentage into UserForm
- Value from wrong column
- Macro help needed
- Finding a matching cell
- Creating shortcut for dialgoue box
- Use sheetname to open a Userform
- run-time error 1004
- Excel- forms??
- Solver Function
- Hide messagbox
- clear the content inside the cell
- Macro to copy and paste information from other applications to Excel
- Pivot table constants missing in vb .net
- Copy Textbox Contents
- Excel database
- Update Access database through changes in Excel worksheet
- How to concatenate all combinations across 4 rows?
- insert data into closed workbook
- Help Creating a Button through a Macro
- Match and then insert row
- VBA inputbox to excel sql queries
- can we make multiple text boxes like this
- Formula data type?
- Embedding Control In Worksheet
- conditional function
- Using named ranges in macros
- Chr() function override?
- Dynamic reference in R1CI notation. is it possible?
- Activation Timer
- really big files?
- Finding results not in a table lookup
- Import Format/Fonts from Microsoft Project
- Form TextBox Event Issue
- Determine if an instance of Word is open
- How to find last 10 cells in a row and paste the average into new sheet
- HTML codes into VBA
- Autoshape
- Code using folder name
- Enabling Auto Filter when sheet is protected
- my macro changes the date format why?
- Creating "blocks" that will automatically repeat when needed
- Macro to set a Print Area
- Pull web data to excel
- RS232 in VBA
- Using the find function in VB code
- After vb macro deletes info question
- MsgBox PopUp based on ActiveCell Location!
- Lock Sheets using a VBA Loop
- Conditional cut and paste loop
- VBA code for sorting
- VBA Lookup
- Click cell to run macro
- Need copy / paste only values macro bug fixed
- Store excel data in a SQL Server database.
- Excel Hyperlink
- tidy up code produced by macro recorder
- Synchronizing scroll bars & cells
- Debug Alternative
- Protect and Track
- Combobox
- Schedule Regular Workbook Updates
- Pivot Tables: Controlling PivotItems using VBA
- Enter variable into popup box, variable defines cell
- Drop Down menus
- Find Last Filled Cell, Negate it, determine another cell and subtotal a column
- Truncation when reading contents of cell
- xlVeryHidden
- copy a worksheet from one across workbooks via dropdown
- stil formatting
- Listbox_Click event not firing
- VBA SQL updates??
- Importing Data from the Desktop to another worksheet using a macro
- Can Someone Please Amend This Macro
- simple macro to create new sheets
- List Box
- format adjacent cells
- Do loop until a value is found
- Refresh Webquery
- workbook object
- extracting the date from an unrecognised entry
- New worksheet based on stats
- Restrict printing unless certain cells are completed
- How to take a list of names and put in a userform ?
- open workbook using workbook
- Image Trouble
- Elseif Not IsNumber error
- Macro Trouble on T tests. 1600 test to do.
- Matching values to reference file
- code for user form
- repeat of formula, print command
- macro equivalent of Control-Home is -- ?
- Find, copy and paste from multiple sheets into one
- SepTerm based on a defined text
- Conditional lookup?
- summing specific range
- Date Picker, turn Off Calculations
- Copy & send single sheet with values and no formulas
- call a sub when data validation list changes
- Get Rows User Selected
- Enter Three Worksheet Change Codes on one Sheet
- Vlookup alternative
- Lifetime and class modules
- Working with large numbers of controls?
- sort question!
- xl file opening problem after sorting and saving in vb
- Find string, offset one column, enter string
- Highlighting rows with X amount of data!
- selecting rows when opening CSV file
- Conditional Formatting based on another selection
- further develop IF(A2=A1+1;B1+1;1)
- Paste non-identical data from one book into another
- Loop-copy irregular columns values to new table
- Variable to select range to copy and paste to
- Create User Forms of "The Course Booking Form"
- Count last non blank column and apply to formula
- Removing all rows with word yes populated and pasting to new sheet
- Question
- Deleting rows Macro
- #DIV/0! format question
- Using Autofilter to find data
- dimensioning/variables for Chart
- Live update with excel?
- Appending two EXCEL rows together
- Merged Cells Problem
- Importing to and from Excel/SQL
- Compile Worbook into Application
- Fill until
- Sorting Columns
- Mailing the excel-doc. from a button inside the document.
- How would I create a filter on many pages
- VBA close without save code
- Fomatting dates
- Move Workbooks With a Certain Name
- Overwriting existing data
- Active workbook in userform - or floating window?
- Adapting VBA Code
- import as sheet form the same folder as the worksheet
- deleting all sheets except the master?
- Delete empty cells
- Error 1004 'cannot access file'
- Calculating Ranges Dynamically.
- VBA Errors
- How do you save ThatWorkbook when using varThatWorkbook = ActiveWorkbook.Name
- Formatting parts of a comment
- get username of the "main user"
- Object Required Error - Adodb Parameters
- Macro for Sub-totals
- VBA to return date created
- Loop until won't stop!?
- Hyperlink Macros
- VBA Autofilter
- Deletion code
- Setting chart titles from sheet name and workbook name
- Refresh All Workbook Data - incoming data insert properties
- Want to add additional columns to attached macro
- Email Notification within Excel w/o sending a workbook/worksheet or anything
- formatting
- UDF for conditional formatting
- Collapsing rows, removing blank lines between data
- creating charts using macros which picks up source data from the active sheet??
- Want to add additional columns to attached macro please
- Delete method failed - error 1004
- move module from one to another
- SaveAs File Path from Word to Excel
- creating new sheet from template and naming them from list
- save excel in access
- how to set logical formulas in excel?
- Use String Variables in File Path and create path if not existing
- How to assign a number to a cell in another sheet by clicking an object?
- How import data from a closed file with an update button
- Auto fill for row 'fields' in Pivot Tables
- Display the value of a cell or range in Userform
- Converting a date into a school year
- getting rid of 662579 rows!!
- Macro for checking multiple conditions & selecting the correct range
- Display value in textbox format decimal places
- How to print entire UserForm?
- Where should I enter this code?
- Serial date conversion
- How to change the desktop name from being user specific to general user?
- Macro Syntax for cell character checking
- Deleting many sheets with similar names
- Clear sheet contents but retain Clipboard contents
- Write textbox value to cell 'on-the-fly'
- Obtaining The Functions Cell
- Value of cell + 1
- Macro for pasting, deleting, and shifting data
- Default Color For Cells