Excel Programming [Archive] - Page 16

copying row data through a macro
trimming a space in the middle of a string
SAVE AS MACRO
hyperlink creation problem
Setting A Default Value
Macro to Hide/Unhide various columns
Macros have slowed to a crawl
Find stops macro if no match...
How to confirm a cell entry is a whole number
Ron de Bruin's Merge - Can I use multiple named ranges??
Wildcards in a case statement
help with my code
Multiple options with multiple ranges
code to hide rows based on criteria - but without looping
Change the action of TAB Key
Comments changes as active cells changes
Problem exporting code in Excel 2007 VBA
Need values not formulas - CopyMultipleSelection
Group lines of data and subtotal
Delete defined names with errors using VBA
How can I use VBA to SubTotal
Number Transforms Into Euros
input box
a little help with an non critical but annoying error
VBA code to copy multiple Excel files from C drive to network driv
Object required Run-time error '424'
Change one label in another form
Help with a very complicated For each Next code
Edit File Properties: Title, Subject, Keywords, (MetaData) w/ VBA
Synax help/ worksheet array
Macro to copy nonadjacent range and paste
GemBox.Spreadsheet v3.3 Released
Sending mail to different mail address based on cell value
Sending to email different email address based on cell value
Query from Access Database based on user selected parameters in Excel
Using a dde link how do I write the data from the "live" cell to astatic cell
Scan/copy and automatic update
Display an Excel form from PowerPoint
Round Percentage
Macro to save the excel sheet to PDF
Replace cell values in multiple columns
Sub to check data by client n add new symbols to client's list
.Find method with numeric and date values, Aug2009
Stubborn Array won't Populate from single ADODB.Connection Query
Find and replace
UserForm Question
ListBox1 = ""
On error resume next
On time from cell time - Followup
xlUp Not Working
Activex Initialization error?
Find value from one sheet and replace value in second sheet
Having a problem with 2001 compatable functions in 2007
Compare two sheets, then copy/paste if different
Office 2007: #NAME error on UD formulas that were fine in 2001
Rond merge help
external link to start excel form
Exit Sub when File Open Dialogbox is cancelled
Display of a negative percentage in Excel with Brackets (22%)?
Variable in Range for excel
Excel 2007 Tables - Get Active Cell Row and Column
variable not reading correctly using sumproduct
Action from list selection
TIPS ON A GENERAL STRUCTURE TO START WITH, ANYBODY?
Change Textbox Backcolor and Forecolor at Runtime
Shouldn't the last workbook/worksheet created be the Active one?
RowSource as Sheet Names in UserForm ComboBox
Between Dates Criteria
calculating ages from dates before 1900
copy area on spreadhseet as picutre
special graph format
Reference Range across Worksheets
Row Height-expand if text wraps in a cell
How to disable " Send To " menu choice from the file menu
Insert Column into active Excel Sheet from Access
Consolidate all tables
CreateWindowEx
backup file
show/hide sheet tabs in '07 ribbon
specifying the column for double click
Copy WS w/ Named Ranges in Excel 2007
Formula Help
Syntax to close Workbook
VBA book
How do I find last occurence of a character in a text string in Ex
Migrating Add-ins to Office 2007
1004 Error: Unable to set the LineStyle property of the Border class
Vlook up to combine data in many sheets
Multiple Graphs VBA
Security Issue with Excel 2003
Message Box should Popup on condition
Sub to transfer values and log the transfer
Working on segments of data from within a list
How to combine amount in manys sheets into 1 summary sheets
Convert 2-digit year
Button to copy formulas
Macro for use in individual workbook
Remover ODBC Dialog Box
Please help with formating
Absolute Scale of Chart Printout
Code for combobox
Customize where FileOpen Pop-up starts?
web query : part of a table not captured
Code for unique Data Entries?
Adding % to gether?
automatically load an object library in real time
Using Macros to Write Links
Sum If - Using the value of a parameter or constant in a formula tochange a condition
Run-time error 9
Querytables WebTables equivalent for InternetExplorer.Application.Document.all()="HTMLT able"
just learning
application.worksheetfunction
UserForm Show Problem
How to load this online worksheet into Excel?
COMBOBOX AND TEXTBOXES QUESTION !!
Compare dates in two worksheets
opening outlook and populating
Determine if specific text is in a cell
Acos function
Mail merge leaves excel process running
Autorun macro does not autorun...
Resetting ListBox1.ListIndex to -1 after user selection
Invoking Range.SpecialCells using IDispatch.Invoke
differentiating between checkboxes
Playing Embedded Sound
Help with .Find Function in code
Why variable isnt working
Tough one - Cell referencing in Excel/VBA
Multiple critera
Tannspose and cycle
Excel 2007 chart line width + axis labelling with VBA
Using Macros to write Links
How do I have multiple workbooks open and have a menu to switch be
Retrieve data only
Application.FileSearch
THANK YOU
Code Run-time Error '13
interactive findnext
Excel .xlsm / Vista / Speed Problem
Can I loop this somehow?
Run Macro (VBA) every 5 minutes
Concatenate and Delete Macro
Copying a row to another spreadsheet
Need to Copy Files (all Subfolders and Files)
Multipage - If .Page(#).enabled Then
Names
Automating macro to run macro from Access
Help with Worksheet_Change;section of code not woring as expected
Excel Worksheet Function Large
Find/Autofilter
Userform and email
Sort Named Range
How to export a range to CSV
Referring to a cell without using Offset
Did evalution of empty cells change in Excel 2007?
Refresh External Data code
Rhino V
Simple if statment just not coming to me
VBA Collections
MACRO THAT BUILDS ON ANOTHER MACRO'S DATA
Can I pull 2 different data tables into one pivot table
Autoshapes loose formating when formula is removed
Help please
Main data sheet convert to high level
drop down and textbox
Give CurrentRegion a RangeName
web query and formatting
Can't find bug because program justs Stops !!
print the pdf file
populating the recipient address in outlook
Run-time error 40036 Application defined or object defined error
SAVE AS MACRO
Run - time error '1004'
problem with "file not found" calling a dll from VBA
Automatically adds a row
Help with counting cells in a selected range
turning off pop up message
ADO help
10/21 Screen
How to populate VBA Variables from ADODB.Connection Results?
Macro for Consolidation of Info from Different Tabs
text to column/row
Colorindex and conditional formatting
Pause in a macro
Copying certains rows to certain worksheets.
How do I pull variable URL from one column and download the contentto another column?
vba insert row does not update Sum formula
programming in vb.net application
Excel Code does not work in Access
Row G equals to any of these part# turn color
Need VBA to delete row and subtotal
Importing Word Data from Form Field with Line Breaks
Combobox - Problem on AddItem
query to external data
Data Entry Macro or other
Checkbox problem
For Each Row in Named Range
Row Height-expand if text wraps in a cell
modules removing problem
REPOST - CF, MACRO
Personal Ledger Problem
Public variable Forgotten by VBA!
XNPV in VBA
IP Address
Macro for Consolidation of Info from Different Tabs
Macro help please
Tier As Range Function
MACRO EVENT
find file that starts with todays date
Datediff & bissextile year
How to change SQL in an existing pivottable
644
Copying Data OR Selecting Columns In Pieces
Debug, Please help
Clarification need, not just by me
Blank cells problem
TreeView.Nodes.Clear crashes Excel 2002.
UserForm Question
Just out of curiousity, why didn't this work (a change perpetuated to all sheets)?
col A,B and C-P moved fr Sheet 1,2, to Sheet 4
Need VBA code to make app expire after period of time
How to display first line in a text box
use sql select statement to load data into pivottable
Can't added two columns from one listbox to two columns in another
Retrieving Data from SQL Server to Excel
Hide Macro Password Characters
Macro VBA Help please :)
check date format in regional setting
Creating a Macro that Selects Determined Values from Drop Down Lis
Help with a complicated For ... Each ... Next statement.
Auto-sort data tables after refresh
VBA Hangs
Lottery Spreadsheet - Find data in a table and color it...
Excel Spreadsheet display with autorefresh
lookup function or table from dates that the overhead changed
Print Avery Labels from Cell Data
How to: Create Dependent Drop Down in a Form
Add ins (.xla) VBA project
Listbox help.
Conditional Formatting Help
SetFocus problem
Macro
MSQuery Parameter in WHERE defaulting to All
Web Query - no leading zeros HELP!
Complex Compare Values, and Copy/Paste if in One Sheet but Not Oth
How do I avoid printing cell borders?
rename sheets(tabs)
hide rows of blank cells
How do I list Ampersand in a caption or quotes? -- & in " "
New Name Dialog parameters
Excel 2007 import text file VBA code - Origin:=
myCell = CStr(SomeDigits) ?
pulling just unique records
How to hide "View Code"
Random Numbers
Macro
Want to read text files of random extensions into recordset
Biased Number Generation?
I've been working a littlbit too long
Store VBA-Code centrally
Run-time error '1004' on server extraction
R1C1 Formula
References Different on different machines
Parameter Query Refresh issue
how to add a pic in to excel cell
Clear Contents of Offset cells automatically
Inserting an object into a cell
Excel cells automatic formatting of text
Change Event
Updating the code in multiple workbooks
Workbook code works on my machine but noy others
How to make the application wait until ODBC Extract is finished
HOW CAN I SETUP IN EXCEL IN THE CELL AMOUNT IN LETTER IN OTHER CE
copy a cell value to an open outlook template
Worksheet automatically saves itself after data is inputted in cel
VBA to delete Duplicate Records (1 column), before which, non-duplicate data merged into remaining row
Iterating on several Cells within a Row
Displaying Currency numbers (e.g. "CAD 1,999") on worksheet
Application Name differences between Excel 2003 and 2007
selecting data for a chart based on specific criterie
Copy range from Sheet1 into empty range in Sheet2
VBA, Macros and Pivot Tables
PivotLines collection
Show Userform when Application Opens
highlight row of active cell
MACROS WONT RUN
password protecting one particular file
Erasing cells when the validation dropdown choice changes
Macro To Update Pivot Tables on Several Worksheets
Share and protect
not showing blank cells in a chart
Data from 2 sheets to create a new sheet with user input?
Sub-total using Advanced Filter?
Center spreadsheet in middle of window
Creating a form
Create N variables
Userform Calendar
Converting Times
dynamic pie chart
Insert total of page in a worksheet in a cell
RE: How do I make a button in an excel spreadsheet for sorting?
taking a word out
Select one or more worksheets from a listbox
Comparing values or text in 2 different workbooks
Combo Box text vertical alignment
Update to List-Comparison Macro to Show What Data Has Changed?
Macro Help
Copy & Paste - Unsafe?
autonumber plus
reference named range
Use of NOW() function - followed by locking the cell
Listbox with Multiple Columns
follow hyperlink then de-select cell (VBA)
Query Data in Excel S/S from Access DB
how to copy and paste "averages"
Putting Formula in all cells give Circular Reference. Please help
FTP DOS vs Windows cmd
Compare columns
ATPVBAEN.xla!Moveavg- where to find explanation of arg involved.
Pivot Table - how do I get the name of the current table
activecell serveractions not updating before code crash
Workaround for Excel 2002/2003 UDFs recalculating and changing cel
a macro that runs automatically when a workbook is opened
Excel Worksheet ListBox
PARSING DATA TO SHEETS
Help needed for creating PDF file from macro enabled xls file
Complex Filter
Help writing a CONCATENATEIF function (filtered concatenation overrange)
protect VBA project view by VB code
Invalid procedure call or argument
Macro to copy certain data from one workbook into another
Pls help with Excel UserForm
Hyperlink with an active x control button
Template(s) Question
Run-time error 91: Object Variable or With block variable not set
Reference Combo Box to Column of Data
Find match from 1st 3 columns and return the row number
import from text file with VBA code
Refresh Queries in All Worksheet
send email to email address in column
Excel 2002 Errors
Copy-Pasting Excel Chart into Outlook default email editor (not MSWord)
How to pass a dynamic array FROM a function TO a sub
Macro - Import, Delete, Concatenate
Copy & paste special
Conditional Format issue
finding the "(" in text
ModifyAppliesToRange question
Run macro to update fields?
alternative required; Fo Each Loop
Match question
Formatting issue when sending e-mail via CDO to Excel 2007
lookup part number and category and provide intersection price
Open files with String prefix
Activecell.ServerActions
Disable a file from searching for a link update on a different user'scomputer
Combox Box - Need to Reference Named Range
VBA Code and Pivot Tables
Sendkeys "{pgdn}" in Excel 2003/2007
vba & bloomberg (gethistoricaldata2)
Type mismatch error
Help with macro
Run - time error '1004'
RE: Shape Change Event
Macro - Find unique value and paste with content from column with border
excel addin
Pivot and charts.
runtime error 424 'object required'
List Box
Getting data from the Internet
Recurring report recurrence updates and history tracker
Unexpected window positioning error
Shape Captions/Labels
Excel not calculating
format a mail-merge file to send 1 message with a list of items
update combo values based on listbox values
Is Multi-Sequence Search Selection Macro Possible?
Works on the trial verson of excel 2007 but not my student version
find last column with data
Re: Sum Variable Range of Cells
Move AutoShape in Sync with Date
Problem running code in proper order
Disable Change-event macro
Change Event (How post Date/Time to Changed Cells Rows but different Column)
Range("Y1:Y" & LastRow & "&")
call duplicated
Number of searched items by google groups
Re: Code Not Working Properly Anymore
Line Input Not behaving...!
Run file from VB in Excel
Re: loop a specific number of occurrences
How to restrict printing certain sheets
finding last column from a target row
Testing length of a number
More Dates
Damn Dates
looping issue
Excel 2007 how to set solver options as available in Excel 2003
Upgrade VBA code from 2003 to 2007
Comment boxes
Working with times - Bug?
Create User Defined Function with VB.Net
How to Change ALL Hyperlink Addresses in a Column?
Concatenation in MsgBox
Excel not painting client area
Copy To New Sheet
Macro to insert value from range on different sheet and copy sheet
copy sheets
Printing Message
cell to worksheet
Copy & Paste on same day of each month
MACRO - RELATIVE & ABSOLUTE - 2007
Setting references in VBA
Sub to freeze all sheets & delete all comments
Need hardware locking for Excel application
Delete Sheet executing macro
Copy Entire Row - Rick Rothstein ?
move cells that meet a certain criteria to the row below
Counting OptionButtons
help with code for scientific worksheet
RE: populate a drop down list with commands
Re: How to prevent a number stored as text from converting to anumber
RE: User Form
Re: Reusable ActiveX button?
RE: Question about globally declared array not available in functi
RE: Copy info between 2 specific words
Re: Still can't validate entry
Multiple drop down list
Print Preview Ribbon
little off topic, but with excel 2010 conditional formatting properties will be accessible through vb
Can my UD function know what cell it's in?
Is there a better Sort than Excel's default Sort?
macro 2003 error 2007
One click row highlighting
Filter Field selection.
References that move down as formula moves across - and vice versa?
Range.
Macro button help!!
MAximum Lines Of Code
MsgBox working is Excel Macro Programming
Separating Values in a cell
Can macro type "vbKeyNumpad5" into a cell - to check for NumLock o
Resetting error reporting after On Error GoTo
Find current row number and select row
Run Marco on 5 out 10 sheets
radio button text bold when clicked
Prevent duplicate entries within a range of cells from a drop-down
letter inside radio buttons (option button)
.Execute replaced in Excel 2007?
Error 1004, paste method of Worksheet class failed
Matching Rows 2nd try
application.filesearch
XChecking i a chart variable is empty
autoclick "ok" msgbox
Macro to import CSV file from fixed directory
Populating Userform and then using selected data.
VB password lost
Looking for an easier way to change the name of copied controls...
Adding date to bottom of worksheet
Do loop with find
array formula question
Sort problem
[VBA] COMBOBOX SHOW WITH CONDITION
Pipe to cmd from excel and back
Refresh screen during scroll
macro to loop thru sheets and add info
Suvive value of Public variable
How can you change file format from .xsl to .xml programmatically
Data Validation Pull-Down: How can I make it longer?
Problem importing Access Choose function into Excel via VBA - skip
Macro reference to a specific cell on a different worksheet
Control a worksheet w/o activating
counting xls files in a folder
Finding the Y-Value of Points
2 loops? got me spinning
Another UDF Question
Help with userform problem: error message> "obj doesn't support thisproperty or method"
Copy Entire Row based on Cell Value
use a variable to set a range
Hyperlinks
VBE and Arranging Windows
Application-defined or object-defined error
How do I increase the available number of formats in Excel 2003?
Vlookup and VBA
Creating folders as per date.
Too much coding for macro?
Run time error 462
Dynamic vlookup from a close workbook
Finding the same unique identifier in multiple worksheets
counting excel files in a folder
How to get the value from a variable
Using a Combo Box text selection to find text on another worksheet
name of file folder
xl2007 data validation drop-down box
Can you sort one cell or a string in vba?
Find last occurrence of the value Yes
Connecting to SCCM Report
counting excel files
Attach file to e-mail using excel macro
VB.net to replace unstable excel add-in
how do you delete controls on a form
Ungrouping sheet tabs with a Macro
Excel Cursor
Validate Year
Easy way to extract data and put into Excel?
Inserting variable outputs into different ranges
UDF Frustration - Won't Update
Exporting from excel to word: issue with data displayed in word do
Input Box labeling
Set Date to Last Day of Month
Scale and Aspect Ratios diffferent
Macro for Full Screen
Incrementing Column Values
Macro to Sort
Code Execution Inexplicably Stops & Excel Soon Crashes
How to add Date Stamp to SaveAs "file name" within VBA for Excel?
How to CheckIn a checked out file in VBA?
Count totals for the same accounts
Reverse name order
ADD LISTBOX, COMBOBOX, LABEL IN THE SAME USERFORM
Cells not updating after data populated into spreadsheet using ADO
Is there an equivalent function?
Error location in VBA
populate word from excel: On clickin "Export" button in excel
Run macro brfore close
"Project is unviewable"
Userform problem with "obj doesn't support this property or method"error message.
TextBox Change/Exit problem
HELP WITH SUMPRODUCT FORMULA USING YEAR() and MONTH() FUNCTIONS
Range row Address.
Set CopyRange Error
Can't find project or library
Open another workbook if condition met
Rename Multiple File Names in Windows XP Professional 5.1
Creating a Calculated Field in a Pivot Table for same field
Formula to calculate exact months and days between two dates
export certain cells from excel to word
Index on another worksheet
How to Show 12 months dates on the basis of from today's date in
Something wrong with my vba code!!!
pasting value ranges of new data into source worksheet
COMBOBOX SEL. / LISTBOX SHOW (VLookUp)
Capitals
"/r/n" CSV file In Excel
Excel interacting with another program, continued from 8/9/09 thre
Macro for Message Box
last day of month in prior month
Double vs. Currency
Chapters???
New Q to old Post: Stuck at Trying to Extract Data from a Website using JSP
Combo box change event triggered from another file
fill range
setup.exe
Compare word document in excel
run macro on cell entry
Copying and pasting a worksheet to a different excel workbook
How to detect changin filename & to hv more than 2 autofilter crit
Problem when trying to set axis properties of a chart by VBA
Adding new name to Names collection
How to Inserting rows above specified cell
Help with Hyperlinks
How to get the count of filtered rows after applying autofilter?
Excel 2007 connection via oledbconnection
loop through and update
Type ahead in data validation list
Page Break Problem
Change from Text to Value
Multiple entries put into string
Minimum width of UserForm
Query then pivot table
Unprotect workbooks
Connecting to Oracle through Excel VBA
subtotaling a column based on three others
finding a specific value on a master file
Trouble referring to a (dynamic) named range on another Excel shee
How do I store my VBA UDF?
Open, Update, and Close files automatically
I need a formula that delete first character and adds another
Run Time Error
Excel 2007 macro recording feature no longer works for inserting p
Increment a range location
Can a worksheet (tab) be renamed via a cell's value?
Need formula to create a value in a single cell by searching a range
selecting cells and getting their content into a string?
Excel 2007 Condition Formatting - Dates
Macro formula array return limits?
Obtain an objects current location
Please have a look at this ....
certain day of month
Exce small program
error displayed on rs.open when using late binding
Opening Macro Files
Couldn'nt unload a form
Open Dialog..! in vb code..!
Addin Security
Listbox Auto Column Width
HELP - Retrieving cells from another workbook
VLOOKUP Insert & Copy
Criteria
Deleting Rows across Several Worksheets if Value = 0
Split function - assign to array
Checking characters
Unable to view variable
Always creates the new range which is not needed in the macro
Lost VBA project
Locate and change font color
Extract auto-calc % scale so as to construct a macro to addcontrolled Page Breaks
Complex Copy
2002 excel isn't playing well with 2007
Macro works on some but not for all
Copy List of Files using Excel
Can this be done "Open Input Box"
macro to select reference in tools-->references
on error resume next
How do I create screen tips?
Access Object Library Reference issue!
Access Object Library Reference issue!
Access Object Library Reference issue!
2 dimension summing (sumifs with 2 axis?)
Code Name of Worksheet in a Formula
Shared Workbook
Check Worksheet Name and Select if Meets Criteria
vba coding question
Using variables across userforms
VBA SQL Server Stored Procedure creating a Pivot Table
Macro that deletes and pastes filterd rows and then some
adding a cell in a text string
TextBox change issue
index/match type issue
Excel macro in Access module
CurrentRegion.Address
Multiple Worksheets, Date
Protection in code?
Can VBA Programs Run on a Locked PC
BUG: print command from command button in userform causes double c
date based question
Multiple Website Import
formula referring to total
calculation
Environ("USERNAME")
How to handle persistent properties in Excel VBA 2003
Autosum
copying cells from one file to another file
Best way using Macros
Merging cells with same parent.
Merging cells with same parent.
Merging cells with same parent.
Finding what has changed.
Excel 2003 interacting with another program
LOOPING THROUGH A 2-D STRING ARRAY !!!
Change the structure of words?
more array help needed
array help
Unexpected Error
macro code to a shared file
finding dates from drop down
How do I assign variables
Floating Bar Chart 1004 error
insert rows after data change in column
Simple VBA
Find next problem
Macro
VBA to Assign Outlook Task
Conditional Formatting a tab color
deleted cells
tab order in excel
macro pasting and moving
sum of absolute value of each cell of a column..
Disable right click menu
Little Problem, Difficult and Hard.
Need hardware locking for Excel application
My ref: RN0001 Find the first & last occurrence of a strings
Automate Pivot Table with varing number of records
Workbook still won't save customized QAT
filldown recurring 121212
Filldown recurring 121212
Format cells help
Formulas using two cells
How to password protect an 2007 workbook without show readonly opt
print button prints two images in same chart
Scrolling and date matching
Using variable names in a loop
Workbook custom document properties
Looping through sheets and comparing data
making code more efficient
How to sum the 3 best scores for each country in a contest?
copy method of worksheet class failed: trying to copy a hidden she
copy method of worksheet class failed: trying to copy a hidden she
copy method of worksheet class failed: trying to copy a hidden she
Programming error - Procedure too large
subscript out of range error: tyring to copy a hidden sheet
subscript out of range error: tyring to copy a hidden sheet
subscript out of range error: tring to copy a hidden sheet
IF, and, or statements combined
Finding a specific text
looping macros
Sorting Images in Excel 2007
Excel to Powerpoint 2003 Chart Width
CSV code works on some, but not all machines
print command from command button in userform causes double chart
Macro Recorder Doesn't Record Anything
flash movie on userform doesn't play when code is running
Error when saving as TAB TXT (euro transforms in $)
Go to sheet based on ListBox selection
System Dates
Graph and data
Countif help
Application or object error - one last try
SubTotal when Cell Changes
How to run same macro on 14 out 15 worksheets
Exclude sheets from code
fixed filter criteria made variable
Delete Method as it applies to format Condition object
DTPicker stopped working
Copy two sheets from workbook & create new workbook
Manipulating MS Access records with excel VBA + ADO
Filter & sort
Remove buttons from workbook
Lookup where target worksheet may vary
unable to load WinSocket dll in Excel Visual Basic Editor
trouble with subtracting elapsed times
Vlookup in to find in multiple table
Macro Help!!!
Auto Update a sheet through Macro
How can I search the Excel groups archive
VBA Code Error
Code error message for Excel 97 users
How to get lookup data from Access Table
Open userform at top of form
Application.Ontime for Private Sub(Proceedure) - ThisWorkbook*
re-activate personal workbook
Problem with VB Objects in Excel
consolidate data that occurs close together in time
Delete Sheets Without Contents
New using macros
Find string/date in array to get value of nearby cell
Detect #N/A or number
vba
Row source question.
Loop through textboxes on a userform?!
Possible form error.
Filtering based upon a remote value
Object Selection
SendMail
Re: extract formula result form cell without running formula again
extract formula result form cell without running formula again
Enter Value based on Cell Color
Concatenate and Delete
How to Pre-Select items in Multi-Select List on Form
Public Function Description
Question about running macro from VBS
Error 380
CountIf function refering to another worksheet
clearing data from a user form
How to insert picture using VBA which refer to cell value
Subscript out of range
Open Folder containing Jpeg files to get hyperlink
Macro to Delete a Row
xlFillDefault
Macro Activation
RECORD SENT EMAIL
copying information from a web site
Value of type 'General' cell different from 'Number' or 'Text'?
Password protect worksheet
Find links to other worksheets using VBScript?
Macro for extracting the filtered data only.
Copy contents of cell to another tab
Script to refresh data and save and close
Transpose Links
Determine cells with "General" number format
Macro to copy data to next available row
Multi Workbooks / Emails
If cell contains specific formula (GETPIVOTDATA)
Excel workbooks and programming upward compatible?
Sending 3 email?
File in Use dialog when I Open an extra excel via the (start menu)
Find first row number after filtering
CDate or CVDate
Sum sections of data
Copy a set bit of text to the clipboard?
.htm error
Which Worksheet is Active?
Find in another worksheet and copy to original worksheet.
Efficiency in code
quick!!!!!!!
What is the VBA equivalent of the excel function VLOOKUP
Select method of Range class failed
Unmerge cells and fill duplicate data
Function that returns if a given cell is visible or not in a filteredrange
Copy 18 Cells in one row
New line of code.. same argument?
Find a cell based on value?
How do I preserve references to table cells across sort operations
Why vbscript examples do not work?
Cond. Form. Adding In dates & out of dates
List of text in a message box arranged in rows
macro / formula problem -- rearranging names in a selected cell
savecopyas read only
Copy Text From PDF to Excel
Suppress Zero
Macro button that asks for password before proceeding?
Move data worksheet to worksheet
Add to LinkSources
Create Interactive Web Page from Excel File
Application.Run error
Linking to Summary Sheet Changing Range
Counting number of e-mail arrived with specific subject for a day, from Excel
Macro copy values to a different workbook
Upload Excel data to web service
Set datatype of a cell?
Need Code for Opening Old Files
Odd Workbook.Name result
Code to Delete Data in Specific Cells
[VBA] Conditional Formatting
Updating criteria table in one spreadsheet from another
Saving outlook attachments with VBA code
BIDS - Excel Pivot Table - Data Cube - What - if analysis
Sum only selected cells
VBA code for sending multiple email attachment??
Excel 2007: Graph macro using reletive reference?
2 level sorting
Excel VBA-Worksheet Name length issue while Querying frm another E
Find Method for finding the next value in a range GT certain value
popup balloon (not msgbox)
Excel addin doesn't work.
On time from cell time
How do I preserve references to table cells across sort operations
Raise Event Problem
Excel 2007 -- Automation Error
Add Microsoft ActiveX Data Objects 2.8 Library in code
cell value
Copy/Paste?
Run macro when when changing cell value with formula.
Selecting a specific file from many
cut/copy & paste w/source formatting except for conditional format
= Today()+1 into Sheet1, Sheet2, and Sheet3
Trying to Close File
Import MS Project Data through Query
Import Excel Data to SQL Server
Replace
Lotus Notes email background processing and open new message.
HOW DO YOU MAKE EXCEL REPORTS INTO ELECTRONIC EMAIL
(Excel 2007) API to get computer IP address or domain name?
Keep destination formatting when pasting?
getting values of a range of data
Maximun number of fields in a pivottable in excel 2007?
RE: Access doesn't always close (Excel VBA) & passing parameters
Looping with multiple conditions in Userform
Time stamp function trouble shooting
enable macro automatically when we open a workbook
Data validation in Userform sub
Unique values in a Collection
text/number formating question
Re: How to calculate the number of non-zero cells in range?
Skip Run macro if module has been deleted
Reacuring subtraction from a balance
Save as question.
Grouping like transactions
To Update ComboBox
Add drawing shapes to Userform
Dir help
Moving Charts
Retrieving Excel data to post to a form
Widen Sheet Tab View Q
send e-mail from Excel, copy and paste at specific place in e-mail
(Cross Post)
Formulas containing hard coded values
Excel 2003 toolbar with custom image
Calling VBA Function from VSTO Code
ActiveWorkbook.SAVEAS for *.xls
How to tell a user no range has been selected.
Multiple message boxes, one after the other in AutoOpen or other?
Elapsed times > 24hrs
Need cell value not cell pointer returned from formula
Need cell value not cell number in formula
Update ComboBox
importing data from excel to sql server 2008 by code at run time
Exit Sub alternative
Type Mismatch
Call Sub
Type Mismatch Error
UserForm Shown while Program is Running other Code
Screen aspect ratios changes when macro runs
Macro for multiple prints
calculating based on color
Loosing VBA project when opening up Excel 2007
MsgBox Special Characters
BeforePrint Sub auto referencing
Macro Help
Insert Column based on data in Row.
users have to manually enable macro everytime they launch userform
userform on intranet: disable save button on initial launch
Drop Down List were Text = numeric values for formulas
TextBox exit routine 2nd try
VLOOKUP question
Email permission question...
FYI Excel 2007: Saving a xlsm file with a hidden worksheet activated makes worksheet visible
Filename str cut too short
swap contents for one workbook with contents from another one
InStr Help - Multiple Criteria
Error Message: Sort Method of Range Class Failed
Concatenate with currency w/2 decimal places
merge cells part deux
userform on intranet: have to enable macro every time
Transfering Data From Userform1 to TextBox1 in UserForm2
Userform on intranet: disble save option, allow open only
.net dll - error 429 ActivX component cannot create object
TRYING FIGURE out how wide a text box should be in userform
Macro to delete part of a macro
Subscript out of range when selecting worksheet...
Finding the average of two generated totals
Please Help
Range Value Assignment Failure in Event Proc
delete row if text not in specific format
Store custom doc properties Temporarily ?
Variable Not Defined
New Application opening for each file
Excel 2007
Sorting by month
Timing for an event longer than 24 hours
Unable to call a DLL function from Excel
Rename Excel File
Adding filename
Command button icons when disabled
2003 to 2007 compatability
Send Email If
Excel macros and Open Office suite
Position Input data in Cash Flow table
2 Column ListBox, Selection data
Make option button link permanent to cell
SQL loop of input values
clear all raws after 5000th
Copy Values to empty cell below filled cells in selection
Workbook won't save customized QAT
retrieving cell reference data
fill dowb using macro
TextBox exit problem
Subscript out of range error - selecting a sheet
Test a grouping of OptionButtons
testing cells in a row
Search an Array
macro to browse files then copy certain data from the selected fil
Type mismatch
need macro for fill down
I have a rng problem
Workbook activate help
Populating a ListBox with an Array
using Solver add-in
VBA and SharePoint permissions
Date in the workbook name
To "freeze" Spreadsheet
Worksheet copy problem
TextBox_Change() problem
Run-time error 57121 "Application-defined or object-defined error"
Ribbon
Copy to Visible Cells only;Modify Code
Auto Filter - Custom Auto Filter
VBA Code Bug
Code to produce consistent new Workbook name
Intersection of two curves
Copy Visible Cells and paste in another workbook visible cells only
UserForm Control Question
Pivot Restrict Macro Only Works for 1 table
column of a input box selected range
Pass activecell(.address?) as a range in a function parameter?
Inserting a row below a combobox determined cell
Hide Column AD
How to PasteSpecial to a Different Worksheet?
how to pre define what to show on the top of the Combo Box
vba Syntax?
option button
Collapse away VBA lines with deep indentation
Collapse away VBA lines with deep indentation
use macro to select printer profile...
'?' displayed in excel: when I hit enter for a new line in textbox
Where to store VBA code for executing against xls in email?
challenge for the braniacs!!! i need help.
Macros
How import a MS Excel Userform into Mac Excel?
Worksheet_Change vs Worksheet_Calculate
Import Excel data to Access table
merge cells
VLookup to a different workbook
chane what 'x' button on top right of the form does
Private Sub Worksheet_Change code not robust enough
cell selection, merging.....
Query on month and day in code?
[VBA] SUM RANGE OF VALUES
Move data to top of column
Assign Macro to Ribbon Button
Pull date from cell with text also
Corresponding Row Question.
beforesave macro help
calling cells in for-loops
Marco to open the "Customer Auto filter dialog box"
Copying selected rows into new worksheet
Putting a value in cell based on another cell
use border for IF test
Determine address of pagebreak preview
Speed it up?