Excel Programming [Archive] - Page 39

Check if Workbook is shared
List of Pivot Tables and info
push button question
public functions using roundup
Searching Subfolders for .htm files
copy worksheet without opening the workbook
Passing parameters from clicking a button
MACRO TO DELETE ROW IF CELL VALUE IS ZERO
Files In A Subdirectory
specific number input, specific number output
Export sheet to C# DataTable
How do I run macros upon opening only if it is not the template?
List of Recent Files
Macro to open the text import wizard
Copy Filtered Data by selecting from a drop down list
Safety & incident reporting
Getting error:External table is not in the expected format.while u
How to control the Excel VBA Editor Main Window Caption
Macro needed
MATCH function, with variable lookup_array
Modifing example code
Advance Filter in Multiple sheets
Problem with Listboxes
WORD ART MESSAGE BY MACRO
What VBA will work when Excel opened in IE?
PLEASE HELP - HOW TO SPLIT AMOUNT BY MACRO
Identify Hyperlink Selection
How to make a particular cell alone as Read-only
number set input, specific number output
Macro insert rows depending on # in Column B
How to get row number?
activate sheet only using hyperlink
ShowDataForm not showing selected range
Re : Excel After-Life for an AutoFilter upon VisibleDropDown;=False
how do I calculate number of characters that will fit in a cell
Macros attached to WordArt
Finding specific excel files
trying to catch error 1004, don't work in 2nd loop...
Macro to Sort
unload Me compile error
Question on RDBMerge Add-in
Cell Coordinates and Printing
popup msgbox ok continue simple code
Add attachment to an already open Outlook email
How to programmatically access Number Format String in the Format
Searching through Subfolders
using Application.Run
Search by Font Colour
INFORMATION MESSAGE BY MACRO
Reset Custom Button on toolbar
Error 1004 - again
Oddity when opening templates from code
Opening a .csv file thru a macro
Array and not loseing trailing zero's 123.00
row totalling venture
OleDb Excel 12.0 bug
Insert image, get name of image
Excel Properties get lost
Set fs = Application.FileSearch
conditional formatting
VB code stalls when file is shared
Macro not updating labels? XL 2007
choosing a range dynamically
Circular Reference (Two problems)
Phone book formatting
Highlighting cells
macro updating imported data and pivot tables
Excel AVERAGE function
Can you trap the Delete event?
Opening Text Files Through Notebook
Importing text files into same workbook.
Linked Access Queries
Building a Macro for different size trend-Charts??
Maximum Memory Issue Excel 2003
Adding Procedures
Drag/drop from TreeView (not in ActionsPane) to Excel Worksheet ?
User Form
Text box behavior difference
Simple Macro
Re:Converting an Excel sheet to an XML file.
Finding variables in code
Close workbook
Blackened cells on pasting
Why would Excel react this way to this loop macro? Driving me crazy!
binding pivotchart with sql server in vb.net
VBC Code
Spell Check in excel
Sort Worksheets Alphabetically
Change Color of Caption in User form 2007
Using same Class in several projects
Option Base 1 in class module
Find and delete
Speed of direct link
Nice and easy - convert text to its numerical equivalent
Range.Find gets slow
Inputing information from one worksheet to another
Lastrow of a range
ActiveSheet test
Manipulating a combo box on a website
Rrefesh pivot table without ODBC
Return table fieldname on recordset
Problem with speed marco excel 2003 and excel 2007.
help with an array formula
weird behaviour from combo box
Why would Excel react this way to this process?
Global Variables
Different Font Sizes In The Same Cell
Creating a Ribbon in XL2003?
Deleting rows
Changing a file extension
update from file?
General ODBC Error
Reading columns and rows in selected range
array formula question
hide rows variable row length
Hide Rows Based on Cell Result
Cell doesn't change if another cell is Y, otherwise make it = a thirdcell
How to programmatically upgrade .XLD to .XLXS
Tab Name Error
Excel to Access
Cell by Cell Loop
MSQuery and NZ()
have a range of cells shade a certain color
Sort problem
Excel 2007 Forms show information
Problem with Logos as pictures
Variable workbook name references
sorting dynamically
Webbrowser and DocumentComplete
Switching between open workbooks
Importing Access Query in Excel 2007
Passing a variable to a GoTo
How do I lock a column in Excel once data is being exported?
Frustrated with my ignorance of the ribbon
selecting workbook
Deleting filtered data
VIA Excel - Composing a Lotus Notes email without sending
Minimise Workbook
Sheets.name
Creating Splash Screen in Excel 2004 MacIntosh
Finding a cell value and deleting the row with that value in it
Error with toggle code
Email files on C Drive
Writing Array To A Named Range
automate excel to login web pages
Re: listobject or listobjects sample code
Data Validation and Macros
Remove Module / Form
Replace old schema with new one in EXCEL file
An issue with "References" in VBA
format Text box in userform
oldest OS that microsoft supports
.net question
Need to generate a msgbox telling how large the file is
Displaying cell contents
The New Rich
Down button goes past bottom of combobox list to next object.
Copy worsheet from different files in to one file
Err.Raise X...anybody got a list of X's and what they are ?
Excel2000 procedure in Excel2007
simplify date input
Print row when cell in one column blank
Custom VBA Function to sort an array of values.
Need formula 1 x 2 1x x2
combine Myvalue with formula
How to Enable Redo Option
Excel programming - Conditional sorting
From where i can ask relating formula in excel
ExportAsFixedFormat printing issue
Can i save activeworkbook to binary data before save ?
Populating Cells with Zeroes
Column Headings Repeating
Close workbook
Number of objects in a collection
Exporting to a "specific workbook"
Creating a Hyperlink within a marco
complete blank cells
Macro for Retrieving data from closed workbook with date in title
HOW TO SELECT SPECIFIC CELL
Create New Sheets from Filtered List
Get current cell after OK on user form?
How to do when the Cell is in color jump to next cell?
Is there an Excel equivalent??
Dates Being displayed the wrong way around.
Select random cell from defined range
Re: Range concepts
Cursors and Mousepointer
PLEASE HELP - MACRO NEEDED
Extract matching data from large data file (csv)
how to show (excel export)webpage in our LAN?
Code to automatically sort a list, each time that a new entry isadded to the bottom of the list
Keeping getting a #Value error
test if a value is in a range of values
lookup help needed
Userform scrollbar nightmare!
Excel 2007 Recognize Formula
Retreive a variable
VeryHideWorksheet With a Macro? .... or even normal hide?
ComboBox
Decimal question in variable?
Move curser left one cell
Update numerous comboxes at once
MS EXCEL (NEED HELP)
Re: What's wrong with your website?
Hide menus etc in Excel 2007
User form combo box
sheet protecting
Working out the start day, for a particular month and year
summarize multiple worksheets using VBA
Re : Excel to Insert an AutoFilter (at will)
Excel VBA macro to encrypt a Workbook or Spreadsheet
Excel VBA macro to send email attachment from default email client
VBA:Populating Cells/List From External Data
A thanks to all help here
nse website query
Help on Visible Property
reset end of wksheet
using mouse click events in macros
Comparing lists in Excel/Visual Basic
Macro coding to perform Dynamic Correlation in Excel?
Hiding columns based on value
Save & Restore a column
Set ws
Navigate Windows
excel runs slow until closed and reopened
HOW TO SPLIT FIGURES BY MACRO
Huge Project and would love some tips
Copyingworksheets
VLOOKUP OR MATCH FORMULA
Catch error
Doubleclick event programming
=AVERAGE formula help
How to automate?
How do assign a name to a remote workbook ?
Need a reference
Function to show all values
Script out of range
how can I hide rows when a field is blank?
Setting Comment size on a cell
RE: What's wrong with your website?
Referring back to the originating workbook in a macro.
Copy A Named Range To a Different Sheet
Re: What's wrong with your website?
Difficulty with formula
macro to append ones files xls into one ?
MsgBox String Formatting Change
Combine multiple Excel documents into one
Spell Check Macro - Move to Cell
Script out of range
Sort List, Create Sheet for each unique item in column, move data
conditional formatting
triangle in cell
Looping through a Range in Excel
Looping through a Range In Excel
Bar Width
Determining which workbook(index) is the one closing
seperating excel windows
Scheduler
Duplication of variables in declarations area and procedure argume
ActiveX controls from 2007 not compatible in 2003
X Cell Problem
"On open” interferes with "On Change"
GENERATE ROUTE No's AUTOMATICALLY
Need to calculate future date based on standard duration and input
UserForm ComboBox RowSource linked to Column with duplicate values
Project - times to be implemented
PLEASE HELP - FORMULA NEEDED
command button to open a word document in excel
Saving XLS and GIF images to Sharepoint with Version history
Can anyone tell me If this can be done
Numbers that self-increment when the year rolls over
Determining who has an Excel file open
Where to start...
Help to modify code Please
Usedrange copy- paste : Blank rows filled in black color
Calculation Context available inside an Excel VBA function?
Delete Activecell if it is not numeric
FORMULA NEEDED
concatenate text and formatted cell
PasteSpecial problem
Mouse Pointer
Macros Stopped Working
Identify excel embedded charts in powerpoint
Enable Macros
Format cell and adjacent cell
ShapeRange.Name
Create a Macro to Range Cells, from the contents of another Cell.
HOW TO VLOOKUP BACKWORDS
Sharepoint - Update Workspace Copy
change the background's color for current cell
VBA - synchronize multiple pivottable pagefilter
Delete rows based on call value
Conditional Format / VLookup
Stock Add In for Mac Office 2004
Has anyone made a Deal or No Deal Gameboard?
can I color true or false results differently in excel
Application wait question
Assigning a Macro to Checkbox on a worksheet
2008 federal payroll withholding tax
Transitioning from Passive Error Flagging to Automatic Correction?
Hot to get line break in macro generated email
need help.
So close... now how to turn TEXT to a Cell Reference
Adding Combo Box Options Automatically and making it dependent
Protecting my vb code`
Textbox question
How to capture Delete key for Shapes on Excel Sheet
Fully fit each page to one page?
what does =EMBED("Forms.ComboBox.1","") mean?
Is it possible in a vlookup to pull formatting too? Like colors?
Excel vba
Check for #NA in VB?
Combobox-calculating issue
Remove borders in range
Formulas still breaking
Extract Uppercase Letters
dynamic formula
Text String to Date
Get Address of Current Cell
Automate Excel URL Web Query
Adding Custom Shape
i need a eqivalent for this posted function
How to handle open file errors in code?
Worksheet loop not replacing new text
Workbook_SheetChange won't run
Difficulty with RoundCorners property
Copy data from a changing spreadsheet to a constant spreadsheet
Format Axis labels: change 20,000,000 to 20 MM
Loop thru worksheets(i)
Worksheet_Change does it fire for a cell changed via foruma?
complex form programming request
Excel VBA and Sendkeys Office 2003 under XP vs Office 2007 under V
Removing text from Alphanumeric Values
Camera object problem
Cyclic copy
Variable row selection and printing
Copy range to closed workbook
Conditional Format overwrighting previous conditional format
Control Toolbox Check Mark Size
PLEASE HELP ! "SPLIT AMOUNT BY MACRO"
RE: pulling properties
Late binding issue with Outlook mail item from XL
Defining a Dyanmic Array in User Defined Type
Deleting specific rows with a specific criteria using inputbox
Programmatically refreshing a data source for a pivot table (olap)
How can I get my Excel macro to automatically send mail using Outl
Conditional + date calculation
Trapping the Escape key when a dropdown validation list is display
Different path
2003 - Copy sheet from closed 2007 file
Macro for cell colors?
XL Save As
Problem with Nothing command
i want to convert the Currency appering in Number to Characters
CONSOLIDATE DATA FROM MULTIPLE SHEETS IN ONE
Search for a string in another sheet
Q for Ivyleaf
UsedRange?? problem
SPLIT AMOUNT BY MACRO
Connecting Sheet 1 to Sheet 2
Another Question about Save As Dialog box
Mmcdaavsystems data analysis
Can "SendKeys" be blocked by an Application?
Adjusting rows versus columns for formulas
Cannot create object error in Excel 2003
Re: Select method of Range class failed
ListBox
Shade differences in excel file
ANIMATE
Code to show/hide sheet to asterisk the password
Looping through worksheets
error vsto application can't access connection string in app.confi
Re : Excel VBA and WorkSheetFunction (Match)
Is there a faster way to loop thru cells
Rolling up the latest date, criteria of range to compare highest d
Repost: Copy/Paste with format/style
12.0 Object Library Automatically inserted in 2003 VBA
Delete all labels on a line chart
Interpreting Correlation result
bulk transfer of comments using a range
Create delimited file
Multi-Page Objects Activate Page
Writing Excel formulas in macros - Help!!
Stamping current date when row data changes
How to sum hours in Excel Macro VBA
add labels to line chart
Evaluate cell in range and change cell attribute
volatile
Viewing/Editing/Error Checking KB shortcuts assigned to macros
Hyperlink Base
calling from one worksheet sheet to source from another
How to get preview or print landscape on a form
Custom Toolbar
Error opening Word document from Excel VBA code
Macro help
Golf Leage Help
automaticaly moving information
Need average of numbers that occur within range
forcing a textbox to update
multiple CHR() in VBA
VBA ERROR
Type Mismatch Error - Copying Data between Workbooks
VBA ERROR
Drawing Objects with vba and workbook/worksheet
Selecting Cells
Adding "fit to" into current print code
Cell link via macro?
VBA IF QUESTION
Use a string as a form control name?
Excel data connection
error &H80004005 in EXCEL
Changing the folder to a value stored in a variable instead of a s
Help using indirect to reference a defined range in another spread
adding colors, patterns, comments to large spreadsheets in bulk
Kill App macro is restarting app
Print rows of missing info
Invalid name error
Sort on C not A
VB code for joining column data.
generic checkbox click form event handler?
Printing an Excel 2003 page showed on Intranet as html.
Help with script. Join values in helper column and run routine.
Locking/Protecting/unlocking file at predetermined times
Vlookup value to the right.
Data problem
Macro
Excel VBA Int, Cint?
Error on windows xp with a macro created in excel 2000 and windows2000
Copy/Paste with format/style
microsoft.public.excel.programming PAGE problem
Why the number 12,345,678,987,654,321 is not displaying in Excel
delete columns based on information in another column
Adding Picture to Excel Spreadsheet Programatically - Using VB 6
[help]how to change embedded excel sheet 's view range?
Wizard Template with Data Tracking
Consolidating Data
Determine if Column Populated
Status Bar
Re : Excel Match and Tilde (~)
getting the named cell
How to Modify Worksheet Range when called by a UDF
reference frame caption associated with a checkbox
Find and Replace and Update Links issue
Weirdest Program Bug Ever ! Can anyone figure this out ??
How can I eneble to record Macro a draw cliparts?
Convert A1 notation to string without dollar signs
Importing XML in Excel
Can't disable macros in 2nd Excel instance
Accessing Excel files via ODBC
Excel ODBC Driver May Determine Wrong Data Type (Q141284)
trying to save off locations
opening a workbook with VBA
VBA IF FUNCTIONS WITH PRINT RANGE
creating, concatinating, cell addresses
Pass IE web address to Excel
value of 2 cells
Open file
Add to Combo Control from referenced worksheet object
setting up input box, and column row calls
Form Button vs Command Button
Blanks and Non blanks
RUN MACRO WHEN CELL IN COLUMN CHANGES VALUE
Commandbutton Caption
Type Mismatch Error in Excel VBA when looping through worksheets
Programmed pause
Referencing Worksheets
Calling Excel Cell Selector from an XLL
Select and Print only Text
Unable to Set Excel ScreenUpdating from ComboBox event
How to determine format?
Code to Create Input Box To Select a File
Error in Macro
VB Code - Saving excel workbook as a web page
loading an Office Theme through automation
Get column reference after string found
Check Characters and change as needed
A better Macro for Copying Data
Wrapping a XLL as if it were a DLL
non-linear step count loop syntax?
Select Case issue
VBA: Possible to colour seperate lines in a list box?
Step Through works but...
Three Letter List
Re-Post - Create Formula with VBA --- Help Needed Please
Copying and pasting macro
Highlighting a certain range of cells
Excel Macro Code Help
Save & Sort
Macro running within Macro
Open the Sort dialog box
Excel crashes when opening a template from VBA 2007
Msgbox not displaying
Files slow to open in Vista
Excel Camera Tool Leaks memory stops VBA
How to get Excel to grab data from browser?
copying random rows in excel to another sheet
Creating an unique list but applying 2 conditions...can it be done?
Percentage calculations
Help! On site and desperate - ADD-IN
Test whether a chartobject is on a worksheet
how to look up a value and return a picture in Excel?
how to count number of pages in worksheet
Excel change value
unable to add the Help for UDFs which will be displayed in Insert-
Multiple selection in Combo/List box
How to Compress Pictures using VBA
Bold text in MsgBox
Re: Image Loading
Delete Individual FormatCondition gives 1004 Error
Run macro with BeforeSave Event
Zero >= Zero?
Sorting more than 3 columns
Text to Columns formatting
Array Formula in VBA
Unable to delete file from Sharepoint Server Library using VBA (Ex
Calendar Control -> Switch to Sheet X
Text file out put
Is Excel Threadsafe
Combo Box Changes When Opening Workbook
Copying info from one workbook to another
RE: build a table that links each cell's information to a "word" templ
Data Problem
Need programming PROs help! Quiclk
Single quotes in OnAction property of a button
1D Array Sort
Linking Excel to FoxPro
Check for the Newest Available Library
Using Dir in multiple nested loops
UDF: How many Monday's in a date range?
Color Cells
Matching IDs with Names (VB)
Application.FileSearch Help
Workbook1 opens Workbook2 and runs Workbook2's macro
Disabling Cut Copy and Paste buttons in toolbar
Highlight and email
Passing Collection to function
minimum value excluding zero
Format cell plus adjoining cell
Count rows, post result in new book
SumProduct - Re Post
EXCEL 2007 Speed & Compatibility Mode
Create formula using VBA
Importing csv by code
Help to create calculation with code
2007 Add-ins and UDF's
Find exact text match
Pop Up Dialog box with options.
Formula is returning #VALUE! in excel cell
Simple code makes Excel 2007 crash
Window not active on Auto_Open
MultiPage Form
Formating a returned result.
Not getting hoped for result
how to show tooltip on own formula? Possible?
Not getting the result I was hoping for
Solver not working in Excel 2007
Finding a text value in a range
Excel VB Code
List Values to TextBox
AppActivate problem
break page
SumProduct
Decimal point
Re-Format from Text to Number & Consolidate multiple Workbooks
Using Conditional Formatting to write Text Value only if true
2003 to 2007 conversion. Unable to save workbook
Page Problem.
Help DLL calling in Excel 2007 crashes
Dynamic Combobox
workbooks close before
Sum a range in all workbooks in a folder
is it possible to show a decimal like 142.35" as 10'-
MouseUp Event Does Not Fire
How to Determine if in Draw Mode?
sht and wrkbook proc copy
Creating a loop
Compare Sheets values by .find loop?
Saveas Error (attempt 2)
Saveas error
Save as PDF
Command button
a Macro for importing & parsing text?
Classic Customer Invoices Filter problem
Running macro
Excel sheet generation using Primary interop assemblies
Pulling cell names from an associated cell
When open move active cell
Copy row from list and print
поиск одной ячейки в диапазоне ячеек
Linked excel field from access form field - help required.
Any way to Display Comments when doing a Save as Web Page?
enable macros without them running
Bizarre Excel 2007 crashes with Excel add-in
Workbook_BeforeClose
Excel / Outlook Express
Looping thorugh Listboxs to populate with name range
Hide Excel Ribbon 2007
#.000"''" to show as 0.125"
Moving timeline
copy the value of the activecell on sheet1 to the same address on sheet 2
Variable range and deleting empty rows
Using and if/then functions?? With a drop down menu?
Deleting Rows in Large Table
Combo Edit box
Warning Box
multiple address in the BCC filed of Outlook
inactive worksheet
Set print area
Capturing current Worksheet Name as a variable
VLOOKUP Question
Referring to Group name
copying from one worksheet to another
Textbox's return a number?
unselect selection
Automatically linking data from Word into Excel
How can remove a project from VBA project list
How to delete Connections from Excel
Prevent VBE from opening on errors?
naming multiple ranges
countif a number even if counted more than once in the same cell???
Excel 4.0 Macro - Save XLS in Excel 4.0 format?
Macro's, filtering, the result of the filter and copying that cell
dynamically reference the rows and columns as R78C15
Excel Macro Help
No dupes
Class Events not firing
"Macros are corrupted and have been deleted" message
File extension
VBA - A Problem with Dates.
trap overflow of an division in vba
A macro to copy content/sub-contents of outlines and groups in excel
deleting rows if they contain a value held in a separate list
Rename a group of files using an Excel spreadsheet
AdvancedFilter problem
unlocking cells
Pivot Table, Variable Inputs
Creating a Pivot Table with a named range
Automatic Date Stamping
Open document with Shell
Using code to replace code modules
Error in cell formula
combo box selection issue
Create range in udf
Raise alert
shell - open document
Copy and paste selected columns between Excel workbooks
Progress Bar
Cell Referencing in VBA
How to find maximum non-blank row number without brute force method?
Save Excel with a embeded PDF problem, can not open the PDF anymor
Divide entire column by 100
invoke web service from Excel 2003
Convert to/from Excel date
unique random number in excel
Get Locked Cell Value
Pivot Table Code - Simple Code Fix?
check box to indicate "no work required"
Help Using Ron De Bruin's RDB_Merge_Data Macro
Distributing an AddIn
Interaction and SendKeys
Urgent Need!!!!! MS Excel/VBA developer @ Columbus, GA
Automatically condense a field of data to eliminate blank lines
Show Specific Item in Specific Field
OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
Open document .xls/.pdf/.dwg/ and others
Exporting Excel to web with VB functions
Need Help - How do I stop using select
Write a function in a split cell.
Re: Insert Sum in blank Row
Re: Insert Sum in blank Row
Excel Macro Help
Data-Transpose Problem
MSN Stock Quote Add In VBA Declare and Call
which is better?
Excel Macro Help
Bar graph with pop-up box or hyper-link
Re: Format Time
How to make duplicated values unique according to a rule
RE: Using INDEX & MATCH in same formula
Re: Auto-Filter
Button in userform
RE: Format Time
Re: Using INDEX & MATCH in same formula
RE: macro to protect sheet
Vlookup for value
Re: macro to protect sheet
Text import wizard bug
color cells based on multi criteria
Error Help ClearContents
how to copy a cell multiple times and in many worksheets
Cutting pasting data to an existing template
Saving worksheet as a text file
Find and use Open Browser
Iterate rows, add like values - an easier way?
How to exclude unique values from a column?
Insert Blank Rows
Custom Addin Reference Crashes Excel
VBA - Finding the odd one out
VSTO - EXCEL - Data > Microsoft Offile Excel Data > XML > XML Sour
Copy and Paste to another sheet
relative columns
copy and paste
Look up data in an Access table using value in Excel column
Links to Files
Problem with this VBA Code and Network Printers (UNC Path)
Copying filtered cells from a specific location
Copy charts and remove links to original source data
VBA - Work out How Many Days are in a Month
copy and paste
copy and paste
open Excel file again and again
simple sumIfs question
Excel formulae to VBA functions
Which formula to use?
How to look at the values in 8 columns, pick the two that havenumbers, then compare to another pair of numbers
Input Dialogue Box
Identify Last Row
Windows Scheduled Tasks
Excel 2007 will not clear
Copy module o another project XP2003
Accessing the functions inside an add-in?
Application crashed on print
Sorting by Measures from Analysis Services cube source
workbook_BeforeClose
CreateObject("Word.Application") fails though Word session starts
Fading non selected numbers in a form
Macro Help
VBA Addin and range names
fill array from active cell
ListObject does not update DataSource when cell value changes
Number formatting in forms
How do I create a formula to tell if A2:A25 contains a negative va
Help with vb and conditional formatting
Relative navigation in macro
File Save in Excel 2003
Copy data from Excel to Outlook
Clearing radio buttons
Problem saving backup file with VBA
Help with multiple needs formula
NEED Formula
First and last rows
Macro to sort
Disable Multi Tab Select Functionality
Saving 500 sheets as .tpl extension, seperately!
Macro statement won't execute
Variable within a range?
Delete an outlook contact using an Excel macro
Right Click -> Export To Excel Is Exporting The Wrong Table?
If ActiveSheet.ListObjects = True ... Not Working
question regarding external data range
How to implement set difference between 2 ranges of values
limit cell input
How Can I.....
spellcheck a textbox on a protected worksheet
Merging excel info into a word table
Shape top position in Excel 2007
Arrays or sumifs
sumifs
Array of collection of match objects from RegExp
Finding the amount of days between two dates.
Return the contents of a cell at the intersection of row and colum
Can someone help me with this sumif formula
match, copy, paste, & color
VSTO - How to find all Pivot tables in the Workbook
VBA: How do I use IF formula with colours
Convert Employee Numbers to names in Excel
Hyperlink Issue
Applying conditinal formatting to sorted results
Finding Excel version using Excel 4.0 Macro.
Forms - PITA?!!! (Rant Alert!)
.PasteSpecial Paste:=xlPasteFormulas / protected cells
Compare & return missing values
copy and paste
Run time Error "1004":
Finding addends of an aggregate in a given set of values
call macro with variable
Formula in one sheet to find first occurrence of date in another
oh difficult...
referencing dao using vba
How do I suppress the "This webquery returned no data" message?
UDF limits
Unprotecting worksheet, using solver, and re-protecting
Realign Columns? Imossible?
AutoFilter fails
determining and existing charts data source
Instr
Autofilter Subtotal
Displaying a Zero where the formula result would be negative
Auto Filter Macro
Macro in Forms
Range("U" & j).Delete Shift:=xlShiftUp <--- Is not executing
Code to change graph scales
Using formulas along with Auto Filters
Problems execuiting a stored procedures in SQL Server 2005
Code to compare
Calling excel macro not located in that workbook.
Hide sheets
use VBA to create UDF to lookup value in a closed spreadsheet
How many rows fit a single page?
Identify User, Copy/Paste Login Info. to File on C:\
Change cell color
How To Deploy C# RTD Server Application
Need to split a cell into multiple rows
Must something be done to a userform?
important Excel to SQL server
Copy .CurrentRegion to a variable?
complex numbers
VBA Macro
Copy/Paste Problem
FormulaR1C1 Help
readall gives error for last file from getfolder().files
A way to link multiple workbooks to one
Weird behavior with Macro VB window in Excel 2003
How do I programmatically build a range?
cdate problem
#N/A Conditional format?
Can't find my VBA code
How do I do this?
How do I retrieve the contents of a Cell from different sheets?
Conditional formatting
Delete variable range when cell is emtpy
Calling C++ dll in Excel 2000 / 2002
Deactivaion of recalc on load
Macro to delete macro?
transpose
copy and paste
copying cells
Hyperlink
Capture autosave/autorecover event
Pick multiple items from list box
Retrieve data saved in pivot table
Programmatically create a label in a worksheet.
how to use if statement for range steps?
search buttons please help
How to find formula keywords for none English regional options
what this is error?
Hard return in textbox for header text
how to add VBA forms to VSS
Check for missing references on opening
Select method of Range class failed
Record numbers and get the output printed in words
Merging wordsheets in Excel 2007
Highlight Selected Excel file in Explorer
Re : Excel VBA with Run to Reset
Find and Delete a specified value IF found in cell in ANY Sheets in a WorkBook
if then else
Determining length of trend before significant retrace
creating filename
Mirroring an offset
RE: programming
More than three conditional formatting
Run time error '1004' using TextBox1.Text as SQL query criteria
RE: Error Trap not working
Requirements for graphical query results?
Printing Macro
how to copy/paste macro to a newly created file using vba
how to paste macro to a newly created file using vba
Excel User Defined function calling RTD
Socket programming with VBA
*Assistance with formula*
Excel VBA Disappearing WebBrowser in Multipage?
Save file close and reopen
Is this task a good candidate for XML?
Insert a Range
custom color palate
Internet - Take Advantage of Multiple Windows When Surfing
conditional formatting
How can I create custom controls on the ribbon in Excel 2007?
hide micros so you cant see password ? .
Discussions in Access
Data Connection Proliferation
Do until problem
SaveAs
How set print area & account for cell text length?
Macro to find specific row on database/worksheet
Adding FormatConditions in between other conditions
Change text for option buttons in message box
Cell to match page footer
save worksheet then email the saved worksheet
Tabbing through Cells when protected doesn't work
Conditional Formatting
excel function update if mysql databse is updated / an inserts hastaken place.
Multiple Ranges and Find/Replace
Best way to solicit input then run a macro?
Automatically saving a file
Cells or Range ? LostFocus
time userform 12:00 changes in 00:05
Userform sorting data
copy text from cells into different textboxes
Querying Team Foundation Server via a Macro
how 2 put check box, list box in a cell
Creating a directory from within Excel VBA
Copy and Paste
Please help me in Macros
Copy and Paste
Reliable Data Conversion,Data Formats and Data Entry Services by DataEntry India
Meaning of some VBA
Run Microsoft Query when Excel is invisible
Export Excel Workbook to a Website
code for Copying rows based on a value
Filter out duplicate data
redimensioning arrays in subroutines
Custom Menu in Excel 2007
shell; vba; does this thing work or not!
Change color of radio button caption if selected
Borders Error
PSERSONAL.XLS macro book
sumif problem
Help to create a macro
Required Field for 7 Numeric digits only
Button tips
print 2 worksheets from print button?
Changing External Data Location Link in MSQuery
Excel - Access Web Page
Pass between modules
Help with the report needed
Re-starting a project but avoiding recursion???
Slow Delete Blank Rows Macro
Cell fill color
EXCEL VBA - Find Method or Range in IE throwing error
"ComboBox1.ListIndex = 0" Doesn't seem to always work.
vba; copy row, paste at offset
Excel automation: Why my code is hijacked?
Data transfer, from template to main speadsheet
Identify User, Copy/Paste Login Info. to External File
Named Range in 2007
Pause Printing in VBA
Excel 2003 automated instead of Excel 2007
Moving Files and creating copies
Autoreference Code
Query with Excel VBA Find Method
Invoice Numbering
Calculate actual trunk utilization based on call start/duration
name selection
question about FindWindow API call
Ungrouping shapes
Help with Calender Day colour
function or format - remove decimal but retain value
Large Data Import (2548 columns/rows)
List
Automatically generated email from Excel
top 10 in Excel 2007--help now please!
Excel Hangs reliably when executing an UDF
Help
Hyperlink - custom view
Pull values from a closed workbook
top 10 analysis
Variable within a formula
top 10 subtotaling
How do I disable cell editing in vba?
changing background color
Books on programming
How do I select "Read Only"
Workbooks_beforeclose() function and out of disk space
hover over text
Formula Array Macro
Open Worksheet, Limit Users to Number of Rows & Columns
Copy data from one worksheet and paste into another worksheet
Compile Error: Can't find project or library
Suppress File Selection Dialog box
macro sort
Compair first 5 numbers
Open a sheet from other Excel file
Worksheet Delete method's dialog box
Copy linked cells content to an other workbook
create search macro based on if cells are merged, or have color in
Strange find and replace query
vba to send email attachment
file sharing
vlookup
Number Format
Interfacing Excel to a Web Browser?
NumberFormatInfo and Custom Numeric Format Strings
Search Companion
last row of a non-contiguous selection
Get the path of the .xls file
Move data based on data type
ChartObject.Copy *very* slow
adding daily totals to weekly totals
autofilter average values
Identify second line
XL2002: XY Chart and Image Position...
macro for serching syllable in a word
VBA problem after Excel update?
adding data to one olumn to another
adding arrays from multiple workbooks
Auto Group
Macro for IF formula
How set print area & account for length of text inside cells?
Outlook messages generated from Excel macro
Help on load the web link into Excel?
0x800a03ec - VB 2005 or VB 2008 & Excel 2007 (Range Text) (AddData
Finding, copying and pasting
AutoFilter Blue Arrow
Excel 2003 #NAME? Error for Swedish Regional option
Printing workbook sheets in sequence
Get macros in Excel to show up as text always on the toolbar?
ActiveCell.FormulaR1C1
Adding Data totals
Adding Data totals