Excel Programming [Archive] - Page 57

Do not allow excel to minimize
User Form Link to Query
Run an Add-in
need help
DAGNABIT!!! Where'd my form go?
Switch Between Workbooks
pivot field order
Keeping a Macro in a New Book
How should I change Macro?
Problem: True vs. False
[Range].Find Help
Repeat formula on each page
Loop in a loop syntax
Execution ends without error message in middle of program
uppercase to lowercase
Appending / Concatenating by Client Number
lookup in a different spreadsheet
Find a cell value in a column then add two rows above
Sum all integers of a given number
Find specific string in range of cells
Vlookup issue?
Perform SUM based off COUNT
Copy cells that vary in range
Unassign Macro Keyboard Shortcut?
Updating cell value by case
Column Number from Column Letter
New QueryTable?
Macro: Clear contents of unlocked cells
How do I create a new VBA project when I run VBA from Excel?
Variable Selection Summation
Issue with Cells.Find statement within With
move data in bold to a summary worksheet
mail merge in Excel Please HELP
Worksheet selection change (running marco when cell selected)
Mail Merge issue please HELP
Importing XML to Excel
Problem auto generating e-mail to several recipients - argument not optional error message
Delete rows depending on cell Value
Sending File From Excel To Domin Web Access Version 7
Lib parameter in Function Declare
Navigation in TabControl.
need some help, encounter run-time error 1004
Malformed GUID error
Capture Time/Date received info from Outlook
conditional formatting a Combo Box
Forward mail items
VBA Editor How to Question
Initiating multiple combo boxes with the same values
New issue with "With" statement
userform question
Combine col & row headings and sequence them to single product val
Find not equal to "0"
Macro - Multiple printing
Worksheet.Unprotect within WorkbookBeforeSave event fails if Save
Macro
Worksheet.Unprotect within WorkbookBeforeSave event fails if Save initiated by VB
Excel 2003 Additional Workbooks After Excel Crash
Copy and transpose paste from one worksheet to another
How can i read Command Line parametres from Excel 2003 file???
Deleting files in a directory
Create dll file and call it from Excel worksheet or macro
API to find position of active cell no longer working in 2007.
Application-Defined Error 1004
Showing two forms
Help with my procedure
Find duplicates, validate each dup row is same as first occurance.
making cells mandatory entry?
Getting and Saving a Cell Reference
Getting Outlook contacts to list in Excel 2003
Problem with transferring data
Making a book catalog? Possible ??
Edit String Variable "on the fly"?
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between.........
External Data Error
Issue with code execution -- it is very slow
Conditional Row Delete on Steriods
Capturing Cell Values
From EXE to DLL
Shell function problem (MS Access)
Significant performance issue with this site
Protecting a worksheet
formula for price increases and markups
Form with no Cancel option
Userform
Event after "Save changes?" prompt when exiting
code not working correctly
Getting a "File Not Found" error when trying to show userform
signature
From EXE to DLL
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets
Return to Column A and current row
Macros in menu
"Added apostrophes from VBA to Excel??" response
Do without loop when using query
string
Added apostrophes from VBA to Excel??
search for cell and clear contents
How to use worksheet function Index
Finding times between 6pm and Midnight...
SUMIF Conidtions
Macro Menu
Pausing in Macros
VB formula not working in Excel
Getting back to file A from file B
ACTIVE X Component cant create object (From Excel To Lotus 7)
Sheet shows macros embedded but none are in VB editor
Worksheet Load
Changing Excel Version for Automation on the fly?
Search Column for matches to a Range of Data, then modify cell
Grr, encountering really annoying issues.
disable shortcut keys
Returning just the integer portion of a number
VBA macro
Excel/Access automation
About using CDO to send email within Excel
testing.....
Unwanted ActiveX warning message
Dynamic path for dll
Help with a macro
Fill cells with code based on content of preceeding cell?
Sending An Excel File To Web Based Lotus 7 (Recent Migration)
VBA code or macro to auto e-mail spreadsheet
macros
execute simultaneous macros
String Building for Where Clause in Query
Find word then use offset to change value in another cell
String Building for Where Clause in query
duplicates
More efficient code
automatic hyperlink
Help with Code
Close Excel from Access
Run-time error 1004. Application-defined or object-defined error
Operating Matrix in vba
is this possible?
The Microsoft Jet database engine could not find the object Sheet1
The Microsoft Jet database engine could not find the object 'Sheet
Toggle Button
Reading XML node data
Date format
The Microsoft Jet database engine could not find the object 'Sheet
Need function to raplace cell value by a range
paste special error
How do I create a progess bar
Unused Variables
Sorting the Data and Saving an Excel file before ftping it to UNIX server
Last posting dated 6/5/2007 - What's Up?
Digital Signature
how to prevent a bitmap from "bleeding" over two pages?
draw a math function
Problem with dates
Does VBA have a "continue" statement like C?
New form of application.run
Formatting Cells
HELP! Reading range into array
Get user-picked list of file names on Mac?
Change font of row cell reference characters
How to autopopulate column w/May using a col w/ 05/15/07(Excel)?
External Data Failure VBA Code
Printing printranges from different sheets in a specific order and as one print job
HELP "ByRef Argument Type Mismatch"
Ask for cell A1 value before printing out worksheet.......
When pasting formulas to other WB, the references still linked to old WB ...
find value in column and move row to 5 rows after the last one..........
Check File Name Existence in Array
Paste a constant
Running out of memory when adding logos to reports
Code for activating shift key
Programming for Excel
Closed workbooks still appear in VBE?
Pls help when "for each" is empty
Using Range Object With Two Variables
Project a formula result from change
Rename worksheet event
Outline macro
Copy cells with varying ranges (VBA)
Using contents of cells as input for variable?
Formating Multiple cells
Excel.Application not defined
Pc to fast/slow or something like that...
basic date entry by user
Find duplicates, validate each dup row is same as first occurance.
open a text file
Populating a combobox
Charts(3).SetSourceData Not Working
Password mask
Macro for page setup of worksheets is slow
Conditional Formula
Question about counting numbers
Excel function in VBA
Range(Selection, Selection.End(xlToRight)).Select
SPEECH problem
Error Handling
Speed Up MS Query update
text box 2 based on text box 1
Excel to PDF
Hide similar rows
Pivot Tables
Stepping through each character in a character string
how to copy formulas from one range to another range in other work
How to find the unique cell value?
Save As Error
How to find the unique cell value?
copy and paste formulas between deferent workbooks.
Email Notifications are Terrible...Difficult to find post
on worksheet load
How do we make Inclusion-Exclusion Principles on Excel?
Hidden 'data' worksheet
Excel User Conference
office clipboard
VB Editor
Copy and transpose paste across several worksheets
??? Cannot find and replace in macro
Calculating percentages based on the number of checked boxes in a column
Adjusting code to loop
Converting Excel Cell Location into X and Y Coordinates
find latest date modified file
Small Macro Revision - to highlight rows and enter how many times they appear in a cell rather than a msg box.
How to check for duplications in a single column
selecting specific columns with data and put it in a new sheet
enter a set value in adjacent cell
To delete specific color index row
using excel formula to indicate the active cell
Excel 2003 Pivot tables
export to html
how to get reference of a cell instead of value in the cell
Can I update User Form CheckMark without running _Click code...?
Lost discussion threads
How to increase a salary sheet by a set percentage in all cells?
Assign macro to text in a cell rather than a control
macro - email current page
save page ,clear page, reuse same page
Range question
Programmatically create DWORD value - how
How do I prevent a bmp from printing over two pages
DISCOUNTED CASH FLOW PROBLEMS
copy data from one cell to another
time vs Day format
Issue with SpecialCells method
Issue with setting Range
Stripping Selective Data from .CSV file to Excel w/VBA
Find Dups in a column, validate all dup rows are identical.
Create macro button
lock a formula result
Using Wildcard to Activate & Rename Workbooks
Copy and transpose paste
Making UI Ribbon, and xlsb files
Increasing the Sheet #
string matching
Data Entry Restriction
ActiveWorkbook.VBProject
Change formulas to variable row in range
Categories
Macro for setting range of Vlookup formula's
Range to Array
hide cells
VBA format date in footer
Validating subsequent duplicate rows based upon the first occurenc
Issue with Sort
Master file that sorts data into sub tabs
some squares on status bar
Create 3 dependant lists from one list
Remove formula and keed data using VBA
Group policy screensaver - turn it off!
simple text
Vlookup slowness
Find a row with a given value in column A and delete all rows belo
Closing a file
HELP No return data from my stored procedure
write to word
keep losing vba macros for IRibbon menus
Failure to execute Private Workbook_Open
how to refer to a merged range value
Importing XML records individually
Email using Outlook
Number discrepency
Do ALL labels at ONCE
Execute code from book1 of code from book2
Creation of Import Files
Excel crashing on macro execution
Excel 2002 VBA macro deployment troubles
executing stored proc from Excel
how do I enter a formula to work out tangents
Problems manipulate excel2003 via .net
Name range example
Function to search different worksheet
Refresh data
Excel Sub / Functions
Transpose data using Vba
Find & Count text within a cell
Using userforms to edit cells
duplicate row based on calculated number of months
How can I test in VBA what edition of Office a user is running
How can I popup instructions using VBA?
Looking up and reporting values across tabs
Re: Exporting Logo from Access 97 to Excel 2000 by copy and pastespecial is stopping Cell A1 selection
Recommend a good book to learn Class programming
Application-defined or object defined error
Convert string
Bug using "Microsoft Visual Basic Help" in debug mode ?
Bug using Help in debug mode ?
VBA code to erase an array element returning Error 2042 ???
Require macro to create toolbar in xl2007
Autorun
autofilter problem
Conditional Formatting
RE: excel build query from cells
Conditional formatting of a Command buttton
Excel RTD function calculates functions twice
Drop Down List Referring to a Named Range on Different Worksheet
Issue with refreshing pivot tables in my code
Issue with With statement
Disabling automatic hourglass cursor whilst VB Code running
fill cell comments automatically
Run-Time error 1004 issue just not making sense
Automatically copying formatting
How to avoid macros getting disabled
macro - copy all rows with colorindex 36
HELP with App_WorkbookBeforeClose!!!
My macro doesn't work with other people's computers?
VBA - specify where data is placed on new sheet
Excel help needed
Run VBA on any file open
Application.Quit out of Do loop
VBA code syntax vs XL Conditional Formatting & Watch Window
solver
[Office 2007] Ribbon scaling
[Office 2007] Ribbon scaling
Change Background cell color depending on date and last value of c
Array Help
HELP "has too many arguments specified" error
Quick XmlImport Compatibility issue
Excel 2000 macro to warn before sorting
Putting in an if statement
if statement that tests format of cell
sh.Cells.Find()
Writing MACRO
VBA Digital Signature for macros dropped
code modules included in sheet count?
checking if user selected cells are within a specified range of ce
Future support of Visual Basic for Excel
Reading MDI Files
indicate activecell range
Formula Conditional Formatting
Hide Macro Actions
Formula Conditional Formating
Can I have the TAB name be a calculated field...?
Insert Multiple Rows - variable
Excel 2007 on server
Help converting a macro from Outlook2007 to Excel2007
Pivot Table Emailing
Pivot Table: Show Description instead Name
Text currency to number
Remove VB code from a sheet
Excel VB: Turn Off Display
[Office 2007] Auto-hide ribbon toggle button and control recent do
Password protected workbook
How to override windows settings for date?
UserForm
find multiple criteria
Validation OK to named ranges in Veryhidden sheets?
Where to check authorisation of computer and username
Create Outlook Meeting Request from Excel
SUMIF FUNCTION
trouble using functions from Strings library
For Each and Collections
registering Help Context IDs automatically
Suppresing Insert Row fuinctionality
hyperlink
compaq visual fortran dll
Use of IF function with years and months
object variable or with block variable not set mean
Creating Excel simulation in VBA
Need a little help with loop(ing)!
Copy cells from work book then auto close without losing data
memorize cells position
Iterating through a collection (For Each)
Calculation mode and recalcs
Insert pictures
How to generate Bar Code by Microsoft Excel
Run time error, Open event, Wbk is Read Only
Enter "Empty" if cell is blank within a variable range
Hi-lighting items in a multi-select List box
Conditional Format on copied worksheet stop working
Function Excel:If a Date>actual date create a RED alert in a cel?
Macro that can switch between tabs
Parsing string to multiple columns
Row Insert, Add Text, Add Formula
execute macro on Worksheet selection
Excel VBA dead ?
non r1c1 name definition
turning Excel into a monthly budget
Hyperlink to a Particular Cell ---- but allowing flexibility to add new rows and still keep the link
Excel 2003 user functions.
VBA code to insert rows in table
make chart points interactive
Command button code does not execute
how to set current workbook to the master after opening 2nd workbo
Excel 2003> how to export to DBF with a field of fraction?
Excel Macro to transpose addresses from rows to columns
Help with Range.("XX").Value = (Newbie)
How i modify icon of a customized button in Quick Access Toolbar?
VBA code for date change? (Newbie)
enumeration by vba or by matric or both
Excel Web Query
Macro to look for three rows of everything
Autocalculate my share balance each month after monthly contribution
cell updates based on day of the month
How do I convert numbers to word in my excel invoice?
Hyperlink.Follow question
Open a directory and close workbook
Strange Error with Excel 2007 - What does it Mean?
Running macro over different sheets for Essbase
Macro to transpose names, addresses
excel resets chart values after workbook reopen
macro to copy row to another worksheet if cell is in bold type.
Syntax to stop code in Watch Window
How to pass arguments to an Excel macro using Dynamic Data Exchang
Re: Copying VBA Code from one Sheet to another
How to launch an Excel Workbook quickier, by ...
Enable Macros Office 2007
HELP: Setting CNTL-SHIFT-F to invoke Excel2007 macro
problem with connecting to excel from asp.net
Coloring duplicates based on values in a column.
Copying VBA Code from one Sheet to another
KeyAscii
Adding context menu to shapes in Excel 2007
COUNTIF depending on cell fill colour
Are VBA userforms always child of Windows desktop?
EMail Small Message from Excel
"application.filesearch" object doesn't support the this property or method
Complicated Macro to Match - Not for the faint hearted!
VBA - Cannot Delete Row with drop down box change
userform/printform question
UDF
Column size issue
unescape a URL
limit textbox to blank or exactly 4 numberic digits
Extracting results of Advanced Filter.
Cell Value Help
Saving Lines / Using a Range in a Drop Down.
Can I apply Autofilter by Column Title instead of Field #?
vsto and vista
Confused about str()
How do I activate a worksheet using a checkbox when it is checked?
Eliminate Read-Write Message
macro to conditionally delete 3-row blocks in excel
Stock List
Any Excel Gurus?
getting seconds to show in cell
Multiply range values with Lookup-value?
Bringing the Add-in to excel...?
Selecting multiple rows in a named range
Excel VBA won't copy Worksheets after sheet Deletion
Macros Tabs and Files
Determine sheet dimensions
Has anybody done this? - Restructuring a row based list to column based
Works on numbers but not on TEXT
Follow up to this post
DTpicker
A Fix - Pivottable - Added calculated fields and now can't clear pivot
Button to insert rows on mutiple worksheets and copy text and info
Common routines to open many files by name
select shape range
Changing tab and hyperlinked cell colors
IF, SUM and INDIRECT Help
Class module constructors
Workbook.SaveAs crashing after Upgrade to Office 2003 from 2000
How do I auto run my macro upon open of file....Workbook_Open() is NOT working?
VBA calling ppt
Restructuring column sequence to rows, based on a unique column.
opening a workbook from an windows forms app
Excel 2007 ActiveX warning
PLANILHA
Deleting rows that don't contain keywords
Linking crosstab query from Access
Build Select Case Programmatically
Why use redim when creating an array of arrays?
summing accross multiple sheets
Automatically select cells based on results size
Left of an object on a chart sheet
Edit cell based on position of option button clicked.
Save button, VBA protected, allow user to define where to save
UDF won't launch macro
Super 2-axis chart Autoscale Macro ;-)
combobox value <> range
Corrupt Pivot Table
Highlighting Holidays in a Range with dates
Best/Easiest way to search/find in a string
Opening Workbooks
Shift Key
VBA editor is shown every time a form is showed
Help with code for timing
Join Function in VB Excel2k
Selecting a specific tab in a tabstrip
copy&paste of several sheets in a folder to a workbook with somesh
Inputbox accepting desired response
Inputbox accepting desired response
Refer to column in range statement
Excel 2000-03 WB suddenly missing command buttons on sheet @Start
Re: Determine check status of worksheet checkbox?
Looping data form creation (need help/is it possible)
Shell function sometimes works, sometimes doesn't
small triangle
Use FindFirst to find record in Access
Question for Dave Peterson - Column Sorter
Find Values and Update
Watch out for ByRef parameters not working!
Placing a user defined type in a Collection
Whats the equivalent of null in VBA?
How can I make a Macro work multiple rows instead of one?
Conditional select range
Copy and Paste from one Worbook to Another Workbook
Error 424 : Object required
Help >> Looping form generation from spreadsheet list
Control toolbox textbox
Command Buttons and Auto-Filter
Integrating browser with excel
creating a user defined function - question on input method
copy/paste values for all sheets in workbook
Resize Picture / object in Excel
HELP how can I do this PLEASE!!!!!!!!!!!
Excel 2007 Prohibits Shapes.AddPicture from URL?
Macro to Simulate CF Italic Red Font based on Formula Criteria
Excel Automation Application is shared with interactive?
Can I use VBA to copy User Form from 1 workbook to another?
Calendar Control & Copy
Empty cell range and error 91
How can I change the colour of cells using a macro?
Compare 2 Columns, then output a list
Many Pivottables created in bva
Conditional Breakpoint?
Hiddening Rows in an embedded worksheet
Moving all files to a different location
Pivot Tables - Remove the "(All)" from the dropdowns
Empty range of cells
Help >> Looping form generation from spreadsheet list
Help >> Looping form generation from spreadsheet list
EASY>>>OptionButton Select Error
Where did my Locals Window go?
further question about XLAM menu- Fluent IRibbon
Checking entered data against exisitng data
How can I syncronize Autofilters on multiple sheets?
Empty cells
Add New Row to Multiple Workbooks
Add-ins and Worksheet activate
Filter numbers with textbox using 123132*
Updateting Oracle from Excel
Type Mismatch
Dynamically Added Control
Pivottable - Added calculated fields and now can't clear pivot
intermittent error and lockup problem
Blank Message Box after procedure execution
DragIcon in VBA?
Inputbox accepting desired response
Inputbox accepting desired response
Saving with password
Listing xls files and sheets (excluding Hidden tabs) help
Monitor OLE calls?
Selecting adjacent cell
testing data in above cell, and choosing column to copy from
testing data in above cell, and choosing column to copy from
Creating a Hyperlink from 1 WKBK to open another WKBK and activate
Application.Quit in Excel 2007
Adding a watch expression in VB
Hoe to Get Rid of the Bubbles in Excel
Connecting to SQL Server via VBA and ADO
vb code for saving a workbook when shutting an excel file down
VBA calling a web application that returns XML
Exporting to a CSV file from multiple worksheets
Auto Opening for Macro
why shouldnt develop in access
Custom Functions
Copying a formatted "template" sheet and naming new sheet via user form
AutoFilter
insert sum when first blank cell found
new workbook with new Query
Macro - If bold then multiply by -1
Converting ExcelML to .xls
send a mail from VBA / excel
Excel hangs on reopening a file
Problems with file to be used on different systems.
Problem: Cells show 0 despite formulas
comparing 2 workbooks and highlighting differences
ExcelBypassEncryptedMacroScan
How to replace cells by (predefined) ranges
Usage of Outlook data via VBA in Excel
Creating a UDF
multiple command buttons leading to 1 event
Host name
how do you email a portion of a worksheet (range) as an insert into the body of an email?
need to get the vertices/endpoints of a line
Help on IF please!
Urgent help on IF please!
Previus value in a cell
Check Box or Button Help
Copying "total" rules in Excel from one cell to another
RUN-TIME ERROR 438
Determine check status of worksheet checkbox?
Registry compare
Code event for the "enter Key"
BeforeSave code that appends date - THANK YOU!!!!
Korean script compatibility with Vba
VBA Problem - Please Help
Convert all text in a sheet to UpperCase?
do macros not like pivot tables?
COUNTIF to compare one range versus another range
password security with excel 2007
Control Click Subroutine (BHatMJ)
Input box accepting only desired format
Search for a string and extract it?
DDE
VBE Toolbar problem
Combo Boxes linked to Cells will not clear.
Page Breaks
Rounding Formula
Double Click Custom Command Bar
column variable into formula woes
CHECKBOX HELP
Speed up VBA - using class objects
Programmatically calculating formulas for new entries
Named Ranges
ParamArray bugs?
shared document: protection issues
Automatic rolling months for forecast sheet
Open a menu
Type mismatch when copy empty cell to Access database
modifying code troubles
Wildcard in Excel VBA
Count
Font of Check Box (from Form Toolbar)
Automatic Sheet Updates
Button-click to jump another sheet
Buttons Embedded in a Worksheet
copying sheets
Help with Find function
Automatic Update to Multiple Excel Spreadsheets
Error using MATCH with dates in variables
Excel grouping then inserting rows and summing up....
How do I complete this Formula
Test
ColorIndex of the current application
VBA Project Password
E-Mailing
Check for a shape - then change or delete it if it exists
address
usform check boxes
Web Query
Write data in reverse
string replace for error bars
copy the range names while coping cells
switching out of Excel with userform open
Need help with formatting
Variable Naming.....?
Case Else problem with #VALUE appearing in cells
Text import and "save query definition"
Pivot Table Programming (Selecting Pivot Items)
Problem with .sendmail
Formatting a Range
need help in my code on generating chart with dynamic range
Out of Memory
conditional query
CONVERT FORMULA INTO VALUE EXCEPT SUBTOTAL FORMULA
i have erorr on my email on yahoo why?
another querytable.add question
Workdays in a date range with Saturday as a workday
ATPVBAEN Problems
Drawing Shapes on Forms
Linking excell with access to choose a single record
Data Entry Form
how to access or copy excel form controls (eg. dropdownlist) values to a database
how to extract Form controls (eg.dropdown box) value to a database
VBA replaces formula but adds row in multiplier
Is there an easy way to open a text file and modify only a part of it?
Copy&paste of several sheets
How can I use VBA to connect to a SQL server?
Disabled all print option on Excel 2003 shared add-in vs 2005
Column width Static
Disable dragging Data-field in Pivot Table
beforesave code working sometimes......
Creating Parameter Fields
Circular Reference
Editing text copied into a cell by a UserForm
Check for File Already Opened - Can't Get to Work
Appending rows in excel from C#
match in vba
Linking cells
Database in Excel
shorten a macro
Macro to Simulate CF Italic Red Font based on Formula Criteria
"dim" problem after Service Pack Installation????
Worksheets.Add --- IF it doesn't already exist
directory listing in listbox
Problem selecting a whole data matrix
Get Path for Linked Pictures in Spreadsheet
Subscript out of range?
New variables in 2002 vs. 2000
Advanced Filter Unique Records and Hidden Rows
Copy same cell, below next.
Loop to create charts
What is the parameter for FormatConditions?
delete rows in excel by service date
using a drop down box to change the value in another box
E-mailing
Is Cell in Date Format
Excel Hangs when using Offset in formula. A bug?
Can't reference Solver in VBA
countif with and
Practical Macro Size Limit?
question for "Dave - temping with Staffmark"
Export Data to Excel
VBA, get data from excel with ODBC
How to create a Macro to Name a Checkbox
SaveAs Filename:=filename, FileFormat:=xlCSV
Which column(s) are sort keys?
Conditional Formatting Based on Cell Values for more than 3 condit
OptionButton visual cueing
Handling Dialog Boxes
Auto_expand on excel
Code issue
Excel 2007 References issue
How can I insert a swf flash in a worksheet?
need help with my code
Insert range of cells with a (UDF) function
Popping up message box with "Make Sure the Specified folder Exist"
formula help please
Referencing tombstone text data to populate a cell in a spreadshee
Use MS Browse Feature...
Browse using MS Dialog
Edit Mp3 tags
Can I set a variable to be equal to the range of an entire column?
if cell colour is then change cell colour in range
Help with this error message
texbox event update
Strange Excel behaviour
Save to Desktop, don't overwrite existing
NEWBIE needs BIG help with Macro
Event Code for Proper
NEWBIE needs BIG help with Macro
Save as, not overwrite
Array to Range assignments behave different going horizontally and vertically
Only Workbook Open?
Insert into a range from a two dimensional array
Open MSProject file (published on server) from Excel
Runtime error '1004':
multiple checkbox's
How are these uses of SpecialCells different?
Conditional formatting to change ColorIndex?
Build workbook by xml
Specify pivot table to hide 'earlier than' grouped data start date
Code for testing whether a cell or row is highlighted?
Numbering - Starting Over Based on Zero
vlookup using dates
read windows notepad file content into excel?
delimiter between two columns
Outlook Security Bypass
Oracle COM Automation Excel Charts
disabel print preview
Notification failed. Please try later
Rectangle Size
Color a part of a cell...
Function AND
Autofiltering by Date Range entered by User
Getting Run-time error although code looks correct
Automate 'Difficult' importing text file
querytables.add question
Unwanted number format conversion
Generating lognormal equity returns
Insert image by clicking on Usreform Image1
Copy form
help with finding a concatenated string
Returning Access Table properties to Excel
help
help?
Column sum into specific cell
Download zip file & extract/open excel file
Looping through cell
a much simpler or elegant way to do this procedure?
Data in different sheets
Automatically Copy Data from One Group of Cells to Another
cmb displayed item vs list
More efficient way for macro to run on multipe files?
Please ammend Formula
Diagonal Border Conditional Format
Create sum formula when using index column/row references
Addcing a cell to a non-contigious range
String Font Color VBA
Comparing info between worksheets
Compare formula/ xlInconsistentFormula
Problem with Text To Speak
Using results from XLDIALOG commands
Present file explorer to Select Directory
extracting data in Word for Excel
Lotus 123 file
Sumif with multiple lookup values
VBA Run-time Error "13" - Question
Macros
Worksheet.Copy() truncates cell contents problem
Volitle
CSV Editing in Excel
(un)solvable problem in excel ?
how to use multiple criteria with countif function in excel
Exit Macro if<>vbYes
user interaction to select a sheet
Excel vba find
Changing Line Feed Behavior
Open a Program
COUNTING COLORED CELLS
Do loop erroring
Listing Available Printers
Urgent help on IF please!
Select ActiveCell Range
Office 2007 Custom UI Ribbon - Syntax Check
Office 2007 Custom UI Ribbon - Syntax Check
Office 2007 Custom UI Ribbon - Syntax Check
Code issue - before_save() - Filename with date stamp - worksheet
Scripting.FileSystemObject
Automating download of csv files from web
Format selected character in a cell
Help With Help.
find string data type related functions
Call UDF by String Name
Deny in "Find" based on flag
Create and label worksheets
Playing a sequence of WAV files
Using an arrays to aggregate.
extracting info from an address block
Listbox Question
Position a string by the pixel unit
Identify Unique Formula's
Dropdown not allowed to be enter other values
Defining Current Directory
Import securely from SQL to Excel over web?
pushbutton to move data from one excel wkbk to another
Pull SQL data into Excel remotely and securely?
Excel - ignore red numbers when totaling rows
How to update references to a renamed Add-in
If statement; How to do something similar to - if(a1-a2>=5,+5)
Which sheet is active
Error 430 in XLS file using ActiveX EXE
Automatically generate next available user ID?
Excel 2002 filtering
Adding a separator to a context menu
Using VB to find certain lines of data with colour formatting
stopping a window for opening
Alignment in a merged range
Using VBA: Extending limits of Conditional Formatting
Worksheet change doesn't work completely
Alloted time
combo box in toolbar
Ignore blank cells
Trying to format a cell with a border
Web query
Re Excel Array Formula
excel to word template code
Track whose made changes
Insert Range Of Cells
RE: MS Query "Connections"
Using VB instead of excel formulas
Automatically close Userform
Pivot Table Programing Help (Selecting Pivot Items)
VBA Code for Excel Colours
Pivot tables - can change row/col vars but can't get rid of existing vars
Re: Sizing a UserForm
Textbox - code to drop into a cell
Calculating pensions rate
vlookup?
Function to copy A predetermined range
How to put an ampersand '&' character into a ribbon button text
Degradation of performance : upgrading from Excel 2000 to Excel 20
sending link in email via excel
How do you create a Macro to return text from multiple cells that fit your criteria?
VBA code to toggle hiding a serie (and relative legend) in a chart
Medical Student Loan Consolidation
How do I save a paswd protected .xlsm file containing old macros
Using Refedit with other workbook
Conditional Formatting
Re: MS Query "Connections"
Re: Alt + F9
Add range to currently populated listbox
Problem Using Scrolling Mouse With Excel 2000 Code Window
User Defined Functions
Combining Two Cells.
RE: Alt + F9
Workbook_BeforeClose Event (help!)
Is the solution in Exel? update data from Word
Need InputBox Help
absolute maximum with sign
RE: Date Conversion
Splitting a Column of Data into Two Columns of Data
Validate data in a range is exactly the same for values in column
Setting Connection Property to pass 3 parameters to an SQL Proc.
Copy Dates and Hours Sub
Array
Re: Runtime Error - Method 'Cells' of Object'_Global' Failed
Re: Password Protection Issues
Re: Question as to type of answers being asked for...
Re: MS Query "Connections"
RE: Insert column in
Re: Question as to type of answers being asked for...
RE: Question as to type of answers being asked for...
change and selectionchange event
Faster Way to Execute Code
Re: Excel Sum Array Formula
Link Filter
refedit error
Add item to Start Menu
Reading Data from Excel to Access progrming
Sheet select
Run Access Macro with Excel Macro
Coverting Alphabets into Numbers
Macro issue
Merge info from multiple rows where value in column a is the same
Re: Copy formula results and launch application from button
Awkward autofilter
Stop Loop
Need help with countif function
Macro not doing?
Reading from CSV date format
Hyperlink excel window problem
PivotTables and xlPercentOfTotal
Error trying to open Word doc from Excel VBA
"Loop" to exit For loop?
Get Browser Address
Is it possible to hide and show buttons?
Excel fraction not a date
use vba to run a windows scheduled task
Getting Kicked out of Debug mode
Alternating every other row different colors
Moving a Control on a Frame during Runtime
For Next (non consecutive values for i)
Need to insert a row and have macros update
Setting Class Collections & their Contents to Nothing.
Hide Row and Column Headings
Programming question - VB, VBA, C#, C++
offset problem
MsgBox message on two lines?
Compare Dates in vba
OnTime
organise vba project
running command line programs from Excel
Date: End of last month as YYMM
font question #1 - roman numerals
font question #2 - arrow symbols
Custom filtering in excel 2003 with more than 2 multifilter option
Conditional Formatting icon change type problem
display a message if a cell value is highe than $50,000
Display date and time
Execute vba code on cell exit
vba chart xlValue axis title truncated, one series name omitted
Hiding all rows where the cell value in column 13 of same row = $0.00
Hiding all rows where the cell value in column 13 of same row = $0.00
Hot Keys
xl2002 problem
SUMPRODUCT in VBA
How to repeat a text value in a column a specified num of times?
Other users of my Excel VBA macros
Searching for Value.
Looking for sample code that would allow me to kill any modal dialog present in Excel
Trig Problems
Macro for disabling F1 key
Array commands
Looping problem
Copying from one worksheet to another worksheet
VBA procedure when new sheet added event
Buscar imagen por codigo
Code to Hide Rows
Array
Two Active Cells in Spreadsheet (or eqivalent) - as for games etc
THANK YOU
Finding Next empty +1
rowsource question
Finding and replacing text formatting for strings within a cell
Inserting Rows on the fly
Dynamically Insert Rows
Re: would anybody help please?
Re: would anybody help please?
Re: Need data in cells on one row extracted to multiple rows
Is there a way to calculate distance between 2 zipcodes?
Re: Compare 2 Ranges, Copy/Paste Row on Match
Re: Compare 2 Ranges, Copy/Paste Row on Match
Toolbox object linkcell problem
Re: Need data in cells on one row extracted to multiple rows
Re: Need data in cells on one row extracted to multiple rows
Re: Need data in cells on one row extracted to multiple rows
Help with Help
Re: Compare 2 Ranges, Copy/Paste Row on Match
Re: Compare 2 Ranges, Copy/Paste Row on Match
adding custom macro controls to Fluent RibbonUI
Re: Compare 2 Ranges, Copy/Paste Row on Match
Re: Compare 2 Ranges, Copy/Paste Row on Match
Re: Function weirdness - #VALUE, then #NAME, then working fine??
Re: Touble with Dynamix Axis Scales via a Cell Value
Re: Touble with Dynamix Axis Scales via a Cell Value
would anybody help please?
To adapt macro for relative lines
Re: "Case" Problem
Saving Row Groupings and Details Hidden
Another MS Query question
Next Empty Cells