Excel Programming [Archive] - Page 15

Sequential Numbering of Duplicates
Workaroung: data point limit?
=COUNT(IF problem, please help
Sorting a Worksheet by the first 14 characters in Column A
Excel and Windows Regional settings
Autofilter Macro
Gathering data from all xl files in a folder
Creating an intentional 'Circular Reference' of sorts in '03 &'07
Copy & Paste from One Workbook to a Macroed Template Workbook
Modeless UserForm doesn't show on Alt+Tab.
How MerketCelle worked in VBA Formatting Cell
Help with validations in Excel
Moving a local name to another sheet
Copy column groupings
ActiveWorkbook.SaveAs Format(Date, “mmddyy”) & “.csv”
Viewing Excel VBA-generated User Form (modal) in Word
Excel Table Width Pasted into Word
Close WorkBook
Open UserForm
Save spreadsheet as webPage with interactivity
Problem but no error - DA
How to set Chart SetSourceData in code..?
help reducing this long nested functuion?
open file and update data?
Worksheet Change event - not running when down arrow is pressed
VBA Font detail loss
trying to find solution to copy duplicated data from one sheet to
UserForm closes after Selection.Insert (RESOLVED)
user form color
change sheet name based on cell
Need a countdown timer
blinking/flashing objects
Formatting Day() Function results
Can scientific notation be turned off?
Find value of active cell in other visible worksheets
Copy from One Workbook to Another
File name
Need Help on Define Names
Faster code to quickly hide several rows?
Creating macro enabled Excel 2007 workbook
Query file without copy inside Excel
screen update
InStr question
Capitalize text upon entry in a cell
Maximise Event
Insert row after blank cell encountered
Hyperlink sheet name to its corresponding sheet
Need a macro
How to stop Stephen Bullen's CFormChanger from minimizing as an MDItitle bar?
loop with many if
Multiple dates in one cell?
Capture match and update EXCEL 2003
Clear cells
close file disable toolbar
Excel Programming on a Netbook?
Public variable declaration
Test for alpha char
Tabbing Problem
pivot table variable range within a macro
Search a 3 digit number and its variants
Naming a range
Wierd range name defined as array of constants?!?
Loading PivotTable data into VBA
Save As Filename
Import Large .txt File; List in Rows
Protect a Workbook
VBA copy clear paste
Insert Menu Getting Disabled
Help Required
Automatically run macro when userform is opened
Download Web Pages/Files -- Need Delay
Data Validation
Scheduling task to run for Excel Addin
Macros
HELP!: Popualte Access Database with data from 50 existing workboo
Excel 2007 - drop down list no longer showing
Overwrite a record instead of add
Add "paste values" to right-click shortcut menu-how do?
Hovering over a cell and seeing a data set for the sum in the cell
How to open a document placed in an Eroom on intranet in VBA
Compile Error: Variable Not Defined
How to update a range of cells if cell value is equal to...
Check the path for validity
Whan a letter is entered it changes to a symbol that is the value ofa different cell
Implement and show pivot chart filtering in excel 2007 as in 2003
How do you importing unicode from web
How do I turn the visibility of a shape on one sheet off and on?
Create userform calculator in Excel
SumProduct in VBA
Excel Crashes on multiple saves
Copy VBA code into a workbook created by a macro
XL 2007 - grinding down to a halt after many rows - no objects,shapes or pagesetups
FIND & REPLACE LOOPING
Change OptionButton true/false status on all sheets
D'you know: Workbook_Open is not called first(!)
Automatically Check Each Worksheet For Duplicate Entry
Rearranging a Very poorly constructed list
Using SMP on VBA over Excel
How to display value of global variable?
fixing a loop
CODE TO SORT
How to get address of cell calling UDF?
multiple monitors
ODBC and Excel
Identifying a Read Only status
Checkbox question
Shared Workbook, automate existing data always wins
Controls inside a Frame do not display in design order.
calculate months between two dates
Macro Needed Please
What is wrong with this line of code
Add to formula to put a zero in cell
Outlook Body Text to Bold
Prevent user to unhide Formula Bar
Set Print Range With Hidden Columns
Importing files
Set Command button location
Macro question
Exporting Module to Text File
Connecting Questions on Querytables
Frames are correctly Etched in the Designer but not at run-time.
Need some help with a macro for printing selected sheets
Selecting a Column
dialog showing time
Match columns to rows then loop.
omit dialog box display during pivot table refresh (macro)
need macro for auto range name (#rows different each time)
How to apply NumberFormat to control on a Userform?
comboboxes
excel macro help... please
Is there a limit for Pivot Tables under Excel 2007
Pivot Table Help
Converting Environ("username") from 2003 to 2007
convert constant string to integer
Hyperlink with Code
compact excel 2003
Hide Worksheet
Error in Excel
Main User form closes when I double Click list box to update 2nd f
undo VBA procedure error when called via change event
making all Sheets Values only
Auto add new row
Alternative to Data Validation (List)
Help with Code
msxml6 update in Window Security KB954459
Assign macro to shortcut keys "ctrl + 1"?
Chart events
Names.Add Name - RefersToR1C1
help with worksheet design
Excel Form - help !!!
Excel form setup
find IDs in another sheet, copy paste non-adjacent data on orig sh
Update username
populate dropdown/combobox on userform with specific values from s
Copy and paste entire line starting at cell W
Speak - How?
Excel connected with Excel
SelectionChange Event
PLEASE ALWAYS INDICATE YOUR VERSION OF EXCEL
Can't you hide a TreeView Node?
Cell Shading Colour Property
capture filter values from a sheet into a dropdown list in userfor
Vlookup for multiple Lookup_value
cannot expand outline on protected sheet
Calculations with conditions
Use mouse location to place autoshape via VBA
Excel Subtotals
Inserting a table with VBA
Validation List
Copy Row From One Worksheet To Another
R1C1 Notation???
vba goal seek in 07 envoking sumcolor UDF
EXCEL CONNECTED WITH OUTLOOK
Flipping Data
Excel save takes 18 times longer than Windows Explorer copy - why?
PLEASE HELP: Index and Match function in Userform to populate fiel
Copy code - JLGWhiz
After module import, code does not work
VLOOKUP macro/VBA Code
copy data from a hidden column to another sheet
Help with subscript out of range error.
How to programmically upload Excel file to Sharepoint?
how to getting menu text
values from workbook without opening it
Delete text if red
Add custom menu item after Help
MACRO HELP CONTINUED
"Comment" format anomaly
how to use modules so that values calculated in one of them can beused by another?
excel comparing columns
Does Sheet Name Exist in a Workbook
Information Display Problem for a variable in VBA while Debuging
VBA code to modify Excel spreadsheet and then email it
Another "last row" question
Problem using DirectDependents
MACRO HELP PLEASE
Translation for ZS into English
Executing Macro Cancels CutCopyMode
Excel 2007 print problem
Saving a variable filename
MACRO to save current worksheet with variable filename
Retaining the order of Data while using Pivot table
User Form Problem
Month, Day, Year and Day of the Week
Code to Reset Named Ranges when copy/paste to new file
Wrong dates in VBA
Call Outlook from Excel macro
How to use templates with macros
Can function be used within SQL statement?
Closing a file with macros
Deleteing date over 1 year old
ADO Recordset to Excel 2007 Worksheet Cell Values via XML
How to use "notify" callback with winmm.dll
Way to make range the whole spreadsheet
Formula?
VBA adding borders
track row changes with date and time stamp
Colors driving me crazy!
comment box's to linked sheet
page through records in detailsview
Display.Alerts problem when I unlock my computer
VBA Loop
Lookup and copy cells if match found
need a macro to combine rows, columns
Can rows / columns be resized based on the value of cells?
Grouping buttons in left-hand grid - can they be hidden?
*Fast* way of extracting cell text formatting
Use column number in a range instead of column letter
ISAM
Macros Disabled
Position shapes to be centered in a cell
spreadsheet overwrite problem! I dont know what is wrong in my cod
FormulaR1C1 ?
delete external data query
VBA - allow something that almost matches
Another solver question
Excel 2007 and 2003 Toolbars
Solver marco still prompts to keep solution
copying full worksheets
rename worksheets using existing cell
MSHFlexgrid1 Problem
What references do I need to program a Textbox and an Image?
Need Help with Refreshing Querytables.
My head is hurting....
How do I Access, File Properties, of Non-office files?
Subtotal Function
Listbox with Check Box Option??
Default value of msoControlComboBox
Before Worksheet Close
Multiple selected charts
paste 2 charts on the same image on a userform
Comparing a vba variable to a range of cells
Excel VBA:Object Library invalid
Macro Help + date
Copy a range to another "transformed" range
Format of Cell with Array Formula - Using VBA
Value within a cell
Colour Uppercase Letters
Macro Help
Assigning a worksheet name to a variable
Manipulating Excel data in VBA code
Conditional Macro execution based on a variable
Hide Entire Rows Range
alle namen in een spreadsheet wissen
Transfering 2D Array into 1D Array
excel range selection
Force proper case on user form text box
Problem transferring Excel macros to another language
VBA Variable
inserting correct number of rows
Re: Digital certificates
Refresh VBA
help with Date summary
loop through ranges
Excel Macro via VBA - XML IMPORT
Excel UserForm textboxes and checkboxes???
Copying web pages onto Excel Spreadsheets using VBA
VBA HELP: Display values in Dropdown2 based on Dropdown2 selection
Why cannot name a function A1 or NA77?
Why cannot name a function A1 or NA77?
data filter
Text Box Question
sheet backup
XLS 2007: UDF not found
Worksheet Function countif
Display specific values in Dropdown2 based on selection in Dropdow
If ListBox = "" then
Browse 4 a file & disconnect a connection to external source
Upper case 1st letter only
How to change parts of Cells().NumberFormat
Macro to Email specific fields in a worksheet
Excel Data to InfoPath or SP Doc Library Help
Searching
How can I edit a NAME.wld file in Office 2007
vba to delete specific name from Name Manager
Deleting a sheet during macro
VLOOKUP
Unable to sort protected table
Problem opening Excel spreadsheeet
sheet backup
array-to-row autofilter issue
Re: Close file when inactive for 10 minutes.
Permanently prevent User to see Formula Bar
.Find method on filtered range
Re: Close file when inactive for 10 minutes.
CommandBar.Control is inactive after error
Remove a date in a cell by code
Vlookup formula entered by VBA, returns from another worksheet
autopopulate fields in userform based on selection in one field
Help with listboxes
inserting data in next row on clicking a button
copying cells from one worksheet to several others
creating multiple worksheets from one
Background copy macro
copying cells from one worksheet to another
Macro to select rows based on dates
Export Code Module
Conditionally sum a column of numbers based on color.
page setup in multiple worksheets
sort a column
Newb needs help.
data matching
PROBLEMS WITH MACROS
Possible to remove Workbook window title bar? Or other ways toarrange multiple workbook windows.
Permissions to a macro
MACRO
VBA solution for printing specific pages
RE: Emailing from Excel using Outlook
Axis titles Excel 2007
What is the test for whether a file is open?
Using IF + AND in Excel 2000
Insert xlBottom border to group data
Certain methods stop procedure execution without notification
Sumproduct forumla for complex sum.
using LEN / LEFT / MID / FIND functions to create a list
conditional formatting
Boiler Plateing text into another text document.
On some PC's prints to default windows printer rather then Acrobat PDF defined in code
CheckSpelling function
UDF interaction with other macro causes Error 1004
Copy data from workbook 2 to workbook 3 mystery!
Concatenate values
determine max characters in a range
inserting an image using height and width from the properties dial
combo box linked to named range
Macro Help - SumRow, Cell Shading, Copy Data
Silent Msgbox?
Cell Properties or XML data
HOW TO SELECT THE TEXT BOX?
How to tell when Beep sound is done?
Separate Filename and Extension
Making one Range out of two
Looking for a 'Close Print Preview' event
Using xla's on a shared drive
open and close another app from macro
Beep & Time
Access query(with custom function) from Excel
countblank
Select cells from a variable position
a mail merge of excel data to HTML, how?
Define a name local to a worksheet
Arrays instead of ranges in function parameters
Problem with a function that calls itself
Beep Not Working
Making a Value in One Column Negative Based on Value in Another Co
vba problem with lookup
making one cell show contents of other selected cells...automatica
Need a loop in my macro
locking cells from specific point to infinity
Re: Nested if how?
InputBoxes & Ranges
Re: Nested if how?
why doesn't this countif work?
copy data code to work with seperate instance of excel
Check for Required Fields, an hilarious error!
Code signing certificate
Delete sheet automatic
Save cell location to a variable
Know what other Workbooks are open
Hide Formula bar while workbook is open
Tabbing Inside of Textboxes
update a new row everytime I click a button
update a new row everytime I click a button
Userform Listbox Headers????
Replacing cell with named range
Overlay shapes on a map image based on map coordinates
Any tricks for speeding up this working code?
Insert into the Worksheet Menu Bar
autofilling a cell as the user types
Protecting Embedded Chart
Here's code to parse a function's param string into its params.
Rounding
Image on userform from picture in a worksheet
Find and Replace alt enter
macro to create a new workbook/ macro to copy columns
updating an add-in used in network
Need % of row value in Pivot Table
Code Stops Executing
Autofill not working.
Pivot Table on protected worksheet -
setting currency symbol in vba
Validate IP Address
error: Object doesnt support this property or method
Can VBA If...Then execute a block of code instead of a single line
Navigate worksheet while waiting for user input?
find a specific chart in Excel from other applications
Worksheet_Change(ByVal... not working now
Referring to current control on a worksheet
Macro to concatenate or merge cells
excel
Pivot Table Automation
copying down a blank column
Excel 2007 Range.Find method 255 character limit?
Create list depending on inserted value in a cell
Knowing where text will wrap
Insert New Row
Looping through checkboxes
Reference schemas for 2007?
RE: Opening Various File types from an Excel Worksheet
Move From control to cell
if error encountered in for next loop
avoid message that asks for confirm delete sheet
Help to read and display data
RE: MS help
Managing very large workbook
How a function can return "Nothing" or "Empty"
Control multiple Excel Instances
Re: <> then hide
change local drive / folder to network folder
Conditional Statements not firing
Insert row
GoTo statement question
adding text to comment
.textbox update in a sheet takes more time than acceptabel
Button Click but not Shortcut Key
Overflow Error
set outlook task through excel
Multiple Variables' Declaration In Loops
Multiple Variables
How to make a worksheet Non-Editable even if extension is changed
Ranges & Inputboxes?
Track if any changes made after file opened
Range(S) is a valid expression when S = "x,y".
Reading desktop/Notebook serial number or system ID
RE: <> then hide
Re: Add-In Message on Open
Need to make progress indicator more efficient
How do I display a (non-modal) progress message?
Re: Collection Object
Re: How big can code be?
Re: Ron de Bruins copy5 code amendment
How to specify Non-absolute formulae references in code
select all (including hidden) rows in autofilter region
Compile error for formula
RE: Macro triggered by date
RE: Macro 4Pivot
Naming a range
Format alphanumeric field in Excel
after print
Calculating Test Score Averages
Pivot Table based on Active Cell
RE: Cascading Combo Boxes
Insert Row Above and Calculate Difference Between Dates
Passing Currency format from one worksheet to another
Moving Files from one folder to another using ranges
How to copy and paste a sheet by pressing a button to another work
inserting a jpg file
Compile Error: with VBA call to "Format"
PLEASE HELP: how to Identify a row and populate the data respectiv
Application Defined or object defined error..?Need help generic er
Selecting Worksheets from active to end
Referring to "previous cell" in a formula in a "varying current ce
Very Hidden
RE: MS help
Select Case
Re: Emailing from Excel using Outlook
Access to references in VBA
RE: How to create a bug report?
add in persistent properties
Re: Found where program stops, but can't stop it stopping !!
Re: Combinations of Ranges
Upper Case Macro
Custom side pane?
How to insert a row into Excel Sheet?
Re: Avoid Update Values Prompts
RE: Collection Object
RE: assign sheet for embedded macro to run in
Re: VBA If Statement
Macro to save the document
is it possible to store outlook user name in excel file
How to handle second table with no values.
Hide Rows Using Checkbox
Macro Help in Pivot
Dialog Arguements
Space in address
How to use Excel to determine cutting and reusing stock to fill or
Help Change existing Code
Microsoft Office Excel has encountered a problem and needs to close
Microsoft Office Excel has encountered a problem and needs to close
Microsoft Office Excel has encountered a problem and needs to close
Sorting question
Any way to make text flash based on a value in another cell?
What is the best Way of update distributed modules?!
Prompt the user for an existing sheet
VBA and Internet Explorer
Content Size for WebBrowser ActiveX Control
Navigate on Web Page
Not returning a number
Remove punctuation mark '
On Error GoTo Question
this action will cancel a pending refresh data command
How do i turn all text to Proper Text
Paste Special If statement
Simple Do... Until problem
ActiveCell.FormulaR1C1
Filtering arrays
converting one worksheet into multiple ones
Text Importer
MACRO to Approve or Decline
Dynamic Chart ranges
DefaultIcon for .jpg set to iexplore.exe.mui
OFFICE ASSISTANTS
OFFICE ASSISTANTS
WHAT IS THIS? OPTION MISSING IN MS EXCEL VERSION 2003.
rows to columns
select column, cut and paste it to new worksheet
matching and finding data
How to remove the password set for an excel macro to view VBA scri
VB buttons
Report manager
Select Non-Contiguous Cells and Loop
"Lock project for viewing" doesn't get saved
Complex problem in calculating when to order an item
Select Case Range
database connection question
Auto hide in excel 2008 mac
Search and Replace
Userform in Excel
Text To Columns On A Different Sheet
Uppercase to Lower Case
Bitwise shift in VBA
Loop Does Not Stop
Change a caption for multipage
Add sum formula automatically using VBA
Change username via VBA in Saveas function
PNG images
Simple VBA Accumulator (Function?)
filling forms in IE from excel sheet
colour a row by code
What XML do I need for this add-in?
trim data and search for text strings
IF statement but in code
Can't get my code to work
auto numbering
like a transpose
TOUGH:split file into separate workbooks (single row, plus group m
My Excel Options button is greyed out (Excel 2007) How to turn it
Calculate Co-occurrence
what is the status "Hidden" in MSDN (it means deprecated)
Can one function get another's ParamArray?
Calling a sub
Referencing a UserForm
Sharing violation
Converting Integers to text
Excel VBA filtering
Matching Column Data
Get fully qualified domain name in vba
run macro before closing if worksheet name is fixed
Why does cell format change when assigning a value?
Excel 2007 vba Is there a way (subroutine or API calls) to get the version of Excel that is running?
Excel & Sodoku
Program Control After Closing Another Program
Preventing sheet deletion
file size too big
Add sum formula automatically
Control Array
Stuck on VBA Web Automation
Allocating a value to a VBA variable from a worksheet.
naming a range via vba
Enter email in 'From box' when sending mail via excel
enter key
Netwrokdays in VBA
Button with no name IE automation
Saving a file to desktop with VBA
Cannot save event macro, Excel 2007
How to count # of "non-empty" rows of data
Summing conditional columns
Select/Delete Sheets
Selecting a range to delete
Send Outlook Email From Excel With Preview
Rounding in vba
importing powerpoint table to excel
Copy data into sheets
Transfer data from one sheet to another
Changing alphabetizing entries
Extracting all Email addresses from an Outlook folder"Undeliverables"
Macro to create hyperlink
Automate Filter in Pivot table in VB Macro
Visual Basic error message with version EXCEL 2008
worksheetfunction.text() and text colour
Re: Goto Sheet Name
Find and select
Running in to two problems.
Restore Autofilter After Macro Runs
How to get Find dialogbox through VBA macro in Excel2007
PIVOT - refresh pivot based on Field / item
OLAP – returning data from a separate list
protection puzzle
Deleting Code from a Worksheet is Locking Up
Can't see the properties for a button???
RIGHT function doesn't read 0's
Rounding Numbers
Clearing Row data for a given range
capturing text to the right
Unable to Retrieve Complete Web Page
=LEN returns incorrect answer
Sorting combobox elements
addspace macro
VB Question
Error 1004 'Range' when using French Regional options but not Engl
Thanks
show a userform and still work on the below worskheet?
Checkboxes
Please Help: Type mismatch error
Writing multicolumn array data to a worksheet range
How do I limit TextBox data entry to 2 digits?
Reformat Data
formatting text in a cell
Find last used row and paste from above
Date of last update when sheet has changed
Condense code
Using macros to open a file with the Find Menu option available
clearing array variables and using an array to determine min value
Create New sheet and copy appropriate data to new sheet
clearing an array
Dim statement
Worksheet_Change Event
deleting a range
Move Data from one group of cells to another
How to make this code smaller
Excel 2007 does not record macro when manipulating objects
how to return a range
Bug when hiding a table column and filtering
Sub to ensure a single, latest input of "x" in col G
Marco to insert rows
Can you add a button to the VBA window
deleting cell range in a worksheet_change subroutine
Code to Refresh inbound data sheets, then Refresh Pivot Tables
Userform question
How to delete content in spreadsheet before new computation?
Type Mismatch error!!
Pass Object from UserForm to Code Module
Validation not working
activechart.axes not in 2007 - what's the replacement?
Format cells based on two conditions
Entering Debug after delete sheet
creating a loop
Your thoughts on Excel 2003 to Excel 2007
insert excel to access
Making Directory if None Exists
Changing Years
Primary Axis Position
Macro Breaks When criteria is deleted
userinterfaceonly and copy method
Return of Cell Location
The Best Second book on VBA
Macro code for clicking on Command Button in another workbook
Exporting images from an Excel woorksheet
excel macro to open word doc besed on user selection
Conditional Format Based on Formula in Cell
CopyPicture Method and "Picture/BitMap" Format
SHEE1. Duplicate all sheets, making 2 copies of ea. / 2. Add " E"and " F" to end of tab name. / 3. Put all sheets at the very end.
Scatterplot with background area plot
Change code help
Running Total
reposition comments
Setting a custom view
Creating range name based on cell value.
Runtime Error 28 - Out of stack space
Hovering in VB editor quit working
Run macro on Active sheet - Columns to rows
Window Background Color
Conditional Testing of 3 cells
Structured reference question
Userform hides by itself
image insertion height problem
Help with delimited text files
Copy sheet from workbook in new instance of Excel
AUTOMATICALLY SENDING EMAIL VIA A MACRO
Help with delimited text files
Automatic Value Change
Excel crash on pasting as values
Applying autofill macro that covers multiple sheets/columns
Save as DBF
problem with cell reference and date
Delete Row
Resizing cells to fit text returned by VLOOKUP
Macro Help
How to reference a range from a UserForm
relation between fields in PivotTable
Delete Loop Error
Help Regarding UDF or VBA
VBA- how retrieve source dir for the template *.xlt file ?
Wanted to show 12 month Date in Pivot table
Code to calculate only visible cells
VB Reference to Grand Total row in Pivot Table
List Rows to Columns
Late Binding - SORT driving me crazy
cell contents in a text/message box
Certain methods, such as Cells.EntireRow.Hidden, stop VBA subrouti
page setup preferances
Refer to a lone sheet
unreadable content in file
retrieving list items from ordered list in HTML
Display Current Date & Time in a cell: Everytime I open the workbo
using a scroll bar to make a slide show
set a workbook variable
finding the file path
If then statement to calculate data
Auto update/fill column heading
Excel crashing when trying to close a workbook
Referencing a UserForm in a Module
Reference between rows, not columns
My created menu looses the icon on QAT
Data Validation
Looking thru a worksheet
Extracting data from external pivot table - Office 2007
Delete rows with 0 in target cell
Open files by looking at list names in column A
Rick - Column Offset Update
changing range in recorded macro
Copying Code
macro on time
How do I add Icon to Toolbar?
Spreadsheet autorun macro, parameter?
Print Code Help
image insertion
Count duplicate values in a selection
Counting cells with a certain font colour
WHAT IS THIS? OPTION missing in excel 2003 version. how can i get
Fill #N/A and blank cells with zero
limiting column selection
Sub to write cell contents into its own comment
Use VLOOKUP to populate text box on form
.NET Programability Support
CopyFromRecordset
Re: Open all .xls files in a target folder, run macro then next
Modify RDB code with find and offset
app activate
combobox setfocus
Active Workbook from User Form
If then statements
Excel 2007 VBA Addin
Send Mail using Lotus Notes
Calculating staff levels
Userform and Email Question
Name list into charts
Error Trapping
copy_paste to the first blank row
Set up search box to, by default, search workbook in the extraoptions?
Column Offset Update
GetFolder error
VB Code for hyperlink
Calculate Field in UserForm on Exit
Top 3
Help with Lookups
pivot table range selection
pull in cell text to referrence sheet name in formula
Ampersand in label caption in Excel 2007 Ribbon
Dynamic copy range
Change formating in other sheet cell based on match condition
Control for selecting dates and times
Paste RTF Into A Cell
Concatenate: Two cells from Sheet2 into One cell in Sheet1
Problem with selection blank or non blank
Call an Excel macro from Word with data
how do i write records in access from excel vb code?
AutoFilter Issue
doesn't anyone here know IE controls?
Counting and deleting rows
Delete cells if
.find with xlprevious
msWinSck.ocx: Run-Time Error 429 ActiveX Component can't create ob
Look up text in an array and select (activate) the cell in which f
Populate Cell with Content of Text Box
TextBox Focus And Active Cursor Movement In User Forms
20 excel workbooks every day to be summarized
sorting dates
using VBA to populate a hyperlink field
IF formula question - nesting multiple functions.
Return to Excel from Word Object
isnumber
VLook up question
Help with if statement
VBA source or reference
Running macro in another workbook
Carolina Girl
testing url string
Creating several smaller worksheets from a 'master sheet'
Scrolling the rows up, while updating.
UDF help to centre and bold
What are "line print settings" ?
new workbook tab macro
VBA sort
Macro to delete an Object
Automatically merging 2 data sets that share some values
named ranges get larger
Formatting within a Macro
.find with xlprevious
find with xlprevious
Macro to populate web form
Help with Run-time error '1004': Method 'Range' of object'_Workshe
Macro to Compare Two Columns of Numbers on Two Sheets and Flag Mat
Dynamic Print Area
UserForm Listbox Selected Item Manipulation
Re: How run mp3 audio files in vba
Appropriate replacement for ini-files... xml?
How run mp3 audio files in vba
Re: Macro issue in XL03 "Compatability Mode"
Template for Planned Preventive Maintenance Program? Anyone?
Re: date format cell, to text format
Disable Poups
Macro issue in XL03 "Compatability Mode"
date format cell, to text format
Problem whit query
If structure
copy excel char to specific page in Word (VBA)
Copy to row xx
Open all .xls files in a target folder, run macro then next
Help with macro to find matching data between two worksheets
Populate values and insert row
How to load /import the external worksheet into Excel?
listbox getting error 380 cannot set the rowsource property
determine whether the activecell is on the top or bottom
List conversion Col - Rows
verifying the url
Ron deBruins copy5 code amendment
Access Control With UserName
Using ControlSource property in Textbox in UserForm
change controlsource for textbox depending on combobox selection
Type Mismatch error
autofilter
Compare 2 sheets, then copy/paste results if Different Values in C
Today's date as file name .csv in Xl 2007
RE: Create executable file to run excel macro
Re: how to find username/passowrd controls
username and password controls
Create executable file to run excel macro
RE: how to find username/passowrd controls
how to find username/passowrd controls
Numbers To Text
Application.Volatile False doesn't work with Application.Run?
Select rows equal to filter and highlight row
User Forms: Can I have something between Modal and non-Modal?
Paste and display issue
printing a file excel just grabbed from IE
countdiff() counts 533 while uniquevalue() lists 539 !!!
2003 Addins in Excel 2007
array output to cell range
error 91 and inputbox string
CHART CREATION
Find the line of code that caused the error?
Problems with incorrect linked values
formatting dates
Report Website problems and experiences
comparing excel dates in vb macro
Problem with worksheet functions and errors
selecting multiple cells in VBA
run 5 macros with 1 button
Formatting Excel through VBA Coding
Unusual date problem
Cannot Get Instance of Com component Microsoft.Office.Interop.Excel.Worksheetwith Excel Interface Error.
ComboBox Please help
Preventing pasting except for Paste Values
conditional count with listing
How to group a table using VBA?
.Find .Hidden Values versus Formulas Aug2009
ANYTIME NEEDED MACRO FOR CONDITIONAL FORMATTING
Get the AVG price for an entire month
Copying Excel sheet to Powerpoint with VBA
Issues with DoEvents command
Re: Find text in colunn Then count rows with data
Search for first empty cell in column
Macro to select / highlight entire row.
Character limit in Range Method
Copy and Paste Special #Value Error
Conditional formatting based on a value in a seperate cell
Deleting rows
what is wrong with this!?
matching 2 worksheets
Lookup cells in one column and clear cells in another
moving rows into columns
Macro for write a txt file
Programming ideas for excel
Retrieve All Children
Copy Format Error
Row spec
Change Value Series in a Chart from Comand Button
Passing HEX or ASCII to a com port
Import Macro Problem
Import Macro
Multiple Ranges in Hide Row Code
Screen flicker w/ Screen-Updating = False?
Selection.QueryTable.Refresh causes screen blinking
Insert obect
PLEASE HELP! Application.speech - Everyone always ignores thisquestion
how to trigger a validation change
Open files from folder by matching name
PLEASE HELP!! SAVE MACRO
Delete formula if....
Auto formula copy
sort data from 1 sheet to multiple sheets in excel
Preventing pasting except for Paste Values
Highlighting leading or trailing spaces
Renaming a UDF param renames the params of ALL UDFs.
Where's a Node.Indent property?
Running other programs with VBA
deleting range with array formulas
Code to Set Printer Properties?
Getting Error in Micro(for Loop)
What happens to data validation when created from VBA?
printing worksheets and charts
Loading data from a PDF
Define range by last cell in column?
Display Value from Sheet1-A1:A10 to Sheet2-B1
Add Item To ActiveX ComboBox
custom menus in excel
List or TOC of Macros in Wkbk
populating a list box based on another cell
web services w/ Excel 2007
How to work multiple ifs
pause code while Query is refreshing, then continue
match the cell and bring the amount
Wrap Text code with merge cells
How to work multiple ifs
Copying cell contents a specified number of times 4 mail merge?
Excel 2007 Ribbon
Excel 200 conditional formatting problem
Split file, saving each tab/worksheet to a new workbook, w/tab asworkbook name?
FORMAT ENTIRE ROW BASED ON SPECIFIC TEXT
Get Network Login Name
Prompt for tab name and then prompt for number of iterations of ta
Fill Color Macro
Display Employees based on Login
How to completely remove duplicate rows in vba
Deleting - Rick Rothstein
vlookup
Macro to copy specific data from master workbook to another workbook
vlookup
Personal menus in Excel 2007
copy text to clipboard
Simple - Del empties
SAVE AS MACRO
How to stop Excel 2007 to create new instance while opening multiple files ?
Macro To Filter As Per List
Having A Macro Run When A Selection Is Made
Help with loop
Exporting & Importing with macros
what wrong here, range Cell as counter
marco/formula
E-mail notification not working
Display Sheet1: (A1:A10) value in Sheet2: (B1)
historical price data into excel from msn money
Loop cells, add rows and transpose for values greater than zero
VBA Sort for varying dimensions
Problem with OptionButton click event
UDF Looks for Named Range Not Function
Sum of every time 2 different texts are found in 2 different colum
Find text in columnThen count rows with data
Export autoshape as picture using VBA? (object doesn't support met
write cell values to a closed file
Write to a closed excel spreadsheet
Copy a File to the Clipboard
Highlight a cell and a message box
Network Drive Info Retrieval
Hide a command button
Colum to line
a little tweaking might work?
Lookup data from another excel files
Copy cells to the left of an event in a cell
Loss of an Excel reference in Dot Net programming
Worksheet_Change help please
Colum to line
copy from combobox to worksheet
Grouping Shapes in 2007
call a combobox KeyDown event from another procedure
find TWO values in a worksheet
Extract time from date
Tough teaser!
compare name in cells
DTPicker Lock property
Extracting data from multiple worksheets
How to set the ActivePrinter Property for Microsoft.Office.Interop
copying an existing sheet
Run Access Macro from Excel
How to compare two sheet using vba and remove duplicate content?
Force synchronize list with VBA
SAVE AS MACRO
Why is the negative point on the chart Black not Red ?!!!
Date dd-mm-yy(EXCEL) manipulation in VB macro