Excel Programming [Archive] - Page 69

Name picture in code, How.
How to get the value oa an optionbutton from another workbook
Excel.Style object: Border problems
delete row code to be modified very slightly??
Delete Worksheets that only contain 2 rows of data
Match the names and record the dates
refer to cells by cells(0,1) etc rather than "A1"
Merge data of cells based on same ( value row wise)
Add a form and put a calendar on it using VBA
Autofill formula on non-Active sheet
Selection.Replace size limitation
PivotTable: Averaging over 0 (Null) Fields
code to add control to a worksheet
Assign values to specific Text Boxes
A program is trying to send mail using Item.Send
Named ranges
Add footer automatically
IF ... ELSE HELP please
VBA for comparing sequences of characters.
On timer for excel?
sum positive and negative values
VBA From MS Access: Inserting Page Break?
Switch off Sort with Autofilter in XL2003
List of all visible worksheets
help with pivot table required
Continual printing?
VBA Code ... Run-skip-run ... Code
problem changing password
Excel to SQL DB Update
Sheet within a Sheet
Auto-Update - Help Plz.
Find Method with list
Text Box in Excel 2007 Chart
creating a dynamic range name using vba
sum positive and negative values separately
Rising / falling points Macro Help
Edit/Replace?
insert new key filter in cbox2
why is my loop so slow?
why is my loop so slow?
Analyze Access table
Autofilter - formatting criteria1 data for valid comparison
VBA to Sendkeys or otherwise inhibit Update Values Window
How to access Fieldinfo?
How to get buttons on floating control to pick up colour
Re: Tools...References Full Path
filtering pivot tables
getting the value of an optionbutton from another workbook
getting the value of an optionbutton from another workbook
Wrong Ascii characters with VBA Print #File command
Newbie Code Question: Showing various pictures on a form
getting quantities according to date
Closing a workbook
Running A Macro when data is updated.
Getting all files of a specific type in a folder
Help with Filter and Delete...... Please
Recurrent error: disconnection from clients
Focus
Re: Tools...References Full Path
Re: Huge bug of Saved property in Excel2000
Re: Creating Windows Message Service Alert
Re: Multiple copies of the Userform when i drag it across the screen
Re: putting often-used combinations of controls in a class
How to amend formula ?
Re: excel in winform
Tab indexing on a form with frame boxes
Run-time error '1004' for looking up date in worksheet
Advance Filter & If Code
ChartObjects and Columns: Different Size Units?
printing code in color
Size with Window Command in Excel 2007
IE Automation combobox
Dynamic Charting (StackedBar)
Home Work Help Excel VBA
Email worksheet from named list on another worksheet
range as variable
How do I hide certain columns in a sheet with merged cells in a row using a macro?
Best way to use INI file
Select cell where column and row intersect.
Cell Validation
A little help vidth a Function
Adding items to a combo box
Offset Count if, between two words!
Run Macro in one worksheet from a button on another worksheet
macro help
Using Vlookup to return a range of data
can't fetch value in excel table if first 25 rows are empty
Cursor row and column
Get Rid of Dotted Lines
Extract Folders Name From Outlook to Excel
"List Properties" not showing
Code Does Not Work Depending On Formula
cell increment range
E-Mail using BCC Fields
Search and replace stuck on
Excel sheets
invoke commands used for excell
First and Last Row in a Range
before_print does not work - f8 key does not do anything
data validation from multiple lists
Printing without seeing the sheet
Can't get rid of clipboard questionwithout losing page.
limiting selections in drop down list
Automatic Formula Add
Holidays list in a function
File Handling in Excel for Mac
Re: Hyperlink Type - SheetFollowHyperlink event
How to extract file extensions?
vba pw prompt undesired for end users
Re: Searching for 3 Add-Ins
Re: vlookup from different file
copying modules and links
Converting Lotus DSUM to Excel SUMIF
Functions with multiple inputs?
Greater than zero problem
Greater than zero
Missing code
keyascii = 13
How do I goto a specific Record in my Database?
Can't start multiple instances of Excel with CreateObject
Chart/Shape Objects: De-Link From Column Widths?
import data without openning excel workbook
extending a chart with visual basic
Is This A Bug????
cycling through code based on menu choices
change PrintQuality to save ink
select from item and show data filtred...
printing single row only
find last item in record
display only columns A to I
Passing Addresses Instead of Values
Is this possible ?
RE: Cell Value = to List Box Value Problem
Reading data from an excel file to access and vice versa
seeking John Coleman
Ising Formula
Re: Help with marco
RE: What's my error? - S&R macro to work on any selection, from a mast
Re: Screen update won't run...help
Re: adding range name that includes a sheet name
RE: copy limit?
Re: How can I add comment and keep the format for all new workbooks
RE: Create new sheet and hyperlink to it
Even More Data Table Problems
More Data Table Problems
Re: sort method of range class failed
Re: Increasing the row count
how to add picture to worksheet from url in Excel 2007
Re: referring to worksheet
Can't read file
Re: Increasing the row count
Chart or Shape Object: A Place To Stash A Few Bytes?
Error desipite UserInterfaceOnly in protection - Why?
Re: VLookup in Code
array UDF not recalculating correctly
workbook startup creates #NAME error for UDF
Need help with loop
OLEObjects collections for embedded files
Re: Passing value to userform quetion
XL2003 working with an XLA and two separate workbooks
Accessing Analysis Toolpak functions
sorting / removing duplicates
Error handler if copy area different from paste area
Using DateAdd function to add 1 weekday/workday
VB Formatting different colors/fontstyles in one cell
Re: How to find the maximum from a list of variables?
Formulas in Arrays in VBA
Re: Object variable or With block variable error
Hide actions while macro executes
Send email from a VBA macro?
Re: How to delete sheets with "Ch" in the sheet name?
Re: worksheet names
Re: worksheet names
Entering Multiple Items in a Single Cell - gmail has it right, can Excel do it too?
#NAME error for user defined functions at workbook startup
Automatically insert pictures
Variant array is empty problem
Adding values to a combo box
Problems Grabbing Data from Access to Excel
Re: Reset TextBox values on userform
Auto Calculate Macro
Re: Extracting data/numerical values from a give list
Automation question
Re: How to delete sheets with "Ch" in the sheet name?
copy cell values to another workbook
Discontinuous Range via VBA using R1C1?
"ActiveCell" in another sheet...
multplying matrix with constant doesn't work in VBA
What is going wrong here...
Problems with OLECMDEXECOPT_DONTPROMPTUSER
breakpoint affecting the run speed of a macro
accessing web tools
Running macros it returns compile error in hidden module
Re: Tools...References Full Path
Pivot Table Refreshes Via Code
Hide clicked commandButton
Help needed with find & Delete
Re: how to hyperlink b/w two sheets?
Auto Calculate Formulae
How to get users' range selection in VBA macro?
Re: Runtime error 75 in workbook_open
another autofilter question
converting excel wortksheet to text
converting excel wortksheet to text
Re: quotation marks in string
Re: Names
Working with a Range object
How to substract a date in excel to 2000
How do I create a commnd button with hyperlink in Excel VBA?
Matrix Countif Statement in Marco
Re: Minimize and Maximize Buttons VBA Forms
Excel Magazine
Import of 50+ Survey Data Results
Re: Omitting Hidden Columns from a .CSV File
Re: Why is this an erorr?
RE: Relatively new to macros
paste named range data
Original Excel File gets deleted and temp file gets created.
Used to be possible in Excel97
Excel takes forever to shut down
Re: start excel in background
Re: Text string with only punctuation
Need Error Message Box In VBA Code - Excel 2000 & 2003
Reference Check
Detecting changes in a single cell without worksheet_change?
Re: email from Excel when a cell hits a specific date
Compare Validation Operator give error
Re: How to use Macro using Visual Basic
Simplify code to lower file size. Possible ?
ListBox RowSource set to range of in-active sheet - possible?
Re: Is there a "most popular kbd shortcuts" list somewhere?
Re: How to Create Sound Alert and Email Alert when Macro is Finish
Gray out and deactivate a particular cell when another cell equals 1
Re: Use CreateObject to add a new module to Excel
ChartObjects/Shapes: Absolute Positioning via VBA?
Assigned Macro not working
Open file from a form
Re: I used a nested IF function in excel-calculates only 1st IF?
Re: How to Create Sound Alert and Email Alert when Macro is Finish
MPORT DATA FROM MDB VERY VERY SLOW...
autofilter question
Macro help needed for large amounts of data to be averaged
Re: How to Create Sound Alert and Email Alert when Macro is Finished
txt-file is UTF8 or DOS.
Need Help Making a Macro Repeat Until All Rows Are Processed
Want $1 to appear in a cell - Text
A function to find a phrase within a range of cells and return the address of the first instance.
RE: Conditional formating
Query does not seem to work...
Create Tabs from Existing Tab
Discounts within Ranges
Formatting cell for text
range(range("A1"), range("A1").SpecialCells(xlLastCell))
Simple Paste
userfom shows up white even though it's grey designed
Copy From Combobox to Cell
excel graph transformations
excel graph transformations
excel graph transformations
custom cell color
Excel Select Case with HorizontalAlignment
Adding Named ranged for each column...
Find/Copy/paste.. then Find/Paste - not working ... at all....
Selecting list box causes sheet to scroll
Items in a discontiguous range
How do I do this?
Why does this not work
delete duplicate data in the same cell
Refresh screen with open xls on client-computer
Copy Column data to other worksheet
Extract Certain Data from closed file
Extracting text to from one cell to create columns and rows
Copy Value from ComboBox to Cell
[VBA] Convert string to Range
If Cannot find skip???
Excel / Form in website
Run Macro on Cell Change
Public variable problem
Deselecting All selected Sheets
VBA and Pivot Table Refresh
Use 1 userform for many sheets, Rather than 1 userform per sheet: How?
userform: object required
Help with Worksheet_Change event time stamp
macro/sub to copy a specific ws from source wb to open wb and overwrite existing ws
Can't get Sheet_Change event to fire - please help
Worksheet_Change
application.vlookup syntax
To send an email to a remote SMTP server
simple looping question
Multiple cells
Drop Down List and macros
Row menu Insert control ID changes
xldialog question
Sum for given date range for given item - can't find this for the life of me
ReDim an array
Pivot Table Refreshes
Formatting Rows based on word being found in cell
PrintOut and PrintPreview show only first record when printed using ADO and VBA
Validating cell contentswhen leaving the cell...
Default File path
Hiding worksheets and rows in a worksheet permanently
converting formulas to "atomic" formulas
Setting horizontal print area
Is there a VBA Function for WorksheetFunction.Text?
Refer to the worksheet containing the current running code
Worksheet_Change stopped working after sheet is protected
Worksheet_Change stoped working after sheet is protected
Anybody remember Excel4Macro's
Image on a worksheet
Relative VBA function
Two Questions; Can I Track changes to my WB that is hosted publically in a network?
Calculating the difference between cell values in different rows - Loop
How to show 'Custom Auto Filter' dialog?
Dynamic Cell Format
Use same macro on 2 sheets?
Ordering of bars in VBA charts created with ChartWizard and union()
Translating A1 format to R1C1 format addresses?
Check if specifik folder exist.
Macro to collect rows with user-specified cell value
Macro to compare two sheets and then copy if match
PivotItems Bug?!
Office Assistant Question
Can this be done?
Isnumber function - question about data type
Quick help
Accessing the Ribbon values
Changing the cursor style in Excel
Re: Returning active control name on multipage
VBA Code to read selection from a Validation List
VBA Code to read selection from a Validation List
If statement combine, Excel 2000 & 2003
Please advise on the production of a frontend, to view selected record(s) of a completed worksheet
Adding comment text - linefeed visible - why?
Calling worksheet functions from within a module
data validation & mac excel
General referencing
I am trying to select a new cell whose row address is based on a variable
conditional formatting: if no formula, set fontface to bold
Selecting simple range relative to the active cell.
How do I associate calculations with items in a dropdown list?
Worksheet and Listbox
How can I add formatted text to a cell?
Filename coding with date
UserForm Setfocus Problem
macro to intsert a word using the "Find" command to search for a word
vlookup Variables
How to Delete rows in a column
Counting Blank cells using evaluate(=sumproduct)
using a countdown variable in a range
HEADER WITH VARIABLES
HEADER WITH VARIABLES
Macro to copy and paste a user selected number of rows
More then one MATCH
error 9 subscript out of range
Pivot Table Sorting
How do I select a cell based on the Column name
New CSV File
Calling a sub
Control Source / Row Source very unstable
User Form?
Using Office assistant
how to sum one column using a second column as a condition
Envoke code with button rather than as data is entered.
Would very much apreciate some help
Filldown Todays Date
Using Time
Copy & Paste Special into first un-populated Row
Calc Prorated Cost based Specific Days in a Gven Month & Year Range.
Selecting Cells
Object Creation
Saving combobx enteries
SUMPRODUCT with AutoFilter
find links without opening file?
Adding rows dynamically via macro
Adding rows dynamically via macro
Adding rows dynamically via macro
Command button enabled dependant upon cell value
Block save file prompt in imported txt file?
determining whether all cells in a row are blank
Excel to run Word macro & Word returns value to be written in spreadsheet
running multiple macros at once
pivot table
Microsoft Progress Bar ActiveX Control - Version 6.0 (SP4) - problems.
for each chart (sheet and embedded)
Lost clipboard contents on Workbook_Activate
Extracting rows based on value in first row
Macro to replace a row with SUM formulas.
macro - compare data in cols n transfer to next row
Add Loop to code
Adding up different combos of columns
Title heading in Listbox1
Formatting Data in excel VBA
Error Application.ScreenUpdating
Color of Cell
Unable to edit DialogSheets in XLA
Comparing cells
Finding values based on current month
COUNTIF "string" in cell
Automating Data Entry (Position the cursor, insert row)
Employee Skills
First Filtered cell in range
Running macros in newly created sheets
Excel 2000 vs 2003 programming problem?
Series Collection Name Problem
Copy range
Filesearch by last modified time...
Double lookup
Number of work days (ie excl weekends)
Opening a excel woorkbook from VBA
Run macro on multiple files
Volatile User Defined Function??
Use Sort method for 2002/2003 in 2000.
name location relative
Edit filtered list
Nome utente
Volatile User Defined Function??
Summing two text boxes on a form - HELP!
naming range moves me to macro
How to switch to next window and back
Collating Collumn
COM Addin Help
edit filtered list
Macro to create Org Chart
How to write directory structure to excel file
use VB to click the submit button, pse see if you can help
Help with Code
delete row and 3 rows below by range selected
Mscal.ocx on a UserForm to return selected date to WorkSheet
Creating a range name based on cell content not being a negative value.
Selecting Background Color?
"Object Required"
User Form
CODE given - Highlighting corresponding cells
Resize Property Window in VBA
Conditional formatting with merged cells
How to: Assign pop up when command button is pushed
possible to save macro with workbook as add-in?
Sumproduct counting blank cells, dates, capturing last row
Assigning procedures Programatically
Variable value display with mouseover
Trouble removing toolbar - why won't my code work?
using a list box to fill text boxes
how to I sort and keep blank lines in between data
Excel: How to generate a list of pivot tables in a file
Centeralising Macros to control changes
Change the format of text in disabled controls
For Each statement setup
Code to Alter value by adding 1 to value in cell 4 rows above
Excluding Worksheet from Procedure
End command not working
CommandBarControl control question when using template
Combobox list items
changing passwords
Scaling Axis via VBA?
help with altering existing code
Run-Time error '1004': No cells were found
Challenging question for the VBA guys
Combo drop down list
Calendar Control
Get single ADO Recordset from multiple Access Databases
Protect ALL sheets in one coded macro
Copy Value from ComboBox to Cell
Using VBA to split individual characters across cells
Need importing macro to recognize #*# as delimiter
opening a file problem
Update Access with a range from Excel,
Reporting on information from multiple pivot tables
CODE rectification while sorting in descending order
print parameters based on if-then
textbox to file (.txt or .doc)
Need help with formula
converting excel formula into module
¤¤¤s¥«ªF¤ÉÂí¸fµØ°s©±-¶À½ä¬r
Conditinal Formatting
DocumentProperty of .csv file is Nothing
Calculating chnages in time
Trying to return a phrase in one cell based on value in another
Copy method of worksheet class failed
Workbooks.Add fails when executed within IE
Can I respond by program for prompt conflict name
Set up Reminders in Excel
XLBook.Save fails in Excel 2007
Replace Chart Values with Second Set of Values
listbox integral 'width'?
Property window - VBA Editor
Selecting GreyScale
Using ADO Recordsets to pull data from a closed Excel WB.
Selecting GreyScale
Compile error
.PageSetup: Any recent workarounds for the speed problem?
Search for string in a cell, then hilight the row
Globals set to nothing
negative number
Rounding up based on a decimal value
How do you run a macro on all files in a directory?
Count and Sum the cells with color formatting
table sorting .... please help.... newbie
Recursion in VBA macros?
Protected cells
card dealing
Demand Loading of COM Add-In
VLookups on Network
To send a e-mail via Outlook which triggered by excel
Copy/paste Column
Personal file opening automatically at Excel start up
Personal file opening automatically at Excel start up
how to set a formula name by using cell values
Excel 2007
Custom Toolbar
Make Inputbox field *****'s
Problems with listboxes in connection with screenupdating = false
Can't use Arrow or Tabs keys to navigate ??
Test Message
vlookup error 2042
Import from access with parametrs
populating a listbox
Macros
email certain rows.
Graphics
List Worksheet in a Workbook using ASP
Code Question
verify external data before importing
Webquery - Excel 2003
table sorting.
lock listbox items
DateTime Data from Access to Excel using ADO
Name value position in a string of data
Start Up Position for Workbooks...
little watch
How to List the names of the subfolders present in the folder (path of folder is given in the textbox by user )
How to stop code re-running
activex message protection
Fixed column, variable rows
Creating a macro for a beginner
Open files from a dynamic path..
recursive parsing of zipcodes from a string
pse see the following scripts and advise if you can assist.
Expiring the Old program in Excel.
Expiring the Old Program on Particular date. Is it Possible?
UserForm Combobox DropButtonClick Event Bug?
Open and Close another Workbook from VBA
xl2007 Pictures.Insert Does NOT Work anymore
Recurring revenue and cost
sending mail through excel
userform setfocus question
How to copy workbook?
Option Explicit set at Application Level by Excel Add-in?
Excel Solver with VB
How do I create a new workbook from an Excel file on the web?
Search non-empty rows, compare text
Import - Access Data through ADO
Excel screen opens off-center
return cell formatting
Problems running a dos program from vba script
How to run a macro in the background & how to end it?
Can't Find Project or Library
System output in Immediate Window?
Setting aws to name stored in an array
Reference the next visible cell
Workbook_BeforePrint macro
Best way to secure spreadsheet
Named Ranges
Excel - Formatting Worksheets.
Summarize sales data
How/where can I get a digital signature certificate for signing macros so they are trusted?
copy, paste into a 'found' row on another sheet problem......
Find method, special cells, home grown function
VBA and internet
Excel data to frontpage or vice versa
2007: Parent bug in charts
2007: Charts.Add
2007: bug when changing labels
Validation question - allow -500%, 0%, "=50%*50%" but forbid "A", "", " ", "-" ?
Invert a range? - I wish SpecialCells(xlCellTypeHIDDEN) exist ...
Using Variables in the sum() function
How to run a complex SQL statement against Excel spreadsheet range?
UDF Worksheet/VBA discrimination?
Array of values in 1 textbox
IF then GoTo
Worksheet_Change code problem
check to see if the value is changed ...
Last row is empty
Calendar to insert dates in a form
Worksheet_Calculate event and input data
How do I enter a function in a cell and run it programmatically??
vLookup Problem
VBA script on document open or close
Macro Newbie
Excel hanging up?
For Each loop leaves file open after .close
Macro Loop
Remove items from a listbox
Strange behavior
Open xml file in Excel
saving a worksheet using a macro
Application.EnableEvents
Excel Form With Date Time Picker And Command Buttons
Find all cells NOT containing "100%" -no loop solution needed
Change cell's color from a image file
Looping with Userform
Can´t set focus on OleObjects ComboBox
Copy & Paste Special Using Values
random number
run a macro wehn leaveing a cell ??
VBA RC1 variables - name error
(x+4)squared
How do I add MegaStat to my tools?
Selecting range for Data Validation list
How in to parse constants in formula to cells
Add info to last row of table?
List Box
How do I add Mega Stat, under tools and add-in in excel?
Prevent getting all rows if Autofilter criteria doesn't exist
Excel Dialog being "Non-Modal"?
Rows to column
Move A1 on every thrid row to a new column
Finding last row of every sheet
Text to Columns alternative
did I uncheck something?!?!
Differences between Excel 2003 and Excel 2000
getting quered data to merge cells
Strange, code works on one computer but not another
Auto date in VBA
Employee Skills Matrix!
Put contents of a range into one variable
help with sumif formula
the differecne between two files
Tabela de ClassificaÃ§Ã£o
Counting visible cells
VLookup type mismatch
VBA color picker - copy of Font dialog combo box
Ole Object Problems
Catalogue Documents in a Folder
Excel Formatting - Think I'll need a macro for this
Workbooks, subscript out of range
Automatic Paste to different workbooks
PivotTable/Chart - Can not Group?
Creating a database from data input in template
Display values in a drop down in range
Setting ActiveCell color
Executing code in a library as a result of a worksheet change
Current file path
Print multiple sheets
Tom Ogilvy - Timer help
Create Worksheets
List of items in an array - VBA?
macro - copy, paste, convert column data
Automation: Adding Text to Cell With Different Colours
Formula problem once inserted by VBA
Excel Automation Problem
Best way to execute an SQL Query on an Excel Worksheet
delete rows with multiple criteria
Selection.AutoFilter Field / Criteria => criteria sometimes non-existing on worksheet
listbox
using 2 Worksheet Change Event in a sheet, is it possible?
Automating update between two workbook
Refreshing a combo box...?
conditional formatting Copy colour of adjacent cell
Automatically copying a row containing formula
Multi format conditional formating
VBA to manage user input in a workbook
hello, very new to VBA, (?) silly question coming.....
2007: terribly slow
VB problem for distiller 6 and excel 2003
VB problem for distiller 6 and excel 2003
2007: .DataLabels.Position
Custom Auto Filter
Greater than 3 condtional formating rules in Excel
find range size
send sub routine variable to global
Converting string "061123" into a date "23/11/06"
Special spinner
how can i read data from a closing excel file?
Working with Worksheet_SelectionChange
Validating Input Box
Variable Execution speed of VBA Code
Replace vs Application.Substitute
Excel vba help needed
VBA Formula
Macro to design a dynamic graph
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations....
Insert Blank Row Based on Value in Column A
Decimalising RA and Dec Values
Sum above
Editing and Saving webpage
really stuck...
how to make excel simply count red x's?
How to call a macro with a flexible name
Is there a way to show something similiar to treeviews in EXCEL (Not user-forms) ?
Problems with my Work rota set-up
QueryTable connection using ADO Recordset
pass combobox as argment to procedure
Controlling realpalyer within vba
Sort with hyperlink
Control property change using VBA
Recording Macro - Excel makes reference to a specific cell
copying formula from one cell to a range
Is it a duplicate row?
Print titles
2007: Connectors IDs on charts changed
SelectionChange works only when Cellpointer is within a given rang
Advice rather than an actual question.
Testing Hyperlinks
Finding Sample VB programs
MailMerge Label printing from Excel
How to create a long validation list?
Variable Range in Macro not working.
vb.net interop
2007: new behavior of grouped shapes
Is this possible? Click a cell to run a macro
I found these text strings printed out. What would they do if used in VBA?
Retrieve Documents Within Date Range using VB/VBA
Formularbar won't disappear with VBA code
Creating Macros at runtime
Consuming DDE and providing XML
Find Duplicates Variant
Ignore duplicates
SaveAs Cell.value=filename
listbox
Saving a txt file
How to create new textboxes during runtime?When user clicks on a button textbox shouls appear.
change current cell colour based on the value of adjacent cell on other worksheet
adding to a VBA COde
Download file with Excel VBA generated from jsp over https
Specify Path / open all files in folder...
Windows Media Player
Excel selective search for a combination of values - urgent
Urgent please - Macro stored in template cannot be found
Windows Media Player
Protecting excel sheet for data input
browse for path in vba
simplifying repetitive routines in VBA
Help with Cut copy and paste...........
Cell offset for filtered list
Menu and Form problems
Help...Automate send e-mail code....
use of category / subcategory pattern with excel combo boxes - please help!
vba excel update to a database problem
Add button to worksheet cell
VBE Editor opens automatically when I run a macro
Non contiguous ranges
Create Worksheet From Values in Existing Cells Using Existing Worksheet as Template.
match cell to range
Command Button coding
name definition
Performance question
How to Stop VBA from executing
copy sheet complete with command buttons and code into other workbook !!!
sum of cells with dynamic range
Creating A Chart With Embedded Data?
Search multiple strings Difficult to figure out
Slow Calculation Index and Match Array Formula.
Data Clean-up
Updating multiple worksheets dependent on checkbox selection
Automating Page Header
ActiveX controls only work in Single window
appAccess.currentdb() -- Interface not registered
I require some help with a section of the following code.
Copy sheet without code?
Creating Subfolders
"Continue" and Exit with For Loops
trying to find a way to make duplicates and add identifiers to a
vbBack... not like a backspace
Right Click
Navigate through selected range to store values...
Storing column() to use later
"Sort key" problem now is "worksheet identification"
set Excel.Axis properties
Macro based on cell value
Create New Worksheets based on Pivot table data
Double search
Cell format as "Text"
Excel print loop
Various different page headers for one sheet
concatenting rows for excel combo box output
How do I make my macro update each month?
Find a number of strings within a worksheet and move them to another.
Output an Access Table or Query to Excel
How to change a cell colour depending on the result?
Cell A1= range from B1-B10
problem with excel vba copy/paste. can anyone help?
sharing
Split datadump and create new worksheets
Toolbar & custom buttons - gone!
is number between to other numbers.
Test for Empty, Null, "", 0
How to set off CommandBars
Manage Word paragraphs inside Excel
Generating a drawing based on a cell Value (Repost Attempt)
delete all sheets but one
Excel 03 Active X Message
Change font color in cells - Excell 2003
Fastest reading of large text files
Export very slow
create Macro â€“ select data, sort by acc no., yr, part no, create P
Extracting conditional format conditions for cell
Executing Userform
change cell color when result is above a certain value
Split a datadump and create new worksheets.
Date type library
Identifying formulas using Validation rule
Calculating ages and volumes: Macro or formula?
#REF! error
Optionbuttons in frame on form
Disable clipboard confirmation
Footers after the fact
Chart Source data in a closed Workbook
Iteratively removing data from a VBA array
Customize Text for Pausing Over Chart Datapoint
Select a file
External table is not in the expected format. OWC11
Converting file from XLS to TXT
External table is not in the expected format. OWC11
How do I stop Macro from affect other Workbooks
Label with Scroll Bars
Problem with formulae in VBA
Export Pie Graph Chart as Image
Last Cell
2007: Macro recording not working for some actions
Hide/Unhide Rows or Columns
Formating cells
Cell Format
finding multiple instances
Add Chr(10) to cell
accessing the value of a slider without selecting it
code to input date after diff. cell selected
American date conversion Macro
How to prevent broken links?
formula help please
Help with Time Stamp
Time Stamp
C++ ATL control on Excel 2003 VBA form
Error 400??
Think I may have screwed myself...
How can I do this?
How to build an RTD server from scratch?
Error on Excel 2003 Workbook_Open XmlMaps
Time Stamp
Retrieving the last save date and last author from a list of files
Need help with calendars...PLEASE HELP!
Pulling entire colum from one cell
Sheets names
Excel 2007 Conditional Formatting
Why am I getting a #VALUE! error?
Excel 2003 VBA calling VB.NET ?
Storage location of macros
Error Message at Launch
excel 2007 UDF name problem
Sort key
Build custom charts in Excel and copy them to PowerPoint
Hyperlinks
Optional Argument anomaly?
Formatting portions of cells
data from external file without opening
calling calendar, get Automation Error
Carriage return in a Text box
How do I read this VBA code?
edit filtered list
Macro for importing a fixed width text file into the activeworkbook
How do I create a mandatory field in Excel
Delete everything after a certain character
Conditional Formatting
2007: .top property not working with datalabels
Menu Item on the Excel
How do I create a mandatory field in Excel
Insert Row in Excel
Merge cells
Hyperlink into Address
Find/Replace in Module
How do I copy an autofilter using a macro?
2007: Chartwizard bugs
how to hide or minimize add-in
summing multi inputs
Copy & paste ranges dependant on results from another calculation
Setting a VBA Control as a variable
2007: Legend format in Surface plots / shadow effect
Worksheet Range Question - Excel 2003
different dates from one calendar
How do I get one instance of Excel to communicate with another instance?
Nested if statements / comparing two adjacent cells and inserting row
Excel Conditional Formatting
Too wrapped up in macros!
VB code needed for novice
Macros
Application.run and ByRef arguments
Make a IMAGE Move
Drop-Down Boxes
How to assign same code inside Option button code space ??
Problem with Network Latency
Align y-axes on charts
How to assign different Linked cells to option buttons
Uncheck Check Boxes
Sending Personalized Email from Excel
"bisecting" loop with boolean flags
populating a list box
Dialog box for user to select a folder
2007: BeginGroup not taken into account
Two more problems with Excel 2007
Create pivot table from pivot table with VBA
lookup a cell on another woksheet by using the tab name
Fill down problem with Worksheet_Change(ByVal Target As Range)
Nested directories from Treeview
command bars in charts
Using Regular Expressions with VBA
MATCHING, & DELETING BOTH MATCHES, IN SMALL DATABASE
Need help with calendars...Please!
Log User Name and Date when userform was run/modified
Textbox Clear last entry
MailLogon Problem in Excel Workbook
Undo Disabled in Excel 2003 using VSTO 2005
Counting days and array element reference
Custom Number Formats in Code
Identfy missing references
open Excel from Web: freeze panes so 1st row is always displayed at top?
isnumeric() and hyphen
filling a column with consecutive months
Two answers to a true "If": =if(a,b*and c,d)?;b&C true, d false?
Combobox to list all Sheet Names How?
How to Duplicate Field Content in Excel Pivot
Scrollbar issue... wider?
CELL Function in VBA ?
Coding for shared buttons
Creating a chart with VBA
Link table from excel to word using word VBA
create command buttons using vba
VBA - Disable up down movement inside ListBox
Copying data to 2nd Workbook slows down as it proceeds
Best Place to Learn VBA
For Each Loop skip using user-defined type?
Solve: Macro Prohibited
Aligning text in a box
Daily refresh
macro doesn't properly record AutoSum (and SendKeys doesn't work)
Multiple hits on an excel file
Copy and pasting ranges
Edit or insert notes on a extracted list.
Multiple macros in one workbook
Definition and use of multi-dimensional variables
Using VBA to select dynamic number of rows
Getting pasted image reference
Creation & Implementation of VB6 DLL in VBA to raise events
Embedding spreadsheet on a website
Re: Simple
change 0.87DR to -.087 and 0.55CR to 0.55
VBA for Hiding Rows with Errors
Simple
Passing string as macro parameter
Using NOT Exists in SQL
Rewrite cut action not working.
External Data Conversion
Solver in Excel 2007
Copy Columns from Excel Pivot Table in a Macro
Select a ListBox value with code
Pivot table and OLAP Cube
how to replace cell references with actual numbers
Data Extract and sort
Excel VBA Control Sizing Issues
edit sheet name
Ribbons / VBA example
oops, how do i get the excel text-menu back?
Copy Row Paste Row (Seperate Sheet)
Moving Digital Certificate with Private Key
how to hide toolbars
Excel VBA and Apple Mac OS X
ClassificaÃ§Ã£o 2
Min of 2 variables
Custom Toolbar
How to protect a macro. i.e not allow macro changes
Selecting a Range after Autofilter
Place a picture at copy
How to write my own an Add-In
Position A2 at top-left of window
Filter a list with data from another sheet
Copy Data not Command Button?
vlookup
Labels on Buttons do Not Appear
Opinions Wanted - Which is Faster???
Basic help
worksheet selection count
Decimal Places
Import table into Excel with lines sliced into separate sheets by UID
Ms-Query Eur Symbol
ScrollBar Linking/Synching.
Any sample code to verify data?
excel vba userform clear details
Editing Code from Code
How to add a title to a chart by means of Excel automation?
Deleting of names
Digits after decimal
Opening a form from a desktop icon
Excel VBA Classes Error: 424 Object Required
Hide Command Shell window
Default folder for VBA modules
find a match from range
link to mulitple workbooks
If and Else Statement
VBA and PivotTable refresh
Glitch in code some where, i think ?
using a worksheet to collect data for access import
Extraneous Calculations?