Excel Programming [Archive] - Page 62

Get grand total from pivot table
Seeing value in textbox
RE: Macro geneated headers not displaying some sheets
counter script
Using OR
comparing 2 sheets and list unique and duplicate rows
Growing file size
Looping through all comboboxes in workbook and setting values with .additem
Sorting Numbers, with Friends, by Formula?
Referencing Cells
Get contacts from Public folders into a userform
Gaining the Column A Value
Conditional reference?
Check values in cells and replace them if they are the same value
help with macro to read and sort data from multiple text files
Vlookup with date in Excel 2000 VBA
Returning the name of an embedded chart?
Subtotal check in Excel 2000 VBA
Why does the line of code NOT work?
Check directory permissions
Calling Classes from Classes
First empty cell
remain "+" and remove apostrophe
range search query
problem with macro
data manipulation question
Leafnode and key in TreeView?
Lost Reference
Compile error, Variable not defined
create pivot table in VBA
409.5 + ???
How to execute a CommandButton_Click macro without clicking on
Another Array quetion, sheesh
How do I write a custom format to make a negative percentage red
Data - Import External Data
Macro query refresh fails
Sorting issues...
Excel opened by program and closed by user
how to escape "+" or " -"
Sheet in Sheets
user a userform index for excel form
Save As Then Replace Bombs Out
Populate a ComboBox
Delete multiple columns based on certain criteria
Creating summary sheet
text only on button
Reference bottom left cell in a visible range
Column Header Alignment?
Conditional application.onkey in realtime?
Model opens up with hidden rows and columns
Removing parentheses in a phone number
CF based on data analysis, Loop thru sheet
Excel maximum Dependencies
Problem with Auto Fit Sub on open
Yield function in VBA
rounding to the nearest 100
Why don't UDFs capitalise properly when input on a worksheet?
Hello
Going back to previous worksheet
Using excel solver in VB.NET
offset copy
Q On Simple FTP/Telnet
Basic macro for copying into Excel
Double variables initialize to zero??
to get its k-value from percentile and array
right code, wrong range
callin the macro dialog to list all stored macros in a workbook VB
macro with paste special returns error
Calling up the macro dialog to list stored macros in a workbook-VB
No Heading Row
Totals at the bottom
setting the Left or Right HeaderPicture
Obtaining Username
Loan calculator with residual amount
Problem with IIf
listing server of demain in sheet
Importing XML into Excel 2003 from a URL
Filter Month then name
Read data from an htm file
Detect Hidden Columns
Class Hierarchy in VBA
How can i Enable/Disable CommandButtons from Wkbook Open event ???
move module from a workbook to new workbook via VBA
Testing CF Conditions
How to check column name in multiple sheet
AutoRun a macro on Closing
PASSWORD PICK UP WHILE FILE OPEN
Once I've loaded the Solvertable Add-In, how do I use it in Excel?
how to send workbook sheet as a sheet (not attachment) via Outlook
Problem with MATCH Formula for different book by variable name
Do i need a Next or Loop statement ?
Loop for X seconds then exit
Formula Help
Delete all sheets except three
Please help with this macro
Application.Visible default changed?
Remove Numerical Values from Listbox and Certain Text Value
Macro limitation
Problem Updating Links
Check for Grouping and Ungroup
pass named range address into variable
VB code to scan pictures
Sheet Array Printing
macro doesn't work after downloading office updates?
Survey / Radio buttons
Conditional Hiding of Rows
Automatic data entry in alternate cells based on drop-down menu se
Command button to run macro in a module
How can make Save faster
Vista and creating ini files
VB + array formulas
myCell.Formula application unknown object error
Can't create ini file on a Vista machine
check boxes + autofilter - is it possible?
Expanding a named range
SQL Codeing behind a PivotTable
Printing a selected record
Printing Assembled Array Using Sheet Names
For each worksheet......
color bars in chart with code?
Follow up to array question
Trigger macro when specific cell doesn't change
Quadratic Polynomial fit with LINEST()
User Defined Function - Can we identify the cell it's called from
Converting a string to an array of integers
User form Help
Make chart axis visible/invisible with VBA
Combobox + Array formulas
automated testing exel applications
Excel and C/C++
Matlab & Excel interface?
Help! Insert a row in Macro
worksheet change event auto populate
Anyone know anything about arrays and vba? If so, please help
Don't save if cells are blank
Compare multiple columns in two workbooks?
Comparing names in different columns
Compare and Delete rows in EXcel
vba : Headers not displaying in all sheets
countif function
Create Password
XLA question
This one is HARD! :(
This one is hard ;(
Excel - Identify and delete duplicate rows
Q on integer, little endian, LSet, data formats, ..
Hidden Members
Fine Tune in Excel
Pivot Table Page Field
Removing modules via VBA
Sort a list across collumns
Macro If Then...?
XL2007 Bug: ControlFormat in "For each"
List image names into col & fill cell comments with corresp images
Excel NumberFormat
Returning hour with a decimal
Macro Pop Up
How to share a private key
test sheet for protection
Error when closing excel file without saving vba project separatel
Can't set the Entirerow.Hidden property.
Copying a cell contents down to the next non-blank cell
Extracting Text from Embedded Word Documents in Excel
2007 EC Excel - Access User Conference
how to apeend data to the excel
How to Append data in excel sheet
Excel Duplicate
Extract text plus "n" characters or date on partial match
Remove Duplicates from Listbox
Different outcome if I single Step or just run the code
Is there an error here? I get a Compile error ???
Thin Borders
printout method on embedded word doc fails - PART 2
How do I Test for the existence of a Worksheet from inside a Macro
Fetch Text From Website
ListBox control on worksheet
Copying columns from multiple sheets in a single sheet based on a column value.
Using variables in macro functions
SaveAs csv
Retreiving Sheet1 Data Autometically Uploaded in Sheet2
I need a office 2000 premium download without cd
Date problems
Mass Adding Comments
How to find missing workbook
MSXML2.XMLHTTP clear excel cache/memory (?)
code to color cell
Screen still changes. Why ? (Application.Screenupdating = False not working
message box popping up when the selection of a Form combo box changes
Reset default command button color (grey) in a form
Count of Worksheet rows and recording this count
Pasting Data without shifting Down rows
Same macro running from earlier opened workbook
Trim() function chain-link. Please Help me...
use validation on the userform of excel
Ctrl H or Finding / Replacing
Setting initial value on text box?
Selection is too large
Reading from a file
how to remove #N/A
Advanced Filters
FileDialog Object
Loading chosen Sheets into an array
Need help with using LINEST()
Run-time eror '1004';
Replacing Path/filename and criteria in MS Query based on cell contents using VBA
List Box
ShowModal = False but Textbox does not show on userform
Need Help with VBA code for an Excel Model Macro
Need to List Servers from one worsheet to another based on a condt
Obtain the Range Name used for Data Validation
Using VBA to Activate a Hyperlink
Web query VBA problem
Return Author Comment
Change format of NOW()
CommandButtons and OptionButtons on Userform
Array Formulas + VB Code
Auto Population for use in scheduling
Dynamically reference worksheet code name
Save Current Workbook With Extended Filename
design one event handler for multiple textboxes
How to determine the current position of an open .xls file?
Plot series on top of other series
printout method on embedded word document fails
Dropdown validation and paste
Create a macro (or function) to jump cells
Activate/disactivate calculation in VBA
looping through columns and rows
Outlook and Excel
Round to nearest whole number
convert number to text
Search Column, If match found then add two values.
Toolbars & Macro Buttons on then
How to get entries into a combox on a form?
Delete Row Sub not working
One more request on row insertion.
How to unload a form
2003:Lost VB Tips in Code Pane
print in macros
Turn off/on auto calc when entering or leaving a specific workshee
MyCell. Value = "total"
Find any letters present in a range - an example
Extract a value from mid string
What is the connection mechanism for Analysis Services
Exporting range definitions from one workbook to another
Fatal Error when opening Excel with Version 2002 only
Assign short-cut key to existing macro
Macro adding line
Confusion about context of variable
VLOOKUP #NA
Grouping and Printing Worksheets in Excel VBA
Loop until TextBox7.Value = 0 Not working...Please help!
Excel 2002 Random Exe Error
Memory problems
Border round questions
Borders
Populating Combobox
Hide sheets by cell value
Excel 2003, Vista, and Sendkeys
Creating folders
Macro to select which worksheet to print
Chart data ranges
Help deleting row
Pivot Table Dates
VBE - Breakpoints and Bookmarks
First Empty Cell in Found ROW
email and radio buttons
Changing radio button control
Font problem
Highlight highest numbers in a range.
Formatting with Macros
Insert Value based on ColorIndex, for specific range on all sheets
assigning numbers to companies
Count worksheets begining with certain text
Auto range a Chart
Take Focus off a Modeless Userform and onto Worksheet?
Removing "The" from company names
Is it possible to access internet explorer settings by vba
Excel VBA Iteration
How do I keep Hidden Columns / Rows from being Unhidden / Referenc
Calendar Control Not listed in Available Controls ?
C# COM given "#NAME" error
capture URL after POST
Code to Select a Combobox with having to Manually Mouse or Tab to enter a value
Macro to export a graph from Excel into Power Point
Trying to define a range for a graph dynamically within a macro
VB coding assistance for Header/Footer
Splitting & Listing Unique values from cells
how to insert row in a linked file through main file.
Adding 4 rows after each total criteria in the column A with formatting and added text using macro.
how to insert row in a linked file through main file.
'Splitting' Rows?
Pivot Tables - Conditional Inclusion of Fields
Auto Clean-Up
Size a text box based on length
List box query
Find Function
Pivot Table Orientation
Printing Multiple Sheets
Manipulating Row and Column Headers
EXCEL file corruption redux
Functions not working in XP
Macro that loses formatting
Conditional Formatted Colored Cells
Text Box help
Is this when it's appropriate to put the macro in the worksheet's code area?
Listbox and Matched Enty
Switch between Design Mode and "Running" Mode
Sort Macro for Named Ranges
applying worksbook protection via a Macro
adding rows during copy???
Find cell
Open All Workbooks
how can I count the vertical pages of a print job?
Test to see if selected range is single row?
Deleting Rows At Bottom
Treeview Reference?
Defining a range in vba???? Please help
Deleting ' before cell contents
HOW TO USE REPLACE OR CREATE A MACRO TO HIGHTLIGHT THE NEGATIVE VA
use a hard return in a text box
ExecuteExcel4Macro "SET.PRINT.AREA" Syntax
adjust the height of a label
Need help stepping down a list based on 3 criteria
Copy Image using VBA
runtime Error '424' using Application.Selection
Referencing a Chart on a Worksheet
(Complex) Loop within loop to create worksheets
Save Data from Excel Spreadsheet
adding password an hidden sheets
Lookup multiple columns
Using Header from a range of cells on another sheet so that cell width can be different
Using Header from a range of cells on another sheet so that cell width can be different
Problem Sorting
Looping: Search Range in Multiple Selected Worksheets, Copy/Paste
Dependent Lists & Timesheets...
code to execute on enter
Working with Dictionaries
link cells?
help with damaged xls file
conditional for fill color?
Counting with multiple variabels
deleting row
Can't paste conditional formatting colors into new book?
Activex controls on worksheet spontaneously resize
Questions and input boxes
Exit File...
Print Word document based on Excel dialog selections
Summing Generated Worksheets
Macro to delete specific rows in different worksheets
Add shortcut icon to a users desktop?
Error handling
david mcritchie row color please help
[C#][COM] Excel crashs when a cell name is a function name
Need Help with VB6 and Excel
protecting an empty workbook
vlookup help
Does the selected cell have a range name?
Break links
Probably a stupid question. Get workbook name.
VBA or Macro solution to convert Percentages to decimals
using macros to categorise a list of customers
VBA Code to Provide Dir and File When Converting to PDF
extracting data
Simple Warning Box
check ocontrols within frames within userform
Count the number of cells in a range with a string containing a specified substring
Insert Row & Paste Data
Problems ReplaceFormat - error 1004
Count the number of cells in a range with a string containing a specified substring
How to protect a workbook?
loading vba code in excel from within C#
Excel problem reading data when aflanumreic field is numeric
heavy file...
very large file.
Test for the existence of a worksheet?
publish activeX combobox and other activeX control
Cycle through multiple sheets
Sub to clear cells with zeros or null strings within a selected ra
order placement of code
Picture as a Hyplink
Copy picture and remove event code
Object Required Error
TextBox value to hide a row in another worksheet
Can this work and if so how?
Sum up...
Issues with Looping macro...Do Until TextBox7.Value = 0 but it's crashing...Why?
??????
Replacing Data
Can I lock only the cells containing formulas?
Range .Count in Excel 2007
Changing values in an array using for each
Specific Printer
DropDown Change Event & Macro
How to do row count?
Copy worksheets to another workbook
automating market updates
runtime error 1004 on web queries
Importing mulitple .txt files to excel
Save file as Read-Only
Optional arguments and IsMissing
Timed Macro
Import from finance.yahoo.com
If Formula
Undefined User Defined Type at compile time
Copy data from an HTML file and paste into excel using a macro
Create a macro-enabled workbook through VB
How to Select Multiple Cells Conforming to A Certain Criteria Automatically?
Last cell (not blank)
Calculating a cell reference
External Web Query
Automating Procedures and Extracting Data from Websites
Combo Box Trigger for Macro using Worksheet_SelectionChange
Is it a BUG or am I missing something?
code to do a sql-equivalent to JOIN() (as implemented in digDB)
Listbox question please
Characters Object limitation?
Floating message
Hide or display column depending on cell content?
How to determine the end range in my code....
Workbook Cell as Target of Hyperlink Object
repeat macro after time interval
Newbie problem with Excel and HTML
extracting field info from getpivotdata formula
Alternative way to change data in Pivot Table
Public variable
Calling VBA Function
Update links
I need help to pivot this Excel worksheet...thanks
Sample fr the followings...
Need help with VBA execution performance problem
how to create cells in a cell ?
Copy past loop
setprintquality
Using Excel/programming in Excel to plan meetings
Split Data 1 Column to 3 columns, Excel 2000 & 2003
checkbox for macros?
quick way to know empty cells in range?
Add text with formated number using VBA
Here are the steps I want to automate...I have recorded a macro but here is my problem.
Add Form Number Automatically on Opening
UserForm Controls Collection
Trap the Send-To event
How to preserve character formatting in a cell
Textbox with insert Rows in Excel 2000 VBA
Excel VBA Code more efficient
NAMES
Format function with international numbers
Design Problem : Help users who do not finish editing one cell and try to click combo box in another
Relacing default Excel message box when user attempts to change locked cell on protected sheet.
Breakpoint debug problem
Concatenate / Select Subset of Arrays
print cells at the top
How do I make a formula determine a.m. hrs and p.m. hrs in excel?
Advice on List Box Search
sorting worksheets new problem
Closing a program
How to Use AutoFit()
using a vlookup command in a for next loop in a macro in excel
Save HTML as simple text in Excel cell?
Macro run Very Slow in Excel 2007
Copy several photos in a macro
Line Input not finding Chr10 or 13
Web Tables (Querying, Using a Looping Macro)
help with macro to read and sort data from multiple text files
Detect macros in an Excel file
Using solver in vba to max value by changing weights? Help???
vlookup help - urgent
VB 6.0 to Launch excel
Macro to copy exactly the I number of times that he/she appears in the column
how to link excel to excel i VBA
Date Validation via Combobox in VBA
redraw problem
Turning Automatic Calculation On after Workbook loads
order of toolbars in Excel 2007
Concatenation question
option butten
timer
ID Number Col A
Error 1004 - Application-defined or Object-defined error
please help : Excel visual basic editor
Hide Column Headers but not row (Headers)
MATCH Worksheet Function
Macro adding a range of percentages
Filter and fill cells based on criteria
Drag/resize an image on UserForm by the user
Display MsbBox in Word using Excel VBA
Macro and new rows
Comments
copying
Delete All Worksheets, Except for Three
Custom Number Format Excel 2003
VBA script
conflict with code
code for storing data
Select targeted rows
VBA Excel and Outlook
Need Macro to run on all Worksheets at same time
Pivot Table Dates
Excel 97 - Comparison
Rename Sheets but.....
Macro in a endless loop
Excel Fields to Text
Code doesn't generate correctly on two of 37 instances
Remove WrapText
Data validation - prevent cell overwrite
File to close itself and the current instance of XL
Redefining chart series
Input box and assigning to a variable.
Automating MS-Access DB to open correctly
Testing for Shared Workbook
Macro to move unspecified chart
Crashing!!!
Get Workbook path but from another excel instance
How Do I Create a Range in Excel VBA?
Automatisch beantwoorden vragen
ListBoxes_Change; Err.Num = 400
HTML files into Excel
Change row height if cell is blank
autofill more then one cell when the cells are not close to each other
Insert Row & Copy Formula
Populate cells with Listbox items
VB and I can't close the excel file
Format a ListBox column
Excel - Analysis Toolpack loading problem
Conditional Formatting Not Immediately Refreshing after Macro Exec
Font to be larger in line of VBA
GetCommandLineA fails under Vista
Saving to "MyDocuments" on users computer
Userform initialise not executing.
HOW TO INSERT "CONDITION" IN DATES BY EXCEL
help with macro to read and sort data from multiple text files
vba & SOAP - which soap library & version?
Copying and Pasting Worksheet between workbooks
print certain cells at the top of each page
print certain cells at the top of each page
Excel 2007 exponential slowdown
selecting sheets within a macro
order of evaluation
Excel and Sharing over Network
getting worksheet names from workbooks
Advanced filter vba
getdata macro with selection
Can I set an automatic timeout for a shared spreadsheet?
Interpolation
Copy method of Worksheet class failed
Convert Column letter designation to a number
Rows in macros
Linked Textbox Controls on Form - Avoiding Cascading Change Events
Help!! xlfGetDocuments returns invalid function error (xlretInvXlfn)
Microsoft Query?
Help!! xlfGetDocuments returns invalid function error (xlretInvXlfn)
Clear All Check Boxes
How to retrieve data from worksheet to a textbox
Fill column with default value
VBA Page Setup/Formatting EXTREMELY Slow... Help!
Formula for fill color?
Why doesn't this find the connectors on my sheet?
simple visual basic question - multiple If statements
Method 'Rows' Of Object '_Global Failed
ISO 3166 compliant countries
Get only unique values?
How to copy an image object to new location in shame sheet, Excel.
retrieve entry from a list in excel
Workbook named range not seen by ADO when workbook closed
event question
displaying 'inches' (") in VB
Display Zero's (0) in blank cells
Selecting more than one cell/colum with an offset statement?
How to open a workbook as a copy?
Inputting info in webform from excel vba
Paste not a Worksheet_Change event?
For each row in a range...
pivot tables: pivotselect with a very large table
Grouped shape name
Break this down...
Get image dimensions
Reindexing worksheet numbers
Auto run macro
Error message when opening a .doc file using excel macro
Shape number for a connector?
Time array
Trigger Question
Delete Columns not containing certain values
General Mail Failure error when routing
Hyperlinks issue
Loops question
Making Hyperlinks from a list of sheet names
selecting multiple cell
Help! Error 1004
How do I renumber a worksheet
Copy sheet into a new workbook
VB code to save worksheet as...
Converting to a htm file
saving excel workbook as csv format?
Copy image to tabs
Getting at the range or cells
Finding the row address with the specic value
date field is held as 38932 how do I export as 3rd August 06
how do i show extra information in data area of pivot table
Dates
Filter
how do i display some extra text information in pivot table data area
How do I add a new row?
Copy...Destination question
[C#][COM] Excel crashs when a cell name is a function name
find duplicate entry and replace across sheets
Display multiple results in 1 cell
Get Webpage data as text using VBA w/o Webquery
Help ! Project crash
creating an array
Emailing Range in Body CC Problem
working with rounded numbersnin a time sheet
Count consecutive repeats
Excel version
how do i derivate a math function?
Message Box with a twist...........
macro to cut/ paste ever nth row
Need help with a Macro or VB code for Header/Footer
LIST Button - Removing Arrow that goes left to Right
Move the cursor to the next row
If drop down list is blank, return error
Date Time Question
Date Time Question
surpressing listbox changes
Does an object exist?
repeating code on files in multiple subfolders
Concatenate Question
Automatically adding an Add-in
copy to closed workbook on a different drive
getting worksheetnames as links.
Passing collections to an object
Error Help - Method "Range" of object "_Worksheet" failed.
help to adjust my code
use VBA to tell if all the text in a TextBox or TextFrame can be displayed
VB macro
mapping table
Updating "#Invalid entity XXXX" using VBA
solver
Select standard toolbar button option
Deleting PivotFields From PivotCharts in VB.NET
Runtime Error '1004'
Conditional Summing
Unload/Hide Userform when switching to a new Wbk
After Query Update
SUM same range from multiple workbooks
Application.DisplayAlerts
Conditional Format: NOT Hidden Row, Not Locked Cell, No Data in Ce
DateSerial Troubles
How to Copy from One File to Another File
Pop Up Message only once.
Capture Enter in textbox
VBA Search Date Range and Populate Spreadsheet Cells
unchanging worksheet reference
how do i program a combo box
very simple VBA question for Excel
Can I save a copy of Excel workbook in MSSQL database using VBA?
Remove .xls from a variable filename
Loop Through Array Copy/Paste Value into VBA Code
help with macro
"Cannot change part of a merged cell" when AutoFilter is turned on
Search Existing Toolbars
Programming a Directed Flow Chart
Date update only on action????
Importing Multiple Text File in Excel
Microsoft Query?
XP 2002 Office Suite vs. XP 2003 Office Suite
VBA Gone!
Problems with ADO connection to same workbook?
Entering data into arrays
Need ComboBox to require entry before moving to next control
Sheet protection and cell fomat changes
Compare columns for dupes
Natural log function
sort macro
format cell reference in a text box
Find empty row and color
Hidden Worksheet
Excel crashes when opening file
how to do this vlookup
SumProduct - Why won't it work?
worksheetfunction question
How to round of the value with ends zero(0)
How to round of the value with ends zero(0)
Input box
Adding, naming Worksheets sequentially
Use R1C1 to select cell
Combo Box
Count duplicates as unique record, sum amounts?
Re-set autofilter selection after adding a new row - programmatica
Formula needed to show blank when values do not appear
Copy image from existing workbook / template
macro that copies and pastes
Inserting a BLANK row
Auto insert blank rows
Copy sheets without macros
VBA Program to calculate Subtotals
Copy destination = different file / different Workbook
Importing Text File
STRING SUM UNTIL
Help with selective info in a FORM
IF Then Statements for comparison
Aligning a connector to a cell edge?
Help with Enable Macro Error Msg (Excel 2007)
SmallScroll & LargeScroll Methods in Visual Basic Applications
Query Folder for Spreadsheets
Returning values to unique rows
COST CALCULATOR
Help with Autofill Routine
Folder Tree and size
remove macro and security warning
create tabs and add hyperlink to each tab
how can i isert a funtion in F1 or F2? Like F1 put DEP in a space
checkboxes' return value
If Statement
Deleting Sheet Message
Help Creating Code
Is there a simple way to combing 1D arrays?
English (UK) Settings Problem?
Excel 2007
Text box results to become a Variable
Macro Help
Using result from text box as a variable
question regaridng checkboxes
q: is this possible in vba - multiple command buttons..
getting worksheet names
Moving around an User Form
Excel returning a record set from a stored procedure.
Reset Validation lists to display 1st value in list
have excel go to defined cells when pressing ENTER
Search two Strings
Stand Alone program
Runtime Error '9'
concatinate a textbox name
Pasting hyperlink from sheet A to Sheet B?
Programmatically reading from Excel and formatting
Matching to dynamic range.
Excel 2000/2003 to Adobe PDF convertor
Question on macro (copying filtered selection into the newworkbook
Hi-Lite "empty" unlocked cells in non-hidden rows
Programming with the VBE using AddFromFile gives Run time error #9
Set drop-down box name
Dynamic change of limits in for...next loop
Web query problem when password required
if statement and cell formatting
Updating a last modified date using the worksheet change event
Disabling error message with Web Query
Color locked cells only in specified range
Opening different files one by one in same folder
AVB Help please
cell date format problem
VB Code..
unique list from a range of cells
Automated graph distortion
using vlookup in a custom function
Resource to begin programming
Limit distribution of a spreadsheet
Referencing a sheet name thats ever changing
Trouble with csv export...
Extending objects in Excel 2003 with VBA
Sorting Multiple Columns in a single operation?
Help in adding another check to my code
Help with events
Macro Formula
remvoe the prompt?
Unhide sheet on open only if password to modify is given
How to run Solver from Visual Basic?
Excel 2003 Pivot Table Drillthrough
Excel 2003 Pivot table Drillthrough
Search Access Table with Excel
Data Validation - Multiple Time Slots
Help With Code:Arabic Number to Text
Mod and Int gives me a Runtime Error 13 -- Type mismatch.
Programming a button
Protecting menu in a workbook or sheet
Staff Capacity Plan Template
ActiveX Control with workbook
help on while loop
Can I pass control to a 2nd workbook
Lock Page Field in a Pivot Table
Opening a pdf file with Adobe Reader
Pivot Field Format – Macro Wanted
Worksheet Activate event if only one sheet in book
Can't Get Listbox Value
dates and pivot tables?
BackgroundWorker inside a user defined function
Farmula wrong result
Format Number as Arabic (Saudi Arabai) inside text
Using If Statement
do xl add-ins have worksheets?
Convert number to arabic(Hindi) format with text
Dependant List
UpdateLinks error?
Convert number to arabic(Hindi) format with text
Count the number of users accessing a shared excel workbook
Excel 2007 Bug
Hiding a Form that's not open
how to select a particular range
copy rows that do not match values in dynamic range.
WorksheetFunction OR
DDE - Chart.Wizard does not work in Office 2007
external data works in 2003 not in 2000
Setting tab widths
copy data from source file to w/book
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?
Adding checkbox to worksheet in C#
Vba code for migrating data from source file to w/book sheets.
Programming a NAME
Dependent lists
Pivot & Ranking
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?
Sorting and mapping change
Using a code n times
setting print range
R1C1 Problem
Can anyone tell me the proper code to copy a range...
Breaking excel links in code?
Merged Cells: Any way to backtrack?
Drill down combo boxes
Can Bloomberg BLP functions create an event?
Cursor movement
Upload range into an array
How do I export data from excel to Powerpoint by macros in excel
No userform, runs from module, want to change mouse pointer
Hide worksheet changes when userform displayed
SumProduct, Match in a UDF
sumif and countif?
getting worksheetnames from subfolders
Fill formula to last populated row
RE: Macro - 2 Sheets - Find/Insert/Copy/Paste
How do I use UDF's in Excel 2007 from 2000
Userform sizing problems
Using a macro to add a count and sum on a dynamic range
Creating a PRN file from Excel
Disable Range Reference Update in Vlookup
Disable Range Reference Update in Vlookup
font scaling problems
Save default dtpicker value
pulling information from a closed workbook (revised)
Message box trigger?
Macro not protecting every sheet
pulling information from a closed workbook
Save default dtpicker value
Excel and 'refresh data' dialog
xlPasteValues
Specifying adjacent formulae for a QueryTable AutoRefresh's FillAdjacentFormulas
String concatenation having null character
Pivot Table w/IF Stmt
Launch an excel hyperlink programatically without clicking
VLOOKUP question
VBA Excel Macro
Listbox Code
Public variable not accessable
format of copied data unclear
Conditional Formatting Formula
Dynamic Dropdowns
Copy row to next available blank row
Unwanted Listbox Horizontal Scrollbar
Application.quit
convert 1006 to date (01/10/2006)
COUNT Function
Rowsource Invalid property value
How do I search by user profiles by username?
Passing a range to a UDF in VBA that references a different worksheet
Fill Listbox with Unique Items
Populating a combobox
Start Date And End Date with pivot tables?
Assigning range to variant
Vijay 1
Assigning range to variant
Work Sheet
Please Help with Short Macro
Insert page breaks every 50 rows but do not include hidden rows
VBA - Row Deletion using If/Then Statement
spliting data in a cell
VBA macro resul Microsoft Excel for Windows has encountered a prob
Long footers in Excel 2000
Macro to set end to create range
Is Win API needed?
Dynamically hiding fields using VBA
Create a pivot table with a local connection
Disabling the refresh of a pivot table
Workbook_open event disabled by manual calc command
Using count for an AND statement
Validation Testing through list
Programatically Naming Worksheets (using catenated values)
Running Macro at sheet activation
Select cell without copying it
identify consecutive columns they are coloured
Need help creating a variable size printarea marco.
Connection between MSSQL from/to Excel
looking for duplicate rows
Two questions about PivotTable in Excel
WorkBook open event
Automating Tasks
Is there any protection change event?
Please explain code
Effecient method of copying and pasting required
How to identify account username/userid when connected to a sharepoint list
listbox issue
Highlighting first line in list box
ActiveSheet.Paste takes FOREVER!!
Test
List Box
Drop down select with same cell entry
opening excel file
BeforeDoubleClick doesn't seem to work
Temporary suspend the validation
List Box
Open event trigger
adding range values to array
WorkSheet_Change code from a CommandButton
best way to set up macro library so all spreadsheets have access?
ListBox with header row, delete row, protect header row
Microsoft's drop down box
Excel 2007 - Personnal CommandBars
GetSaveAsFilename alwyas overwrites existing file
Rota cycle
copy from one sheet to another
Error code - Could not decrypt file
Show/Select Visible Rows via ComboBox
Help with code
Column function
Chnge code help requited
Find * in a cell & ClearContents
Copy paste from Excel to Outlook - Graphs, pivots & cells
Transpose certain cells in a row while keeping other cells intact
Using Excel template from VBA - Virus scanner problem.
Use of Like to extract data
Application.run is not working
Auto Update Pivot Table Help
Combine consecutive Rows
How do I Create 'ragged' arrays in Excel VBA?
SaveFileName in Excel
I am trying to create a sheet with doubled drop-down lists?
Syntax for a macro to unprotect a union of cells
VBA print preview hangs Excel
ADO - Paste Links
Pivot Calculated Field -If Statments
Call Macro on KeyPress
Excel 2007 formula error
Create hyperlinks from external links
Thank You all for the help..one more question..for now
Track color change
2007 EC Excel - Access User Conference
I need a work schedule template for a union plant with 170 people
File protection
Search for Code
Combine consecutive Rows
Copy from recordset errors in ADO
Include help for a user defined function written in C#
attaching specific files to e-mails
RE: Edit Microsoft Query
yield analisys tools
yield analisys tools
Moving a shape with text inside without editing text
copy excel
formula help
Using Lookup in a macro
Tabstrip
Loading a JPG into an Excel worksheet
Excel Copy/Paste Macro to another open application. QWS3270
Click Event - list box
Image on Connand Button
Send data from userform to specific cell on specific sheet?
Can we get the current page number, or just row number?
Can macros be viewed or edited while in shared mode in Excel 2007?
Problem loading userform with frames
VBA Stringbuilder
Split data to worksheets
I need to add an Input Box
Cumulative summing: sum rows 1-12, then rows 1-24, 1-36, etc..
Excel 2007 - Deleting Rows from a Table with AutoFilter
Exception from HRESULT: 0x800A03EC when setting string in Range.Value2 field
Export Excel Spreadsheet into specific table in Orcale
rng no work correct...
Macro protection - How to test Windows registration infos
Store Data
browse between worksheets ?
How to add a button in Application Level Excel add-in?
Remove Left Most character
Sending e-mail using CDO
How do I implement this in Excel? Need programming tips.
Macro
Trying To Open Second Copy Of a .XLA?
Copy Multiple Workbooks to Worksheet
Userform Stepping Through Sheet Data
Userid
Distributing macros with an addi-in
Slow down by page set up code
Record macro to include changes in dropdowns
user entry form for excel search
Hyperlinks after a SORT
I need a Macro to extract data by customer to new worksheets
For Tom Ogilvy - ADO issue
Excel document not saving
ADODB.Connection
"Procedure declaration does not match description" error, _dblclic
Password protect macro via a macro
Can column character be added?