Excel Programming [Archive] - Page 48

Block copy of Datatable to Excel Spreadsheet using C#
Using autofilter to trigger an event
There's got to be a better way....
Find row and insert formula, skipping columns
how can i run excel/word macro to C# .net programs
After copy of row, cannot paste to activated sheet
Customizing menu buttons in Ecel 2007
Strange Occurences
Difficult text to number conversion
Copying a range
vlookup with match
select row(s) and shift up one place automatically
Coloring fonts
Dynamic File Name Referencing
Export "Define Name" Dialog
How to filter and count unique record?
How to display results in a shape?
spreadsheet control
Error renaming Worksheets when addin is loaded
Speed up saving of a workbook
How do I adjust 2 variables to minimize the difference between 2 waveforms?
Can't run macro
Attaching to Running Process
workbook before print target
Use of Variable
Autofill Macro.
Listobject selected and Deselected event
Import Macro in PERSONAL.XLS will not import to my main document
List files that contain macros
Office 2003 SP3 Installed Now Can't Use Excel Through COM
Looking up 2 values to return only those that match to another cel
autofilter questions
Programed sort generates error: originated as recorded macro
automated copy and past special feature
Choosing a Subject Title, How to be Specific
SUBTOTAL in SUMIF formula
Run VBS from VBA?
Problem with code
Loop How-To
Want to find a service company to write an Excel 2003 macro
#Value! Same formula, different outcomes
How to synchronize the data changed in Excel to a SQL server
How to ensure sequential command execution via SQL Query tables?
CreatePivotTable: Invalid procedure call or argument
Add Subtotals after inserting row
Prompted for VBA password when closing Excel with "Lotus Notes Qui
Range definition
Request for error handling tips
RunTime Error 57121
need some pivot table help
Error Handling in Each Sub
Object properties viewer
Print to PDF with Acrobat 7.0
If help. Multible IF's
Excel 2007 Save As xlsm by default
how to auto-print if data is on report after each sort?
vba code for opening password protected workbook
Import data from MS Sql Server to Excel
Group by SUM
Selecting and cutting unknown picture numbers from a specifc range of cells
Data Array in Listbox?
Create ListBox and Populate with Array
Help - Macro has stopped working - Compile Error
Problem filtering by data >12/01/2002
email out Pivot Chart with one record only
Return User to Last Active Worksheet
Date Problem in VBA
writing amendments to a different worksheet
How to delete imported data
Macro on new file
Unknown column length
Copy data to another wb based on specific criteria.
XL2002 - SeriesCollection.Index
Data Labels Macro
Out of Memeory
Error 424 when trying to determine whether Sheet exists..
Match Found - Delete
The object invoked as disconnected from its clients. - To many she
Passing worksheet as an argument
Passing worksheet as an argument
find and copy rows based on dates in two columns
Manipulating arrays
Select non empty cells
Search in matrix.
MAKING A GRAPH WITH A MACRO.
Store variables in code just as you can w. constants? Available to read/edit?
Listbox-2 entires should select by Clicking Listbox-1 entires. How
addin running in different Excel instances
"Listing Contents of Sub-Folders"
How to Enhance Excel as a Distributed Application?
Trigger Macro on Worksheet Delete
Custom Pivot table results
Create generic macro for a custom toolbar
Run macro when cell is selected
Printing
represent tabular information as plain ASCII text
Copy a Variable range
Pulling "Irregular Shaped" Data from Excel
How can I use VBA to creat new web query?
"Dir" uot of order
Combo box on user form
Retrieving hyperlink from MS Access database
ppic
Sub RepStats()
Print individual schedule; 1=attend class 0=don't attend
Print individual schedule; 1=attend class 0=don't attend
ToolBox cotrol
Replacing the contents of a variable as the name of an array
Error Could not set the ControlSource property. Invalid property v
DOWNLOAD CRACKED 2008's SOFTWARE: ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008
Create Combo Box and Populate
how can get average of 3 max values out of 7 values in a row
Convenient way to ignore Debug.Assert ?
insert pictures
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated
Working with 2 sheets, need to auto fill 2nd sheet with date from
Manipulating arrays
Match and extract
Reading a cell content and using it later
transfer data from excel automatic to access
Accessing a control
Function/Sub
Microsoft Excel Web Query Connectivity Kit
Pivot Chart Problem when Refreshing
Auto mail from xl
Activecell range copy
Copying cells between sheets
Copy and Paste LAST ROW of data non-contiguous
Delete code after use
Find/Replace Event or Find/Replace for Protected Sheet ...
Automation Error
"Set" problem
How can I open on 3rd Sheet Q
How to use excel form in VS2005
auto fill data
EnableEvents
question on VBA and Checkboxes - Newbie
Format date as Custom YYYY yields 2005, but fx still shows 1/1/2005
Transporting text files from notepad to excel
Reference error in excel
Help with if elseif verification
Worksheet_Change
Scope of Tables Is Workbook, Not WorkSheet
Macro to delete specific cells
Calculating a total controlled by multiple variables?
ComboBox font color
Sub-Menu Listings
Userform Background Transparent?
Help/Advice copying from one sheet to another
Command Button That Will Toggle
Copy/pastespecial error
Extract hour from date
Excel auto copy cells
Automation Error
Use Macro from Source
Excel-based MIDI Music Synthesizer
Validation Lists
Using application.ontime
Is it possible to run a macro in tandem with, or right after, ctrl+c?
Adding Line Style on Forms (or another way)??
where do my SQL querries get stored in the MS query tool in excel?
Value issue
Date calculation
Series Number when Create Chart
How to know a pattern's texture features
Macro to sequence ("$A:$A") to ("$IV:$IV")
Address of calling cell?
Copy specific cells to new rows
Excel VBA Noob question: Read row data into VB6 Structure(UDT)
Custom Properties or Tags for Shapes in Excel
VLOOKUP in Excel
Clone a record, edit it and add as new record to database.
Test for if sheet is HIDDEN
Compare Two Sheets Generates Runtime Error 13
Cut/Paste Certain Rows from Workbook1 to Workbook2
Printing forom different tabs
Check this free people search out
can not find installable ISAM
Copy sheet1.range("A3:G5000") from an open file
[Quickly!] Removing PrefixCharacter (i.e. leading, hidden apostrop
Subtotal < 0
How to connect MS SQL Server using VBA Macro Programming?
skip blanks in array formula (help!)
Convert string to date
Compound Interest
change the format of a cell message appear "Too Many Cell Format"
delete drawings in a centain selection
macros or formulas not sure
Last day of month is saturday or sunday?
delete drwaings in a centain selection
Group & Outline - how do I hide detail programmatically
Export to CSV file problems
Weekdays
Excel problem
Deleting a sheet in a shared and protected workbook
I want to highlight multiple cells using VB
Addin Error after installing Excel 2003 SP3 , does anybody have same problem?
Saving to USB Drive either D or E
Re: reading longvarchar(484), data always empty in Excel Options
How to make the sheet index name same as the sheet name after inserting sheets?
Product Finder
Recording Regression in Macros
Form button crashes XL2007
Error when changing the sign on numbers
Lock formatting
Hide UserForm Background??
copy values from vertically-horizontally
When content of a cell changes, content of another deletes
vba
Difficulties Opening, copying from another workbook and closing
Macro Help
Syncronizing tables in different worksheets.
email macro read receipt
Paste special values and formats
Force save to CURRENT directory
compare columns
Function Problem.
Hierarchy Macro
how to add a sub at the application level open event?
Pass an array
customizing drag functionality
Moving Public Function From Workbook Module to XLA
Issue with imported data
multiple cells
Selecting Autoshapes
Shell command writes file to wrong directory
Using a function to hide rows
Can this be done?
pause without break point
Counting number of occurrences.
Relative reference to a table across multiple worksheets
Collections and Keys for Ranges
I need to change hardcoded background color
Why are my date results incorrect
Will countif work?
Copy worksheet to new workbook question
Selecting a range by using a loop
Missing Data
Coverting single-value array into an ordinary variable
Search for worksheet name in Excel spreadsheet
Fill Right Variable Number of Columns, then Calculate Using Offset
Change format DATE language
Arrays problems
Custom colours in charts
Formula to VBA
Conditional formatting (?) help
Search data inside column
exception 0x800A03EC in excel
Return Value of Number
List duplicate Files in Drive
Returning a value in a range
MsgBox()
How can I select a range manually with the mouse?
Conditional cell protection
Range variables
Problem with a a number ending in -
Macro in Different Versions of Excel
See the line number
On Error
More Sumproduct!
Add and remove toolbar custom buttons
Hidden excels popping up when a new excel is opened.
Why does the date toggle between formats
Buttons lose macro assignments
If statement with VLookup can't quite figure the formula out
Create Custom Paste Special - Row Heights
moving personal.xls to another computer
million dollar question!!!!!!!!!!
GetPivotData in VB
Passing parrameters when calling a sub from by clicking an object
Name of Class instance
Macro won't execute when Worksheet is Protected
Location of validation message box
How to automating Excel from an SQL Server Script?
Macro to select max value of range E
Direct DLL reference?
Clocking - Maybe Caught in a Loop?
Setting the namespace when doing a SaveAsXMLData
Macro to copy adjacent columns for a specified condition
.Find, cells with spaces
Custom Toolbar - Buttons, Macro Assignment.
Series Collection Question
Japanese text lost when save as tab delimited text file
Redim Public Array variables
Deleting Column Based On Header
Cells.find only reporting range in AutoFilter...
Allow value in only one of two cells
First time I see something like this!
Auto Mail
Custom Commandbar, dropdown vs combobox
Lookup in External document
Pivot Table Calculation
Office Clipboard empties itself when enabling/disabling commandbars
Convert name into email address?
IF Statement with Dates.
Validation code when using File + Send to
IF function for two columns in diffent cases
Merged Cells
Remove Sharing Code Error
Lookup and Sum
Creating a Variable Range
Selecting last sheet in workbook
Problem entering data in hidden cell, via macro
Macro to change chart references
Save Current Workbook
Print row repeated on selected pages
Sum of a column if some rows contain #n/a
printing a quotation mark in a text file
Select top 10 in a list
Excel 2007 - cannot get worksheet change macro to work
Menu Selection as an Event
Deleting Column Based On Header
Paste Special a string value
Referencing cell numbers in a formula
REpeating Values
Control tab order of unlocked cells on a sheet
Multiple cells to listbox
Custom commandbar, submenu questions
Search Spreadsheet add to list
Help figuring out chart design
SendKeys "%{F11}", True
Urgent - running time error type mismatch
delimiter sign in csv files
Effect of "Save As..." in making VBA code work, or not
How to highlight a Formularised Row
Comment or not
Cells.Find bug that's very strange
Problem with excel macro - getting automation error - URGENT
APPLICATION OR USER DEFINED ERROR
Trouble saving xlsm worbook in Excel 2007
replace unicode characters
Pivot tables field grouping
how to hyperlink to different files as per my choice from a list
Offset question
programatically inserting a control within a frame
Adding text to an Activecell
Entering a certain text automatically
run time error 13 type mismatch
Automatically running an Excel macro on open once only
Automatically running an Excel macro on open once only
Automating weeky copy / paste
RE: Is there a way to make the text blink on and off using Excel V
UDT copying a array to worksheet
Search Results to Listbox
Search Results to Listbox
FileDialog Question
Setting up Excel (2003) to handle users with different editing abilities
C++ code
copy/paste
Slow Print out of the last of 3 pages in this macro any ideas????? Need Help
Inserting or Deleting Rows
Automatic Serialization and print
Userform moves when hidden and shown again.
Compare two lists for matches
Fill Blank Cells With Text Value
import data after last line of data
Select and Run
Please help debug this code!
Newb VBA sub...
Conditional formula
Excel 2007 "Tables" Reference with oledb?
What am I doing wrong?
Activate a template file
Macro designed to send mails via Outlook : question on certificate
Loop, reading registry settings
consolidate Sheets
Excel Rows
Delete a Range After Paste Special
Export options
how do i automate parsing a workbook
Creating "mega formulas" - help me test macro?
Was ok in 2003 not in 2007
Checking color of conditionally formatted cell
Macro to assign cell values as folder name
Question on MS Office "certificate for VBA projects"
column returning null values
Why doesn't Workbook.Save work?
how do i fill cells with random color?
SQL string-how to reference cell/range
Border around range working -Border for cells within range not wor
Open workbook from code without running macros
Open workbook from code without running macros
Skip or Ignore Missing Worksheets
text parsing_table creation for single column
Help getting multible subs to work together
Search with multiple results on different lines same column
Need help with Vlookup with and IF statements
How can I prevent #NA in Lookup
reduce calculation time
Copying, Pasting and Saving as (delimted.txt) on seperate sheets
Problem with Loop
add a calendar control in Excel form
Syntax error
Cells.Find Bug that's very strange
mspview.exe
Complex strings break 'Evaluate' UDF
Workday fxn not recognizing Sat/Sun/Holiday start
Track changes in cells.
change font color for cells starting with "T "
Copy Selection - Paste Selection - Delete Selection
Macro Question. Is refresh needed?
RE: Sumif not equal to
Excel VBA Programming
Arranging Pivot Table data
Set formula as variable w/o "=" sign
Advanced "Conditional" formatting which changes by cell selection
Named range in chart - any way to change the workbook reference with VBA
Deleting an ambiguous shape name
Delete a chart
Emailing with Lotus Notes to multiple, user entered, recipients
Complex SUMIF
nested formula alternative
Reference... AddFromGuid
How do I add info to "Change Tracking" comment box (blue triangle)
Odd behavior
WorkbookBeforeSave different actions on exit
How do I Track Changes on Multi-Cell Targets?
How to display Excel 2002+ "Find & Replace" dialog via VBA
how to get vba to display excel 2002+ "Find & Replace" dialog
Should Be Empty Cells
"Debug" not available
Open workbook to specific worksheet
Combobox number formats
Clear Cells and Worksheet_Change Q
Hotfix for Office Excel 2007 (KB943075)
Copy & rename a sheet appending 01,02,03 ..etc
reading longvarchar(484), data always empty in Excel
HELP!!! using full hyperlink filepath within VBA/API
Retrieving data over a network
2-byte characters: from VBA code to a worksheet; in MsgBox prompts
delete sheet in shared workbook
How to run 2 CreateEventProc modules on 2 sheets simultaneously
Identify last row of record in a pipe-delimited text file
how to lookup a value in a table
Using a userform to enter data to specific cells...
Input Box Question
Custom chart types; Recorded macro acts strange
Simplfying the Sort macro
Automated Web Form throught Excel
Automating via VBA - Delete "Corrupt" Excel Names
Copy sheet from file to file
Query Wizard - Table Options
How do I set up connection between cell with consent and outlook?
The Most Simple Question Ever
ActiveSheet.Shapes macro
Repeat Button
getting table name from a text box query
Running a gif in an html window
Hiding Windows Start bar
Issue
Additems from one listbox with multiple columns to another
Help with modifing code??
Count of rows with nulls
Declaring Offset as a variable
themecolor, colorindex, color picker
Append existing cell value
Selecting varying length range
Print Pages by Page Number
Creating matrices and subsequently prosess those in a loop
Web query and carriage returns
How to trim cell information
ISNA command in VBA
ISNA command in VBA
Find range for plotarea
SYLK file format ?
VBA Cell to TextBox
Retrieve value from closed workbook without using recordsets
Use Contents of Drop Down List
Macro Help
Worksheet_Calculate with no effect
Commandbar dropdown vs combobox, how do I set values
distinguishing filenames
programatically deleted code still triggers macro warning
Ron de Bruin
Access query not returning results
Commandbar works first pass, but not thereafter
Re: Paste special macro
Importing data: OLE DB and data link properties dialog
Re: Paste special macro
Data replacement
ComboBox question??
Error trap only works once
Printing a UserForm
Can't wordwrap the contents of a text box
Creating a unique list of Cost Codes in Col. A from all worksheets in all workbooks in folder X
Get avoid of message
Excel Conditional Formatting
Verify selection of cells
cutting entire rows based on conditions and moving to new tab
Help! Jumping ListViews!
Excel Performance
Add Data Scaling in same chart
Conditional formatting?
is there an equivalent to windowsoff in Excel macros?
Multi-Select List Box
Find and copy range from one workbook to another
How to prevent focus by clicking combo box ?
Tooltip to Differernt Datapoints in Scatter Chart using OWC
Workbook.Saved problem - bug or feature?
Named array value in a string variable
trapping Print events in VBA
How to change the default directory
Click on the Cancel button
Slow Network
Error in loading DLL message
Insert picture, resize to specific width, keeping height proportio
how to display answer as whole number and remainder
Objects height and width scaled percentage placed in work sheet
Stopping a macro
help with macro to query data from DB
How to open an Excel window hidden
[VBA] loop, problem of 101'st iteration
Find the actual date or higher one
Open a workbook then goto a specific range
VSTO, with Visual Studio Express Editions.
Help creating a form that will pre-fill from another worksheet
Userform Textbox
Worksheet change doesn't look at code
Com-AddIn for protection of VBA code
Close Userform
Close Userform
Data Validation - lists if certain column is certain value
One line query on for loop assignment
Valid values to use in Names collection?
Chart Size & Position
Credit Card time to payoff and defered balance
Verify Userform complete before close
connect to Access 2007
Specifying the Sheet
Find Conditional Format Met
Link textbox2 to textbox1 via a vlookup
Havig a problem Syntaxing a range ?
Filtering on dates
InputBox Ypos Calculator, oct07
How to find data in Sheet1 and list them in Sheet2
Printer Problem
Data Validation
Help end the testing tedium please
Time in Excel problem :(
Charts still linked to old book.
Selecting Values Based on Constraints
ComboBox Question
pivot....urgent
Problem in Linking a software with VBA
runtime error 1004: how can i use rows.
runtime error 1004: how can i use rows.
runtime error 1004: how can i use rows.
Print worksheet but dont want two cells too print is it possible
UsedRange.Select - but is it?
Selecting correct MS Outlook Object Library (repeat)
SQL script to select another file in same folder
Saving a Chart
Undo VB macro action
Add data to excel worksheets from text file
UI controls change size when used
Import data from multiple txt files into one xls file
DLL that takes and returns ranges does not always work
Problems with importing data from WEB
Ignore Missing Worksheets
backfill cells with macros
Absolute verses Relative file path in SQL
Activate ribbon tab via VBA
Has file EVER been saved?
FOR loop macro
Macro to change directory based on cell content
Change / Remove Border from ActiveCell
Strange Type Mismatch Error #13
Check an object reference
Change Project Name
Forms.HTML??
ShowModal = False gives improper form paint
Pivot table based on amount ranges.
Lets try again code help
Step through sheets, but exclude one
user form for dates, used in variables
Working with a template - referencing and activating
SaveAs Method adding a large number of comma-delimited blank lines
Working with Visual Basic Check bo contrls
Attempting to use VBA to Ping within Excel...
Vertical Page Break How To Change Help
how to clear all unlocked cells except D4
Range Usage
Value Sheet
BeforeSelectionChange
Save File to specific place`
FOR loop macro clarification
"PasteSpecial method of Range class failed" when range Number of Rows > 2000
shrink to fit expand
Excel 2003 advanced programming
Removing rows based on isDate
Second Fractions
get data from excel, paste to web page then run web page?
Help with search and create code
Access query feeding spreadsheet control in a user form
Create new sheet with a macro
Vlookup help
Copy/Paste Formula
Newbie question
How to capture the Print button event
Auto_open from Worksheet Object Code
Macro to allow spell check with protect sheet
CLOSE WORKBOOK FROM MENU WITH USERFORM
Disbale button when worksheet protected
Code Fails at this Line: .Refresh BackgroundQuery:=False
Create an alphanumeric value
Help needed... please (Copy Past Macro)
Modal dialog delays ribbon update
Zoom to fit Columns
Watch Window
Conditional Formatting Macro?
Open hyperlinks when file is moved
xl2002: Position Picture in SeriesCollection
Add a row to the current Selection
RGB fill colours
URGENT LOOP ?
How to create protected VBA project?
Size chart to window
Refresh Data if Access File has Password
Access Reference
Automatically Save a file on the Desktop
Get Property value of class instance by passing string property name
Solution on previous threat 17/10 about error 1004 while inserting HPageBreak by code
Check if all values in a column is identical
Used range and SQL query
How to use ScrollColumn?
Why does this hang up?
VBA and find: "lookat"
Proprogate column calculations from row1 to rownn
VBA - JumpTo Specific Row
How to add series to a chart using a macro
asdoublevector() xlw (c++ )method
VBA Broken in Excel 2007
excel program to create and update soccer league table.
Problem with ActiveX control
How to force users out of edit mode?
Divide the values of 2 integer variables?
READ ONLY RECORD SETS
Email tabs based on checkboxes
User List Box - List from Hidden range - VBA worng
Import External Data: Dynamic URL
Listbox populating progmatically
excel if Range a1>a2
How to create an excel Pivottable-report from a dos command
Pick List
Re-run subroutine when pivot page field is changed
Problem in exporting to csv
Run Time Error 2147417848 - 80010108 method Copy of Object Range F
Is transfer data from one Excel file to another possible?
Another Method for Parsing Names
Importing mutiple tables with the same field names
Hide Command button on close
Workbook protection
Listbox's, .Enabled and .Visible do not work
VBA Sort
Data Types
delete folder
Using Excel to download a batch of files from a website
Import text file : why do fractions in text format result in month/day?
Macro to select MIN MAX from selection
Number / Pound sign problem
VBA, Webbrowser and Radio Buttons
Writing a macro to sort and export data to multiple worksheets
Excel File Open and Locking Issue
macro to hide data (with conditional formatting?)
delete every row where value equals user input
Strange error in VBA
Can I Create A Button On the Top Tool Bar?
how to automatically sum columns and rows in a template
assign macro to active workbook??
401k withdraw calculation
Avoiding hyperlink error
Dynamic link to workbook
Userform Controls
Format a Userform Textbox Properties
Copy & Past Macro Question
Excel Lookup Question
Supress headers/footers first printed page
Find data for a Macro with a Dynamic Range
Marco for pasting in word
Sorry forgot the vb code for the header!
Determine real colour of automatic line colours?
maximize one of three minimized workbooks to certain sheet
Header
Macros in Excel 2007
if this than that macro
Embedding Objects
Accessing a sheet-level named range through ADO
Form
Pivot Table From MS Query
is ws protected with a given password?
Code runs for a while, then stops working
Concatenate Formula Using Nested IF(ISBLANK)
CONCATENATE with CHAR(10) IF NOT ISBLANK
Problem using RTD in EXcel 2003
Lookuprng error
how do I create a personal folder
CountIF or SumIf Question
Refedit retains focus (Repost)
Need to create a macro that does this.....
Scrollbar not working
VBA Scripting
Getting the save prompt
test
Msgbox Help
Stop Re-calculating Randbetween
Automatically produce Multiple PDF files from a single chart
Bitmap copy of Excel Range into Outlook MailItem.
Run time 75 Error path/file access no-how to trap???
show all the rows before closing the document
Add Description of Variable for User-Defined Functions
Selecting cells in a row
Please help with "simple" code issue
sorting data based on variable number of rows
Prompt for file name and paste contents of active sheet
Update a spreadsheet based on a drop-down selection
How could VBA connect with another customized application programm
How could VBA connect with another customized application programm
predict text based on cell range?
Coloring Rows based on contents of cell A on each row
Displaying Userform
Predictive Text based on cell range?
hide multiple rows based on condition within rows
Excel VBA script not fully working... help!
Union Two With Ranges
Error 1004 when using the copy method
Combo Box selection only shows bound column info after selection made.
macros changing to modules?
DIsplay a value of the cell calculation is #N/A
Get Button Names (worksheet)
Contains or Includes
Can't get into design mode in Excel 2007
Trying to Run code on Opening Q
Worksheet.Copy Expected Function or Variable Error
Join cell data in two columns
Error 1004
Refedit retains focus
Select Cell in first blank column of a row
Macro behind Toolbar Menu Selection
How to verify headers
Hyperlink creation problem
Search and replace
Slow running code
Hyperlink to local PDF file page
Pasting internal cell format from 1 cell to another
Excessively large file size?
LINQ-to-XML manipulation of Excel Files?
Copy Paste Special Values Workbook
Modify code for multiple sheets-Help defining array
Floating Button
Adding a command button to open another spreadsheet
Application.Cursor = xlWait doesn't display hourglass
Macro Button
Problem Excel Calculation Service
CONCATENATE with CHAR(10) IF NOT ISBLANK
Picture Box application in VBA
Distribute Add-In as Machine Code Only?
Worksheet_Change event not triggered as expected
Excel 2007 crashes when I open a file with vba code
RTD IRTDUpdateEvent::UpdateNotify() never returns
Test message
C# Excel cell content partially strikeout
VBA Autofilter --> what if criteria doesn't exist? Error handling??? Please help...
Array Problem
How to Weight Grades vs. Averaging Student Grades
Excel language for modelling
What does a File open like this Q
write all data from web import into single cell
control Outlook Address book from Excel VBA
control Outlook Address book from Excel VBA
changing cell format based on word in first cell of row
Substitute for SendKeys?
MsgBox Question??
VBA API Default printer
Update Access Table Record
How translate 0.51 in € 0,51?
Adjusting FlexGrid column widths
HELP!.. copy Bitmap of range from Excel to Outlook body
Unable to insert Pagebreak before row 1108 !!
How to hide Excel2007 quick access toolbar
Buttons with macro in XLA not found
AddOleObject() fails if a key is pressed
Adjustable Font Size
problem with macro - its case sensitive! - help please
Merging multiple excel files into 1, almost there just need some help
Selecting correct MS Outlook Object Library
highlight only formula
Chart vanishes in paste operation
I need to use fill-handle with hyperlinks
Hyperlink creation problem
How do I change columns inside a range?
working as excel programmer
excel 2007 web page add in
Run Macros When Spreadsheet is Open
Unable to read file
Duplicate Values
I can't open a VBA programed excel file in Excel2007??
Help please with vb programming
String width not exceed column width
userform not working
Gods of VB, I call on thy.
CountA, Subtotal and "move to the first cell in the next column"
Re: Macro to expire after a specified date
Pasting values from a textbox into a single cell on a spreadsheet
CountA, Subtotal and "move to the first cell in the next column"
Excel VBA : Memory Problem
Multi-Format IF Statement
Delete a Workbook via code
Refreshing Web Queries and DisplayAlerts
Return fractional part of values
Help with checkbox code
Accounting Format not aligned
Multiple lookup?
Finding a value in a cell matching up with a column/row
cut and return
FTP CSV file to Lunix Directory
custom printing
VBA code runs in Excel 2003, fails in 2000
How to test for a Row being Visible on a Spreadsheet
Message while macro is executing
Data entry and lookup
Text import and transpose - pretty difficult
Compare five values
Code to create folder and subfolders
Userform Validation Issue
Old, working macro now stops partway (without error) after Selection.Insert
Ranking without preset Excel function.
Which VBA code is better
Display Contents of Folder
Hyperlink problem
VB Error 5 loading userform using Workbook_Open
Vlookup VBA Beginner Help
Creating drop down menu links
Save As 2003 in VBA not working
Compare values and place variable value on sh2
Apply format with check box
Copy Sheet1 from Workbook1 to Sheet2 Workbook2
VBA code deleting everything not just rows with specified values. Please help.
PasteSpecial method for range class failed
Sound / Beep function from within VB or Excel VBA
Auto Positioning the Cursor before Executing Code
Adding a new Sheet but not making it the Active Sheet
Subtotal & Sum Question
TreeView
Setup project for automation add-in
asynchron querytable refreshing
Submerge text, shading, image in cells
Treeview additional components
I cannot record a macro in relative mode. The button never shows.
Show Message Box if Error
Must Contain a Numeric Value
Workbook BeforeClose Event Error
function "sumproduct" in VBA environment
Handling Errors with Workbooks.OpenText
How can I enum the all visible items on quick toolbar and Tabs
Control Array
rngFound not finding correct value when more than one match
Question about private subs
Select statement failing
Get value in a cell
In-Cell Drop Down Via Data Validation (Auto Search)
Putting A Macro in a Cell
Error Message
Copy current color of conditional formatted cell
Having problems saving pdf's from excel to a sharepoint site.
Clear Contents
embedded Word document
Create New Workbook and add VBA Code to using VBA
Checkbox sum
How to make sub handle more than 1 cell ?
Sorting a variant array
Find & Replace part of cell contents
Trying to update a access table
Find Next row
I need macro
excel / VB personal library
set data source dinamically
Use VB to invert ranges
Adaptable pivot tables
Inserting a record into multiple tables based on the Master Table.
Get path to file used as a template from opened copy
Error when multiple macro driven workbooks open
Update or Append Access Table
Unable to get the MINVERSE of Worksheet Function Class ?
Help with code issues
Change color of userform caption bar
Send Range to Outlook and Email it
Run Macro automatically if cell =x
Auto Entering Dates Across Seven Worksheets and Navigating
text data in pivot table reports
SUBTOTAL vs FREQUENCY!?
programming training
Center the Column Headers
split a number into its digits
Use tab key to move between controls on multipage
Excel programming
Programatically sort worksheet column
Path/File Access Error
array formula
Newbie needs assistance with VBA code
Running code in opened workbook
Ranges and Arrays in Excel VBA...
Bold the font in a message
Range("C100:D200").Select with variable names
SendTo CSV file
ActiveControl returns "wrong" value if ctrl is on a multipage ctrl
RTD problems in Excel 2003
Column totals depending on different criteria
unable to set the Orientation property of the PivatField class
Erase Drawing Object
blanc line
Subscript out of range Error
Key events on user form
Summerizing data
Invalid Property Value error in UserForm combo box
PROFESSIONAL MENUS IN EXCEL 2000
Formatting columns of unknown length
Out look express-insert values in body of the letter though VBA code
Loop thru variables
Using an array with an additional independent cell value
Bulk querying and caching of Cube data
Matching records (Excel 2007)
Saving to a text file
Help required with UDF
Excel Compress Photo
Color Theme in Excel Addin
How to see if a macro is running
In VBA editor x = 1.1e-3 is reformated to x = 0.0011
Help with combining/merging code
Text Combining Col A and Col B to Col A
Command Button question
Excel printer paper source
Macro Activation
Help with SetFocus required please
Help on IE Object for Excel
Copy time from one column to another in a macro
Renaming an open workbook
Help with a simple menu please
Refer row or column of a range name
Named Range not recognised by VBA 2007
What am I doing wrong
HP Desktop for sale!
Run-time Error '1004'
A little variation of conventional sorting
Watch NFL Games Online
Calculation on/off event
Trying something with Record Set
split
Copy cell data and assigning to variables
Macro coding using GIF
EnableEvents problem
Timed closing code questions
ARRAY MULTI LOGICAL OPERATOR
Fix code - check to see if a workbook is open, if so, save changes then close.
Deleting a txt file after reaqing it
Help with CDO mail
Extract a column/row from a 2-D array
Check to see if Outlook is open Q
Looking for worksheet according to name in cell
Events
Ping domains / Host
Copying & Pasting into a newly created worksheet
VBA Code to move DataLables to top of Chart
SIMCORP Dimension - Denmark
How to read a collection name index value?
License for Excel Macro
Fraction
Text to Time
Using WorksheetFunction.Max()
Find next empty cell in column.
Comparing ranges?
about ctrl+g in vbe
screen flickering
Linking a Ribbon control with an help file
Using C++ dll in Excel
working with pivot tables items
Number format won't copy
Adding Last Saved Date to Header
relacionamentos
In A macro create a string of variables as needed
Code Not Working with Click Box
Can I send data from one excel sheet to another at a designated ti
Solution: EXIF Tag Reader Class for JPG Files
Running a Sub Procedure every 5 seconds
Re: paste into new sheets
Data written to wrong cells
<xs:element default="value"> not wotking in XSD schema
View Array Contents
On click procedure fails, but not during debug
Send To Worksheet / CSV file
Copy Cells from one excel application to another
Help On search macro
E-mail one sheet
UserInterfaceOnly
Read Large Array without writing in the worksheet
Tab Delimited Query
changing format of a column in a listbox
Re: paste into new sheets
Data Validation Question
Fill a multicolumn listbox with data from a range in another works
Help: Need refresher of some basic programming code