Microsoft Excel Programming [Archive] - Page 27

Move and Link2
Re: Recording Historic Trend Data
get cell value and use it in vba
Pivot table cell format
Re: using Outlook Redemption - help needed with some code
FileFormat actual values
Strange behavior with old macro now throws error with "Application
NEED HELP! Macro loop
Find difference in min and max value
Move and Link
Copy structure chart
UDF for Sumproduct
Syntax errot
Naming Ranges to use for Solver
using Outlook Redemption - help needed with some code
PROBLEM: ComboBox text size increasing every time box is selected
RE: Help with hidden columns
Re: Calculate phases of the moon
Recording Historic Trend Data
Re: Help with hidden columns
Re: clock use
Re: clock use
Shifting cells to consolidate record rows
Sorted data macro not working. Advice request...
Help with hidden columns
Please help! Macros
Add a message to this array.
Excel animation
Data Validation
Computer lock time
Excel Creation/Manipulation Programmatically in .NET
Multi macro inputs
RE: clock use
Reading From & Writing To an Excel Database
How to format a line between two points on a line chart?
Naming a listbox as a string
Select case question
Delete rows based on results of cell tests
VLOOKUP help
R/T error 5 - invalid procedure or argument
Lock cell if based on value of corresponding cell
Workbooks_open()
Variable declaration in Excel 2007
New Spreadsheet Created Based on Value Column "O" (alpha)
What is wrong with this For Each statement?
VBA
Selection multiple ranges with Cells property
I need to add column based on two conditions using Excel 2003
Select Case question
right click menu
Resizing points
Can anybody get this code to perform on the correct worksheet?
Last Row Code
Assigned Macro to button
Change the size of the font in office programs
chart error bars
Determine the best km/h
Test if cell value is in an array
Getting to the right worksheet
Filter by macro
Excel 2007 | Add-Ins Ribbon
delete picture within a specific range
Variable column problem
retrieve specific info from different 'groups'
Searching Google for NG postings
Save as, changing default fileformat in Excel 2007
Lost post Re VBE
find/delete row when cell has less than 16 alphanumeric characters
Excel 2007 Add-ins
Programming resource
Command Button & Font Size
4 Macro inputs, 1 out
VBA to add one to columns on condition
unmodifiable comment macro
Eliminate resizing points
Date Modified and By Whom
Re: Not able to copy a VBA array with formulas into an Excel range
How to add Checkedlistbox Control to VBA?
Cut and Paste dark blue and red text
Re: Vlookup & ErrorType
Copy sheets to mulitple workbooks in a directory
Printing Macro
Add up to zero
Excel function to update time every minute
problem with UsedRange
DATA LOGGING
Re: MATCH and INDEX combination using multiple criteria?
Hidden VBA Code
Test for Optional and Asign one Range to another
QueryTable Problem
Microsoft Security Warning
Ecape key to close/exit sheet
Help Pls - Changing Txt on Msgbox button
Can VBA use array constants
Test for condition before running macro
Excel-2007 problem while closing the files
Find cursor position relative to extents of a picture
Module / procedure name detection
Recording macro usage
Time
Looping through delimited text and using VLOOKUP
RE: MATCH and INDEX combination using multiple criteria?
excel 2003 output file
macro
vba versus vlookup in excel
Excel 2003 with 6 Conditional Formatting
Start when open file
0.6237571 Look Inside Now ... 0.2499105
0.2718226 I Want To Look In Here ... 0.2651864
Case sensitivity
achieving sequential numbering
Copy PIVOT table?
Loop thru a Validation list
animation
HUGE macro
Delete rows if not as range
Go back to update my data with my data entry sheet
Simple formatting question
Re: Calculating Due Date
Stored procedure in SQL + vba to return a subset in Excel based onLIKE %varchar% clause
RE: Calculating Due Date
Re: Data Validation - 1st or 16th of the month only
RE: Data Validation - 1st or 16th of the month only
Re: Data Validation - 1st or 16th of the month only
format code not working properly
Form shows in the vba
Avoiding an extra sheet when creating a pivot table
How to fix mystery sheet
How do I count the number of rows selected?
Input Box Q
From Excel 2007 to 2003
Sort Macro
Multivariate statistics
Filling out forms and make one cell entry appear the same in anoth
fin last row withtin a range using built functions not VBA
HELP: Is it possible to use VBA to update links in multiple workbooks?
Autofilter on Day
recalculate hyperlink location
Message Box on Input
How to format ListBox columns
Plot graph depending on drop down box selection
How can I indicate in a macro to which last sheet to return ?
macro
Repost - XL Project Protection
Type Mismatch Error in Array
Missing Control In Addin
Create validation list with Worksheet_change
Enabling libraries using VBA? Can this be done?
Creating Formulas using BV
I want to sum all data values in a row EXCEPT the lowest two
Copy range from workbooks into one master sheet
Extracting data from consecutive rows into every "nth" row
programming
Import txt file with fixed length from VBA
football games
Programatically Export Excel Chart to Graphic in SharePoint
using user input as search criteria
copy range using
Expected expression error help
RE: How can I make clickable boxes for cells?
Re: How can I make clickable boxes for cells?
XML API in VBA under Excel?
Display New Table Style dialog
Sum columns of data in vba
Macro files will not open
Loop a specific number of times
Remove Formulas then Delete Cells based on conditions - XL2003
Populating a Cell by Choosing from a Pick list in another Cell
Run-Time Error '1004'
saving a copy without formulas
Excel Add-in problem
Find value and move to end of data in same row then move values in
Add one to Column numbers
copy range using last active cell reference from 1 wkb to another
HOW DO I SETUP NUMBERING INVOICES
Reproducing sheets with values only
Convert date to serial number
Reuse xmlMap
Excel Macro to Compare two Columns and write to a third
Create WorkBooks based List
Print hidden sheets
Find a blank line and put in a formula
Need help writing a macro to Save changes in a worksheet
Replace cell formula with revised text as noted within a cell valu
DoneX XCell Compiler
transposing data question
Re: Re-numbering Excercise Using VBA
Printing Excel to CutePDF
Ball bouncing
Select Case or If - What's the difference
Select Case not working - Why?
Add image
VLOOKUP
Drop Down Menu - Data Selection Request
Re : Excel FilterMode to Trigger WorkSheet_Calculate()
Counting rows in a column
Excel Calculation Problem Formula etc
Help me in printing a hiden sheet
Printing a hiden excel sheet
what formula would I use to add information in a range of dates?
Copying data from 100 tabs to one summary page
Copying data from 100 tabs to one summary page
Copying data from 100 to one summary page
Copying data from 100 tabs to one summary page
ecm2001 crack torrent rapidshare download 14150236317832207766
Changing Sheet Cell Formula Reference
Copy a row using VBA
Moving to newly Saved Workbook
Automated Sheet
Changing Do Loop to For loop
Bin2Dec
Run-time error: The object invoked has disconnected from its clients
Need Macro copy range of cells
Email specific addresses
Capturing YES/NO from two option buttons
if and statement
Macro Printing
DateDiff() problem
Excel 2003 macro won't run in Excel 2007
Code jumps to WS_Calculate on a different sheet
Removing a macro button after execution
Display an array in a MsgBox
Userform Listbox subcategories?
Excel not showing steps as I F8 through each line of VBA code
conditional formatting test
runtime error 3343
Obtain User ID
ranges
Conditionally-like formatting just a part of a cell
Email with mailto equivalent
Sort single column
Code optimisation
find wildcard text between {} cut, and paste in another cell
Return Rows from another workbook
Powerpoint and embedded Excel sheets
How to count # of dates that fall between a start and end date.
Date Variable
Password protection worksheet
a deployement problem
Macro Help
Copy cell contents to access form
Excel 2007 Import .txt file error 1004
ActiveX control causes "Reset project" notice on file open
Editing Text File Without Opening
Creating a collection of visible worksheets
UDF + managed code
cells that are outside the range of cells defined in
Retrieve cell value & format at the same time
RE: post to different sheet
RE: Determine user's Email Address
Expand selected Rows
Dynamic Link Library
Excel Macro not running after enable trust.
Enter File name in cell
Comments
Populating one cell using multiple checkboxes
Excel Waiting for Another Application to Complete an OLE Action
Re: Calculate phases of the moon
Type Mismatch (13)
Comments
Userform combobox: best match on partially typed content?
Range to an Array doesn't contain values
vlookup help
T-SQL with a added field
Vlookup error
finding and summing case-sensitive text
Referring to column or row grouping using VB
macro to save as
adding row
adding row
run-time error '1004' general odbc error
Stepping through VBA code, Excel not performing actions on split s
Last cell touched on sheet
Cut Contents and Paste
Code to split Worksheets into seperat workbooks
Macro to compare two columns and if condition is met write to a co
Application_defined or object-defined error - Run 1004 error
Activate Excel when double click
Scroll specific columns only
How do I Match Data usign criteria from 3 columns?
PDF
Excel 2003: Help with Drop Down List
Basic Macro Help
Macro to Insert Unique Password for Multiple Excel Files
Insert Table into Shape
Get data reference to last row
Combine Duplicate times and SUM values v2
Combine Duplicate times and SUM values
Condition formatting problem
Date Variable
Use late binding to get at the FORMS library
worksheet_calculate
convert text to number - performance problem
assign macro - toolbar
Filtering For Data Using Macros
How to Post data to website to VBA
Restricting sheet_selectionchange code to just one column
How to Create Unique Reference Numbers for rows of information
I want to define title rows -1004 ...
How to restric another excel app to attach to the created applicat
is it POSSIBLE to create a Database in excel using VBA...
Formula to get number + 80% from previous
Scatter Graph - bring line to front
RE: Screen tips
split worksheet into multiple files by every 25000 rows
Autofilter - Contains
Auto open Data Form
RE: csv data into forms
Vba Formula To Include Activesheet Name
Can I assign a formula to track when another cell is changed?
Printing integers from a userform
How do I run a macro from another file?
Help With Macro - Cannot figure out what I am doing wrong
How to copy worksheet from one excel file to another
Finding an exact string in a range
Pragramatically grouping items on form
convert text month to numeric month
if-then-else in VLOOKUP function
Slow Macro - Formatting Macro
Macro Digital Signature
Can Relative dates be used in a query?
Are relative dates avail in query?
Virus Verification
Code doesn't disappear
Excel 2007 Save as .xlsm
How do I compare two sheets and output a report?
Sorting dates
Excel 2007/Vista - PastePicture Problem
Why so many "Service Temporarily Unavailable" errors here?
Printing odd and even page footers
Printing odd and even page footers
Excel Query Causes Access To Go Read-Only
current year
Pivot tables using multiple tables
Multiple Data Sources - 1 pivot table
Creating Ranges
Default File for Excel 2007
Controls on Sheet
update of worksheet cell extremely slow
vlookup
source sheet name as a wild card
Using Find to Cut & Paste
(Excel 2007) Query Data in Database?
How do I respond to prompts "Too many cell formats"
End (xlDown) question
Extract and summarize data
Office 2007 Shortcut Menus
Arctangent problem
Programmatically list references in Excel
HOW DO I USE EXCEL TO CREATE FILEs AND FOLDERS FROM A TEMPLATE?
VBA SUM Function
Copy
Language independent formulas
Apply maco to multiple worksheets request
How to extract complete HTML code in Excel
Export of select query data to excel in Access 2007
4.0 macros in Excel 2007
Creating and transposing a multiarray
Calculating Pay Periods
Counting Macro
Sort Pivot Table by Gran total automaticaly
Pivot Table
range selection object code
About the need for digital certificates
Date: Auto text entry based on aging
WriteLine function
Copying a differing range of rows to a new worksheet
Change worksheet, two trigger cells on one worksheet, only one triggers correctly; using two If statements, do I need End If?
NewsGroup - Windows Mail
Finding a file
reseting hidden shape counter
Change date to display as # week of the year
How do i enter data in different workbooks from daily data
Option box text - linked to cell
Controlling 3270 Through Excel
column letters and numbers
Deleting rows when certain cells are blank
Office 2007 Shortcut menus don't stay on
On event settings
Creating an Excel combo list in VBA
Pivot table help
Content of Cell clicked in another cell
Password Protect Unhide Worksheet?
Minus Dates
Summarize Data
PasteSpecial values pasting formula also??
Level of Indentation of a cell
file size becomes very big after copy
Trap Save / Save As for all Excel workbooks
AdvancedFilter and setting the range
How to add condition to coding?
Export Chart as TIFF or JPG
VBA just stops when opening a macro workbook
VBA to center Selected Cell in Current Window
xl to word procedure - troubles with references (xl2003)
Multiple Object Right Click Event
An Easier Way
Refedit very serious/urgent problem
RE: Creating a range by going down a column until an empty cell is fou
Transposing in groups of rows
Replace number in formula with ROW number
Chip Pearson's DistinctValues function
How to add condition to coding?
Remove code from a worksheet before emailing
Have TextBox display a dollar value
Excel Updation
Hyperlinks fail when constructed using Autofil
RE: Remove time from date
Re: Remove time from date
Open sheets as per the range
RE: Remove time from date
Find the first lowest value in a column that exceeds $foo
RE: Macro to delete rows until a row contains a certain text string
Pivot Table Range
Can I change the reference to a named range via VBA?
Text String (Edit w/Carriage Return)
RE: Excel 2003 with SP" 1004 error
RE: Excel 2003 with SP" 1004 error
RE: Excel 2003 with SP" 1004 error
Combobox Dropbutton click event
need a macro explaining
Sorted range into collection
UserForm MsgBox problems
variable page breaks
Add.item in combo box not working
How to programmatically set Error Trapping in VBE
Dim c as Cell
Tricky OFFSET routine
Sort Dynamic Range
Run-time error '50003': Unexpected error
Auto-expand/rich auto-complete option in Excel combo boxes
Number of Characters in a Cell
Dynamic Pivot Item Selection
Delete All Q
Column header letters
Autofilter run time error 400
Find. On other sheet
Getting #ref error after row / cell is this a limit in excel 2003 tia sal2
Picture alignment
Macro to generate list of folders
macro doesn't work
RE: Small favor
How to share macros from personal.xls?
Re: Find & Format Data Using VBA
function runs in VBE, but not from spreadsheet
SQL code pivotting
Need help to increment default WorkBook name in code
Why is search nonfunctional in this discussion group?
multi level conditional formatting
Macro to delete blank rows in a worksheet
Conditional Formatting More than 3 with Formula
Excel 2007 - Data Form
addin detect worksheet activation
Refreshing one cell
Macro to Update all worksheets
Declare Non-contiguous Columns as Arrays
Sort Pie Chart by slice size, don't sort data
RE: Find & Format Data Using VBA
Need to move row from worksheet to another
March Madness Excel Bracket
March Madness Excel Bracket
Getting #ref error after row / cell is this a limit in excel 2003 tiasal2
Call .BAT file with paramaters using Excel
Getting the sum from filtering
Date Picker component
Copy paste - Values - formula - Optimise
Copy and paste a row from a table
Macro to open view with a password
XLM Macros: Problems With Custom Toolbar Buttons
Userform Text box Format to Currency
Refresh pivot data automation
overflow issues...PLEASE HELP!!!
Force to update textbox value to cell
Importation donnée Web sur excel avec authentification
Help on Excel Macro VBA
Go To Worksheet.Cell Referencing Another Worksheet.Cell
DateTime format
Set variable date range in query?
Frames on Form
delete if contains
Can Application.Vlookup access a range in a file which is not open?
Sort and summarize code help request
Microsoft.Office.Interop.Excel very slow and crash after writing a
Using a Combo box
a registry problem
ComboBoxes
Send Mail Commands
Deleting shapes with VB deletes cell validation as well. EH?
Controls slow down worksheet response times
Cannot select multiple controls
Textbox values
Stopping duplications been entered into a listbox
Worksheet_Change for Row Insert
Worksheet Sort Order
Re: No Index Violation when adding data in Acccess from Excel
follow up to Gary's Student macro
Clearing option buttons
Workbooks.Add question
Macro Crashing
Link to cell from PowerPoint
combobox selection to change cell range data
Sort selected range
Looping Macro
Deleting all code in new file only (creating using save as)
Assign copied range to a variable
How to set value of Textbox in loop
Convert Date
Macro to Auto-refresh a pivot table
[Excel 2007] Maybe a bug with Dialogs(xlDialogSaveAs)
Sort variable range in descending order
User defined menu stops working when workbook saved with a newname???
Set OptionBox value via VBA
Command button to run a macro
SQL in vba using excel sheet as my table
re-setting view of sheets so A1 is top left
Set all sheets to see A1 as left top cell
Trying to copy data to a new sheet and row
Msgbox Without ok button
template path for active workbook?
Jump from Excel to another application
SaveAs
Detect when Word document is updated
Emailing Worksheet - adding muliple reciepients
R1C1 notation in VBA code
Excel 2007 Copy or AutoFill issue
Create Your FREE Niche Search Engine For Earning Affiliate Program
Where to post Qs about kernel32 DLL usage?
Send UserForm Data to .DOT Template
Re: UIRibbon/VBA/XML question
Add to CommandBars in C# without addin
Add to CommandBars in C# without addin
Add to CommandBars in C# without addin
Add Menus to Application.CommandBars["Cell"] C# without addin
Add Menus to Application.CommandBars["Cell"] C# without addin
Add Menus to Application.CommandBars["Cell"] C# without addin
Dropdown list of hyperlinks
Macro not repeating output from search function
Linking Cells Macro
reading a string in a png image file
Lotus WK4 Excel not showing pic images
i need macro help
Formatting a date from an input box
General vs Date format question
Using the Application.Caller function
Is there a "ChangeCell" event?
Run code from within a UserForm
Testing for Digital Certificate in VBA Project Programmatically
Using macros stored in .XLAM add-on via custom RibbonUI control
List unique values from multiple sheets
What’s wrong with this countif procedure ?
PDF file size
Can you auto populate a cell by clicking on it?
for x to - next x question
Combox Help!
Using Text in a Formula or FormulaR1C1 property
Re: Delete Specific Rows Using VBA
Running macro from another sheet - VSTO
Re: Delete Specific Rows Using VBA
Re: Delete Specific Rows Using VBA
How do I create a macro to remove blank rows...
Macros
Importing Data from Access Query to Excel Sheet
userform combobox rowsource from database
need code to copy text from workbook and paste it in a new outlookmessage
Accepting solver solutions automatically under VBA
Go to top left cell of selected range
Disabling "group edit" mode in Excel
how to clear my content in cells but keep the conditional formatti
programming etiquette
RE: Button Text Gets Smaller When Button Clicked On
Looping through a listbox
Dynamically create drop down box when cell value changes
Triple Number
Data Validation doesnt work with Copy/Paste
Close Match
VBA and loading forms (Excel 2002)
Create new pattern in Excel programmatically
Can I create a new pattern in Excel programmatically?
if formula
Querytables.add with sql query text stored in separate text file
Redim preserve does not work for me
Sum the Variable Range
Securing codes by corrupting the file (Leo Asked)
remove space
Custom Number Format
Add new Patterns to AutoShapes in Excel
Security
Seks v polnolunie
Seks v polnolunie
how to clear my macro tabulate content?
Copy/Paste Problem: Runtime error 1004
Which references am I missing, to call Outlook from Excel VBA?
Pivot date, that's all
Can read all threads other than those I want
Fill in of cells excel 2007
Step thru a function procedure?
Determine if Sub Exists
loops
Number pad onkey IDs
udf for returning names of wrkshts in active workbook
Finding the Max Number in a Table based on Other Criteria
HELP: Error Occurs With Macro Making a Pivot Field Visible
macro issue
Automated google search
Auto fill cells
Using a Form to control variable fields.
Time Tracking problem.
faster method to delete rows
Public Range Constant - how do I?
IF HELP
assigning macro
Need help with merging a range of cells
ELAPSED TIME BETWEEN TWO DATES
DETERMINING NUMBER OF DAYS / MONTHS / YEARS BETWEEN TWO DATES
Match or Lookup
Test if an element of array is empty
Embedded chart alignment
Input format
Using flowchart in simulation
Shift+F9 results differ from Sheet.Calculate
Reference for Trim$ ???
Sort Macro
tabulate output data from different combination of input.
change image in picture object
display pivot refresh date?
A bug : Run-time error '1004'
Clear value if cell changes
Java screen
F9 not working
Re: Lookup dates
Job Ideas?
Finding a specific text
macro adding
RE: a doubt
Message Box - Yes/No
Lookup dates
conditional formatting
Autofilter used programmaticaly causes error
Auto emailing of files
Exiting listboxes in a userform
Making cells mandatory to fill in
Match Files
Date/Day VBA Calculation
Excel 2007 Custom Right Click Menus for Connectors and Shapes - Re
Macros 2
Change Control Toolbox Button Caption
how to catch these events?
(Repost) new order of table
RE: Quotes and CSV files
Macros
rows to columns
Importing Text File problem
Include function arguments (like range finder) in Add-in
string manipulation
Teach me to Merge Data
How to call GetPriorityClass,GetThreadPriority?
DEC2HEX
RE: Find and Delete
RE: Find and Delete
OrderThenFindEmptyCell
Count every group of numbers whose sum is zero & put number next toeach number
Using a variable in an If statement
ADO to XLSX file from Excel 2003
Pass a worksheet as a parameter to a function?
Remove custom menu
sum a range
Text Box not showing inputted value
How can I align pictures to the columns in code
Macro to Copy Defined Name range as a Picture file
Chart Source when copying sheets to new file.
Clear Contents of Specific Cells in Last Row
Open Document Format (ODF) and Office Open XML
Formatting Macro using rowcount
Macro/Trust Center Settings
Cell reference in code
Synchronize sheets by row?
VBA - Programmatically Open SP Files
Clear a range of data
Password To Run Macro?
FormulaArray in Excel 2007
Copy range values in C#
VBA Check Spelling doesn't highlight misspelled word
Autoamate Concatenate Function
gallery in 2007 UI Ribbon w/xml
Variable menu with single "on-action" procedure
Excel 2007 Custom Right Click Menus for Connectors and Shapes
pivot table show items with a value
assure that calculates ends before save to pdf starts
Create list of duplicated numbers
filter and delete
Lookup closest to
How to assign a macro to a pivot in Excel 2000
Match file names listed in column with file names in folder
customised userform
Merging data
how to get excel to combine numbers to a given total
VB for Chart Axis
How do I reference a Worksheet from a Form (Add-in for Excel 2003)
RE: No Index Violation when adding data in Acccess from Excel
progunta
Automating Excel from Word - How to Sort a Range of Cells
Macro to Open excel file when file name is entered in cell
Extract Data Code Modification Request
Reporting Service
Add Number to variable date
how to access data from excel to/from another program using Vb
VBA Quick Question
Enter
Named Range or through cells
How to stop Macro warning on opening workbbok
Excel 2007 Print Preview
Why does this not stop when I push "yes' or "cancel in the message
Problem opening folders with hyperlink (URGENT)
Check Refresh Status of External Data Query
Import URL picture into Excel cell
Save Method Of Workbook Class Failed
Strange cut and paste result between worksheets
Find a sheet within a workbook (If/Then/Else)
Form temporary variables
MsgBox
Format Text Boxes within A User Form
Multi Select check boxes and drop downs
Delete Specific Contents
Problem Opening Folders (again)
Excel Spreadsheet
Upload Excel formats to database
Offset Ranges
display text when mouse passes over a line
change line colors on multiple sheets.
Run a Macro within a Macro
Import data from multiple files
For each worksheet in workbook problem
VBA Runtime error '1004'
Opening a folder with VB
Cross Excel Updation
copying blocks of data from one sheet to other sheets in same book
Adjusting a Macro
Compare and replace if equal
Message Box Warning
How to close Immed Window in odd situation?
Jump to Yahoo Mail with Active Cell Contents, and then perform asearch in the Search Mail Box
Import picture into Excel cell
Vlookup error in VBA, 2042
MS Excel MVP?
open email template
Index is not in range
Matching !!
define UserForm properties
Sum Function
Workbook Summary Sheet2