Excel Programming [Archive] - Page 49

Wscript.Shell Run vbs Fails?
Re: Option to overwrite with VBA initiated open/Save Common Dialog
excel set data source dinamically
Re: macro run
Re: Option to overwrite with VBA initiated open/Save Common Dialog
Ctrl-A Fix for Excel 2003
Complex IF statement
Check to see if a range name exists on a sheet
Display and close form automatically
Transfer Data from ListBox to MergeFields
Search for a string, find the column and use that column to sort by
Adaptable pivot table ranges
vba macro to define 3 files, and import columns
filout web page form
VBA question - vlookup
An interesting problem
Sub to automate process
Web Query - row is too long
Reletive Referencing - Marco issues
Auto Email from Excel
I thought this was ordinary sorting...
Can Excel 2003 support ADO.NET 2.0?
performing algorithm
Refreshing external data
run time 1004: the method 'applycustomtype' for object '_chart' fa
Shared add-in UDF visibility
How to get the range index from combo box ??
Printing outside of excel and selecting printers
Returning text from Userdefined Functions
Returning values from graph
Cell Update
Buffer Overflow
ComboBox problem
Help with code problem
Help with User Form
userforms
Customization of Forms toolbox
UserForm
Reissuing a DAO Query
While-Wend loop to fill in nulls
SQL statement for left outer join for ranges in the same file
Doubleclick
Please help
VBA Macro Question
Macro to paste selected data to new book
Simple Find/Replace question
Adding an series of "If" statement's to test for values
Need help creating an Excel AddIn
shell function
Run a Macro on Workbook Open Q
Progress Bar Macro Incorporated Into MyMacro
Code to open multiple password protected workbooks
Return to cell with last executed hyperlink
Floating Data Validation cell??
VBA macro to average
Deleting Columns to the right - 1
How to close Access from Excel VBA
Match Error
CenterHeader, RightHeader, LeftHeader
How to format cells to duplicate for every 5 rows.
Change formula by using a referrence from other cells.
Color Mismatch from System.Drawing.Color
Hiding the Excel UI when running a userform
VBA Code Optimization for Array Formulas
Portuguese Social Format NOT desired
Inventory calculations
Remove All Condition Formatting
VBA and MINVERSE
Gen pivotcache with data filtering/conversion
Create Macro to Copy and Paste into Google Maps
Custom Data Bars
OnTime: Pass Object Arguments
adiing textbox..at runtime
Urgent Help required
setting up number combinations
Excel 2007 and vb... ShapeRange.ScaleWidth problems
locate drive
Transpose Rows to Columns based on Like Data
If column A is invisible?!
corrupted calc on sheet
Is there a limit to the number of items you can select?
Printer Path Question
help please
VBA defined named range not appearing in Names list...
Multiple combo boxes and event handler class
Problem with Excel's COM interface in XLL
Want Enter to put CR in Textbox (not just CTRL-Enter)
Nested If's vs. GoTo statements
AUTOMATICALY SAVE
How to calculate time to rum a macro?
Calculation toggle
If and then statement to sum corresponding prices.
Randomly Select from a list
External data refreshing to include new rows
Multiple sheet search
can I use an update macro on multiple columns
Problem with Excel Charting ... Please Help
Strange? VBA code returns wrong date format (not a date)
How to populate Combo Box ??
Speak Doesn't Work
Template Constant Update
Use of global between workbooks
Check column contents for series
Fetch Autofilter options
Remove password
Automatically flagging cells
stop automatic recalulation when error occurs
Text file created from Excel
screen flicking
Copy rows multiple times changing value of a cell in one column each time
Range("A1").Select
Copy Rows Multiple times "changing" values in one column
COMPLICATED VLOOKUP
VBA code doesn't run when value selected from list
Activecell and integers
Help with locking a file after 365 day the a code to reinstate it...
dsum with IsNumber()
Responding to system shutdown
how to reset Excel menu?!! (not a normal one)
Find "X", bold entire row
Worksheet_beforedoubleclick
Optimizing transferring values
Optimizing transferring values
send email without spell check
Text box
Need to find the right function code
Switching between workbooks
Pivot tables that "lose" data
For each... next (to act on each worksheet)
Transfer data from sheet A to Sheet B
Sheet protection
Add description to UDF argument
Beforeprint with multiple If then else statements
Data Ranges
[UserForm] Editable datalist
code to delete null rows after criteria found
Effects of certain code on file(s) being closed
How Can I Run A macro Automaticly when I close the workbook
Excel locking cell based on value in another cell
Create List based on Cell Value
vba code to delete null rows after criteria found
commandbutton removal
VBA to do Data Sort Excel 2007
I need help with code to run a DTF file
SaveAs Text
Do it for "n" cells
Shade Cells Yellows if Column (D) has a value of C in Cell
REPOST: Applications Extensibilty 5.3 Problem after upgrade Options
Help with sorting issue??
Workbook.SaveAs
Look for new entries in data
Create a macro to find value then delete it
hide zero rows / shadwe every other visible
Exception Occurred
scroll area
Open Workbook - Password
Skip past Password Protected Excel file
Pivot table programming
Clearing a Collection
ENJOYING WEBSITES at [email protected]
Getting UDF to run against the sheet it's been entered on...
Turn off AutoCorrect in Excel via VBA?
sign a macro with microsofts ca
how do I close the connection from excel to access after refresh?
Check Worksheet When Workbook Is Saved
Button to delete a row?
Pasting unformatted text into Notepad (from a range in Excel)
Hide Rows (Current Date) / Unhide Rows
Referencing CountA - Excel automation object not closing
Ubound matrix
Window into a worksheet while on a form
STILL NO ANSWER, DOES ANYBODY REALLY KNOWS
Has Ctrl-A shortcut changed?
Changing Picture Number when cutting and pasting
Open Multiple Workbooks
connecting to an olap cube outside the intranet
How do I read data from an OPC server into an Excel worksheet?
Hyperlinks and File Links
Search for text string
Image pasting to incorrect cells or bad location within cells
PASTE UNFORMATTED TEXT INTO WORD, DOES ANYBODY REALLY KNOWS?
How do you count this?
Copy a worksheet to a new workbook without links
Cells Left Blank
Macro to order coluns
Copy excel text on a range and paste special to Word
Force UDF to re-evaluate
Automaticly download pdf file from web site to folder
Looping macro
macro to exe
Gap between Headings and Start of Output
Trying to create a Macro
How to use Excel to create XML messages conformed agains schema
how do i add negative time to positive time
Count Textboxes and other objects
RunTime Error 5
Open-Save Strategy
Text Combinations
How can get unique value
listbox multiselect to control original cells
Formula Help :-(
Finding last items in a list
Excel hangs on Save As
Need help to extract characters
Hide Sheet when another sheet is chosen
xl2007
Copy actual URL from hyperlink cell
Searching for an Outlook Task from Excel
If Statement Limitations
Exit Field vs Exit Button......
Autofilter with VBA
C# Interop Shape xlMoveAndSize property doesn't stick
Excel 2007 calculation bug fix
Using C# and Excel 2007 Office Open XML
Need advice on Solver loop
Auto delete contents
Looping through selected worksheets and delete a range (e.g., A2:D15)
SURELY macros still work after exiting the workbook they live in...er, don't they?
Open workbook with password.
VBA Editor Utilities
Looking for an alternative programming technique
Warning Message while using VBA to code
macro not giving right sum
Who Am I?
compareing 2 columns
Showing Formula
drop down list accessed by typing the first few letters
Grouping/Counting/Concentrations
Order of Event Firing with Automatic Calculation
Excel Event Firing with Automatic Calculation
Really Complicated Lookup
adding unique number from list
User Form Creation
How do I create a control button??
Disable Checkbox on Userform
Search for date within a range of dates
bug in protect-unprotect macro
stumped!!
Autofilter and VBA
awaiting the execution of code...
looking for a losing button
Unhide Rows Date Older Than 7 Days
how can I move multiple worksheets into one workbook
retrieve info from email
Sorting left to right
Help with the following code??
Comparing Problems
Using XMLHTTPRequest within Firefox
Filtering a column
dynamic range based on criteria, within a dynamic range, passed to a function
Sort Outline numbers
Data validation lists in adjacent cells
modifications on the code
Remove a Defined Name
Tracking row changes on the same row with fixed column
creating a dynamic range based on criteria, within a dynamic range, and passing it to a function
Keep 6 months of dates from Today to (Today + 6 Months)
Complex IF OR AND Statement
getting content from cells by the cross point of the row and colum
Draw Diagonal Cell by Cell
Ref Edit Control Error Excel 2003 files opening in Excel 2002
Run macro on every worksheet
collecting data from a single cell and putting it into a columof c
Getting Query Parameter from Worksheet Cell
Working with an array rahter than worksheet
setting reminders in assigned tasks
Sort Macro Start On Row 7 Until Null
runing macro of imported module.
select file fro listbox and send via email
Trap on close event and control save
Highlight Matched Rows
running a macro after updating a cell
External References
Embedded Worksheet in Excel
Back to Previous Sheet (Leo)
!! hyperlinks to listbox column - Possible?
Pivottable: 1 xlPageField but with many "Sub" pivottables
Creating Add In's
Preselect Filters in Pivottable from Analysis Services
How copy Criteriarange from uatofilter colun to another sheet?
Formatting unlocked cells and stop users from pasting
SpecialCells Select problem
VBA methods
Sending cell information to another workbook....
hide and unhide option buttons
Null in a ComboBox.List
Automatic Comment
Print Macro with two drop-down lists
Please explain modules/sheets/workbooks
calculate average from every two or three or four rows
Evaluate a range of cells for true or false condition (Div/0)
Moving cells in Excel 2007
Match and Index
Removing a control
how do i use range of value in same cell example 1 to 100
Toggle sheet visibility
Formula help
Toolbar is floating every time when excel is opened, how to dock?
Compare data by Column?
Creating PivotTable in Macro
vlookup in many books
how to use VBA for updating pivot table
Wanna insert checkmark with code
Write Worksheet To Network Directory
copy sheets from many files into 1
iterate through textboxes on sheet
Create a "Send" button
macro to save range with cell formats as static html file
winsock
Code to install Analysis ToolPak at Workbook Open
Sum values form different tabs
using UNION via Automation = invalid range result!?
Help w/ SQL Statement
Scenario/Pivot Tables
Delete/Add Dates To Worksheet
naming sheets
Links to Other Data Sources, Can't Turn off Application.DisplayAle
Selecting all of the sheets in a workbook
macro button on/off
adding values from radio button selections
THANK YOU!
Validate part of string
Embedded Visual Basic for Application Controls
Help with For...each...next
Vlookup thru many books
Email Range as picture or bitmap. - Lotus Notes
Extracting data from Access in Excel
Making calculations down one column while moving down another
Automating application error responses
Change which columns are deleted.
Formula to build hyperlink?
adding 1 to previous cell value using code
Getting info from all .xls files which are open
Hyperlinks within a Userform
macros
Automating the Creation of Userforms in VBA
Delete Duplicate Names in Excel (Clear Text)
Command button to refresh data
2 questions
excel 2007 macro/vb programing question
I need to use CreateObject("OracleInProcServer.XOraSession")
Vista Registry Entries
Web Query not downloading data filtered in web page
Question about parsing a column of cells with a comma in text
Deleting menu
How to copy rows into an Excel *template* with vba
Toolbar not hiding
Custom Function & Application.volatile
autofilter none result
Printing documents via a listbox and hyperlinks
include access database in excel workbook
Hide when cell value (x) is < 1 but > -1
VLOOKUP WITH MACRO
Calculate Percentile By grouping Data in excel
VBA Function to Check if value in a String variable is actually a cell Address
text box input data concatenate to file name
Call center quality assurance form
Cannot send mail in Office
Matching cells
countif
getfile and sharepoint
VBA: Problem with ctrl- and a-key Listbox event
randomize numbers
ListView selection
Excel trim function maybe?
Automating copy/paste/paste special when row references change
Formula Help
make cell active in beginning of macro
Incrementing an alpha character
auto rounding for quadrillion numerals
How to make/add own msoControlSplitButtonPopup?
Copy Values Between Worksheets in same Workbook
Get Title, Forename(s) and Surname
Excel 2007
One Pivot Table changes another
HELP: VBA Code to extract data from an SQL Server database and put it into Access Database
Autofil from a list box (data validation)
Automate identifying if 200 plus files exist in a folder
How to access Application Ojbect of the Current Excel Window in C#
Excel Crashes on using Transpose Function
Invisible Application/Visible Forms?
Copy Rows From Worksheet Into Another Worksheet Same Workbook
Excel Automation - Export Txt
Worksheet button question
Excel question.
ActiveX Control in VB.Net
Problem with multiselect listbox items selection
better way clearcontents column?
VBA code for INDEX MATCH Functions
delete macros by macro
Web services
Set Global Variable Inside Object Module
Copy Values From Worksheet to another Worksheet same Workbook
.Value = .Value - Error
Preset fields in Lotus Notes Code
Add New Sheet when Multiple Sheets are Selected
Send mail problem
VBA to open a shortcut to a workbook
How Can I gets avaliable list of all criteria in autofilter
With stmt and Range
counting responses
Running an excel macro from the task manager
Trying to clean up code that I did through a record macro
MouseUP event
subtracting column from column
another group archive
Load user form??
Pivot table
Trying To Append String Variable To Another String Variable
commandbars.add problem
Error Search
OR clause doesn't execute the last condition
Applications Extensibilty 5.3 Problem after upgrade
password protect
An Unhandled Win32 Exception
How can I load a user form from within a worksheet subroutine?
How can I load a user form from within a worksheet subroutine?
named range
Information from numerious excel worksheets
Opening numerious excel files
Page Margin Setup
Aqua buttons
Reading the PrintArea Pages
Automate CD Changer
Sum a column of data
5 Bells Ring Sound
Trouble making another worksheet active
linking the selection of a drop-down list to a quanity in another
Macro in Excel 2003 will not run
control should go to next cell
built myself into a corner, how to exit gracefully
Opening and retrieving information from numerous excel sheets
Opening Message
Sorting problem
Copy Rows From To CSV File
Enumerations or Collections
Creating XML
Form won't update!
Debra Dalgleish's Excel file that displays a comment in a cell instead of a pop-up
custom icon in custom commandar
Locking RAND()?
How to make a few rows visible and hide some others ... faster
Textbox filling cells
Name.Add problem
Find next blank column with Macro
Stuck in endless loop, HELP!
SQL
Saving format detail of entire row/column
Get names of all workbooks in a directory
Stop the Debug option from coming up
Colour change by date
Deleting a sheet with the same name
hiding rows
Debug window displays for no reason
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007
AJAX : Dynamlically pushed JavaScript not working after Update Panel is updated
Speed of Execution
Calculate Last Digits
«æ! ¤â¾÷²M³f5§é°_
Protect Workbook Code Queres
SQL query from one excel worksheer to another one in the same book
How do I tell when a Shelled Process ends?
Can I automate the checking of the "Solver" box in VBA References?
Code that includes Solver taking extremely long time to execute
Selecting portions of a column instead of the whole colum
Help with drop down list selection
Help with code assistance
Copying certain rows to another sheet
Using Vlookup in vba not working or ending w/ error 400
how do i use range of value in same cell example 1 to 100
Determining the cell position of an object
COUNTIF on changing range
Data Validation used with VLookUp function
test for next group doesn't work on the last one
Copy ActiveWorksheet Columns B,C,F to Another Worksheet in Workboo
vlookallsheets across workbooks
Random Select
Autofilling Lists based on prior list choices
update form
Insert and lock picture into a cell
Using Application.OnTime within a class module
make cell appear blank if no date in that row
need to make cell blank if no data in previous cell
ADO SQL
Delete Rows If Date Less Than Date Value
can we hide the steps of a macro
Looping : For... Next problem
Can someone do me a favor? small script
Create Outlook Distribution lists in Excel VBA
Dealing with date formats on expiration date
Color in Cells without Showing Up in Print
I am getting duplicate decimal points on numeric validation
Column Differences
Is there a free RAM requirement
Application.Calculate
help with macro
CSV codepage Excel 2003
add some text in a cell that has just been inserted
copy sheets to workbook and save as sheet name
Cascading Style Sheets import into Excel
how to get excel to calculate from ASP?
Alternative to SendKeys for field that' not in tab sequence
ELSEIF for multiple if ??
Copy Cell Content to CSV file
Context Menu Commandbar Question
Context Menu Commandbar Question
Programming the filter of a pivot table
Print Performance in VBA
Help with macro?
dynamically linking subsistent worksheets to a master worksheet
Texttocolumns and Date Format using Macro - UK International setti
Error 1004 in WorksheetFunction.VLookup
adds rows to all service groups except the first one
Sorting a column with numbers into descending order
Linking Workbooks
Show / Hide Label
Worksheet copy doesn't copy formulas
Do while
Macros and Formulas
pivot table
Combining cell entries to one cell with code
Combining cell entries to one cell
Disable Macro
papou..Can you
Changing file name for a data import from a text file
Remove opening dialog box
Cannot see my combobox on my worksheet??
E-mail Each WorkSheet in collection to pertaining Manager
Help with this code
Worksheet Change: Display/hide columns depending on date
Unhide All VeryHidden Sheets in a workbook (w/o naming them)
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet.
Run Sub from Button
export chart as wmf
#VALUE error on VLOOKUP of text
rows to columns and colums to rows
Macro that will sort and create different worksheets
pop up window and protection of sheet
VBA drop down list help
Verify correct cell
Programmed error messages
Using ADO Recorsets in sql SELECT sentence
Add multiple IF statements
Stock Quotes
Saving format of row/column
get column name
Placing time with date
HLookup Problem
Click tool question
Disabling or Restricting Web Page Preview
Last Save Time for non active shared workbook
How Can I gets list of all criteria in autofilter for any column
Passing a string to Case statement
Macro to delete 'tick' Character
Call a procedure whose name is stored in a variable
Change from row to colume n colume to row
run macro only in certain file/worksheet
Changing color of text added to a cell via a form
Help! Serious problem with Excel and embedded files
End property
Fill each time one cell/row with a specific number,for defined col
How do I write code to enable drag/drop from ListBox on UserForm to a cell.
filtering?
? Object What object
Data validation drop down list selection change
vba entering a formula in a certain cell
graph of y=ax+b in excel
Deleting column in a worksheet that is not active worksheet
find, copy and paste
Strange Right-Click PasteSpecial Behavior
How to include boilerplate "terms of sale" below range
Printing worskeets in several workbooks
problem with active cell
Names referring to valid range in the active workbook
adding some rows in the middle of adding some other rows
String to Variant conversion
how to make chart on selected range?
data over formula
Run code only when a sheet has not been changed
Moving numbers to different months
calculated field
Goto Worksheet with Defined Range Name
IF
Import Text File into Spreadsheet
Macro or other code for deteming Months, Years, Quarter based on d
Font Keeps on Shrinking
Function ACOS in Excel VBA
algorithm to add 20 rows at half way point & at beginning
Listbox Locked After Adding ListRange via VBA
Macro Free Workbook?
Dates from InputBox
Macro Fee Workbook?
An empty cell = An empty cell ???
Referring first row in range
Conditional color formatting in a pivot - possible ?
Simple VBA code questions
Calculate and UDF
Close other open excel files
VB Code to link to website
SheetName Worksheet Function
macro/vba for a range of hyperlinks
Compile Error - Help
count used rows
Specify an Outlook folder for already successful Task creation procedure
function for checking for an odd number
hide non active sheets in workbook
Dim xxx As String & IF?
Collection verses array
Worksheet Calculate
code that searches for current date
Vacation Accrued /Sick Days Accrued
menu bars
get external data - new databse query speed help
Macro for Menu at start up
VBA---Tools--References automatic
Filter a pivot table in a macro
Thank you
help with macro
Excel Object Model
Minimise worksheets
VLOOKUP Trim vs. No Trim
How to set a range equal to cells greater than 0 (Column "A" only)
Deleting rows
Using a cell value to trigger macro to run
color font for listbox column
renaming a workbook
add-in, data in Add-in file (woorksheet)
Solver working intermittingly...tried some previously posted solut
conditional colour of cell
Days added to a date
Numbers to Lexicographic Index Number (CSN)
Repeat entries in rows 5 & 6 into next blank column
Change Excel Title Bar/Caption
filter on date
application.run
retrieve ping status in ms excel
A Must Read!!!
Missing Excel Workbook Template - with VSTO SE installed
extract pictures from excel file (c#) ?
try to log in to web site by using excel vb, but not sure the butt
Insert a blank row in a Pivot table
Combine 2 IF STatements
excell programming
Email Using Template
concatenating text with address reference
re: click button to go into the web site but not certain where to star
Date format changed after saving to .csv
Verify two sets of data to find mistakes
Range Validation property not working w/ Protected worksheet
Registry is not updated
Problem with Data Validation
Query Data from MS Query
return a concatenated formula into a cell
first time array help
returning formula into a cell
Formula Help
Expanding VBA to include more than one column
Delete Hard Return; Special Character
Trouble with cell value
help with a spreadsheet
Noob Question 3
for loop doesn't advance
Converting numeric Part No. to text
Find next open row in a column
Import CSV files into template
Noob Question 2
Loop through a range using a specific start and end
SUM in Userform
Re: Selecting a Range
label on top of a listbox
Variable rows to repeat
Selecting a Range
Programmatically maximize a userform
Delete Row if Col. H contains either"Current Period" or"Year to Da
how to Add a command button to the standard commandbar of the visual editor window
Noob Question
Filter
name of calling routine
Find used range and ignore blank cells when running macro?
extra excel style
Not enough memory for OLE checkboxes
copy selected cells to new sheet.
Delete Columns if rows 8 & 9 are blank and place border
Listing the files from a directory
how can i run a macro from a formula
error handling for network connections
Auto calculating the month end
Remove Text for a text file
RE: Get a total when number or rows is not know in advance
Re: Get a total when number or rows is not know in advance
How to let write only some simbols in the cell in Microsoft Excel
Get a total when number or rows is not know in advance
Excel Cannot Complete this task
code to change color of negative cell
Copy Workbook, Formula Not Working
Moving blocks of data across worksheets
What is wrong with my code??
copy function
Run time error 3085
Insert formula in multiple worksheets & copy output to new sheet
range object error
On Key press
compare cells in a column for duplicates
Cursor movement upon an event
Find Unique Records; Must Use Fuzzy Logic
Find and copy duplicates to new worksheet
Excel / Access User Conference - Oct 24-26, St Loiuis
QueryClose problem
Closing IE windows from VBA
Help with Macro Error Message?
keep on working while userform is active
Pivot table: showing COLUMN summaries for some, not all, COLUMN fields.
Accessing events of com objects
Code to Check for Pivot Item
Custom Menu
Passing Form Values
afterprint event?
Calendar Control missing
events=false not acting?
Changing the default value of the tab key in vba
math applications and formulas
math applications and formulas
last used cell function
Populate Spreadsheet #2 from Cell references on Spreadsheet #1
Incoming curve ball (still coming)
Conditional Formatting while working with 2 columns
Cancel Ontime routine
Removing blank lines in a workbook
Apply a R1C1 function to a specific range
Parent/Child Macro
Automated data logging with excel
Automated data logging with excel
I need a formula for some calculations...
Select multiple sheets on a dinamic context
Closing Form on pressing Enter or Return-key
How do I create a list from another list with exclusions (such as blank cells)?
ADO to pull data from Access query
Customise Header
right-Alt with SendKeys
Range("A1,F96").Select - What's wrong with that?
Error when returning user-defined class from "factory" class...
File, Save changes all dates in column to 1/0/00, created with VBA
Format sheet after importing a csv file
add empty space in formula
speeding up this code
Re: Syntax - Loop through rows in a selection
Syntax - Loop through rows in a selection
VLOOKUP on 2 sets of criteria
Can't print only 1 page wide-what am I doing wrong?
Do Until Loop Not Working
Do Until Loop Not Working
Pasting formats in without conditional formatting?
Re: Copy macro to a new book in 2007
Copy macro to a new book in 2007
Solver not working for me
Macro triggered by an event
Copy macro for a list box
VBE Tools>Reference question
Help! ... need to vlookup but can't make it work!
VBA Vs .net components
Looping Down a column
VBA on error next .....
If function and math formulas
Re: Looping through TextBox's
Looping through TextBox's
list of all cubemembers
Clicking on link from VB?
Populating a List Box
Looping through images on a userform
Implement Excel cell function using VSTO
UniqueItems Array
FormulaR1C1 v Formula
For Statement
How to find internal connection
Cell content shows up in Print Preview but does not print - why?
Sum of Value for duplicate number
exiting the whole macro
removing cell formulas
Getting unexpected error message
Unable to 'Drag n drop'
AddIn
VLookup in VBA
Recalculate to hide rows
Query - Through User form ?
Saving as *.csv or *.txt with double quotes
Excel with IE problem
extract data from backend, display on frontend
macro to scroll the worksheet and continue to run macro in backgro
WEB query for zipped CSV file
on data add formula
Re-organize data in Excel - I need help
How do I display Unicode Text on UserForm.Caption
Licensing an Add-In
Add-In Toolbar Control - Removing The Toolbar Question
VBA Code to delete duplicate and extraneous data
Validation Code Problems
Two Pivot Table VBA Questions
columns in refedit to a combobox
Clearing Cells
combind print copy amount
update newbie
Excel-How Do I prevent data conversion to date format
Links
Inserting page break conditionally
Insert row code
Minimise unwanted windows
Invoke macro on Autofilter Criteria Selection
Links
When is a Loop Necessary ?
can not locate the internet server or proxy server
Named Range
Find last cell with matching value
Could I jump to another Sheet by clicking on a cell
convert all formulas on a worksheet to aray formulas
Disabling a forms 1.0 button
Avoiding Redundancy (.Find Method)
can an excel file compiled on a Windows PC be used on a Mac computer?
commandbutton?
saving an excel file with a serially increnmenting number
Extract several variables from textbox content
Copy Worksheets Into Master Workbook
Create a macro which takes a column name and width and sets the column width to what it should be
Works when stepping thru only
Re: Rounding Up & Down
Rounding Up & Down
Web Query
Custom VBA Code
Email question
Check SpecialCells(xlCellTypeBlanks) for >0 blanks
I want to format a worksheet based on values in another worksheet
Values from a range in one cell, seperated
Any ideas of integrating Unix with Excel?
Executing an FTP call
Want to access the SUBTOTAL of a list from within a worksheet
Import data from Microsoft SQL Server into Microsoft Excel
Tag/Identify Cells
Deleting characters to the right in a column....
If function with average fomula to be tru or false
Rounding error???
test
How to reference variable worksheets and variable row
create a series
How Determine, cell has got reference.
works and doesn't work
how to have arrows appear on a form
text box or list box values get sent to email distribution list
Sort & lose links
iif() function
iif() function
how do I make the title bar disapppear
list box that has text that has hyperlink qualities
Get row number using input box
1004 error - can't find text file to refresh ...
Disable 2003 VB code for users using older Excel
Start a macro when click on tab sheet
Dates: How to check if date value is 10 months and or 1 year old?
AVERAGE, STDEV, SEM with criteria
Single quote in sheet name
restricting other applications from being opened when running a macro
How to change the colour of a line
Textbox Value Changes
divide and copy rows
Select & deleting all rows based on the contents of a cell in the
Add a character to all cells in a column
RE: format all column width
Help with SQL and ODBC Text Driver
format all column width
Help with building a formula based on cell values
RE: SUMIF
Deleting Values in a Row based on a Certain Criteria
Conditional Formatting help
RE: SUMIF
SUMIF
Macro Copying Rows That Change Dynamically
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul
insert an ICON in a cell
Searching and storing Column Number
How Do I list all range names in a worksheet
Additem to ComboBox using the Column Property
Save copies in different places
Evaluate an Array Formula before inserting it in a cell
RE: UFD to change color based on string
Cut button is disabled
UFD to change color based on string
How does data validation work
Hyperlink created with a macro, altered on save.
Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..)
I Disabled the Find Dialog Box?
Professional Excel Development Chapter 5
Delete Rows if any cell in Column H is blank but do not Delete Fir
Help, One form Closes another Form when closing itself...
"Run application" based on condition...
Sorting on more than one column
complicated search and extract.... i think
Using or loading external code
Calling a Public Function
AutoRun Macro with a delay to give user the choice to cancel the macro
Problem with 'Popup Menu' visibility
generating a #VALUE
VBA to autofill next blank cell in same column
FieldInfo
wrong calculation ?
find word initial then final......
Visual Basic Editor Layout
More Efficient IF
More Efficient IF
Password Protection
Look for cell containing "Initial" then if the next cell after equals "Final" then delete both rows.
HYPERLINK TO FILES IN A FOLDER
Can't right click embedded objects
2 Dim Arrays & List Box
Insert row on multiple sheets
Problem: Workbook contents vanish
Ws Selection Change Event Code, Copy a Cell problem
Comparing 2 files on date/time stamp, and based time difference do a subroutine
Create VBA Function/Sub programatically within Excel VBA
How to hold Macro running?
VBA Forms
calculateing cells on demand
Formatting after Importing
CopySheet After
validation
Trigger wrong time HELP
Limitations to Excel Add-Ins
Question about Pivot Tables
Want to get text entered in a Userform TextBox after hitting Tab o
Use Custom Document Property to identify xls files not yet process
Conditional Combo Boxes
Delete Empty Series from Chart
Adding "Add-Ins..." control to custom tooolbar
Excel- find the last filled cells in column with empty cells
Progmatically set "Application.Dialogs(xlDialogFormulaFind)" optio
Evalute Array Formula in VBA code
Load Value into textbox
Append character to cell
Notes "DocLink" Icon in a cell
Last Row in Formula
trying to use PasteAndFormat method in Excel VBA is not working
changing active printer for Word.
Vlookup in another workbook
Solver Iterations-how to change number
Export worksheet to .csv
UserForm & listBox
Countif to changing range
Using vLookup function in VBA
tracking updates
Update Pivot from datasheet in different folder
Finding Duplicates in a list
Creating 1 row from n rows using concatenate and if then statement
Display message if "find" command comes up blank ??
change values in a column
Find a string
Want to use Excel to parse a text file
help statement unfinished
Last Row in Column not working
¹Å¶*£¨1912-1949£©Ãñ¹ú´É²èºø528°Ñ´ÉÆ÷400Antique£¨1912-1949£©Porcelain teapot 528 chinaware 400£¬ invitation visit£¡¼þ£¬ÑûÇë¹ÛÉÍ£¡
Optional Arguments in Custom Fuctions
Protecting validation
Error handling help
Lists from other worksheets
Removing hyperlink without removing the font settings /border sett
Find Multiple Values, Copy Entire Row & Paste
Mulitple If Statments
Looking up the value of a cell in a named range
Combined text and variable in a message box
Need help on Excel macro.
dynamic value not copying correctly
Change hyperlink property to new location
Protect Code
Name of Added Worksheet
list of all cubemembers
Data recognition help
Copy multiple values into a single cell
Travel through no of sheets in a workbook.
File format conversion on server
Problem with script, please help
Hiding rows
File Link
Moving up one cell
What are {}, how do you use them in IF statements
CopyFromRecordSet extremely slow
Copy, Paste Special Values all sheets in workbook
Managing objects in VBA ( specifically good practices with destruction)
selectionchanged event
Synchronous execution using shell function
Email
Accessing cube functions (ie cubevalue) from VBA
Can i hide specific data series in an excel chart yet show the values in the legend???
protection,distribution
SQL doubts
Can this be Done?
replay from a database through RTD
load .xla addin's when open Excel sheet.
Excel cannot complete this task with available resources
UserForm with ListBox
Extract Data
Select next Cell Down
Automate Formatting to Changed Pivot Table
Trouble exporting using Chip Pearson's export