Excel Programming [Archive] - Page 63

importing files from our mainframe into EXCEL
Find matching tab names between different workbooks
Disable Customize dialog box
print no shading on selected sheets
How can I stop date formatting?
Cannot remove custom commands from 2007 add-ins tab
Help with my macro for two autofilters
Copying and Pasting
Renaming a tab to a date from a cell value (Tom Ogilvy code)
novice working with a spredsheet
conflict between validation list and export data from access
Code exucution stopping spontaneously
Mocro trouble - Sum if and check for formula
Using a TextBox value in a file String
How to pass cell reference to VBA function?
highlight punction marks in active cell
Macro to Copy Mulitple Worksheets to New Multiple Workbooks
How to retrieve from Excel/VBA the SharePoint (v. 2003) user's ID when he/she is connected to a list
E-Mailing Code Error
Paste special
Check if a sheet exists in a file, without opening that file
Selected sheet within a Private Sub
Getting Excel to not plot emty cells
lock cells
Date format
sample macro for printing by selection
Copy sheet problem
RANGE DATE CODE
Stopping calculation on workbook open
Interrogating Data on Hidden Sheets
Labels and Captions
Syntax- drop down menu contents wanted
Macro to Hide Row based on Value and then change Checkbox value
Cycling Through Pivot Field
Retrieve data from external excel document
On Time Function when Logged Off
Using Transpose from within VBA with >256 array
_xlfn.SUMIFS name?
List Box Row Source
programming in excel
Printing a number of pages with them numbered
Referencing output on a drop down field from two columns
Required Selection to save or print
Using the AUTOFILL Function
open workbook, display certain sheets
click an internet pop-up "OK" button
Filter on multiple criteria, same cell
Capture request/response HTTP headers with VBA
Worksheet-specific event handling needed
Run a macro on multiple files in folder
VBA Not Running in Exported Pivot Table
Need Help
How to Install Older Object Library
Autofill Macro
Translate in English please...
Multiple Worksheets - Protection
Goal Seek
Can anyone help?
Listbox - Width
cell referencing with variables
Query Refresh - Turning it off completely
Get Control Before AND After Printing
Query Refresh
How to get the value of a meged cell
VB code to check number in Rectangle box
Is filepath valid?
Copy selected mulitple worksheets to mulitple new workbooks
can't modify field
read next two cells over using Large function
Can we make Excel close itself without asking anything?
How can I check to see if I can see a server or shared drive?
textbox array
RE: Is filepath valid?
browsing between worksheets ?
Preventing macros in attachment
Number Stored as Text.
When does the Access query run at worksheet open?
annotation
How to pass arrays of integers or doubles to VBA function in Excel
RE: read next two cells over using Large function
RE: Get Control Before AND After Printing
RE: Copy selected mulitple worksheets to mulitple new workbooks
Require second qualifier in attached code
How do I make a set of invoices from a list?
Anyone have ideas on the Public Variant problem I posted about 5 or 8 posts ago
How to catch the event when an Excel window gets focus?
SUMIF from another workbook
textbox formatting programmatically
Turning pages into PDF
Open a form from Tool bar
Public Variant problem
Looping thru TextBoxes
Copy/Paste problem
Evaluate("1")
Event not shown for an ActiveX control
Concatenating Numbers & Text to create a String
Remove Macro Message
Keyboard vs Mouse
CTRL+R Fill Right
Finding an occurence
Simple problem, must be too early...
SendKeys variable
Save Button in Excel
Page Break Location
Linking Excel Charts to PowerPoint (Office 2003)
need help on how to grey out one option button in one group box based on the selection of another option button in another group box
Sheet Tabs
Subscript out of range error
Retrieving Excel data
Userform Queryclose and Unload problem
se e somente se
How can I select non visible cells?
Graphs with entries in multiple column and dates
Storing important values: ini file, XML, Registry, where else ?
Problem with FollowHyperlink and Firefox
Set selection of Pivot Table using VBA
How to specify a range?
Run time error 1004 - cannot insert object
help me out
How to find cell with specific format?
SaveAs filename PDF
ADO SQL syntax query, using a variable
Sheet1 Data Autometically Uploaded in Sheet2
Import Data from 2 Workbooks in the same folder
Creteria Help
names and deleting them
Proper Name Totals
change the fore color
pagesetup object
Prompting user to answer a question before saving and closing wkbo
how to unhide a multiple sheets trigger by a checkbox
Help with Excel Array?
PLEASE HELP ~ want to have users enter date only once --
How to get "/automation" when automating?
option button (Form)
.Avi video's and Excel
Link Cell with Comments
Mysterious auto_open
ListBox3.ListIndex = ListBox3.ListCount -- How to select the last item in a Listbox?
deleting an entire row if the cell in col A is empty
Delete Temporary Internet Files with VBA
Problem linking assembly to existing Excel file
Help with My Macros Program
Go to cell based on formula result
sorting on a non active sheet
Programming my macro
Parameters of SUMIF in VBA
excel macro
VBA to copy a template worksheet to new excel workbook
Adding empty row with code
Macro to Autofill until there's a new value
Creating a list from previously selected list
Validation List Width
VBA can't find file as it moves from folder to folder
Search multiple workbooks in file for data
automatically installing mscal.ocx
Importing data from website directory
using MailEnvelope
Unable to modify cells in a VBA function
form appears on second monitor
VLookup OR If Function?
Why this error and how to solve it ??
Format cell based on function result
Import images into excel cell from database
Can I link to a print command from a cell?
Can't select worksheet
Select C6 down to last used cell, as determined in column B
TextToColumns 2000 and 2003 differences?
Call the edit-links dialog box
convert Excel data to Access
how do I prevent access to certain cells?
Copy sheet problem in Excel 2007
Change event and ranges
Executing Macro when Workbook is Open
Clear Named Ranges
comparing lists in 2 workbooks and de-duplicating
Inserting comment in unlocked cell in protected sheet
Open File in Folder
How can I delete rows programmatically based on certain criteria?
Relative reference in VB with If Then
How to deleted duplicate record on columnA
Runtime Error 5281
Help seperate Arrays
dot net excel error
InputBox Question
select all sheets?
How do I write a looping in VBA in Excel?
Add-In File Size Growing Inexplicably
disable cut and paste
Links Box
Admin password to Individual protected worksheets by users
Data Validation type query
Selecting the Last row
What of these is the correct syntax to refer to Properties?
Find item in list, return a value
Sorting data over multiple sheets into array
Calculate Sheet Option
Update option button from c#
Calendar
button that controls macros?
find identical record in one sheet
Checkbox - Change color of label when clicked
Help - Nested IF
List Separator
VBA Extensibility library and dynamic code compilation
Cursor
Comparing two lists and removing duplicatations
txt tab-delimited to CSV
Recordset from excel worksheet
On error GoTo Question
Save all files opened
copy last row with formulas and paste into next row same sheet
Filter sub
When I hit return in a multiline text box, focus goes to next text
how to copy / paste in userform multiline text box
Selecting the correct range
Checking cells contain a value
dialogs
dialogs
Help with syntax
Highlight a cell if it changes as a result of formula recalculatio
Uploading in Internet
Closing Print Preview in Excel Macro
How to paste a date to the last blank cell?
Merged cells .Offset(row,Col) inconsistancies
Extract Country/Region of email sender from outlook message
If then to hide a combo box
Adding Custom property
userform error 1004 select method of range class failed
adjusting a macro that retreives access data
Offset,Match,Copy, Paste Special - A Complicated Task - Help Pleas
merge columns
Connecting to SQL Server table
Record macro to name multiple ranges
Opening "locked" application
VBA: AdvancedFilter - Unique Copy of column of names doesn't work?!
filter results to userform-sheet
Problem with Combobox.Dropdown method
Using a Macro to Copy and move data! - HELP!
VSTO Excel AddIn Question
How to copy the new Excel 2007 conditional formats
I'd like to put multiple rows in one CSV row
VBA Replace using wildcard?
Calendar popup
moving to specific cells based on the value entered
RefreshAll in a shared workbook
Using a drop down list to trigger filtering on another worksheet.
referencing the activecell
add ref to Microsoft HTML Object Library
Searching rows
How to make a cell appear in upper left (top left) corner of works
Find Text in Excel File
Need help comparing 6 of 10 numbers
How do I cut a portion of text out of a cell?
Excel - Condition statements
Additional controls to Toolbox
Running Totals in a particular cell
need previous row help
Add Ins check
General Cell to Custom Date
Connecting excel to the weblink
Environ("username")
VB Circular Calculation
Data Validation - Multiple selection.
Change single click to double click
Selection.width / .height / .left / .top from cell refor userform
Check if a workbook is open on a network.
counting data from an Access database
Worksheets, comboboxes, and integer values
expanding subtotals
now that i got the posting to work
How to select the last row before the page break on an Excel sheet
what's wrong with my friend ?
*** Need urgent help!
LastCell
Excel formula to add then subtract
Find/Replace Unshown Apostrophe
Help with a file?
Macro for recording current time into other cell
Macro to compile totals of values on multiple worksheets
update league standings based on results entered
Forcing to paste on a specific row
how to select current sheet tab
Store values in Combo Box
Create a Text file from Excel
Oggetto: Automatic Borders On Breakpage
slow macro
Compare blocks of cells
more than 7 nested if (revised)
Listing all UDFs, Classes, methods etc..
Sorting question-is this possible
Slow code needs speeding up!....any ideas??....
increase your sperm volume naturally
sorting data
more than 7 nested if
more than 7 nested if
Conditionally load picture woes
Excel comparison of two sheets
Desktop icon name
"File Not Found" dialog box
i need help
2007 EC Excel / Access User Conference
how to change the workbook name in a macro when the name us changed
How to move a graph when I scroll down?
Excel VBA PivotItems Problem
Move to a specific cell when closing worksheet
Working with a .exe file
Moving data from column A to Columns B,C,D,E
RE: Moving data from column A to Columns B,C,D,E
String in text box
Autofilter Criteria From a TextBox
Transfer clipboard from Task pane clipboard(office?) content to Excel (windows?) clipboard?
VBA password
Import XML into Excel just get first line (=file)
Map this!
How to write If proedure
Closing a Cell When Excel goes Inactive
Data on UserForm to different sheet based on day of week chosen?
How to find No of sheets ,sheet no
Sorting - VBA
Couple of basic questions from a beginner:
replace a formula by a value but further +/- is still need calculate
Workbooks.Open
Date posting issue from Form
After Copy and Paste, Add to an Existing Named Range
Inserting a Blank Row Upon Save
Changing appearance of RefEdit control
Method Range of Object Global Failed
a comment box that only displays when the cell is actually selected
move to next row
getting the filter items
Automating grouping of Excel pivot field
If statement not working
MergeCell performance
Getpivottable function
Read-Only
Before_Save IS KILLING ME
Multipage Tab's
IEnumPrivacyRecords Next Method
Excel VBA cut and paste bug?
Can't delete named ranges?
Error Message - accessing an Access database
SQL: custom names of columns when using IIF (excel quering access database)
trigering macro
Need help with BeforeSave event
Consolidate text
Programatically set up footer
Help: Multiple Checkboxes (, naming and visibility)
Extended DataValidation Dropdown Listbox - Object Creation/Inherit
MS database query: Statement CASE WHEN THEN ELSE END
Prevent Single Worksheet from Printing
execute a .exe file and type a text string by vba on it
Excel Macro for match name
Opening an already existant Word document with an Excel Macro
UpdateLink error
Problem with Document Properties
Add name problem
If <> equal to named list require user to fill out desired columns?
Determining the size of an input array
Concatenate & Write to Text File
Can I use VBA to change name and controlsource
The Excel 2007 Office Convert function sometimes gives me blue scr
Using offset following an autofilter
new user needs help with programing
delete userforms in vba
Resetting cells with 0 to empty cells
'Range' set by userform
More users working in the same excel at the same time?
be able to access worksheet while form is running
Case Event
workbook event
Workbook event
Disable commands for one workbook
Stop error code from executing
Duplicate row source of combobox (code pls.)
Date
excel 2007 Save As?
limit on number of worksheets
Programming Office 2007 and compatibility with old office
Track changes by row in different worksheet - History tracking
How do I convert an Excel 2003 VB Project to 2007?
Make one excel sheet from multiple text files
Make one excel sheet from multiple text files
Looping Through Every Instance of Excel
VBA Help with Make Visible Rows
Macro to create a shortcut to make next Worksheet visible
Retrieving querytable parameter values and locations
sortTable works in 2003 but not in 2007
Range Name with VBA Exciting :) or Nightmare :(
Excel Sheet Validation
leading zeros NEEDED during imports
What gives... Application.Interactive = false
Select reference via code
Data-Validation-List-Width of list must be > colomn width, is this possible
USing SQL in Excel using VBE
Mscomm1 buffer problem
DELETING ROW
SELECT Query
Counter for user clicks
List FileName
record all links durng navigation using VBA
record all links durng navigation using VBA
VBA macro speed
Using Checkbox Values
IFT
Import Calendar from Excel
Variable type Confusion
Date problem in a SELECT sql statement
possible to do a vlookup using colorindex?
Hide Columns based on checkbox values
Hotkey that finds a character, then positions cursor on it?
How to reject user operation on the application I created
Selecting Cells on two worksheets
Adding macro code to a new worksheet
Double click event on Cell
Triggering a macro to run by changing a radio button
Undo a change in a userform
Nested " " "
WebBrowser
Combo box change
Range through Inputbox
Can VBA issue a command to eject a CD?
Execution very slow
Range Name Conflict ON OPEN
Make onTimer wait until Excel finish database request?
Code Execution Has Been Interrupted?
adding data to existing data and replacing old one in excel?
Why not working? Array Problem.
how to auto generate an excel format file contains formula using C
Trying to Understand Worksheet_Change Event
Copy function
Random number from range
export sheet data for batch script
Drag & Drop Form Elements
copy multiple columns
Lookup Data on a Worksheet
ADO limitation to number of excel 2007 columns??
How can alert icons be displayed?
syntax question
Why Evaluate?
Autofill Merged Cells
How do I have the result of a formula display in a blank cell
filtering out some data
unlock range of cells
Clear corresponding cells in other worksheet
Clear corresponding cells in other worksheet
Run time error 35788
Looping while msgbox is active
Comparing two ranges on different sheets and copy matching results to new worksheet
Creating Workbook Sheets from Dropdown Menu
ControlSource and Localization Issue?? (run-time error '380' Could not set the ControlSource property)
browsing worksheets between different workbooks
automatic recovery info
Trick to Keep Conditional Format Colours?
Save Data
How to select the bottom right cel in a 'CurrentRegion.selecion'
how to get around the Enable Macro security message?
Is there a max height for the user form in Excel
Conceptual question on .Value and .Formula properties
Excel Find/Replace OR AutoCorrect...
Need to perform action on range
Filtering and removing rows
Import Cell Values From An Unopen XLS File
Finding max and min across multiple sheets
Macro for Graph - problem with Range
Check month
Select a list, then sort
Goto specific sheet and cell
Setfocus Problem
How do I setup Excel to connect to a server via TCP/IP?
put data in to another workbook
excel error when closing workbook
Misplacement of objects on a sheet
How can this be?
Advanced Filter with Union of Ranges
Userform Terminate
Userforms Values to Workbook Cells
Conditional Unloading of a Userform (I've got in a right pickle)
Text Lookup on MUltiple Sheets
Adding "additional" controls programatically
Deleting all data in a Worksheet
How to pass value from one cell to another
convert long list into shorter list
Macro path follows the "SaveAs" file
need a robust transpose(array) function
repeat macro through cell until first blank
URGENT: Office Add-Ins not showing in AddProject Dialog!
RE: need a robust transpose(array) function
RE: repeat macro through cell until first blank
Case Select
Creating a button
Trigger Excel Solver by User Defined Function
macro to change series xvalues in chart
SaveAs
inserting pictures in Excel 2007 different than in Excel 2003
Function Needed
RE: repeat macro through cell until first blank
RE: Creating a button
Why I can't see Excel VSTO in "Add Project" box of VS 2005?
Copying Data from a row above...
RE: need a robust transpose(array) function
Conditional format
Excel 97 fails to execute Workbook_Open() on New XLS from Template (FYI)
problems with excel web queries
Creating a Pop-up Summary Box with Data
Querying an Excel File with a changing file name
password protect the button in Excel?
Excel sort column with indirectly referenced dymanic worksheet
Copy value
Trying to close a window without saving
Import decimal numbers with trailing zeros into Excel
Please help with code.....
Prompt user to select directory
Command Button
user input "Rows to Repeat"
Data Validation
random not truely random.
Userform hack minimize maximize
Declaring Array
Get rid of security warning
Loop through found value
VBA Range Addressing in For Loop
ActiveCell.Row & Column intersect
How to specify save PATH in macro?
RTD Server While Running A Macro
wb.savecopyas results in read only copy
Excel 2007 labels in formulas no longer supported!
Publish an Excel 2003 Chart to HTML file
recognizing double digit numbers in strings
changing date formatted as general number into date format
Online Survey Tools
Sorting macro on dynamic column of different sheets
Excel 2007 vs. Excel 2003
Using File System Object to retrieve paths filenames and dates
Simulating VLookUp in Macro
Using symbolic in Excel Macro
On Open Message
Run an Access Query from Excel VBA with Parameters
Fill ComboBox with unique items
Logging time in Excel
Nested "If formula" - returns zero when reference cell is empty
Copy marked records from Workbook to Workbook
Removing the data tracking add-in link
Print Multi-Page Word Object in Excel
IE Internet Options change via excel vba
Adding one to the current value in a cell
Command Bar - make it go away when you change sheets
Spinner
Print / Write to text file and usage of buttons
Printing Excel from an ASP page
Web resources for use of SpecialCells and Intersect
array function for multidimensional arrays
Please help: C# COM Plug-in not releasing Excel properly when embedded
OPen different files in a loop
Relative Refs
Sort order of a collection
RE: Select a word in an cell
Insert new row with formula using ShowDataForm
Need help please for deleting rows that does not meet several criteria
Pivot Table - got what i need it to do but cant add simple calculations!
Newbie questions
date and time calculations
Text Box - Control Source
Issue with Excel Macro
¥u**·s¦~..¥þ·s PSP $998,PS3, Wii.¤½»ù7§é
Find value from sheet 1 on sheet 2 and copy to an offset from there
Excel DDE freeze my computer.
date function
url not accessible
how to find root in Excel/VBA?
Manipulating data from a portal (web)
help pls.........
how to add a password to the VBA code?
How to format with a strikethrough like something's been crossed out
Using a time Variant with OnTime
Problem with Range and Occurrences
Images
Importing from Outlook - how to remove the alert.
Range / VBA
Saving Files
selection command, problem with column index
Loop learning
Hiding 2007 title bar
SET RANGE WITH 2 COLUMN
Running code on Excel Startup.
change from message box to result in cell
set range with 2 column
Saving an Excel File from Access Automation...
Problem using an object inside another object..
adding a form to a VBA project
Run-time error '1004' at "Application.Calculate"
Adding Rabges without for each loops
another question about find
Lookup / Loop / Help Requested
Copying Graphs
Lookup / Loop / Optimization Help Requested
Sheet names
CalculatedFields.add function not working when refreshed...
EZ - Pull data from another workbook
XL 2003 VBA form Listbox-limitation in max number of columns
Conditional Format Query
'Application.ScreenUpdating = False' isn't working
Macro to filter 3 columns and then copy data then do the same again........
Prevent Reviewing CommandBar from showing?
Macro to Pull data from multiple excel sheets
Write Data to a closed workbook
Workbook_BeforeSave Does Not Trigger
Web based spread sheet access
Automatic Refresh Question
Formula.array in excel macros
Dump macro result into cell
Tough One! Trying to pull data out of columns seperated by commas.
How do I share VBA code in multiple workbooks?
Apply Auto Filter on One Column
How to copy an XL2007 conditional format from one range to another?
Type mismatch error'13'
Excel 2007 and cdo 1.2.1?
Finding Duplicate records
SQL in VBA to Access a Database and create Report
Calculating Sales price by Entering Gross Profit
Disable Delete Row
Cell format change mess
Protect sheets before close
Scroll Limit
need to update price increases on multiple sheets
How do I cycle through buttons in a FOR loop?
Referring to a named range
Copy and insert name on tab
add-ins not loading
Uh Oh... :-(
find and display a picture
Using ODBC & ADO in manipulating data from worksheet. HELP! plssss
Immediate window gives different results to a UDF
IDENTIFY CELLS WHERE FORMULA WAS OVER-RIDDEN
Apply CommentBox to objects?
combolist array.
Assign macro to WB-specific toolbar button?
Stopwatch from Excel
SORT COLOR CELLS INEXCEL
find excel files with vba modules
Retrieving Data from Sheet1 into Sheet2
How to use Excel faceids in a Word document
VBA Query
Excel & VBA & SQL - Bob Phillips please
printing multiple dates automatically
Re: Duplicate value are removed, but how can i display in tx8 the amount of duplicates there are ?
Moving from Excel 2003 to Excel 2000
??? Why Combobox font size shrinks with each click
how to format code in VBA?
set scale in an excel chart
Do I need to use VBA for the following control structure?
the Add-Inn working in Office XP environment but in Office 2000
Re: Select a word in an cell
Re: stop macro if no SQL connection found
Compare sheet1 with Sheet2
Skip other codes if value is Zero
Report with macro losing links to a particular worksheet after running macro
Find value in hidden cell
referring to selection from multi-select userform
Simple radio button form help
Embed Image in Add-In
date range lookup
How do I import a .dat file into excel using VB scripting?
Chart Position in VB6
retrieving cell value from a query linked workbook
range search
tab rows
Page Setup
Solver - macro combination
Change code by code. Can you do that?
Copy Data from Website
Attached templates become spreadsheets
Extracting Rows of Information Based on Value of One Column
Retrieving the last cell in a column and using this row number in a counter
Speed issue with Multilple Web Queries
Countif using a named range
Hi Guys..!! Welcome to online community.
Delete All Columns Except
Select 1st cell of specified sheet in before close event
Macro to call database table needs to process faster
Autofilter based on user input?
Create pause in Marco
Function arguments without quotation marks
Function arguments without quotation marks
numeric format
Accessing Excel 2007 Userforms from Macros
event fire
Userforms in a separate worksheet
query table indexing - HELP!
Transporting Variable from macro to spreadsheet
Font Color to match other cell
Code won't Run when getting Workbook name
copying same data to several Workbooks
Addin Install
Moving a file within a macro
Issues with Time being converted to Date/Time format
Selecting Specific Sheets
Using getItemImage for a Gallery
Digital Signature
Parameters of a printer
Colored Cell
How do I send an e-mail in Outlook triggered by results in Excel?
Save with dates
Return the Date of a certain Day Each Month
Forms and screens
FileCopy Error 52
Need to dynamically choose Ranges of non-empty objects
loop with do while
Finding row number at the bottom of a block of data
Syntax Error
Easy loop
Adding Multiple Hyperlinks to Excel
Erotic video with Jessica Alba
Mp3 music online
Free TRAMADOL !!!!!
Hey bro, found this site
Problem with Type in a class module...
simple question on autofilter
loop to check cells for numbers between 2 number range
Copy excel table to Word, loss information in memory
Select Data from SQL Server
SaveAs
formatting a macro
Formula fails to read name
Disable Conditional Formatting After Page Break
Name Ranges Acting Up
Conditional Formating...
Conditional Formating...
Dates related cells
sum value then insert new row
Accessing the underlying OLE data
dynamic validation
Modify ClearContents
Reference combo box in after update sub.
Convert tabs to spaces
Can you use SQL to query Excel tables?
Autofilter cut and paste
Maintain view of a sheet while macro runs
Verify Accounts
Rogue name
DSN THROUGH ODBC
Tough questions
RE: Rogue name
Counting number of rows with Cond. Formatting to avoid save problem (KB 215783)
Macro to Create Workbooks & Worksheets
Sheet Printing order
Select Case question
Function in class module cannot be assigned an array?
Copy Selected Text from Text Box
Hide or show data labels depending on value?
VBA Code...
POP UP asks values for different cells
USE SQL IN MANIPULATING DATA IN EXCEL
Lost my Command Menus - Please Help
unique error 400 only if internet not accessible
Disable "Hyperlink" menu item
Excel / MHTML issue - urgent! Help!
File Search
ControlFormat Problem
Date picker control
Button not working
Multiple Filter Criteria in Excel VBA
lost .xla
Re-Naming a column
finding AddIns folder
AddIns
File directory
Add-In Install
Validation lists
If / Then based off conditional format
CLosing Linked datatable
GetSaveAsFile
vba using the OR operator
Need help with IF statement
Popup Menus Help Please
A problem when trying to run a dll from Excel / VBA
RecordCount not working
Loop Question
RE: Code for Returning to Last Active Worksheet Please
Save/Print PDF on Mac
how to return to an OLE workbook when ActiveWorkbook is Nothing
xlusrgal.xls in excel 2007
Compare aumont and insert "Balanced"...
Auto Open
Looking for excel spreadsheet to support balance sheet balances
Combobox
Fill Cells with Red
Add values of cell H1000 in every sheet.
Help: is it possible to launch acommand prompt shell and have commands piped into it?
SAVING DATA
SaveCopyAs corrupts pivot tables
Sumproduct - visible cells
Refer to cell in diff sheet
Format text as bold/italics/underline PROGRAMMATICALLY/formula???
Counting mixed chains of numbers and letters
Delete Rows help?
How to Sum
Filter using a Text Box??
Is it possible with VBA or otherwise to disable the ctrl-scroll zooming in excel?
bi-directional dropdown boxes
Excel copy after question
LCase function gives an error
Automatic sorting
Subrouines and graphics in VBA
formula for extracting uniques using 2 columns
Sorting numbers as text
What am I doing wrong here
Evaluating names range from two different workbooks.
Getafile from Cellref Path
Stored Procedures & Connection Issue
CSV
RE: Code for Returning to Last Active Worksheet Please
External Excel Macros
Pivot Table
Trouble with code
Excel range coding in DLL
Emailing Cell contents in EXCEl using VB
Setting number format by multiplication - possible bug?
Capturing Time
Question on conditional formatting & email macro
Pasting custom formula
How can I make Excel read a value from a textfile and assign it to a variable in my VBA code??
Did you know that...
Copy used range
HRESULT: 0x800A03EC
Adding a space?
input box question/help
Globally update button properties?
Macro For If Function
exporting graph to power point slide
Find values in a closed excel workbook.
Digital Signatures in Excel
Cycle thru Graphs
Deleting value in TextBox with SpinButton attached
Where does excel store your personal settings..?
Protect WorkSheet using VC++
AutoFill Help Please
VBA 6.0 GetOpenFilename
Add the $.00 pennies if no value is present after the whole number?
Converting Excel worksheet to PDF then print
want to list only rows with highest value of duplicates from a column
Attempting to copy/paste data from one worksheet to another (same info but diff layout) based on date criteria
How to delete rows of referenced cells...
What does this one line code mean?
Excel VBA Data Grid - Changing Column Width
Runtime error 380 - Could not set the list property. Invalid property value.
Creating a named range in a workbook using VBA
Open MS Access Database and running it's maco from Excel
popup message
Linking spreadsheets
Identify unused macros
fractions in forms & cells (not DATES & Decimals)
linking excel spreadsheet to streaming realtime quotes at options express
Excel VBA ---Text File counting
Convert a number upto 100 to binary
Nothing happens with range("B2").Goalseek _...
Help with creating a VBA in Excel .
Auto Email
Saving a file with time and date at a set time period
Call VBA procedure ilocated in another workbook
Copy Comments problem
Launch external application
Appending Hyperlink to existing text at certain start row
use F keys
Autofill cells in 1 column :code ??
Referencing cells safely
Individual Action Item Worksheet Creation
Column Help
Code does not work
Date Validation
mousedown event on transparent label problem
Programming for column shift
Exception from HRESULT: 0x800A03EC while binding values to a range
Button Sort Macro Not Working
schema.ini file
I Get subscript out of range when tying to access worksheet
Sort by Group Header or by Group SubHeader
Need help with Debug
Transferring Captions/Text between UserForms
open & close event
Pages setting
Message Box
Re: dynamic sum
Want to disable scrollbar in split pane.
macros disabled
How to Combo Box Calendar
Trying to get better with Arrays...
Managing links to Summary from constantly changing worksheet names
paste from clipboard after delete cells
Serial No
MSN Money Stock Quotes addin
Copy from Excel 2003 status bar
Determining which "mode" excel is in
Workbook_Activate not triggered by Alt+Tab
InStrRev issue
Custom Data Validation
Intellisense disappears after a couple of seconds
add column
hidden columns
Looping to insert photo
WATCH WINDOW
Opening a Excel file to a Specified Worksheet
2007 EC Excel / Access User Conference
Pivot table auto field selection
Do until loop with use of another macro in loop
Assistance with VB Coding in excel required for Telnet and FTP functionality
Simple User Form to hold only text
Excel VBA -> COM
Undelivered Outlook Messages
Remove XLA as a reference in VBA
Displaying Values from 2 cells in another cell
Reading Excel file into datagrid asp.net
copy rows to sheet 2
Change Number to Arabic and back
Table lookup
Save as mhtml loses custom document properties.
Excel 2003 stopped by compatibility Pack
exporting data from Excel to MYSQL database
VB Code to search,copy,paste and stop at blank row!
Sharing VBA Add-in reference with more than one other Add-in
Save As MHTML loses custom document properties.
case sensitivity check for List values
exclude from print area
form inside a loop
macro to print workbook
XMLMap and Schema validation
Excel VBA help - Range selection
urgent-looping through data validation list then printing as per each value
how can I get into a cell that it"s protected with a password
Is it possible to have a messageBox to display for 2 sec's and then Close AUTOMATICALLY ?
Grid Selection
Cell References
Sub & Function Problem
Putting the name of a worksheet in a cell
Licensing Protection
ComboBox with multiple criteria
Deleting Rows
Saving a copied workbook - 2 questions
Can a color (other than whte) Bleed to Edge of Excel 2007 Workshee
Fill cells with names from list
Marco to generate a summary list from a data
Outlook attachments
Outlook attachments
match vs find question
Pass a string to an address
first and last row of range
Macro
column count
Access to user-created menu
repeat entry based on value in cell
Insert a file ito sql-database via Excel wo filestream
Spacing in a listbox
How do you destroy a specific object or collection?
How to reach Application Objects in Events?
"Config file"
programming a button
error msg!
Web query failing due to too many temporary internet files?
Using Arrays to Fill a Range
Default data in an input box
How to control updating of random numbers
Excel VBA search for value of a cell
Easy Question
Save Event Handler
Change Text Colour if Value is in a List Q
PAStE SPECIAL
link to other worksheets
Question
Detecting text fits into column
Unable to figure out VBA Code needed
CUSTOM PRINTING !
HOW TO DISABLE CUT N PASTE OR HIGHLIGHT N DRAG IN VB
getting msg box for no match!
Unlock protected VBA
More than one cell answers??????
Solver with limit
Using Code Editor Slows execution speed
Help with vlookup with certain cell change
Populating a cell with concatenated text...
Selection Grid
#DIV/0! Error
remove outliers in a time series
dynamic range and series
Saving Macro - need help
I don't want to repeat the same number
Error in loading DLL
Paste Column Width Language
compare and compile nonblank data from seperate workbooks in an automated user form
Place Thin Border around Cell
Find duplicate range or cell ref (as precedents) in a cell's formula - an example
procedural help lease
How do I make a word in Excel flash?
Worksheet Listbox Populate Problem
How do I use looping and offsets thru 2 tables to generate a cash flow per week
vba to delete rows
SaveAs Dialog comes up twice???
UserForm fill by Range
If then VB statement
Selecting a range of cells , how to ?
Selecting a range of cells, how to ?