Excel Help [Archive] - Page 91

Solved: Testing or Case of String
Solved: simple problem, please help
Solved: range areas limit in 2003
If...Then...Else Loop Error
Editing Formula Macro
How to store large complex data in array
choose folder with restrictions
Search all worksheets within a spreadsheet for a value and copy data to another sheet
Search for value and map data
Solved: Max / Min Userform
Solved: Automatic concatenate
msgbox content redirect
Encryption - v2007
Solved: non standard list comparing
Look up values
FUNCRES.XLAM? Why is this file in my VB Editor?
Sleeper: Creating E-mail in Outlook using VBA Excel
Converting x y values from a chart mousedown_event to cooridinates in side chart
State/county combo box
create hyperlink using macro
ODBC Connect Help
[SOLVED:] How to format workday end date with 17:00
Sleeper: SQL ROUND function work in VBA not VB6
[SOLVED:] not allow copy
Rename before moving a file
Is it possible to print pages based on time in a column
Vlookup multiple worksheets between two workbook
Solved: Treeview
Solved: open, save files
Refresh Worksheet
[SLEEPER:] SUMIF by year and also grade
Solved: Can vba code create and Activex CommandButton and set its properties
[SOLVED:] Read pdf scan
Bug in excel sheet
toolbar question
Solved: Need help with copying data from another workbook
Auto fit cell without using MACRO
Is there a way to shorten these codes?
Solved: AutoFilter question
Select a cell in sheet2 when I'm on sheet1?
Open file prompt then click cancel button
Separate text
Create Multiple Workbooks with multiple worksheets from master workbook
class module
Spreadsheet Control changing its size at runtime
Color text in textbox?
Solved: Transfer Variable Wbk to Wbk?
Use variable with Sheet Codenames
Solved: if & for statement
using MODI with Excel
Solved: Create shortcut
Solved: Loop through and Copy
Sending an email via Outlook from a non-default address
Data connection wizard / Microsoft query
Change Excel icon
Formula/Macro help need for pulling "words" from a cell
IF THEN Macro
[SLEEPER:] correct add method for ovlPointer
[SLEEPER:] Listbox item on click updates the same listbox
email & attachment word doc.
Solved: Charts and Legends
Solved: lookup previous row in a column
VB Userform with combobox help
Solved: Variable address backwards reading
ChartSpace not changing correctly
Creating a dynamic list of sheet names
Solved: Massive size of Excel file
Solved: UserForm ,Vlookup,Validation Combo To TextBox
hiding vba coding
Solved: Creating sub array from a range
Import CSV to Excel problem, paste only to 1 row
Solved: List Box in Excel VBA
[SOLVED:] Hide Rows Based on Cell Value (formula)
Insert form values.
Solved: Copy data from multiple files to a single worksheet
Solved: If/then help
Pivot table issue
Onkey method to call Label click event
[SOLVED:] If I input =3000/3 in cell A1, then the value in cell B1 is "/3"
Deleting a chart object in Powerpoint
Macro template in vba
Search and replace VBA help needed
Msg Boxes
Automatically play CD, open it's .xls file & save it in Excel default directory
can a userform be a child object of a chart
Updating macro to Excel 2010
VBA for Printing Sheets
Solved: separate text
VBA to update Database
VBA to open Web page and Enter Data in Text Box on webpage and click on Submit
Solved: Delete range based on cell value
Solved: Find & Replace Macro replacing outside of defined area
External Pivot Data
Solved: Return name of word doc in same folder as excel sheet
Macro that deletes a row based on multiple conditions
Count number of pages in a TIFF file
Reset different data validation cells
Solved: 2 separate Range value inputbox
[SOLVED:] List directory contents based on cell value
Feed Listbox from Combo box & List Boxes
Modify code to extract data from a text file
Pivot tables - VBA
Automating Date Change in a macro
Automating Date Change in a macro
External links (defined named) won't delete
Solved: List Separator
Quickly accessing a submenu item
Marco to Average, transpose, paste data into new work book
Excel 2007 gets crashed when trying to save a file.
[SOLVED:] Get Items in a ComboBox from MSAccess Data
Solved: Format csv Date to xls Date format problems
Archiving Files - Create New Folders and Archive
[SLEEPER:] Send mail cc open contacts
Select Dynamic Named Range
[SOLVED:] Call .exe file with input file
Solved: Help!My code is find one value not all
Solved: Find Last Comma
Solved: String Division by Index
[SLEEPER:] Portrait and landscape when printing same worksheet
Custom y axis on bar chart
VBA code for macro to create list from various worksheets
Search Date
combining two TOC macros
If?
Solved: HELP!!! Cannot get code to select cells based on specific text within cell.
trouble saving excel to tab delimited text file
Modify macro to import text
Command Button
Solved: set print area
Copy & Concatenate
sumif help please
Checking to see if XLS file is local
Solved: Formatting Edit
[SOLVED:] Sort Arrays ...
File name pick- Excel VBA
Solved: How do you obtain the CellColor value?
Solved: If Statement, need help
Open Workbook at Specific Sheet
Place cell content in Web form Text Box
Count the Rows
Extracting a users e-mail address
Open from the default browser
Populate Listbox error
Double save macro help
Copying value from different sheets
Solved: formula to split a cell
If 2D range, do this...
calling sub from module not work
User Defined Function Error
Activate a workbook
ChDrive without mapping
Messages from Excel
Solved: multi dim listbox used to populate cells?
Delete and move records between sheets
VBA code is needed to Do X every 1 hour
Solved: Counting items vs. UBound
Message box if no value.
Hide current cell indicator
Help protecting sensitive data
Extracting Data from a TXT/XML file
Hide worksheets - 2007
macro security levels for a particular macro
[SOLVED:] Page number in cell
Help with VBA that copies data & creates new file
chart properties in recording macro
VBA Copy Sheet with all Formatting
Add text in cell based on choice from drop down list
[SOLVED:] Pulling data from different columns based on specific data in one column
Sort by Date column
[SOLVED:] Rename embeded Button in a sheet
Copy filtered rows
Supply Windows Username and Password via VBA
[SOLVED:] Conditional Output Where Names are the Same
Debugging Userform
KillYourSelf.xls warning message problem
conditional number formats
User Form Drag & Drop
Calling Stored Proc Error
Random function VBA
[SLEEPER:] Delete unwanted Data
Macro to create and export multiple Pivot charts
Find All and Replace Offset Value
Formatting via code
[SOLVED:] Kink in AutoFilter
Sleeper: Copying a sheet from 2003 to 2007
Strange VBA Operation Outcome
Count Passes Thru Sub Routine
Solved: prevent msgbox display
[SOLVED:] Counting Occurrences by Date and Time
Group by categories VBA
RunningMax
link label (form control) to cell without using vba
Solved: Dynamic Ranges
If statement and Vlookup
Bypass code
[SLEEPER:] Delete cell range not whole row
"Find Next" and reverse concatenating
Define Names inactive worksheet
Search text
Solved: Do something only at opening of workbook
Solved: Hide and shove worksheet depending on if something is true
Return true to a cell if a range has been altered
Set a worksheet to be the worksheet in which a relative range currently is loated in
Solved: Run macro before a worksheet is shown
Import data from SQL
Solved: Scroll columns and rows
Rows count
Solved: Createobject("outlook.application") ACTVE-X Error....
AutoFilter
copy cell and add extra cells with additional info.
detect if other workbooks are open
macro shortcut runs on other workbook
Basic Vba help
2D Array of Arrays with User Defined Type
Solved: Put borders around selected range
Get PercentRank of a selected range?
Solved: Compile Error loop without do
[SOLVED:] CountIf with variable Range
The Fastest VBA?
[SLEEPER:] Code to Remove file password
Bat file to enable 2003 and disable 2007
Select Entire column of a cell
Solved: Right double-click listbox
excel can't complete this task with available resources.
copy web data help
Force tabbing through an multiple cell/matrix range
Loop through cells and delete matching
Record time and date
Solved: Triggering a sub with a change in a range
need help creating highlight macro based on range of values
Dynamically Pulling data from other workbooks in folders
highlight cells based on various criteria and the calculate the number of cells highl
Compare two workbooks sheet1 column A
QueryTable ... destination memory
Column compare
How to read read data in from the worksheet?
Edit code
Apply theme colors
Excel Find and Replace paste in multiple cells
Excel 2007 Comment Help
Sorting, even-odd
Can a command button pass variables to a program?
Understand code
Error on copy and paste to powerpoint
Need help to create an Excel Function
Solved: Selecting Noncontiguous Cells
Solved: Force lower case
Sum $ within a cell
Solved: conditions for multiplecomboboxes
Solved: Problem when Excel function RAND() is triggered by a macro