- index?
- preventing data in hidden columns from being deleted
- commandbutton to run solver?
- Code too long? Error 1004
- on open, write to text file?
- Variable into Currency?
- how to count on every occurence
- Formulating number difference
- Calculating a date based on code in cell
- Msg Box with User Input?
- Locate a File within a Directory's Folders
- Soccer league scoring // Excel right option?
- adding cells in two sheets 1 and 2, and put the sum in sheet3
- Counting Cells with Conditional Formatting
- asssitance with copying data
- Macro to delete only sheet #'s not named
- Paste Into Current Cell
- List of Folders
- Regression Analysis For Ranked Attributes
- Delete Specified columns and/or rows script
- Trouble with AutoFilter
- windows sched to run macro
- Report?
- Offset Range of more than one cell
- Is Shape a textbox
- Default Option Button Values
- VBA code just won't work
- Clear date range
- user id
- Code to find alike items in a spreasheet
- Define/pass varibles to Sql query
- Code to send body of spreadsheet
- creating a small database
- active x combobox
- VB code for newest sheet
- Find a Specified Value in All Sheets of a WorkBook
- Open a Word document using cell value as the file name
- Inputting into a Form using a variable?
- how do I write this in VBA
- Automatically put data in sheet 2 when rows in sheet 1 exceed 65356.
- Condense VBA Code
- Variable in Sum Equation
- Offset using range of more than one cell
- Can anyone tell what would be the first step in learnig VBA
- Loop macro to try various values, and then record the various answers in a new column
- sql/macro/VBA question
- Problems filling combobox with data
- How to copy a combo box to new rows
- Macro for merging cells "without actual cell ID"
- Formulas
- Multi Range formula from Autofilter
- macro for copying data frm a particular column
- drop down boxes
- Runtime error 1004 paste method of worksheet class failed
- Open Access Report
- nSheet variable to select the sheet
- Delete Sheet
- Range Variable
- place a limit on length of text
- Linking a dropdown box to give results
- Duplex Printing - Problem with worksheets?
- What's wrong with my dropdown list?
- Code to open a workbook , copy info and return it to another workbook using a cell v.
- Filling in dates
- moving between pages;
- Selecting data bettween dates...
- SpinButton question
- cell text alignment vertical - using VBA
- dont allow saving
- Select Unique values ....
- Creating macros in Excel so info in Access database can be shown in spreedsheet
- Count function to count a specific value.
- Call module from another workbook
- Calculating Total Time
- Help with updating labels on form
- Syntax error in 9-line macro ..?
- Conditional Macro for moving data
- Comparing system time
- I am looking for adding column like this example
- Autofill from data entry form into 2 worksheets
- saving csv files
- Copy cell number of times
- Scroll bar adjustments
- see my vba codes and see what is wrong
- filling sheets
- Create custom function to exceed 7 nested If functions in Excel 2003/XP/2000/97
- VBA - randomise 15 question from the pool of 80-90 questions for user to selected
- Insets row in sheet2 when row is inserted in Sheet1
- excel macro for sending emails
- Hierarchy
- Macro To Change Letter Grade To Number Grade
- naming a column & naming a cell with a number
- Macro to run Ms Query and import the data into excel
- instr and with findnext
- selecting a range with two variables
- Macro Print External txt file
- Excel 2003 to 2007 missing picture
- Cell Data
- Excel '97 to Excel 2003
- How can you make a Global Variable?
- VLOOKUP returning N/A
- amendments in code for emailing...
- Formula combining CONCATENATE and IF functions
- Best way to 'tweak' my code?
- Using every nth row from another document as source
- Selecting the sheet the formula is on - but NOT the active sheet
- separating cell values
- Page Creation & Formating
- Delete Row Based On Cell Content
- Copying data from closed Workbooks
- Read .xls data -> insert in .txt file
- Search one value and add another
- filter column with special characters
- "If" - "And" formula
- Locations finding
- New to ExcelVBA
- row highlight
- Macro to Delete All Sheets Except One
- Size limit for input file in VBA?
- Cant select entire sheet
- Selecting a picture object
- Format Headings Export
- Copy Worksheets to Word
- Autosave
- Adding a lotus notes hotspot button through excel VBA
- Min to Max list
- Automatically filling cells
- Auto adding date to a cell
- protect workbook from everything
- Writing blanks spaces in a .txt outputfile from VBA
- Adding Item
- Selective function if cell empty/full
- Protect all worksheets with conditions
- combinated if then question
- Adding Data and Maximum Selections
- Sort in descending order
- Getting one field value from pivot table
- dealing with grams ounces pounds
- what wild character to use for choosing numbers
- copy lines a specified number of times
- Code to add message box
- How to conditionally format Font Typeface?
- excel 2007 command line parameters
- Max function in VBA
- Manipulating Excel Worksheet Embedded into Document
- Odd Runtime error
- excel match question
- looking for foumula to filter numbers
- Macro With A pivot Table
- How to deal with Message Box in VBA
- Message Boxes
- Validating data in a user form
- Automatically Move to a New Column
- If Match statement
- worksheetfunction.vlookup
- Macro to save and send as a notes email - suggestions please
- Message box code
- Copy Rows from selected Sheet to New Sheet based on Cell Value
- Copy data from selected sheets to new sheet
- Specify Directory in Auto Save Macro
- paste value after each calculation?
- removing rows featuring certain words (wildcards needed)
- VBA code to renames Tabs dependent on Cell name
- Exit a running macro elegantly
- If statement - run time error 68 - Device unavailable
- VBA is waiting for Large Excel file to Open.
- Protect Sheet and Sorting
- Prevent Shrinking UserForm Too Many Times
- Remove toolbars....flaw I can't work round
- VB copy multipule cells
- Select only unique values in a particular columns in macro
- Issue with Shape(text box)
- creating a drop-down list
- Change All Pivot Caches
- Public Function
- VBA Code More Efficient
- macro for adding a column at the end of that column
- How to find count of unique values based on multiple criteria
- Slow to Open, Save and Exit
- Graphing specific cells
- Create a Command Button
- extracting data from cells and sending email WITHOUT attaching workbook
- Need Help testing if a cells contents match that of a cell in another column
- Listzing distinct values
- Check if cell is part of a named range
- Select Multiple Cell Macro
- collect data and place in text file.
- Add Sheet through VBA
- All my sheets open now
- POI API in java
- Excel Solver giving wrong optimal solution
- Running Excel 4.0 Macro in Excel 2007.
- Special Paste Error
- paste into cell
- macro where array varies
- Chart VBA for .CrossesAt auto Code
- sheet summary
- Macro for Filtering
- DDE Macros and data formatting
- number of rows
- VBA or VB.Net
- Format in Combobox / Listbox
- extracting data from a calander
- How do I display only column one of a pivot table (2003)
- VBA to File Save As & Replace
- Copy Paste Macro
- macro to graph values
- Data Sorting Macro Help
- sending an email
- If then and delete row
- capturing row delete
- advanced exporting
- How do I skip part of a macro?
- Auto-fit code to run when tabbing out of cell
- Macro Code Only Pastes Once Need to repeat
- Question related to Sensitivity Report (Solver)
- Evaluate end of folder name
- when cell has entry
- VBA to select a data set - not hard code it
- Creating hyperlinks in VBA
- Text Box name changing, macro to delete not working
- TABing through text boxes
- Filter but keep certain headings rows?
- checking for an error in a cell
- Macro Each time range in column a is changed
- How do you populate a ComboBox?
- Userform Pictures
- Saving a Spreadsheet everyday at 12 midnight
- vb convert column letter to number
- getpivodata macro
- How to skip cells to add data
- Obtain All File names in a folder
- If Statement not recognising outcome
- Having cells change their contents according to what the contents of other cells are
- excel to xml converting
- find pecentage
- LOOPING: Faster rate of convergence required
- Assign macro to clip art
- Need to color a certain cell based on values from other cells...
- Moving Vertical Lines
- How? Open Workbook to specfic tab & cell?
- Removing AddIn From Available List
- DSCN Course Assignment
- Consolidation
- data reduction
- Dynamic Indirect Validation Dropdowns
- How to add check boxes as sheets are added?
- Distribution planning based on order data
- Creating a series of workbooks from single workbook
- VBA Code