Excel Programming [Archive] - Page 70

naming a variable range
How to code WinXP Search into Excel?
Making form for excell time sheet
How to set payment dates and frequency?
Excel 2007: 2 Problems with textboxes
difficult
unique list
Create file list
Autocomplete not triggering worksheet change
Command Button / Inputbox Questions
quicker copydown
Return values from UserForms
Tabs in Text Boxes
Count # - Compare - Find - Identify
lookup date in the interval
changing "trusted publishers" via vba
ComboBox RowSouce Question
-2147417848 Error Code - Deleting a Worksheet using VBA
Global variables
User Defined Functions
Adding an Object to a MultiPage
I need example code. Need a large Math (times X) table.
Deleting zero's within a range?
send keystrokes to whereis.com.au - get directions
memory address
Re-asking about "ugly" procedure ??
unique, blank free, editable dropdown...
array storage in memory
Cell formatting in formula bar but not in cell
VBA Code to Create a Toggle Button
Run a macro after a particular cell changes...
Merge Cells
RE: Excel data exported to custom Outlook form
ClassificaÃ§Ã£o
Question about UDFs with VC#
format problem
Multiple Passwords to open worksheets
Display info in Combo box'es
how to use VBA variable in formula?
sum currency value between empty rows
do you have data ?
File name as a variable
refer to a particular cell in r1c1 style
More than 4 conditional formating?
Creating a function from a chart
Opening another file in background
Error printing from VBA to Adobe PDF printer, "Do not send fonts to Distiller"?
How to insert the Raw data from a Text file to a Microsoft Access Using VB
Find and display rows with criteria
!!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER MILLIONAIRE !!!
!!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER MILLIONAIRE !!!
!!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER MILLIONAIRE !!!
Charts are hard / found a BUG in ChartObject behavior
Creating formulas
vba equivalents of set.name and define.name
running old xlm macro
Object Is Object evaluation problem
sumproduct
Naming a range and then use it to create chart
Reset Range after row delete
XML
passwords incompatible with macros in 2007?
question about opening SQL results in Excel from ASP.NET via XML
Run a macro after a cell changes...
"cheap" way of saving array
how to insert the date in and make it change automatiquely
Macro to select dates in the page field of a pivot table
sumproduct
RAnge as Table
Re: Find cell address of previous active cell
Control Update of links
send mail from excel 2000 and Outlook Express
Making a ConsolidationReference default to the current workbook.
Generating multiple variable permutations
File in use when opening VB app
auto deleting records form more than one sheet in a workbook.
Take Focus Off of CommandButton When Exiting UserForm
How Do I Add Column Headers to a ComboBox?
Get Font Color Dialog
#2: VBA to Pick Range and letter
Cell formatting shows in formula bar but not in cell
Question About triggering a one time event based on a specific cell value
how do I?
clipbourd
Macro code for deleteing rows
Formula to VBA
Setting Range Variable
IF(ISERROR function
Data Entry & tabbed spreadsheet question
Writing a macro to save worksheet
Vba code meaning
how do I freeze windows with VBA?
how do I freeze the window with VBA?
Create a search and go to button
Changing Codename in VBA
Problem creating a query
Embedded OleObject displayed as icon
Referencing password from another file
standard Data Form does something cool
FileCopy Probelm
pesky invalid external reference error: how to track it down?
Excel Macro Problem Copy Data from sheet1 to 2 but into different cells
Oracle Sequence Jumps by 3 from Excel
Sum a value
Date in Excel
Date in Excel
Date in Excel
Userform Cancel
Pass Command Button info
cut and paste 5 numbers from one col to another for entire column
selecting an area with VBA
Dimensioning question re: chart objects for PowerPoint
Read-Only alert when opening 2nd instance of Excel
Placement of code
paste value from vba into cell
Program Control - Gotta Be A Better Way
Running SQL Querry after every 10 minutes.
Getting info from individual sheets into master sheet
Copy and Paste in steps
Re: Text to rows...at wits end
Suppress update links message
data validation syntax
selecting a worksheet page
Can I stop the close method in an auto close macro
Problem with OWC11 cells alignment from C#
Prevent selecting multiple cells
POWERPOINT SHEETS IN EXCEL MACROS
Buttons not working
re-post border on userforms
countif again sorry
How do I use a multiselect listbox
cointif
Timer object
atpvbaen link
AutoFilter method of Range class failed
Event on a cell click
forced entries
Automatically enable the macros when a excel file is opened
How to insert Stock quotes from Web?
copy data from WS to WS in same workbook
excel xml
Backing Up Open Excel Files - with a Timing Component
Custom User Form
shopping list for bargeordering
macro to move contents in a cell and add to another cell
xml
AutoShape Location
deleting cells
Detecting a number versus text?
Control update of links
Password prompt when sheet is activated
Sort on collumn H when leaving sheet
how do I set up a macro that will move the cursor down one cell?
Message Box - Click OK to go away
Complicated VBA? Moving filtered data....
Sort on collumn h when leaving site
Selecting a default path/directory
Change Dates
Date Check
Arrays
make submenu of checkbox
Print range & Command Button
Selection Combined with Search
checkbox calculation
Help me with this UDF? Complex nested IFs...
Help me with this UDF? Complex nested IFs...
Clear Contents Macro
Run-Time Error
GetAddress
Turn AutoCalc off on opening file
xl 2002 date problem
Trim Conflicts with Data Validation
How do I tell the pivot table to ignore the PivotCache and go straight to the data in ConsolidationReference
How Populating Arrays/Range in VBA code
User select Save To Folder
formula
Pasting data into excel
Sort control doesn't sort top line
Worksheet Change event problem
Print sheet 1 on front sheet 2 on back of a page
How to associate/store user data with excel workbook?
Help with a quick way to close all duplicate windows using VBA please
Negative Numbers count
loop
use vba to find two conditions
Deleting Sheets - Without a prompt
Userform Entering Data to a spreadsheet
customize AutoFilter
Cell Formula Changes When Different Cell Value Changes
Loged On User Name
Filtering by criteria
Hide - Unhide
Copy and paste macro
Custom Help Files
Disallow CTRL+ALT+DEL
How to determine if a Folder/Directory Exists in Excel VBA
Conditional Formatting Code Problems
instr() ?
Problems with conditional formatting
can't copy conditional format formulas in Excel 2003
Filtered rows not in code???
what is macro?
Duplicate Msgbox
Calling XLA Macro from DLL.
Save file without prompting in Excel Macro
Path of template folder
Data Bars in Excel 2007
OnKey Help
is this possible in excel?
Excel Date Into Multiple Cells
Excel problem :(
Type Mismatch Error when Inserting a new row
Mail Merge Formatting Issue
Run-time Error '1004'
selection of non consecutive ranges
How to pass the name of the cmdbutton calling an Excel VBA procedu
Stop auto update of filter macro?
Re: Autofilter Delema
wsname value of range name
Inserting a filtered excel dataset into word as a table....
Paste into new Excel book not working
SMS from Excel
Color index & conditional format
Conditionally format in code and count at same time
Choose Printer other than default
If/Then statement
Returning the position of the Cellpointer in the range
In Macros - compilation error
Replacing formulas with values from DLL
Problems adding a column
Cell Command Bar
Problem with named ranges
Send an email attachment (pdf file) from Excel 2003 using Outlook Express
Change Default Print Options On The Fly?
Launch VBS from VBA
Re: Problem reading HTML code from Excel-VBA
Selecting and pasting formula into a variable field size!
Re: Problem reading HTML code from Excel-VBA
How to spool through worksheets in a workbook
Change cell formula based on input in different cell
Multiple Drop Down Boxes to Hide/Unhide Row
Why doesn't this create a boxed range?
End Select without Select Case, Block If without End If errors
unique data validation drop down
How do I make references to cells in subroutines relative?
Get only child nodes?
RE: Copy paste slows down
Optional Parameter Testing
Right click generates 2 mousedown events??
Nested if formula
Loop trough comboboxes
How do I identify a number in a range and then multiply?
Logos in Excel
copying cell info from one worksheet to another based on a specific date
RE: Force Integer in Inputbox
automatically saving a file every 5 minutes
Inserting a Filename
a macro that will change the file names within it after running
Cell Selection for update 55 columns
Re: How to check worksheets exist or not ?
How to create a worksheet in Excel using c#?
How to tell textbox to treat number as number, not text, and notshow zero
VLookup problem
Selecting adhoc cells for formatting
Help with a statement
Loop function
How can I use a formula to multiply changing cells by a static pro
Searching through Web Folder
Variable ranges
Eliminate one cell
is it fair?
Vary Vlookup column ref in vba
syntax error
Cell references
Event Change on colour index
Merge Cells
excel scheduling days
Dynamic Counts based on different conditions
Connect to a Website
RE: Cascading list box
Link to workbooks
Have "Freeze Pane" button track current state
Compare and add
Evaluate an odd number of data lines
printing multiple sheets in one print job
I get this error: Sub or Function Not Defined
Excel 2003 crashes when i make a chart
Fully defined formula links?
Need to find particular string within cell text, if found a value is copied
Form Question
how to transfer #'s from one column to the next
Suming in multiple spreadsheets
Emailing range for Excel and adding body text
Name multiple cells in a range in an ordered manner
xlDown going further than data
subscript out of range new!
Worksheet.Copy( @parameter1, @NextWorksheetinArray)
Comparing and Adding
determine which formula to use
Problems Displaying Help
Print Subtotals of variable entries
Add User from a UserForm
Add line and text
Editing a cell
vlookup
Error Message "Runtime error '13' Type mismatch"
copy and paste contents of sheet
How can I get an empty cell with a formula
file path in input range of filter
If cell value between dates say "due"
Auto_open OR Workbook_open
i have two parts of a solution but can still not get it to run
spreadsheet control in userform
Determining Portrait or Landscape
Assign macro to custom menu
Find names of all open workbooks
How to send email from excel
macro problems
subtotalling records
File error: data may have been lost
RE: Help fixing a very ugly procedure
Userform RefEdit updating ComboBox values
Re: Checking if another workbook is open
strange problem displaying array in list box
Deleting every other row
To check worksheets are open or not
select offset (variable ,1) to offset(variable ,variable)
Duplicate Query with a twist...
Re: task bar attached macro name probles
Re: Range too complex
Make form active (set focus)
count the number of digits ISBN : 0524102434
Error when inserting AutoShape ????????
Placing an absolutely positioned image on every printed page
Text Box : Controlling what the user inputs
Re: Trigger a Macro from the result of a function? "If A1= Yes, Enable Macro1"
Adapt hiding columns?
Sending mail through excel
Loop and delete
Delete Page of a MultiPage
Find string on a row and sum value from same row....
run a macro inside of a function
Userform ... populate optionbutton from spreadsheet
code for command button not work
Multicolumn Listbox Value to Spreadsheet
Simple game to demonstrate TOC using Excel/Powerpoint/SAS
System.Runtime.InteropServices.COMException (0x80020005) in excel 2k7, but worked well in 2k3
Re: How to create separate instance of Add-in for new Workbook?
Pivot Tables in VBA
Area Between Two Cells
RE: In excel macros remove by default message's of excel
OCX works in XL2002, not in XL2003
Email Address
How can I create a Macro that can update a sheet?
Re: Using SessionVariable(LOGON_USER) in VBA Excel macro
Macro for Sub Totals
Re: ADD CELL TO RIGHT HEADER
Delete Table from Excel
Fill combox box from text file
Re: Undo history
In Cell Checkbox?
Re: Application.DisplayAlerts not working
Excel and events
Re: Multiple Lines in Message Boxes
excel positioning in points for autoshapes
multline option button alignment
vba equivalent of an autorun xlm file
Re: Find duplicates, sum and delete dups
Re: Corrupt Excel File?
Custom VBA Drop Downs
Check Font or Font color and take action
Re: Copy paste slows down
C# Functions Library
Cell and font color
how to freeze the spreadsheet ?
Re: Out of memory error
Open workbook with password in VBA
Excel question: "Problems during load" -> Table
Finding the "Block If without End If" error
RE: how to copy a sheet to diferent workbook. no paste
Visual Basic Macros, relative position
Circumvent drive mappings, reference network location
Variable Range to Create Chart From
ComboBox displays duplicates - please help
RE: Bar chart help wanted !
Set few range variables at once
RE: Macro run time error
macro for changing font color
Input range to UDF ?
URGENT - File Menu!
Re: IN MACROS HOW TO IGNORE ANY FILE.
How do I determine the Left & Top coordinates of a graphed point?
Ref Protected Worksheets
Re: Saving Worksheet/Workbook via CommandButton
RE: Refedit (can't get to work at all)
Use XIRR FUNCTION IN A VB 2005 PROGRAM
Export Worksheet Data Problem
Rotate a Shape
Debug This
Debug this
RE: Reading in outside file
extracting records from a list by typing one criterium
Re: Getting error trying to replace characters in a cell
Re: Creating HyperLinks in VB
Selecting the cell in Column A
RE: ADD CELL TO RIGHT HEADER
Re: Creating HyperLinks in VB
Problem disabling/avoiding refreshall popup
Re: Refedit (can't get to work at all)
Re: Appearance of listboxes
User Form Error Excel 2003!
connecting two cellswith out changing either of them
RE: SetCursor API problems...
Microsoft, what is the process for troubleshooting XML spreadsheet errors?
RE: Data validation
Conditionally showing hidden columns in XL 2000
Problem with Autofilter macro code
RE: Hour Glass & User Forms
Re: changing tab name on the bottom of an Excel sheet by macro
Re: Creating Invoices
RE: Multiple Column Listbox
Re: Multiple Column Listbox
RE: Adding a Row Simultaneously in Multiple Worksheets
what is Microsoft script editor and where can i find a tutorial?
RE: hide column
RE: Using Offset?
How to merge 2 ranges from to worksheets?
Re: Checking if another workbook is open
Find first non numeric character in string
Re: hide column
How to summary by ColumnA + ColumnB + ColumnC by VBA ?
Is Excel 2007 completely backward compatable?
Setting Zoom according to User on a network
Assigning Macro to a button in a macro
Name Box
External Logo / Image / Graphic linked in to worksheet
Opening files through code
Error when using IDE commands
Capture outline expand event?
Simple Formula
AODB Recordset
AODB Recordset
ActiveWindow.SelectedSheets.PrintOut ?
Warning the user about closing Windows:1.
Change Default Sort Order - Please Help!!!
Question for Peter T - Copy Paste controls at runtime
Removing the Apostrophe
SELECT UNIQUE some_column FROM MAILMERGE.DATASOURCE
Positioning a sheet
VBA Form Input Range
Before_Print
Menu to view available worksheets
Updating a cell
maybe by VBE users.....
Delete row below once data is copied above
Create and Update Multidimensional Array
using array as argument in VBA sub
No page break in these rows! How?
Disable UserForm Objects
Aspect Ratio for Printing
It's very strange! Please review and give me a clue
Click Events on a MultiPage
Divide contents of cell
Weighted average UDF... a bit more complex
How can I get a value from one drop down list to another in excel
Date validation with abiguous format
A more elegant solution to grab a range?
Open validationlist when cell is active
Verifying input
Everthing worked fine and then.......
Excel automation
Need help with 2 HTML files in the body of an email
Equivalent of ActiveCell for sheet that is not ActiveSheet
use Cell text as sheet reference
Weekly Schedule!!
Read, Find, Copy and Sum Macro
inserting string into excel table limited to 255 kar??
Empty Source Data
Load Unique Value from xl sheet to combobox, Possible ???
Can't send email from Excel with CDO
File modified date problem
Sharing and Changing a Macro in Multiple Workbooks
Sub Form Usage
Need More Elegant Solution - Simple Program
Locking a linked workbook
Lat populated cell
Help with Pivot Table Code Please
Resizing range
Returning to Original Workbook After Saving Sheets
Send Email with attachment from VBA?
Workbooks still appear in Project Explorer after closing in Excel?
Import Dbase data Using VBA
I REQUIRE SOME HELP WITH CODE
Re: Dynamic Name at STATIC under SOLVER
Using Vlookup function to solve the below problem
Combining multiple rows to one
echo on/off - does vba for excell support?
Inserting Components
Toolbar + import image
How to change where validation should be?
Is there a way to get an AVG date?
Format Excel Drop Down List
Conditional Worksheet Printing...
VBA Pasting
DOES ANYONE KNOW WHERE TO DOWNLOAD READY MADE QUERIES
Excel save time
how to calculate with vba the number of records in an excel- table?
Excel 2007 (Beta) - strange behavior of macro
excel 2000 post service pack 3 hotfix - correct an issue with solver with VBA
programatically interpolate in excel
How can second, third user sign excel file containing macro
how to name a range with vba?
Sending mail via excel
Send keystokes to different application
Showing/Hiding Pivot-Items
How to move every nth value in a column
Generate a list in new sheet?
Getting a weird result on this one sheet in Excel
link a checkbox in a sheet to a checkbox on a userform?
link a chackbox on a sheet to a checkbox on a userform
copy picture from footer to worksheet
Executing xlAbort from Excel Interop
subtracting two date/time columns to get total time
terminating remote links?
short cut needed for listbox(sorry a bit long)
Duplicated range names
ColumnWidth
Callback C# code from VBA Macro
Highlighting a range using a Macro based on more then 5 conditions
How to embed a PDF file into a userform
Code not working in Excel 11
how to get each smarttag in smarttags in c++ com
Closing methods
how to create programmatically a table?
opening text file in excel through inputbox
Requirements to run excel 2000 with VBa
copy row including the button
Is there a Glitch in this code or what ? Not consistant results !!!
capturing date of entering data in a spreadsheet
Excel 2003 worksheet - How do I sort columns?
Search one column return value from another
How to ungroup ?
Upper case and Date problem
Transferring Control From VBA Form to Spreadsheet
How can put a text string in a cell
run macro whenever any workbook opens
conbine cells into one column
Transform a table
How do you evaluate cell value in vba
Two event Macros in one worksheet
Replace empty or " with content of cell above, using R1C1
Can a min'zed wrkbk pop up an alert to the desktop w/o restoring the wrkbk?
Cell Colour
Chart problem - works in VBA, but not VB.Net
HWND of Listbox in UserForm in Excel macro
Hyperlinks in two different cells
trigger event on userform focus
Insert Rows after word total
Combine Workbooks with Same Prefix into One New Workbook
Quick Graphing Question
Working with Remote Desktop Connection
Loop down, then across
Put Excel Data into Powerpoint Template (tables and graphs)
Programmatically determining if worksheet is protected
Event macro to extract data based on value of 2 cells - help
save nonactive worksheet as a seperate workbook?
Expanding a range
dont see custom document properties...
call a macro with arguments in a Command Button
VBA edit menu actions
Looking for String Function
Find a break in sequential number
search in a list, then replace using 1st column always
Worksheet Protection
Replace text with variable using VBA replace code?
can a C# plugin return array to Excel? or set Range values?
Round calculations
Where is the problem???
combining values ?
Digital signatures
Scheduling - adding minutes to time
bring focus to workbook with variable name
Macros skip steps and/or stops in the middle of code
beginner ColumnsQuestion b + 1 = c how?
Display autoshape with circumstances
Check the "Windows Regional Languages" setting?
How can I detect "nothing"?
Copy and PasteSpecial help
Commandbar properties
Auto fill Row Numbers in Col A
problem resizing range in vba
sumproduct syntax
addin toolbar
Scroll Event
xsl to xml problem during load
Selection.Resize error
Testing for "Password to modify"
if value = 0 then
SolverOK setCell and byChange args are not passed to the solver
Problem with setting a R / W property, FileSearch, LookIn
delete a macro
Restart
Find Value of column
Userform Development
Problem with code
display a chart on the useform thru excel vba
Loops, ranges and VLookup
Header & Footer from vb6
unpredictable combobox behavior
Help! Can't refer to a subroutine on a worksheet
System error &H8000FFFF (-2147418113)
VLOOKUP always required the searching field SORTED?
Select some sheets automatically
Using Container in Auto open macro
Hide Zero Values
Series collection pb on Ecxel 2003 chart
Pb With Excel 2003 Charts
Allow user
how to detect change of calculation-option
Round Function (Significant Figures) for Large Numbers
Highlighting Range of Cells based on another cell with 5 condition
hide blank rows
Server Throws Exception on Workbook.Close
Make page break every several lines automatically by VBA
Savings settings for an add-in in the add-in's own worksheets
Inserting comments on protected worksheet
Applescript question
Cancel button on messagebox/inputbox
Data Grid control
Hyperlink to Hyperlink
Reference Cells on another worksheet
All charts in workbook to powerpoint
macro to delete specific row with queries embedded
How to make worksheet saved in VB6 visible?
check boxes
Need Help on this complicated issue - VBA and the API to Dynamically Set Screen and Window Sizes
Is the string a date?
User Form: Multiline text box to multiple rows
Multiple Logical Tests in IF function
Search with multiple results
turn an filter off or back to All
Geometric shape programe
Macro to Filter>ShowAll on Protected workbook
How to create a workbook from a signed addin that is itself signed
Inserting a character into a cell that has text.
Union Statement Question
Excel API programming
Hyperlink calls macro passing argument
How do I save more then one Excel worksheet to .csv file format?
checkbox linked to a cell
printing hidden sheets
Need help with deleteing sheets using VBA
Problem with validation deletion/modification
Problem with Validation deleton/modification?
Count connected users
Use MsgBox to get filename and save .xls file to pre-defined path
sum
Paste results not as expected
need help with macro to convert number to date
Looking for Excel function verification tool
especific cell of an access table
separate "A1200:AB13000" into A, 1200, AB, 1300
Defined Names
the first event that occurs after a file is done saving?
List subtotals
DSUM?
Buttons to run macro do not work ...
Reading from Numerous Text Files into Excel Column
Macro help, very slow
.NetFrameWork\Policy\AppPatch, v1.1.4322, v2.0.50727 and Excel,
automatically sending workbook daily to email recipient
Filename Recognition
LENDING A FORMULA FOR INVOICES
Comparing two dates in one column
Process will not end from task manager after vba code is over
RE: Program won't work on all computers
How to cancel the selection?
Conditional Formating For Expired Dates
User Form: Multiline textbox to multiple rows
How do I select multiple selections using the range(cell(),Cell())
Checking if the sheet already exists
Excel Beta / Command Buttons
Trap error in: ThisWorkbook.VBProject.References.Item(i).FullPath
Copy and Paste Rows according to Drop Down Box
xldown in a non-contiguous column
Drop Down Lookup Return Value From Another Cell
Addition/subtraction possible with occasional empty cells?
Resetting the background color of a cell?
open filename containing specific characters in known folder
Creating an addin
How to replace Excel solver with some free solver codes in Excel V
MsgBox for filename and static path
Need to place 3 formuals in VBA
Searching mutiple sheets for a value in one column
Save one worksheet from a workbook to a new .csv file
Finding last row in range with blank cells?
Text box in User Form resizing upon data entry
Stop a Macro if no Data found
Trying to write a macro
Turn formula into vba
Applying Formula Based on Cell Contents
Sorting Rows on a password protected worksheet
Loading SQL Data into Excel 2003 with VBA
Clearing Values in a Range under certain conditions
How do I take a number from a cell and mult each digit by
Excel starts without any bars...
Sorting 3 columns in a 2 dimension array
Truncate string
Truncate string
Weird Behaviour of Code
numbering add-in
Close excel application
Loop in Excel
Updating Excel Code
Excel updating
VBA error -> increased file size
Assistance please for date range filling...
Excel to find a name in a column and if found place a tick in sheet 2.....
File comparing, fill file2 with value from file1
remove item fr listbox (correction)
Formula Help Please
Open new workbook(s) when userform and excel are minimized
returning multiple cell addresses
How do I set Printer Paper Source using Visual Basic?
Error in setting formula (Match) with dynamic variables
Saving xls in specific directory
Select print area
Multiple look-up / summing
When Using Format(Now(), "yyyymmmddhhmm") get wrong number of arguments or invalid property assignment Error
Get data from magnetic card reader to each cell
Find next ID in non sort column
Selecting a Folder or Subfolder
Determine if a File Exists
SaveAs Dialog Box
change filter with criteria back to All
Template Help Task Pane Appears When Workbook Is Open
Referencing Cells in Multi-Area Range?
track changes on an excel sheet
FYI: One macro really helped for capturing data from multiple workbook stored in a specific folder to one excel file only
How to get handle of Combobox in worksheet
Storing data in MS Access from Excel VBA
Navigate between 2 workbooks
Assign variable ListBox names
deleting rows across worksheets?
Simple if formula in a macro
Selecting next to highest number in an array?
remove item from list box
A challenge
Winzip and remove files
Custom control event problem
Store range of values in an array
Displaying Chart on Userform (with Scroll Bars)
Get the max number from a collection
Can sumproduct do this......
Amazing... something hidden in cells...
BeforeDoubleClick processing question(s)
Sort question
list sub totals
How to jump to specific cell
setting multiple values in array at once?
How can I put a list into a range of cells
GETPIVOTDATA
Cell wrapping event, does it exist? How can I calculate cell filli
sorting a one dimensional array
Force use of a date picker control
Help with auto filter
Array UDF
Does anyone know how to force a cell re-calculation
Found a glitch in the OFFSET function.
Replacing Chr(10) in a string
Passing range to a Sub
Macro To Print Files By A Listing of Filenames And Paths
Some help with Find/Find next
Worksheet Button Properties
how to define range for autofill without knowing the last row .
Option Buttons
network location
Merge columns into single list and replace with count of occurrences
How to find the first occurence of any number in a string
Text in DAtes
Copy data to multiple specific worksheets?
Variable in cell reference
Only for experts - please help
Text in dates
macro or function
Paste totals from 1 sheet to another
calculation problem...
Loop Routine in Excel
Edit query in Excel
Gantt Charting
Print dialog return help needed
Find & Move Sheets
Disabling CTRL R or CTRL D in workbook
Edit query in excel
Adding formating
Saving a variable value
Calling a function in another module
Count Space, comma and fullstop in a string
Macro to insert formula failing...need help
"ActiveX component can't create object"
Macro to copy files
Determing range name that is tied to the active cell
Remove duplicated Items in combo box
Scroll Combo box with mouse wheel
Module Protection
Need to create "on change" logic.
Reset variables
data validation invalid in dynamic validation list
lost VBA editor toolbars...
Charts
Convert input to numeric
change combobox values one by one based on selection in multiselect listbox
Apply format to whole column depending on row 1 contents
Display col width in a cell
Info in Formulas
My anti-virus has deleted my vba macros!
CommandButton State
replace defined text with page break in vba + excel
Date Value in wrong format on userform
Special Filter Macro - one rngFilter, several Worksheets filtered
Newbie: Reading color information
File SaveAS
Referencing Named Cells in Find
Edit a cell macro in Microsoft Visal Basic
WHY THIS CLOSES EXCEL IF THERE´S NO SHEET NAMED AS...???
something just not right in code, please help!
count
showing a listbox with last entry as the default
make a box with... or other solution
forgotten array
Any experts on the "if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG!
Duplicated code window and userform window problem
Anyone know what's happening with this bit of basic?
hide sheet tab and protect
Sorting macro needed on a protected sheet
Delete all named ranges in a workbook
Date "E2" to add 7 days How?
Trouble with this code
add items to listbox
Choosing multiple items in a dropdown menu
Many Workbooks into one spreadsheet
How to copy a file into folders that are created based on a list?
Extracting data from outlook
Macro to open, calculate, the save many files.
IF file Exists, then ....., Else.......
Copy and Paste data
AutoFilter button
Macro runs on cell value
Enable ESC to canel UserForm
R1C1 and A1 style conflict in formula problem
multiple lookup formula question
Change event on single cell fires many times
Quotes in CSV Files
"On Open" Run Macro
How do you know what version of Excel you are using??
AUTOMATIC INVOICE NUMBER FOR PURCHASE ORDERS
Disable Close All
Auto cut & paste
Deleting rows based on a cell value
Saving Excel File in Current Directory NOT My Documents
Saving Excel File in Current Directory NOT My Documents
Excel 2003: VBA: How to Speed Up Row Deletions
Setting default value for combo box
Formula for Cell
Import code help
Getting a collection of named ranges using wildcard characters?
Number stored as text
Converting months as # to Text Month
forcing cell format to be negative currency?
print query continued.. nearly there - possible ??
Run Time errot 1004, with formula
What are MICROS in EXCEL and how can I benefit from them?
Re cell reference
Automating key strokes to a dialog box
Pivot chart display options
1004 Cell Protected Error for data validation lists when locked and protected
How to use vba for inserting data into a sheet that is acting as a template or form
How to calculate
Automate importing
Passing arguments to a module in a Cell
Color alternate Entire row dependant on value in "A"
Getting Excel to send message via Outlook 2000
How can I automate creating a sheet for a unique value that is bla
Auto Shutdown
JUMP to the next cell with TAB key !
Delete Worksheet Condition
Removing subtotals - annoying 'feature'
WorkBook _SaveAs method help
Can you Add Check Boxes??
Pausing or waiting in VBA
Add method of Workbooks class failed
Find syntax
Issue creating a furmula in VBA, Please Help
COLORED cells, how do I make them PRINT without the Color?
Macro to run on cell change
Optimizing Excel Reading
Removing Commas from xlcsv
Comparing columns and deleting rows based on criteria
Help with Creating a Macros!
Delete column if a cell is not named
Cell to display text from cell on focus??
Rule for jumping to a public function
automate importing
Output Array Values
Vaiable in range().formula
Sorting a listbox
annual to quarterly
Mouse Scroll in Combo box on excel worksheet
Protect Chart Sheet
Successive VLOKKUP ?
Windows().Activate vs Workbooks().Activate
Excel as a reporting tool
Code is not running
Is there an alternative to Application.Run
Array Vlookups
printing a html file progra
Passing Controls on a form between modules
Remove duplicates from list but leaving one row with highest date
If Len > 5 OR cell is alphanumeric Then Clear contents
Using ActiveWorkBook.Container
SheetSelectionChange
Using solver variables to access database values
Formula
Information Right Managment
Formula for calculating storage days
Chart to PPT without opening PowerPoint
Select last months file
Join statements using ADO across separate Worksheets
How to make fetching and displaying of data from dtabase to workbook faster??
Query
Select specific Project in VBA
Tracking changes with respect to the correlation in entities
Excel VBA Vlookup
Method 'Range' of object '_Global' failed
subscript out of range error with 500+ files.
Chart to PPT from linked sheets
unique values to array
Global Variables in Excel VBA
MultiPage: How to enable controls in Frame on Page
Price List For Sales Representative
ERROR 462
Reinstall EXCEL
format from empty cell below
Help Please
Re: OptionButton problem
Change Lowercase or Proper to ALL CAPS
using variable with .Activate
How can I find type of control on a form
How can I find type of control on a form
Convert String to a Contstant
Set Range Question
Passing info to macro from icons
Chart to PPT
Transferring (Copy/Paste) Info to another excel workbook
Command Button question
Adding rows to a 2 dimensional array ...
Caching?
in formula, want 2 use 1 for A, 2 for B, 3 for C...Help plz
collage out of my photos
how to undo changes made by micro
Embed PDF in Excel UserForm
Text box problem
Input login ID & password in IE
How to hide row/column labels from VBA?
Help with code
Auto-email based on cell value change?
set textbox cursor in mouse right-click
how to arrange dimensions of source data array?
Excel to Power Point?
Programming a dynamic range then apply it to a chart
Combine Data From 2 Columns into 1
using ado db connection in different workbook
Autofilter: jump from visible row to visible row by command button
find ""qqq""
copying data to muliple worksheets
Custom Function to Retrieve Spread Sheet Data
Custom Function to Retrieve Spread Sheet Data
Adding Data Automatically
Match of cell values
calling C# DLL from VBA
Conditional Formating
List box Code
VBA Conditional formating
Copy cell value from W/book2 into W/book1
Measure Text and insert underscore.
Formula for cells
automatically add sheets and link them to external workbook named
Userform Newbie
Filling Blancks in Columns with the containing of cell.
Formula HELP !!
Formatting Text for Drop Down-HELP!
Problem with Cells Selection through macro.
resident functions
Adding Times
Application.Match and Ranges
How VBA Excel handling the Lookup with multiple "index"?
Retrieving time value from cell as decimal. Why?
Autofilter innerhalb der eingeblendeten Zeilen mit Pfeil rauf / runter springen
Help with Conditional Formating
Solver function question...