Excel Programming [Archive] - Excel Help Forum

Delete worksheet
Drawing Lines in 2003 and 2007 differently
Protection and Save disabling
disabling arrow keys for InputBox
Excel takes focus when Printing
VBA Equivlent of VLookup/Match/Index?
Opening a file with the next working day in the filename
[SOLVED] Cells.Interior.Color question
Programmatically UpdateNamed Range
filter features+macro
How to use multi-column ListBox?
Macro to copy/paste cell based on value...
Remove cells that contain zeros or are empty from 'pastelink'
Locate row above cell with specific text, and apply formatting?
Delete row containing protected cell.
VBA Enabled Time Sheet
Cross referencing lots of data
Can i create a Macro to run on dynamic data??
Running SQL Stored Proc through Excel VBA
IF Command playing up
Match & Find function
Protecting individual worksheets with a password
Getting around Dependency Tree Performance Bottlenecks
extract data from email to excel
Using a named cell in a macro
Code to colour a cell does not work?
algorithm/addin to solve this problem
Compile Error in 2007
New Sheet Problem
[SOLVED] Log of who has opened Excel File
Conditional insertion of rows and cell values
Catch non-existent dll compile errors
Worksheet.Opentext failure?
Sheet timeout?
[SOLVED] create a macro for a monitoring system
Pulling certain info from Yahoo Finance without ticker symbols
cant select array of csv files for processing
Protect/Reprotect Execel 2007 Sheet
MISSING: Ref Edit Control
Creating a Custom Data Entry Form to Update Multiple Excel Records at Once
Estimate/Actual Amount Compare, Match and Output
Email cell value to multiple recipients by a workbook
qualified references - why does this not work?
a few questions about slowing code and its quality
Macro to Insert Page Break Where "A" Column Changes Value
Sorting Data
Copy last row from autofilter selection
[SOLVED] Totaling 2 textboxes in a form
Defining changing ranges with vba
Prevent deletion of cell content after writing
trying to create a scheduling function
Delete macro after running it
[SOLVED] Combining IF, AND, OR
Dim x Date
[SOLVED] Open different files in the same workbook
Project is unviewable
Filtering the record to new sheet
Taking some data from table
Worksheet Events Not Working Consistenly
Worksheet Events Not Working Consistenly
Exiting subs
[SOLVED] looping with dates
[SOLVED] Position cell in top left position
[SOLVED] Macro edit button grayed out in excel 2007
Help saving user inputted data from a worksheet to another worksheet and saving it.
conditional locking and unlocking of column cells
Importing jpgs from excel to word data merge
data validation
Importing Date Fields from Text Files
Downloading Data From Yahoo
Finding a folder based on data in an Excel cell or cells?
VLookup VBA error trapping
Using a date range as criteria
Unable to set the visible property of the worksheet class
Pictures and field completion
Macro to Change Cell Background Color From White to No Fill
Upload Data to Master Sheet
[SOLVED] Saving To A Network Drive
[SOLVED] code for printing
modify ALL files in a folder
Linking Partial Data From One Cell If Data In Another Cell Meets Requirements
Deleting cells in multiple worksheets at the same time
Convert a CSV file into a formatted Excel file
Delete a row in a macro
Assigning PivotTable Name to Variable
[SOLVED] Getting a COUNTIF based on two columns
Upload entire sheet to SQL database
Print Macro
Delete rows based on unique syntax
[SOLVED] Delete Row if value = "" or if value ""
Reading Date
Sum into the TextBox
Track Changes without sharing the workbook
[SOLVED] Border color issue in Excel 2003
Can a cell value be sued as a directory name
Move over or down given number of cells
[SOLVED] Combine different cell values in to one
Move autofiltered query to an existing worksheet in same book
[SOLVED] select only cells with content
Excel Referencing Problem (enhancement)
Macro to lock cells after a particular cell has been change
[SOLVED] Faster way to Create a Table from an array
Need a fix to this macro
[SOLVED] VBA problem finding a cell in a row
multiple worksheet_changeselection events
Add wildcard to workbook cell searching macro. (ws.cells)
VBA - Check if selected worksheets exist
[SOLVED] Join various columns from two data sheets
Ranking Table Help
Group by..
XIRR Function in 2003
Username macro
[SOLVED] Pulling information from a spreadsheet
merging 5 cells into one cell
Choose 2nd workbook
[SOLVED] Linking Partial Cell Data
[SOLVED] Consolidating column based on intances of a value
Updating Excel with Word Form
[SOLVED] Close all workbooks except for the main workbook
[SOLVED] Limiting the scope of auto-updating
Formatting/locking/Unlocking range of cells
Search Box that searches and retrieves data from another sheet
Copy a formula from one cell to another with a VB Macro
Paste Data Into A Filtered List
Extract Text in Email to Excel In Specific form
Dynamic Range of Columns with fixed Rows
Find All Function / Macro
Protect and Unprotect Outside Workbook Automatically
[SOLVED] Opening several charts from a list box.
Help with worksheet events/drop down lists
[SOLVED] Scan Through All Files and Subdirectories
Excel-linked Powerpoint presentations
Not Open Excel File After Fixed Date!
Excel Macro
Add vba to each workbook in a folder.
Combo Box ListFillRange causing save prompt
Copy a drop down box as string
[SOLVED] Add color to cell based on selection made
[SOLVED] Delete Row if Specific Word in Column A
Selection is Range or Object?
[SOLVED] value of i in a for next loop (even/uneven)
[SOLVED] Clear Contents of Named Range in Excel 2007
Setting desktop as location variable?
Macro: set filename as a variable?
Copy / Paste a Dynamic Range in Email
Using Macro to Run Vlookup+Excel 2007
Password protect TextBox in Excel
[SOLVED] paste special macro
unmutting using vb
How to merge multiple Excel Files into One File
Applying Vlookup using a Macro(Vlookup+Macro) in Excel 2007
Web Query with Delay
Copy and paste loop
Automation Error: "The object invoked has disconnected from its clients"
[SOLVED] Creating folders from Excel Spreadsheet?
how to merge sheets
[SOLVED] VBA - file prefix only?
[SOLVED] Disable selection of a validation list
[SOLVED] userform Sr.No autogenerate
Stop pages showing
Range variable doen't adjust to moving cells between sheets
macro for pulling information from website at regular intervals
[SOLVED] Find Code for Button
Running Macro based on a cell being equal to specific value
sum function with a break point
on error message
send mail and close workbook immediatly
[SOLVED] Different method for finding variable region
Working Code Suddenly Broken: Run-Time Error '32809'
[SOLVED] Shift Colors To The Left
Macro to Create a set of folders and copy the active workbook
[SOLVED] deleting the first 8 characters in vba
Need to access non-native menu commands in VBA
Macro for dragging formulas a variable amount of columns
Help exporting multiple files with unique data
[SOLVED] Hide rows based on date
[SOLVED] macro window with buttons to accept user input
[SOLVED] error 1004 trying to set print area
faster method for saving data from userform to worksheet
Macro for Copy and Clear contents
excel macro for sum calculation
[SOLVED] macro that will paste multiple selections in one row
DBF file update
Copy and paste weekly totals
[SOLVED] Save All Macro(s) in Personal.xls
Locking and unlocking column cells using VB Macros
[SOLVED] writing values to range - first entry repeated
[SOLVED] How to set combo box to a value based on a change in specific cell
Find the Latest date and delete the rest
[SOLVED] Macro to perform simple calculations
Delete Rows That Have a Color Red in Cell
Copy formats/formulas in new rows
[SOLVED] spinbutton to increase by different increments according to current value scale
[SOLVED] setfocus from module to userform control
push data to another worksheet based on a choice of 4 cells being checked
[SOLVED] Leading 0 not showing in cell
If Then Statement - Part Not Working
[SOLVED] copy sheet and rename based on date
IF Then Statement - Part Not Working
copy vlookup results to new workbook
Excel 2007 Copy HTMLTextArea value fields into a range
[SOLVED] UserForm - Only one button toggled at a time
Automatically select another open spreadsheet
Creat Random List
Email with CDO
[SOLVED] Error in Macro (selection.delete)
[SOLVED] need to extract two coulms from a workbook with 31 tabs
Storing VB Code in a variable withing a Macro
Macro To Copy Cells as CSV
[SOLVED] userform Time Card
[SOLVED] clear, copy and paste on different sheets
Copying data from sheets in workbook
[SOLVED] xl forms on top
Protect and Unprotect using vba
Copying Information from Website to Form (2007)
copy value by vlookup
Better way to look up
[SOLVED] Range selection from variable start point
[SOLVED] Mouse Coordinates in userform
Erase cells after a certain value
Naming tabs automatically
VBA worksheet_change
[SOLVED] Web Query data into one single cell
Range Select + Delete Blanks
Need Help with Macro!
Use Lookup then copy in Macro
[SOLVED] Adding a page to the workbook with a name
[SOLVED] Average based on data in two columns
Insert Row Macro
[SOLVED] Named Ranges from VBA
Why doesn't this code work for Excel 2007?
[SOLVED] Save worksheet automatically
macro to insert page breaks
[SOLVED] look for 1st matching entry for multiple data ranges in worksheet
pivot table data field calculation question
[SOLVED] Return cursor to last (previous) location
[SOLVED] How to delete items from Shortcut Menus [Right click]
[SOLVED] Option to print - use print macro
Proper syntax to move a row to another sheet with a variable involved.
[SOLVED] Moving Personal Items to TOP of Menu
[SOLVED] Right Click Menu - Adding (Paste Special)
pop up resizing macro adjustment
ADODB Connection String
copy password protected sheet
What is "set" for??
[SOLVED] Macro to save shared addin to personal addin folder
Solver Issue
Not Save "Read Only" file via Macro
[SOLVED] Referencing a named range, from a cell
[SOLVED] ListBox on Userfrms