Excel Programming [Archive] - Page 86

Custom Class In VBA
Print all named ranges
copy result from a .xls file to another without macro
Excel rank question
Saving particular sheets in a Separate Workbook
Macro to create/edit calculated fields from a range
Setting Scroll Area
For each control in sheet
Problem on openning a program via Excel
Urgent Help Needed "Re-orient data"
Is it possible to import an xml file using VB or macro at runtime?
moving through sheets in a loop
Animated gif on userform
Macro to find empty cell and select range to print selected.
Shifting the position of x-axis labels
Is this possible?
Change Pivot Table Range
Adding "WorkbookOpen" Code Programmatically
Suppress messages/warnings using Workbooks.Open
accessing/reading vba macro without enabling macros
Sorting records with a macro
VBA Calculation Error #VALUE
printing related code question
Merging a CSV and XLS file automatically
How to write a range function?
Why isn't XML on my Data menu?
Dates in Pivot Tables
Don't understand - Arrays 101 (Help)
Trying to work with User-selected non-contiguous ranges
looking for heat loss programme to size radiators
Change Chart Series with VBA
help help help arrange userform in vb classic 6.0
I want to change the dollar sign to pounds
Invalid Web Query errors.
Multi-tab Setfocus Problem
inserting a row
using excel functions in a macro - not familiar with macros at all
Data Type Problem!!!
macros to export to txt
linebreak in ControlTipText?
determining if cell is a date or number using C#
Size of worksheets
How to create drop down menu for freeform objects?
Fixing macro to choose a blank row
detecting the first blank row in the spreadsheet and populate the blank row with data
what is the formula that help when cell=0/cell=0 to be display a .
Assign a color to the cell
Need help with a macro
changing Print Preview default value
date and day calculations
XML in excel
Copy cells to table in Access
Have drawing object automatically move around point on graph axis
how do i learn to write excel macros?
Average Calculation in Excel VB
VBA for calucation instead row/cell reference
Run-Time Error '1004'
Copying marked rows to another sheet
Cancel Button Routine
combobox values
Executing an excel macro and emailing a column in Outlook . .
compare name and copy to current worksheet
error message 91 when entering wrong data
how do i save a single sheet from my workbook?
Formatting All Sheets in a Workbook so I can Print
Combo box error
VBA programming books: any recommendations?
VBA programming books: any reccomendations?
Excel inserts single quote marks into formula
close excel
newbie macro question
programmatically add Outlook control for user interaction/feedback
Creating a "sensitive regions" image on a form
save as issue
Animated GIF
How do I restrict an inputbox to 5<= string characters?
How would I make the result row of a lookup the active row ?
How to create a live chart
Looping Help Required
formatting question
SumByColor(Rng)
Truncate/Mod
Command Code Confusion
spinbutton enabled = false not changing colour
union range problem
Excel VBA Hell
Copying a Currency Format?
Cell wording should change if result is +ve or -ve
Auto Update Time When Cell Changes
Highlight the autofilter cell to make it more visible
inserting conditional rows
help, find copied cell
Excel export to Access
Changing this code
Saving a single worksheet as new file before close
COPY DATA CELL TO CELL
Database Functions and Hyperlinks
Printing non-excel files from excel
pivot table
Tabulating Player Positions
Code
COPY DATA CELL TO CELL
Trim Help
variable - insert blank row/select range
how do i tell a macro to begin in the current cell?
Reviewing toolbar always opens on one particular file
Reporting data to UserForm
romanian currency (ron)
locking cells
VBA Code Examples
Search for multiple things at once
Excel Pivot Table Drop Down Macro
24 hour time
On load
copy a string from worksheet1 at row a, column a to worksheet2 row a, column a
Delete files with VBA
An obsure application or object defined error problem
Calculated Fields Based on Running Total Fields?
Search Column then Paste Data at end of Row?
Yet another progress bar Question
Need to Search Column then Paste Data at end of Row? Advanced Filter?
how do i change the numbers on the row header?
Calculated Fields Based on Running Total Fields?
Find first empty row in a worksheet with a Macro
Variables that survive an entire session
How to debig a UDF
Save a file without saving the macro
Need help adding accumulator cells
Search for text
Change cell data
Userforms: Disabling - Enabling the X
show userform
Morefunc VSort with array of long output
Exit with out saving
How do I get data entered in sheet1 to auto populate sheet2?
Find Match in another WB and return detailed sheet
Find the Error in my Code Please
cant compare cells with numbers in them??
Export txt file problem
Look up error handling question.
Looping...but why?
data between the dates
Hide command button
selecting ActiveSheet.UsedRange
Prevent Sheet Rename
User form help
Naming range where the no of rows indeterminate
User form x button
File path...
RE: Help needed Writing formula that totals data at end of column
RE: Help needed Writing formula that totals data at end of column
macro graph highlighting some numbers
how can a create a print command button in excel
GROUP BY & SUB TOTAL - HOW to do it???
Re: My ultimate goal is to create an ID that will always be unique
Textbox Content Type
Protected sheet - add rows & fix Summary
Forcing calculation through automation
Sort by rows...
GetConnection
Inputbox help...
Accumulator cells
copy from three sheets to one
axWebBrowser1_DocumentComplete event handle
Populating a chart with Updating information
VB Script to automate Excel does not run as Sheduled Task
find and paste
MISSING: Microsoft Word 11.0 Project Library
Searching for a Date
CutCopyMode is never xlCut!?
Limit data entered to list (drop-down control)
Disable Copy, Cut & Paste - First Post
Connection Recordset Loop Problem with VBA - Help
Password protection with grouping causes error 1004
won't update formula
TextBox Updating
excel - sql
message 'calculate'
Why does this produce an error?
Macros works on one PC but not on another
Macro to empty row
CopyFromRecordSet changes cell formatting
how to copy data with out using paste method
dos command for es\xcel to add an entry in cell
how to search a string in VBA
Auto Fill (number & its repeat in bar code) for stickers
Return activecell's column header in Alphabet
Network Macro Crashes (cannot Save 'read-only' File)
ComboBox Problem
Using a macro to import from another spreadsheet
lock only formula cells without protecting sheet - leave open
use of activecell.formula
PLEASE HELP** Pivot table auto updating
File error. Some number formats may have been lost.
adobe VBA object
How to copy a sheet and rename it with the value of two cells from the source sheet?
Looking for rent to own/lease option in Excel
Convert Date to number
External Data Range Name doesn't refresh
Sorting - use of variable sort key
Run-time error '1004': Method 'Cells' of object _Global failed
need help creating a...
Macro gives error 9 unless Administrator
Making several Excel Apps Visible
VBA - Activate a PowerPoint presentation in a specific Excel windo
VBA â€“ Problem with compound SUMIF function
Creating cell ranges
Menu Event
Control Class Module
Using If Then to count multiple criteria
Executing Excel menu commands from VB
Convert and Extract?
Prevent certain cells from being copied
Macro Will Not Run on Some PCs
Macro Will Not Run on Some PCs
Macro Will Not Run on Some PCs
How to prevent copy/paste of cell with validation?
create a new formula?
Toggle Between 2 Windows
Add-ins not loading
lookup value in sheet
Excel Marcos
Who saved the file?
Master sheet to split sheets back to another master sheet
squashed test in combobox
Can't enter break mode
squashed test in combobox???
wierd error I cannot figure out
Size bug with DTPicker
Finding a named range based on cell value and copy/paste to same sheet?
Using Button on User Form to save Data to specific Cell??
MS Query hangs in Excel
How to move data in Column A into seperate columns / rows
Temporary File Error with SendMail
limit to copying rows in workbook?
Display Alerts
Auto run macro on individual worksheet open
open an other workbook to eddit
Cut and copying cells in a macro
What are hidden processes of SaveAs function
Determining Row in Which Labeled Cell Resides
use Outlook address list as time /date/ signature stamp in Excel
Formula that will leave cell blank if cell is blank
Conditional Formating with Function
copy sheets with values only and NO link to old workbook
Copy A Workbook Automatically
prevent chart values from changing
Populate a cell based on a keyword it found in another
Populate a cell based on a keyword it found in another
How do you move the selection one cell to the right in a macro
Interrupt code
InputBox Variables
Where should the code be stored? (Excel97)
Combine data from two sheets in two one
<Parent> of the Clipboard
How many rows are hidden?
Need Excel VBa to display Arabic characters
Highlighting row causing problems with other progarms.
How to get a vba macro to show up in the macro menu
Loop thru Range Help needed
Creating a new folder
Problem with sql statement in vba
making a phone number to be just 10 numbers
WScript.Echo... VBA Reference?
Defining Names for variable ranges Using VB
How do you remove all the symbols?
Hlookup Errors
How do I find duplicate rows, add quantity field & retain one reco
Extra series in charts when created using vba
I would like to enlarge a checkbox/checkmark to fit my cell.
How do you control worksheet naming of detail from a pivot table?
Finding unique values from a filtered range
Automatic log on to website and download report using VBA
transfer/copy data between sheets
Hide Sheet depending on List choice
Help with run-time error
Insert row variable
Excel Drop down List with Named Range
macro will not run from vbscript. help please
Hide combo 3 based on combo1
Deleting evey nth column
Hiding Column/Row Headings/Numbers
if statements.
simple... HasFormula ?
MS Query in Excel problem
Increase Row Height of every other line
Find/Replace from Table
Start Date minus (Years + Months + Days) = ?
Please Help - Vlookup in a macro.
change a range colour after copy to another worksheet
Sub works sometimes
Currency
Issue with Hiding Sheets Depending on Workbook Name
GOTO the cell which contains the cell link
Textbox Help
Auto Formatting A New Worksheet
Unload CheckBox
Excel as top Window
If Array
What's the difference between 'Set UserForm1=Nothing' and 'Unload UserForm1' ?
How to change cell colour based on numer of months?
Change font size in Msgbox or Inputbox
how to copy an excel sheet with out using paste metod.
Please help to detect this file
Found a small problem........
Scanning Barcodes into Userform
Looping: Selecting elements from a named range to change calcs
Importing select Range from multiple workbooks
Probably a completely stupid question!
macro not running on workbook open
How to make an inventory of incomming goods
Opening zipped/compressed files
help with ron bruin site - preventing outlook secuirty help needed
Where am I going wrong?
Deleting excess rows
O2K code in XP - what gives?
Date in header
Still need help
Challenge Parsing characters in a String
Numbers not copied from closed file
insert page break
VBA to Identify changes in row1
How do I have a value appear when I reach a specific level?
Importing csv data
How to program double click of fill handle
a difficult problem
bold AND standard text via function
how do i set up auto number in excel?
Returning an array from a function
Error creating Pivot Table
Rich Textbox Control
"File Download" dialog box
Error when use find method in vb6
excel error using .NET web application
VBA - Get array of filter values
"Activeworkbook" function not valid when workbook embedded in Lotus Notes?
Pulling specific information from a sheet
Read/edit/write from/to files
Excel bombs out in macro...help please!!
How to get get variables to move from userform to main sub?
vbcsript calls excel macro
How take form based data entry back to main sub?
Possible to select a range of cells from a Shape Object
how to disable insert column
Range object lacks Value property
Excel: Mass change relative cell refs to absolute (more than F4)
Accessing clipboard through VBA
Complex Variable Programming
IsNumber in VBA (not IsNumeric)
Partial correlations
Partial correlations
How to right-align data in a column of a listbox?
automatic input company name & address pressing branch #
Identifing charts by user selection
command
print
Add a form to excel work book
Range.Select error and screen maximizing error in Workbook_Open()
Interaction between 2 UserForms
Replace Input box with Project Array
Boolean formula
FORMULA
how to hide a macro name from macro listings
Range.Select error and screen maximizing error in Workbook_Open()
How take form based data entry back to main sub?
spontaneous update of Excel spreadsheet - HELP
MS-Query / Excel problem
Use optionbutton value to select code to run.
C# VBA DLL issues
Automation Error using Chartobjects
How do i get the vba tool bar in excel 12
HOW TO: Move a picture to the top left or top right of a cell via
Extract and Save
Hyperlinks being cropped upon save.
Calling procedures from within VBA
Color Scheme Trouble
Excel macro for multiple series in a single scatter graph using 3 columns
Advice on code
How to return a list of all selected Sheets in a Workbook
list box DELETION during a macro
Outline, expand or collapse via VBA
Help copying rows and arranging in new sheet
Macro to Add Comments with vlookup
Drop down list query
Running SPSS from Excel
Setting a criteria in an AdvancedFilter macro
Running SPSS from Excel
Help with VBA code
Pivot Table - '% of Total' question
Replace Formulas with Values
indirect reference to a formula?
Page Break by using Subtotals is wrong
Opening a xls for append
Use a macro to modify a combo box
Hide All Worksheets Except Specific
Getting the values of the points in a trendline
Using Relative Reference in a Formula
commandbutton to replace spinner
Help with activating previous sheet
Help with capturing user defined error messages.
Excel Functions for Records
PLEASE HELP...How do I update a pivot table with VBA?
Would like to change all "yes" cells in a worksheet with "logged"
Cell Contents as text in Msg Box
Validating number of characters in textbox
I have many excel files, would like to aggregate into one
Can not change default folder to network resource
Macro - Insert formula
Excel 2000: Comments
Deleting lines that are not needed.
Able to open same excel workbook at the same time !
July 19-21 London Excel User Conference
how to print charts which are embeded in a sheet
Is there a property to get the values for a point in a chart series?
Automatic use of Solver in an Excel model
Re: Send sheet rather than workbook.
Send sheet rather than workbook.
MsgBox containing text from cell
automate filter
Locking Data in a specific cell depending on selection of another
mark and skip a specific row
Kill a process - Could someone check this code for me
universal worksheet name
Protect HEADER and FOOTER ?
Reading the row number with VBA
Date Time Picker : Error 35788
Recording Mouse Actions in VBA
Help Please
Help with code please
Check File Existence
Maintaining formatting - Excel => Word
Excel=>Word
Excel=>Word
Help to solve login problem
Dates in range not selecting properly
command for adding value in excel sheet
Tough one
Using a variable to gain access to worksheets through codenames.
If Not c Is Nothing Then
How can use LONGLONG type of C++ Dll in 'Declare Function' statement?
License addin
insert rows needs to copy formula
addin design
Save addin in runtime
Addins store data
Formula Question Please
Want to change text in a cell on sheet2 if date changed in sheet3.
How to activate and control modem from VBA Excel
Archive Attribute Excel 2003
sorting the tabs
Change Cell Color On Condition Of Cell
insert row and copy formula
IE & Excel
Lookup Value
Last used column
Can I add code to ThisWorkbook module with VBA extensibility?
Sorting through multi-item list
Method 'CheckIn' of object '_workbook' failed
Insert function
Finding number of empty cells
Hyperlink
Inserting values in MsgBox
how to make cell read only
Can I right-align numbers in a Excel's VBA listbox
Autoclose code from Bob Phillips not working for me
selecting an AutoFilter value in code
Visual Studio 2005
Delete etxra information from cells
1-800 number
Delete non-contiguous selected rows
moving worksheet
excel .NET Addin in c#
test
Help with Ron de Bruin Script
Pause code in vb
Go to last col
Hyperlinks on UserForm
GetObject how does it works ???
adding a VBA name to workbook names collection
text box to variable
Find specific text and return coordinates
Dependant combo boxes
Excel look up contact card in Exchange via user form
execute macro; save it and close using Application.OnTime
Automation error
close .chm with form
View settings
Code help
Drawing Object in a Userform
how to import .csv to excel
Using a variable in solver
Loading worksheets from an add in
pivot table - multiple excel sources
Running a Excel function from access vba
How do I overcome limitations in Find-Replace?
Updating a Named range Automatically
Saving to a certain month folder
Check Point in VBA
Check Point in VBA
Protect a Macro
Increment Purchase Order Number
Is it safe to add event proc. to ThisWorbook module, if yes how?
In progess
schedule macro - application.OnTime
Common Dialog Boxes
count the number of nonblank cells within a range
Print Code not working
Please Help..Neeed VBA code to delete information in a cell
Open only one instance of Excel - 2003
Selection of variable rows
countif
Access to the undo list in Excel
Sorting with multiple rows grouped
Open a document using VBA
Problem to launch a program from Excel
How do I post the date?
Copying Rows from one workbook to another
Copy a value in a column over blank cells
inserting formulae
inserting formulae
Activating previously used workbook
Shortcut Key to follow a Call'ed Procedure
Get Line From Text File
opening form in new instance of excel
Select & edit items in a listbox in VBA
Having problems with textbox setfocus
more then 1 figure in more then 1 cell ?
Macro needed
Help with copying a range by selecting a cell.
Outlook - Object Model Guardian
Removing unwanted 'enter' character from comment
Change Dates to 01 of Month
Compare named ranges
Sub to replace pictures in a workbook
Re: Printer Dialogue
References to other workbooks
Calendar control doesn't work on some machines
Help with user form - selecting more than 1 file to process
Printer Dialogue
Error in macro - please help
vbYesNo message box
Rand function
Please help with this error
Describing a Range with Variables
Links Deleting
search over range of worksheets
Saveas csv file
Recording a Macro to create a Pivot Table
Set position of excel chart to cell A1
How to detect row number of selected cells?
Release of DocuCom PDF Gold 8 and Gaaiho by Zeon
VLOOKUP and Multi Lists
Dating local singles here for free!
Round function
Getting data from unopened spreadsheet
How do i setup a page break for a group of values/ rows .
help needed from someone with xl 2000
Using linked cell to change value in combo box
tricky SQL problem using VBA Excel to read Access File
VBA - Saving Rows With Text Criteria
Add amounts in a column based on transaction date in another column
forms toolbar vs. control toolbox
When To use GOTO Sub?
populate the fields
correction to the question
automatically populate fields from the source file
stopping a macro based on a conditional
SUMIF based on 2 columns instead of 1?
I need to go to a excel spreadsheet get a value for product/qty
Worksheet close event
how to change font size of datalabels of two charts in a sheet
Vba recordset for Excel programming
Run-time error 75 Path/File access error
Auto-run macro after auto-query refresh (Excel2000,sr1)
How to determine the height of a Range as an Integer
Determining whether dynamic array has been used
Can you open Access Database through Excel VBA?
Please help me create pop up questions
Re: Finding picture stats with VBA?
Finding picture stats with VBA?
Looping through dynamic ranges from multiple worksheets
How would you access an email address in Outlook from excel?
Time display 1/0/1900 after imported!
help to delete spceial folders
Excel crashes when adding code using vbproject object?
Split() and a few other questions
Sheet Name
VBA Printing
copy folder
Compare Two Worksheets and Highlight Changes
Closing Excel w/o Error message
Excel VBA Printing with several pages in a sheet
delet rows based on cel content
Selecting just my text
Need help using VBA to compare data in Excel columns, then manipulating data
Adding Values
date
Embedded hyperlinks not copying right.
Macro to Delete a Row
Get Average on results of Autofilter
How do I use excel to create a unix script?
Excel forms - authorise / deny forms
storing a value in code
Select column by finding the text
Worksheet Name
Worksheet Change Event
How to create a date conversion in MS Excel using VBA
opentext
restricting input characters
drop down list boxes in excel
How to copy module form one workbook to another
Structure of Excel Links
Macro Speed and Virus Scanner Installed.
Combobox exit event search error
Call function with adodb.connection Problem
Formatting font in a list box
programming input box
Now not regonized as a built in Function, in some spreadsheets?
Refresh Data
solver error
Textbox Keydown event not triggered.
Adding two values
R/T error - 424 - Why?
Dynamic Conditional Statement
How do I create this range?
Quick question on Add-in
FileDialog Box Question
Scrolling in editor window of Excel VBA
How to call a function of an user defined DLL from Excel?
Help w/ .Range(passing searched cells) I can't do it
Advice Please?
code not working properly - VBA beginner (random numbers generation, no repeats)
Set addin reference at runtime.
i am trying to use a formula that accepts equates words to a cost
How do i make a macro which opens a box at startup where I can enter a date which...
Print setup - fit to page - zoom
Macro
Help Plz
countif in vba
automatically assigning pivot based on unknown range?
automatically assigning pivot based on unknown range?
creating and populating an excel chart from within word
Copying rows to different worksheets based on a cells value
basic coding question
Row count
Get external data from MS Access using variables
Bingo Card Generator
check Open Excel applications
calculate time and multiply it by $ amount
Macro
Pasting Question
Help with code please
Using Ms form in Pocket Excel
Search within range for first populated cell and copy to new workbook
error when setting XValues for chart
how to clear up mixed date/text column
how to clear up mixed date/text column
how to clear up mixed date/text column
syntax when using a variable in a formula
how do i find and replace using variable input
how do i find and replace using variable input
Basic Checkbox question
Macro issue with Merging Non-Contiguous Columns
Adding a custom label to a series point
library/object name conflict in Excel VBa
Create new excel files, Save backup of excel file
help in VB for cell values changing in rows & columns w/result in
PLEASE help
passing a variable from sheet to form to another sheet
Tab Colour Change
Calling a function from Select case
Newbie Q: Specifying external Sheet name from Inputbox
vba toolbar additional controls not opened
Problem copying data with ADO
Re: Problem copying data with ADO
Getting a value from a web page to put in a userform
open a form maximized
Problem with creating a named range
Sum data in workbook 1 and write result in workbook 2
How can I disable multiselection of tabs in excel
Inactivating a Sub Function
saving messes up my command buttons
How to summarize two sheets in the third sheet
validating input of textbox before publishing
Avoiding the 'Update Values' dialogue
running an XLS Macro from within an XLS attached as Object
Border help
Big problem with doing one part of invoice
How to change value of cell based on another value of another cell
Delete row if column criteria was met
Excel2002 & Trapping Esc key
Office 2007 Problem
EXCEL 2003: how to add CR or alt-enter using CONCATINATE function
How to check if external .txt file has text in it...
Sum Times
Add open file to last files opened on Menu
How to hide freeforms conditionally?
help please (VBA to insert images)
how to sense -1 value at any cell in a column
advanced filter- no findings
Does worksheet exist
Arrange column after delete
Downloading Refreshed Web Query Data into Adjacent Column
Excel popup position
Copying autofiltered data to a specific (changing) row using a macro
R1C1 style reference as Condition
Code assistance needed
Text initially appears in a different cell to one selected until e
How to "wrap" email names in a Macro
compile error
Comments
Mass Delete/Paste Graphics in a Workbook
Intellisense
** Imp ( can we use INDIRECT to access cells in other worksheet in the same workbook)
what should be syntax for evaluate Indirect
Evaluate(Indirect) doesnt work
fastest sorting routine for 2-D array of long values
Using Arrow keys in a macro
evalaute concatenation gives problems
Macro to print and email a pdf
increase rowheight to show imported text in full excel 2000 VBA
Help referring to query tables by name
Tutorial - Use MSCOMM with a serial device
simple question
Pivot table code help
VBA to open in different browser
How to assign a macro to a key e.g. ctrl-S
Change a constant from VB
Sendign email from within Excel
Outlook 11.0 Library
Workbook Condensing Problem
start a copy of data at a line depending on date
Help Please - last bit of code needed
Find cell below last number in a column
Extracting Numbers
Need More Help on Stuffing Checkbox control
Copy rows that meet a certain criteria
Frustrating Boolean/loop iteration problem
Multipe file transfer using FTP
Re: Frustrating Boolean/loop iteration problem
Inserting data into a different worksheet
floor and rounding
run time error 1004
Need help with For-Next problem
vlookup txtx and sheet...
print preview
Determining number of pages
How to stop the popup warning window when clicking on a hyperlink
YES/NO Button - Tied to Macro Functions
DT Picker control
Excel macro works with keyboard shortcut, but not command button. Please Help.
syntax issue
instruÃ§Ã£o OpenText
Roudup problem
Saving to network - trap error
Stuffing Multiple Checkbox Captions
How do I make excel talk to outlook using dates?
Rollup the SUM of a column until last non empty Cell
Excel Macro Advise.....To Open The Template Dialog.....
inputbox with wait
Sumproduct and wildcards
Obtain folder names in a excel sheet
Filter Problem
NEED HELP WITH FORMULA, possible an array
Variable Error
Bloomberg xl function - a simple question
Returning Arrays, emulating standard function behavior
Combine workbooks into one master workbook.
Excel VBA Form error message
Is there an easy way to do this? (formatting numbers)
Re: Can anyone help me tidy up?
Can anyone help me tidy up?
Chose two printers with vba
Protect/Unprotecting Sheets with CmdButtons
Splash screen that is not rectangular?
How do I create a macro for adding spreadsheets?
Protect/Unprotecting Sheets with CmdButtons
vlooukp with sheet and txt file
Problem with rngCopySpot.CopyFromRecordset rs
MACRO FOR READING MANY FILES
setting rowsource
email question for ron debruin
On Error GoTo Failing - HELP!
Shortcut contents
Default value in empty cell
Page set up across multiple files ? x
macro vbscript doesn't run !!! I am desperate! I need help
Determine Last working day of Month
Determining Last Edit Name on Excel Workbook
How to find the addresses?
Incorrect date format when opening txt or csv files via macro
Arranging rows function wanted
writing macros in excel
Sheet-Variable in Berechnungsformel
Anyone help to improve my code?
Passing calling workbook name to called workbook
Problem with RICHTX32.OCX
Hiding Row based on cell value
Saveas with date problem
user form, saving values
Problem with compiling this VBA - help please
Refresh external data
Cells.find help
External Data Query
How to access the text selection when user is editing cell
How to set user's input in textbox to be numerical?
How to write a marco in Excel to delete worksheet?
what does "Compile Error : Invalid Qualifier" mean?
HPageBreak Row
How to apply the trim function to a whole column.
Can the Save Changes prompt be bypassed when using a volatile function?
Replacing Series Point with Characters
Variables description in a function
Date comparison in VBA (MS Acess)
In what version was the change event on a data validation list fixed?
How to move a button with an assinged macro
Need help please
IObjectSafety
ADO Excel Datasrc
Word Color of statusbar
Transpose a .csv from columns to rows
Printing Help Sheet For Addin
Professional Excel Development book question
Is there an onload event in Excel?
Understanding: "BUG: VB Hangs While Automating Excel Using OLE Control"
Help !! How to scan Outlook e-mail contents from Excel VBA
Help request for vb .net in excel
Loop until cell is empty
Need to open two macro excel files for macros to work
1004 error
Find function in VBA ?
conditional cell.value statement
best image on a userform
worksheet exists or not
Excel Locked up behind splashscreen
Multi Column UserForm ListBox
RTD Server question
Error 1004 Paste method of Worksheet class failed
Selectively Populate Excel VBA Combo Box
SUMPRODUCT
Determine if a worksheet is sorted
Transpose a .csv
Event change copy
Event Change Copy
using odbc, get external data
page break problem
Macros
Hyperlinks dialog
Count remaining rows after autofilter has been applied
Opening multiple workbooks in Excel through VB
Macro to copy a row, then insert shift:=x1Down
Creating a Flag based on cell value
Automatic Page Breaks
Copy rows to new spreadsheet
Copy highlighted.
Select all sheets and copy
Trace Dependents not working
Macro
Range is not being picked up
Re: Range is not being picked up
Variable help
Need your help. I need to add additional information into cells
Disk id
"Reference is not Valid" when calling fast fourier transform
Macro
Filter Macro
Error trapping
Cut selected value frm sheet1 & paste value to sheet2
Excel into Word
Minimum DatePicker
Run Time Error 1004!
automatic email notices
automatic email notices
Automatically update print area
Alternitive to Collection of Ranges
RTD Server question, Excel to Excel connection
Programmatically counting info from formula
Differences in controls on forms and sheets
Explain some things please
Barrier Option
inserting code into a Worksheet_Change event
sheets macro
conditionally insert image
Determine upper visible corner of sheet
problems using Filesearch object when files have a password
Formula Not Found - Urgent!
how to get the recent values corresponds to the time
Imported negative values
how to link an Access Database from excel if it required a password to open
Function to retrieve maximum value of Y axis scale in chart object
***PLease help. Need to Merge directory of files into one file.***
Function to retrieve maximum value of Y axis scale in chart object
macros run increasingly slowly
sending excel spreadsheets to cell phones
Vlookup Question
Multiple combobox and change events
Import XML Data
Formatting e-mail generated by Excel
How to get TOC shown in HTML Help when calling from VBA?
Print Macro
use VBA color the cells
xlUDF
Macro to automatically paste a pic based on a certain condition
Passing Byte array to DLL
Create a report using multiple queries
Selecting charttype from macro is not working
Making a macro interactive
Change event for comboBox
workbook_open execute macro
unique list
ComboBox Events Fire Many Times
Answer to Saving worksheets as individual workbooks using code?
Reffering to named cells
transfering all data.
Sumproduct Help Please
Temporarily stop script
Error: Double execution of macro :-(
SQL REPLACE Statement (or similar) in MS Query
Constructing a chart: HELP
form using windows explorer
copy and paste
find text then insert new row above
Urgent help Runtime error ‘1004’ Method ‘SaveAs’ of object’-Workbook’ failed ?????
printing using macro - too slowwww
Clearing cell contents
Re: Always Sendkeys...
Combobox change event issue
End(xldown) not always going to last cell?
List could not be retrieved
Update cells, from a filter
Export data from excel to IE form
AdvancedFilter with Blank Rows - Any Help
AdvancedFilter with Blank Rows - Any Help
Stopping error
Excel program only runs on one computer
Lookup problems
Copy or replace sheet1 from a closed workbook
Standard solver in a macro
Deleting unique cells in two lists
Setting a Variable range in VBA
EXCEL 2003
Show only Print_area range
Transfer data by defined name
EXCEL
Need help adding formatted textboxes
sheet named as an integer
Emailing from nominated email address
Text Display in cmdbar
Read .xls File Via C# Without Having Excel Installed
Starting a 'floating' form once a spreadsheet is open
Button on condition
Programming drawing obj. to center around value on graph
script to hyperlink and reference a cell value in the hyperlink
How to receive e-mail using Excel VBA
Loop to find next empty cell to the right not working.
UDF with several cells output
Inserting columns in rows with some text
Time Loop
need macro to page break between company names automatically
Disable Security Warning
Sheet change code
Using a user-defined function from the Personal workbook
Forms window comes back like Freddy Kruger
How do I exit on blank cell?
Does a worksheet exist?
Importing multiple files into spreadsheet
without using a loop...
Re: Open excel file from password protected Intranet site(IE)
Combination of left and right justification in a cell?
Excel Indent function flexibility
strange error when assigning macro to a form object!
Desperate for AddNodes msoSegmentCurve Help
Checking user defined types for Nothing
Display % of Subtotal
Obtain grand totals from a PivotTable
weighting a cell
VBA-Error Message Assistance Needed
Jumping to a location in an excel sheet.
Range or test for blank?
global variables
Rectangle with curved corners
Referencing and loading Solver programatically - how?
usedrange function
What is the verbage in VBA to send files to Excel?
Turning off the "We are sending on your behalf" message
how insert pic into excel and have cells shifted to make room
urgent help with autofiltering wanted
How can I reset an Excel form that has radio buttons.
Copying data & creating new worksheets - error
A work problem
Format for underlining a cell
Help with rolling quarter figure on a pivot table
Conditional formatting based on conditions in other cells.
Pivot Table Run Time Error 1004
Change Macro names
IF ACTIVECELL contains
How do I get VBA to generate a chart with square axes?
CheckBox question
Making a worksheet macro superfast
How to load Excel startup files through code