Excel Programming [Archive] - Page 104

VB Macro for Excel
Help
import txt file macro
Ranges of Named Fields
BUG: Font Size / Control Size Changes
Global macro for resizing and reformatting Excel charts
import data from works 3.0 on windows 3.1
Determining whether a named textbox on a chart exists
Replace Update Links prompt
Referencing a cell when using VLOOKUP
Logic and Loop Code
Change to UPERCASE
Check cells for 'Auto Save As' file naming
how do I automatically advance data to next cell when overwritten
Help with creating hyperlink via VBA
Create a new folder
Change to Worksheet Change Event
Help on Echange rare
Need a Macro plz !
What's wrong with this code?
Writing a line in to a file
Open multiple text files and paste contents to single cell
drag and drop a formula
Need Help with Set Object = Collection(index)
Cells.Replace in VBA
How do I make my Excel 2003 document work in Excel 2000?
How do I select the last entry in a sheet, to use in a formula?
Another way to remove formula
Last item in listbox not getting displayed.- - Excel VBA appln.
Programmatically inserting hyperlinks
Create Discout Table
Open dialog box and disabling
run-time error 1004
Check if date is valid
Runtime error 91 when connecting to SQL Server 2000
selecting range and copying to new worksheet
How to disable files type combo box in Open Dialog box
exact copy/paste
Help with a Macro....
existing file excel2000 macro
How do I calculate an offset between two ranges?
Best way to write an app using Excel sheets that doesnt look like excel
turning off automatic calculation when loading VBA add-in
Need help with arrays (I think)
Returning value in VB editor
searching in several columns
Listbox selection follows hyperlink
Remove Selected Entries from Excel List
lookup formatted cell
Text to speech
HELP: survey data collection & analysis
Name the ActiveCell
format as %
Activate Previous worksheet after adding a new worksheet
appending records
Idiot can't insert page breaks.
Rollup worksheets into a master worksheet - automatically?
how to average a cell value across worksheets?
Finding and Formatting the 5 highest values in a range?
Macro/Loop If Statement Help -delete the row with the specific te
Deployment and config files
VB code donation required please!
two unaswered questions, Could you answer me one or the two of the
problems maximizing windows in VBA
Compile List of Rows With an Empty Cell
UPPER / LOWER function VBA
Obtaining column/row numbers of cells in user defined function
FormatConditions appears to kill copypaste
SaveAs macro in Excel
Copying Selective columns
VBA Excel Model Diagrams
Macro Won't Open up Userform
Toolbars and menus
Automatically remove a Combo Box
Double Countif
update cell in automatic mode....
Compile List of Rows With an Empty Cell
Worksheet Change Event
tracking database change
Need directory path without filename
How do I get A ComboBox to execute
skip hidden sheets
Finding the last modified directory and file
Recording Macro, toggle absolute/relative reference, button disapp
Activeprinter
Lock Checkbox value
Concat and summarize 6 columns to 2 columns
Open files within specific file structure
VBA code to change registry value of existing DSN
Macro Sum Formula For a Variable Rang
Tools...References shows "MISSING:" in front of 2 references
internet connection via excel macro
Listbox Slider control
Stops at certain row with Error 91
Runtime Error 1004???
Columns resize event
Compare a selected Range with a Named range and select cells that do not exist
Finding the number of rows on a worksheet
how to add database values to a specific cell
Bug with SelLength? (Excel 2000)
Problems sending file link in email
combination
Porting Modules
how to - Insert predifined text in each cell of a column
How do you insert lines to make an accounting journal page
"Always trust macros from this publisher" is greyed out in Excel
Re: Help
Adding only working days
Help
Creating a master list
Command Button on Pivot Chart
Export or save my digital signature?
Re: Ron de Bruin (ADO help)
Loop
How to offset certain cells after dragging down a formula
Using Older versions of ms excel with 2003
Assign Cell Content As File Name
Excel should rewrite macros when adding rows or columns
Macro to select cells within a range in which the cell color is none
Supress dialog box when MS query returns more than 65536 rec's
RE: Error when loading a programme from a tool bar
where do i place the code ?
Application.WorksheetFunction problem
exact number of characters in textbox
RE: Copying table from webpage to worksheet
insert data ODBC
changing rows for columns
Macro for Excel to add up items and delete extra lines?
changing cell values from within UDF
Is it possible to unprotect a workbook without opening it?
Opening Word Files in excel sheets
Open CSV file, format data and write output to a text file.
How to re-set focus to the text box after deleting invalid data?
RE: I want to add a checkbox at the end to return data to a separate s
Reading excel data into another aplication
action on lostfocus in a cell
Capabilities of a User-Defined Function
Merge / Collate Workbooks into 1 Workbook
word å’ŒExcle å›¾æ*‡æ—*æ³•æ˜¾ç¤º
NEW VBA in NEW Excel ??
Re: Inputting month and year only
Message on screen
Closing Excel Application
Deleting a record from Access data base using programming from excel
Re: Inputting month and year only
linking format
Database question
How to duplicate Worksheets
Re: Changing directory names
Re: Changing directory names
Doing a macro in every worksheet except 2
Re: ATT: Ron de Bruin (ADO help)
code for organizing array
Solver
Re: Excel not adding proplerly... - sample.xls (1/1)
Re: Excel not adding proplerly... - sample.xls (1/1)
Excel not adding proplerly... - sample.xls (0/1)
find all instances of text in string
Determining File Size
error 2015 performing vlookup
final answer to run macro at certain time
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project.
Need help with loop
on click change cells color and increase a number..
Consolidate data in an 2-dimension array in VBA
All Subdirectories
Clipboard Clear API error
Database
Re: Clipboard Clear API function Error
Newbie: Help with workbooks
User defined functions
Object variable or withblock variable not set
Weird Cell Behaviour
Object Defined error
Doesn't recognize worksheet
Error trapping
Userform locks up Excel
Exporting Access Queries to sepcific ranges in an Excel workbook
Send a query and receive data through a Comm Port
Format Series in Pivot Chart
Exporting Access Queries to sepcific ranges in an Excel workbook
email several attachments (change to ron's macro?)
HELP !!!
Workbook to Web
using a multi-select listbox to pull data
Thanks Tom
Adding a control to a User Form
Macro only working on 1 row
Unable to set FormulaArray property of the Range class
duplicate data, if command in VBA
How do I handle #Value in VBA?
DDE Commands
Delete 2 rows skip 1 delete 2 more
Format Data Series in Pivot Chart
Code compatibility issue
how shell open AcroReader w/command line filename?
How to round down to nearest 5 minutes, time calc?
VBA to control the Mouse
How can I use the worksheet function FIND in VBA or is there a FIN
Autorun.inf
Problem with Code --- Please help
Automating Solver in loop
File or function not found error
Can't get OptionButton choice result from form?!!
Adding a column with reference to another
Usinf cells for filename
GroupName for OptionButton
Which runs first, Workbook_Open() or external query refresh?
Macro to Update Charts
which event/method should be used to handle sheet refresh in VBA
Help declaring array limit with variable?
RE: which event/method should be used to handle sheet refresh in VBA
Automatic filtering keystroke
Copy Paste Special Values
Moving objects
Changing the size of Comment Shapes
Help wih complex formula or macro or solution
Text wildcards
using cell info in an equation... Very frusterated
Null to Zero from External Data
Number rounding within a formula
Custom graphical cell contents
Sheet Reference in vlookup
macro abouut solver
Late Binding
Calling a Sub with a Command_Click
selecting a cell based on lookup with VBA
private macro and shortcut key
Trigger macro when nr of sheets changes
Workbook_BeforeClose doesn't work!!!
Graph Ranges
Find Column heading and then Delete entire column
Copying a variable range
VBA Code to copy values &formats to the next worksheet
Make textbox1.value default
Function Used?
Locking components BUT Still allowing to change settings via VBA
Populating a database with a template
Find last word in cell
Too many different format cell
sending e-mail it is ok from VBA not from Excel it-self
UserForm - Storing user's choices
Sheet Listing
Progressbar
VBA help to replace if formula
VBA Help to replace If formula
Which sheet will be printed?
digital certificate
array question
application.dialogs(xlDialogPrint) - arguments
copying data from text file to excel sheet
Display of arabic-type fonts in Excel VBA forms
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro
Delete words in cell if that word is in red
How do I Clear ALL unprotected data entry fields in a protected sh
VBA copy from single to merged cell.
RETURN TO C
Copy and paste values for particular column
Before print
VBA code to edit a formula in excel?
First-time Use Code
password protection popup
Excel 2003 protect not working in Excel 97
Move to a set cell if
Data Validation with additional input
Changing the active workbook
copy line nased 2 button on userform...
Assessing whether any checkboxes are checked within frame
Validation, how to see "today" date on top of the drop down list?
Test for for sheets existance
Followhyperlink using specific web browser
Userform Textbox multiline Vs format in worksheet
Help on cleaning / speeding up code
Disable Option in Como Box
Need offset range for loop
Microsoft Query using Excel
Using a variable in a formula
Pivot Table - display filtered data
import text file
Hyperlink Code only works when file saved on desktop
Autofilter method of range class failed
Menu item deletion
Last row in spreadseet
excel2000
accounting software template in excel 2000?
get HelpContextID's or Tags of all userforms
word automation
Error Handling to mitigate "Run Time Erorr 13 Type Mismatch"
One sheet e-mail
Dynamically name MultiPage Pages
ado command timeout property
MouseDown()-MouseUp()
Please help!
Template
Automatic Border along Pagebreak
macro in excel 2000 vs excel 2002
Adding Sheets to a combo Box
ranking cells in excel
Why can't you use brackets, braces like parenthesis in Excel?
help extending formula to range
How to set the value of a cell using its row and column numbers?
Parse out answers from a column
Range of averages
Code problem
Re: Subtotal - copy to other worksheet
Data sorting with a twist
Reading a text file line by line
how to retrieve properties of a file in VBA
Export UNIQUE rows to access with ADO
Subtotal - copy to other worksheet
Anything New with the Too Many Cell Formats Issue?
transfering data
Worksheet Sizing
Excel won't quit from VB.NET
Loop problem
Repeated Multiple Find
Numbering
Display of Record Set
The formula to determine if with 3 separate if conditions.
Accounts payable projection and tracking
comparsions of columns and deletion
Manual sequence to add a combobox/dropdown/listbox to toolbar
Move cell info from one worksheet to another buy click a checkmark
Delete excel file after copy
Delta
Getting text data from textbox
disable events does not work
Macro to view 'Print' dialog box
Before Print and UnDo
VBE PROTECTION
Programmers available
date problem
Trouble calling Add-In Macros
ActiveWindow.VisibleRange.Width - Is this the correct code
Re: find question
find question
Change cell value when right-clicked/double-clicked
Print VBA code in Editor format colors
Good chalenge on header/footer
Return of position on page in excel
ActiveX control error -
URGENT !! Drawing Programme in excel
Screen updating
user form error 9
Check if cell value is found in a seperate range of values
TEXT() function problem in Excel 2002
Array formula returning #N/A when inserting new rows.
Next w/o For?
Mathematical Time Conversion Formula
Help with complex formula or macro or solution
Fill-in Range from UserForm
Code execution interrupted on PrintPreview close
Controlling Monarch through VBA
Linking Multiple Workbooks
Access Question
Color text macro
How to fill an internet field using VBA
Add-Ins ???
Text color in listbox
Can I make an alert box with with a yes/no question?
Color Text Macro
Macro to synch three pivottables based on same data
Paste event
Array contents in module page?
VB to protect cells not working in Excel 2003?
How to fill an internet field using VBA
Creating and Destroying Excel Objects from VB
Interfacing EXCEL wir an RS232 serial device
If Cells.Find finds something
Vlookup
how to protect VBA source codes
Merge consecutive cells using conditional formatting.
How to get value of CheckBox in VBA?
Change zoom to fit different resolutions
Mutli-dimensional Array to Single-Dimension Array
Hiding Rows
Sort collection string keys
List in cell
Forms, Range Control
if statments using text
Disable Form Events From Being Triggered
Add Current workbook as an attachment
user defined function receiving a range as parameter
Counting Digits in a string
using vba to copy user-defined chart type
Using picture files
Resizing Picture
copy line with 2 condition....
using input from user to select wk1 to wk52
Adding shapes to xy scatter charts
Copy line based a click into userform...
First New Post
less than 0.5 but more than -0.5
VB code in Excel
filling userform textboxes
Locale problem
External table/range reference trouble
Flashing message in cell (alternate font and background colors)
VBA and SQL
Excel/Access ODBC
Use Macro to copy part of text in cell
Connecting To a Excel Database
Using VBA to access files in a list in EXCEL
Alarm, Play wav file
select cells in red only
vb exe crashing
Choosing multiple Criteria to populate a textbox.
run vba code dynamically of another add-in workbook
MsgBox Position
Find the nearest point to 1000 rows where "amounts" balance and apply special formatting to that row
.offset() function
Variant
Is Nothing
Deleting a chart using VBA
Disabling Security Messages (Macros)
Change Process Priority
AppActivate
Combo Box Sorting Update Problem
OLE Error
How can I call Fourier Analysis from a Visual Basic macro?
Why does this not work
copy column
Timecalculations : How ?
How to show messge box text in Excell work sheet
Selecting part text in a textbox
Scroll name in about-form for credit
Ok IM REALLY LOST.. PLEASE HELP
If Not equal to statements
Date returning value or day of week
Two columns whit same value
hide columns
Check box
Lock to copy/ modification data
How can I make For-Next loop with date?
Worksheet
Hlookup Problem
getting extra excel instance when controlling from access VBA
Run Macro & Rename Sheet upon creating copy from blank.
Convert Excel 4 Macros
RE: How can I make For-Next loop with date?
How to make a function change other cells in worksheet
Is there a Template for Church Business and Reports?
Copy method failed
Urgent help on floating segmented bar chart
RE: Urgent help on floating segmented bar chart
Disabling and re-enabling the AutoFilter from VBA
Late Binding or Late Anything
source location and error message 400
Code looping until machine freezes!!?
Help with word object
Dynamic Hyperlink
Help with Vlookup
Need to Add References
how to close active ie browser using a macro
SKIPPING A COLUMN
GetOpenFilename - Error
User defined type not defined
copyFromRecordset - vs - getRows
Check for previous entry
find values and combine in one cell
find values and combine in one cell
possibly array formula for depletion
AddIn functions in code?
Cell formatting
Selecting a row relative to the position of a button
Filter copy incl more than it should
Populate Combo Box with Text file
List all worksheets (and Document Names)
Media Player versus Windows Media Player
Macro Required - to process data
UDF Raising an error
Autofill
Find latest date for each row
DropDownBox?
dropdown.fontsize ??
Transfer rows with varying criteria
Project: Assignment letter
long list into printable view
Transferring rows with variable criteria
load local htm help file with HelpContextID
Path name in title bar-READ ONLY prob
Checking accuracy
Input box Type:= 8 not working
Selecting a range using a column number reference
Cells.Find for text w/ line break
No active cell
Removing items from listbox
Problems changing Embedded Chart Name
Re: VBA Question: User Form and input masks
VBA Question: User Form and input masks
Email body with a script and a table
Interesting performance "black hole"
Error message
simultaneous pairings
Why it is not pasting it to the correct place?
Copy to PDF
export range as picture
Rogue Admins
spin button code
Forms and scrolling
Sum (IF
Auto fill
How to detect if a workbook is hidden through VBA
Need help with odd behavior of worksheet rows
Code with query goes from greyhound to turtle speed
A new excel challenge
Dynamic Find and Replace String Within Functions Based on Column Values
protect and unprotect
protect and unprotect
Move Part of Cell String
Imported file Date formats unrecognisable/unconvertable
How do I program telnet using exel through dos?
Security discussion - how to effectively distribute an Excel file
VSTO Date Evaluation
OPen excel workbook...
Copy Down Formulae
problems w solution 4 enable AutoFilter for a protected worksheet
How can I copy data from one workbook to my own workbook?
printing the project
How can I copy data from one workbook to my own workbook?
too many combos
i need help
Problem with AppActivate.
to update or not to update
Allow user input, but not format changes
How to see columns from which values were not returned by HLOOKUP functions?
Count Numerous Matches Only Once
Variable Acting Like a Constant?
CubeFields
Address Property
Determine if an excel file is already open
Download from SAP too big
Passing an index to a second workbook
Data sorting a crosstab table
Filtering and coping w/combobox
Chart Objects Error
Find a value in a column
Selecting multiple criteria HELP!!! :(
Excel 2003, paste special menu
opening a .csv file via VB
Row Reference
Golf League Help
Entering subtotals quickly in several columns
Same value in cel
Text alignment within a listbox
Copying sheets form other workbooks
Sort Data Automatically
How do i can countinuously update time?
Smart Application.Path
emailing in Lotus Notes
Compile error: Can't find project or library
Excel strange (erroneous?) decimal behaviour
closing excel
Search Google from Textbox
how to check if folder exists
Find part of string & delete row
Changing the text color of a complete row ...
Macro when Inserting Line
Sending Mail from VBA
How to replace a function with its resulting reference in a formula?
Activex control button problem
Select a varying range of text and paste into a cell
what is mean by ^ in formual
Insert calculation with VBA is slow
Paste Method failed (Activesheet.Paste)
comparing data in two similar format reports
Dos Directory
Personal.xls
How to Clean up exported Userform.frx?
userform problem
How to replace a function with its result or resulting reference in a formula?
showing / hiding gridlines through VB code
filter using VBA
VB-macro - Copy from another workook
Chart problem.
Quick question - quick answer about assigning shortcut keys
Loop through cells meeting conditions
CustomDocumentProperties problem...
MatchEntry for combobox added during runtime
Activate and Display a Workbook in Internet Explrorer
Printing Help
How can I copy the data of sheet 1 to sheet 2 with modify?
Copy Cell to Same Cell on Multiple Sheets
Saving file using data from worksheet
Highlighting entire row
VBA ".Find"
Convert code rows to columns
repost: Need Help With Steaming Data Macro
Excel opens All files in Default file location
customize calendar (some dates in red color) in excel
Importing csv data into worksheet from the web
How do I Sum variables
.Net Excel Add-in missing Images in ListView
Paste method fails in VBA
Relative Ranges in excel macro
One custom menu copies
Linking access records in to excel
Disable "Select Multiple Items" in Pivot Table
Display contents of (Multiple Items) from Pivot Table
reset the data range...
Exported Date Format is Changed by Ecxcel
Excel VBA to click 'submit' on form
how do I add paramters / criteria in the excel query?
Userform/Module
Select Case help
ColorIndex and Caps Change too slow
Macros with the VBE
Add the specified number of work days to the a date.
convert to a number
Writing data to SQL server
Last Row of Selection
change font color whenever click a page of multipage control
Copy filterto workbook
Custom Number Format
Maintain focus on one worksheet while collecting data in others
Application.Calculation gives run time error
Stumped on Array
before mail
Form Close Button
Pivot Table - 3 columns turn-around-times
How to find the rows existing in one column but not the other?
OLEOBJECTS IN WORKSHEET ARE WACKED
Identifying Objects (again)
File name in Vlookup
Get the list from Autofilter after filter some criteria
Conditional formatting two rows at a time
cannot shift objects off sheet
IF THEN-HIDDEN ROWS
Finding cell address for minimum number
How to define tab key settings?
VBA does not recognize Excel worksheet function "indirect"
One macro to rule them all
Re: What is wrong with this code?
Moving cells to another sheet
Refencing a Microsoft WORD Library in EXCEL VBA
HELP with this code!
Verify the format of the content of a textbox included in a frame
Removing Cells from an Excel Range
How to clear items on a form?
What is wrong with this code?
Selected Cells Menu
Create floating button based on button click in menu
Want macro to select current cell
Using Wildcard on Workbooks.Open
Validation Question
Color Rows
Help on Vlookup for Undetermined Range
Returning Columns to a List Box for a Holiday LookUp Table
Follow on to: Determine if a workbook is already open
what is stdole reference in excel vba library
Formatting text in Commments to cells
Advanced Formatting [2]
VBA
Adding Excel charts to PowerPoint presentation in Office 2003
Copy tab delimited string to worksheet row - VB6 application
Excel and Vba questions
Open an existing workbook and reference it
error in XValues
Use VBA to format paint cell(s)
using VB to filter
Formulas in Pathnames
Restricting Characters in a cell.
Is this wrong?
How can I upload a file to my webfolder?
Halt all code while macro runs
Can't close e-mail
Userform from a Userform Problem
Read Binary
Variable table array name in VLOOKUP
New Job
working with large text files
Excel: I can't see the worksheet tabs on my screen anymore. HELP!
How to display data in Combobox with no dups
Accidentally Protecting Sheets
Retrieving range string from named range
"ByVal Cancel As MSForms.ReturnBoolean"
Attaching sheet to e-mail
Validation inputmessage multilines
How to transpose an excel worksheet having more than 10000 rows into a text file, may by tab delimit
Too narrow columns
Save workbook with 10 different names
Change "Properties" of files
Problem Pasting entire row.
How's this verification done?
Advanced Formatting
How to force Excel to NOT update hyperlink paths?
Add double quotes to each field
Worksheet reference vs Worksheet("").Activate
Consuming a web service in Excel 2003 that requires a certificate
Creating a back up copy.
Refering to Public Variables in Functions
Find & Delete Duplicates across two Excel Worksheets
Fill an individual report with values from a team report?
How do I copy a worksheet form a workbook in my workbook
Run Time Error 13 Type Mismatch
Select Case, Less and Greater than?
Excel VBA: Browse For Folder - Cancel Button
Preventing automatic upgrade of references to ADO
Cancel RefEdit
VBA to Merge Cells
LIKE in Excel VBA?
How to activate add-ins for particular files??
Force a Message Box to close unanswered
copy userform input to cells
#NA error using vlookup in vba
Sorting Data.... Help!!!!
Locate cell name using variable and looping
-1^2+1 vs 1-1^2
event with commandbar button right-click?
From excel to word
Trouble with web services in excel 2003
Rank items in VBA Array?
how to write a macro for solver function
copy paste special values
Chart on a Userform
Dropdown Sub Menu
dialog box to pick path & file
Easy solution need for find problem
time stamp a cell that doesn,t change when time stamping another
type "cheese" in a1. Click cheese and get picture?
data entered on multiple sheets also added to summary sheet
Automated data entry
New Sheets for hyperlinked files
time sheet help
Macro sheet by sheet error
Distributing Macro's and Personal.Dot files
Retrieving data from work sheet to USER FORM
Form creates new workbook and pulls data
IF THEN FORMULA
Can this be condensed
applying a macro for a specific field to a range of fields
Data input macro
Data Field in Pivot Table
Identifying Objects
workbook open query
UDF for opening most recent file added
Prevent User from Going Past a Certain Cell
I want to make one loop
How to hide a textbox
VBA Beginner: Help with Checkboxes on created User Form
Userform searching and update
filter a combobox
Determine if a workbook is already open
Search & Extract various strings from many files to one excel file
List Box Multiselect Form
please help
please help
Re: Set as read only based on user name.
Select last worksheet in workbook
Searching multiple columns
Set as read only based on user name.
Add data to different worksheets in same workbook
Data Entry Form (similar to default Excel Data>Form)
Arranging data
List box: Populate with Range Names
Using Excel VBA to close IE
How do I count cells in spreadsheet that are not empty?
Pathname reference
MaxLength Property issues
Clearing Ranges from Multiple workbooks.
vb code help with date format
Re: SAP BEX
Run an External .exe
Re: SAP BEX
VBA in Excel - Public variables & VB 6.0 vs version 6.3 in Office
VB executable
Group date into Year and Quarters
why am I getting a 3010 error?
using a range in a custom function
Get File Size (Number of Bytes) of Active Workbook
access closed workbook
Can't Trigger Event Procedure from a Checkbox created on the Fly.
Link Checkboxes and Grey out the Check
IF ... and... HELP ... :)
check if worksheet is empty
Concatenate to a text file
InStr GRRRRRRRR!!!!!!!!
How do I create a range with all values in a sheet?
Assign Macro 2 a Button....confusion
Long running macro and screen update
Creating a varying UserForm using cells from a hidden worksheet
Wrong number of arguments - Help
Private Sub Workbook Open() - question
VBA Coding - any ideas why this UDFs not working?
Re: How to write an average formula from VBA- SHOULD BE SIMPLE!
Re: Help with VBA Mail Merge
Conditional symbols
How to check if Software is loaded on a users C: drive
nested if loop with logical OR/AND
search for string within a string
Large documents and Java
Re: building a reporting sheet which reports by date and shows values of another sheet
highlighting duplicates
Re: How to write an average formula from VBA- SHOULD BE SIMPLE!
Re: How to write an average formula from VBA- SHOULD BE SIMPLE!
Re: Pass Excel User License to Variable
Re: Pass Excel User License to Variable
Advanced filter in VBA - criteria in non-adjacent ranges
Sorting multiple columns as one
RE: Copy row if....
Re: Copy row if....
Re: How to store current row into variable
manipulate string
Working with Rich Text Format
Write variables from a loop, once only
After VLOOKUP!
Advanced filter: criteria in non-adjacent ranges?
newbie help - code need correcting
Find first empty row
RowsToColumn
Using XLA to load VBA program
Dynamic calculations according to user input
Sum
Linking to external workbook
subtotal question
Linked sheet design theory
to click on a cell and go to named local HTML file
Capturing Steaming Data Macro problem?
Countif declaration problem with ""word""
VBA, Excel Date Problem
Need Help with Macro Code
Simple Question
Watch to Trap Protected Sheet (Repost)
Run Time Error 1004
Excel Templates
[VBA] Creating sheets based on criteria
Looping through a group of checkboxes
pastespecial question
send email with email addresses in a range of cells
Pasting Values of range to another range
Just the numbers please...........
save as from combo box list
Accessing Microsoft Access Tables
Do not know to how reference another sheet in my formual - embarrasingly simple I hope
COMBOBOX
Microsoft Discussions Page Layout
Disabling Menus
Dim
resize question
hiding a workbook
How do I "conditionally" change font size based on text length?
Find Duplicates and Append
Send button in Excel
transposing and creating new rows
Macro with Drive-change?
Supress screen update while writiing to another sheet
Macro to Change Font Color
Opens directory
Optimization question: how to bypass copy and paste
Sheet1.Activate vs Sheet1.Select
automating a procedure
Error 1004: Calculate Method of Range Class Failed
Random Sequence with no Duplication
formula
Sizing of copied columns
Data > Table
TreeView
Add Sheets
Macro
Error Handling issues
wrong reference after dragging down a formula
General Loop question
VSTO Cell Alignment Enumeration
Question regarding "INDIRECT" and Charts
Range select
Extracting column number of max value
? activate a commandbutton in code ?
Repeating macro procedure on several worksheets
Continuous Range
Loop through Combinations and Keep a Count
today() bug
VB code needed as this is way beyond a novice like me!
Run several macros in a row
Help with Object variable error
Deployment of Microsoft Office Xp Primary Interop Assembly
Which control caused the macro to run?
making a formula over varying ranges
Control Face ID's
Automating to generate the next Invoice No.
Editable combo. Elaborate code example wanted.
HyperLink
Naive question on Range naming but please answer
Re: Save workbook, in .zip
Save workbook, in .zip
Strange conditional copying of spread sheet??
Paste Special
code skips blanks in data
Im literally a beginner, please help!
drag formula down with other reference
Help with code
copying combobox
i = input box - help
Autofill dynamic no. of rows and columns
VB Code help
Playing sound in VBA
public function
Adding Labels to XY Plot
Very Strange Error when using Format()
Read out VBA code from a damaget excel.xls workbook.
Copying data to another sheet and sorting it automatically
Multiple selectboxes on one row in a listbox???
Combobox_change does not repond?
Error opening recordset where table is empty (but has field names) - How do I avoid?
Saving Excel workbook in SQL server using c#
problematic problem
Saving Excel workbook in SQL server using c#
Avoiding macro run for terminating by user
Saving Excel workbook in SQL server using c#
Can I get all fields for all tables in a FoxPro DB into excel (one table per sheet) automatically?
copy all named ranges in a sheet to seperate sheets
using cell data to name a range
Compare multiple listbox contents
Excel instances remain opened
VB Complie error - can You Help
variable interest rate calculation
Autofill with changing data
Error while Checking for Regular Expressions Library in VBA
change curdir to a folder on a network
Maintaing a Data List
Conditional Formatting or a Formula I think?
Embedded queries...
Re: PasteFace issue
Navigation Command Bar
FOR EACH statement
Display Last Figure
Command Button
mouseover-event
Copying individual files (workbooks) into worksheets
Message Box Colour / Color
Printing a Sheet without opening workbook
FollowHyperlink automatically
IE Window Name
IsNumber question
Conditional format question
Reading the Clipboard Source Information
display and change listbox data
comparing rows and deletion
Visible Instances of an Application
web page title into range "B1"
Conditional Formating a range
Code Doesn't Wait!
Docking the Watch Window
Range question
Data Validation List
VBA Printing
Combination Formula
Can Excel act as Access?
Bypass entry of data from Lookup Table
Create a list of unallocated payments
deaking with nulls, I think...
Macro to go quickly to a sheet
How to copy the hyperlink of a list of cells in another column
Unlock VBA Project
Userform access on multiple excel files??
Find last used cell in row with blanks inbetween
Copy/paste error help
Newbie: Can't delete to left with WScript
DOS....there must be a better way
Selection
Range problem
VB code help please
formula help please
Keep getting runtime error 1004
Microsoft Excel 11.0 object libary
Extract cells
Worksheet tab popup menu not working
Delete rows with numeric values, leave rows with text
copy question
renaming sheets dinamically
Formula help
Workbook_BeforeSave Head ache
Macro help please
Excel macro to open files within a folder
Printing pdf
Compare cells and grab if matched
Unexpected SaveAs prompt for workbooks with pivot tables
Trouble with Calling a workbook
Why does memory usage expand so much?
Problem with references/variables
Open A Word Document from Excel
does excel know in which cell a button is located?
VBA and line graph
comma as concatenation operator ?
macro to add in a column by manipulation of other columns
de-link *dates* in chart from data
Select Case for Active Worksheet syntax.
filter of column problem
Excel VBA Help
Row Number of Max Value
Capture ENTER
Macro to append En Spaces
double click and move over
clear the values, but not the formulas in a range
Index Match #N/A error, please help
how do I refer to a multi-sheet named range
RE: I hope this Excel question belongs here...
Runtime Error
Userform.Lable Variables
Storing Sheets Names for loop
Color added to Dos