- How do I make an adlibs type sheet
- Autofill macro based on above data
- If File Exist...
- error 1004 in 2000, but in 2002 ok
- macro to automatically run when spreadsheet is opened
- Urgent help thanks!
- Delete all sheets that are not selected
- Can anyone give me on an offline update?
- accessing other excel files
- Using Find with different variables
- Loggin Windows ID on After Event Verified List
- Macros crash workbook
- Working with simple multilined cells
- Formating several lines at a time
- How to format a cell and setup a button
- search engine in excel
- VBA filter and data count
- Getting the Address of a merged cell
- UserForm
- Updating counts and totals
- Possible to identify the name of the file that was opened using a wildcard?
- Count unique items in column.
- Check Box Toggle
- Sequential numbering and Rows
- Extracting Part of String
- Checkbox Macros
- Select Range
- copy formula's and conditional formatting to another sheet..
- Check if name exists
- entering data based on a lookup table
- Saving the workbook...
- How can I use vba to determine the name of an interior color?
- Force save as file type
- How to merge and weedout duplicates
- IF and OR function
- Count blank rows between occurrences
- Creating a folder if it does't exist - Problems
- Find method on columns?
- Compare two years accounts data
- Changing font color based on change from previous value
- Advanced Filter Macro - Won't run the filter
- how do i reference cell value
- Remove customers whose rows = 0 in col M
- How to run macro when value of cell is entered
- Can Mod return a decimal?
- search will not pick up cells values that are hyperlinked
- Listbox Click event
- Sum values based on cell colour
- averaging values from other sheet
- Saving Data
- Add command button to assign "shortcut" macros
- import all text files in folder
- A few macros dont work properly with Personal.xls
- Copy sheet and save as txt
- How to check value of column from other Worksheet & copy corresponding value
- Code to locate string or enter a new string with corresponding value
- creating a Input message box asking name then only the excel file should get opened
- count number in column
- How to convert column data to row and column
- Deleting rows based upon partial cell text
- Best Way to Approach this Scenario?
- Check digits between column
- Macro sub-menu unavailable
- Anchoring hyperlinks
- Cell does not always recalculate
- Drop Down List Choice gives Different Checkboxes
- Copy and Paste Question
- If/Then help
- Help with a MODULE
- add ins for log graphs
- Sorting based on corresponding cell
- auto input text in 'a' when text entered in 'b'
- Using excel to grab data from MS Access tables
- Select Case Error Handler?
- Setting chart MinimumScale
- Enable / Disable CommandBarControl
- reading excel file from zip
- Text to Columns
- Getting workbook_open to trigger on any workbook
- How to undo a button command?
- Another Rounding Q
- Message box alerting when cell clicked
- Auto save on exit selected data sheets, instead of whole project?
- Macro - Conditional Formatting
- Compare digit with 2 coloumn
- SaveCopyAs from xls to xml
- Extracting info from cell
- How to make checkbox change cell color?
- help on find how
- Adjust selected range
- Alter certain word in a textbox
- Creating a used parts list?
- Revision to Formula/Macro to Check Column and Copy Row to Other Sheet
- Problem With Excel Form
- pivot table within macro
- Free Add-ins for SWOT & PEST Chart
- Format Column data to be Col and Row
- Print only Pivot Table
- Setting Y-Axis with Cell Values in Protected Sheet
- automatically save a copy of the workbook when saving or closing it
- How to return to "original" sheet after using a link to a other sheets?
- Inputbox - HELP button not displayed
- copy paste problems
- Macro To Insert Conditional Data
- Excel Macro to exclude 1 sheet in WKB
- Want to Use the Same Macro in the second Row also
- How to insert split data to particular columns
- Cannot allow multiple Range in a Sub
- can you set a time, and have excel auto...
- Macro excel to copy and paste table from Word
- Links Within Tabs - Break Link In One Tab But Keep In Another
- Timestamp when worksheet opened
- SaveAS vbYesNo command button
- Merge into Publisher
- Command Buttuns and Assignable Tasks
- How do i hide buttons when starting excel workbook?
- How do I autofill colors, based on input of text
- Totals of serial from several sheets
- VB Code To Update An Entry Based Upon # of Copies
- UserForm with Options
- Massive Statistical Number Crunching
- UserForm with Options
- How do I keep the VBA with a copied worksheet
- Macro to Search column and if found, copy a cell within the worksheet
- Delete empty cells within row until you hit nonempty cell
- Auto data sort between spreadsheets
- copy paste, inset, cut ..disable
- Disable Save As in Read Only workbooks
- Split data insides a Cell
- Adding Data to a word table using Excel VBA
- extracting excel data
- update a value only TODAY, then FREEZE it
- Dynamic Link Button
- Master spreadsheet to display value from children
- conditional hide unhide columns in different sheet
- hiding an entire row -conditional basis
- Unused Variables
- Copy sheets....and page setup
- changing colour of selected cell
- Script for Macro running rules
- Deleting rows based on criteria
- Code to find #N/A in a range
- Why Today() not interchangeable with Now()?
- Auto-retrieve and manage data from another spreadsheet
- Incremental numbering based upon user input
- U D F
- macro that executes when a file is saved
- challenging sorting cells
- Running a macro from a different module
- Reducing the code - applying the same code to several WorkSheets
- How to create a msgbox that show sum result of A1-A10 ?
- Can I use VBA to check if the sheet(xxx) is in Page-Break mode or Normal mode ?
- unable to delete range names
- Problem with loop
- equalling 1 if first 1 in a column between text
- Macro to run scenarios and save cash flows to corresponding scenario sheets
- Can I password Lock a sheet in a Workbook
- Simpson's rule for integration
- replace all defined range names in the sheet that start with "Street" to "Road"
- Copy and Paste from previous Row
- derivatives of a cubic spline
- CheckBox and Submit Button
- Repeat macro from user input
- Update Pivot Table with New Sheets
- How to create CommandButton that run exists macro ?
- Hi
- Search Macro
- Insert row, copy formula, delete values
- Add sheet problem....
- Finding the NEXT bold cell
- upper case for many textbox
- Action based upon cell having contents
- Adding a column
- Drop duplicate values from string
- initializing the userform error
- Changing font attributes on a page
- QueryTable import from many text files in a loop
- Insert rows and copy data from other sheets
- Filter by Value in cell
- How would I do this 3~2~3 -----> 3~2
- Insert copied data, leave rows in tact...
- Count Number of Lines in a .txt file
- UserForm exiting prior to completion
- Code for multiple worksheets
- Allignment of xlDataFields Values
- Macro Tool Bar Error" The macro.xls!'pick canot be found"
- Macro to take all tabs to cell A1
- Function to change the colour of the cell.
- column heads in excel vba
- custom navigation using cursor keys
- custom navigating using cursor keys
- How do I asign a range of cells to a combobox?
- How to Go back three cells ?
- Hiding the same column on multiple sheets
- Selecting an array with a varying number of sheets
- Figuring Percentage complete
- Import from another Excel file
- Find and Replace Macro
- insert copied cells
- data validation
- how to delete the row if index is known
- Excel Macro into word & powerpoint
- Limiting custom menu selection based on sheet name
- Checkbox without text?
- Column Widths changes automatiaclly
- paste special problem
- Macro to use on movie scripts
- Dialog box to locate and copy to a specific row.
- CONCATENATE #'s with a twist: #~#~# /or/ #~# /or/ #
- Hiding/un-hiding non-specific rows and specific columns
- Insert a Macro without Overwriting
- Searching for specific word then delete it
- multiple text box references from a user form
- Data Validation List
- Auto delete a line?
- Macros Not working when adding excel sheet to microsite
- Highlight Selected Cell When Using FIND
- My Progress Bar Doesn't Update..
- Printing Multiple Selections from Separate Worksheets
- macro to compare information in sheets
- Dialog Box
- Command Button & HTML help!
- Populate multi-column list in sheet not in UserForm
- Poor export formatting leads to complicated Macro?
- Compare data and copy to matched row
- Array limit for a macro created chart
- Macro to save results of formulas
- Search Function
- Marking changed value cells
- cancel Events using macro?
- Pivot Table Macro
- Finding sheet that matches a cell value
- Delete the same rows on multiple sheets
- Column selection
- Using a combo box to navigate between sheets
- Password protect macros
- how do I paste into a spreadsheet web object?
- Add reference programatically based on Office Ver
- message box if the sums of couple of cells dont equal with the sum of others cel
- A "go to" formula in VBA with Indirect function
- select ALL Shapes
- export data from a database to several sheet in excel
- ThisWorkbook.Close crashes excel
- Linking files using cell contents as filenames...
- Help urgently required
- Completely disable ctrl key?
- How to input quotation marks within a cell using VBA
- Compare common variables across two worksheets
- Macro to find multiple results
- Use Excel VBA to populate Powerpoint