Microsoft Excel Programming [Archive] - Page 24

VBA Copying/Pasting problem when data is filtered
Save as marco
Inserting and Deleting Rows and Columns
Summing column cells based on values in other columns
Recorded macro selection widened
Going to a "set" range
VBA Formula Help
Re: combobox list of sheet2
Protecting worksheet
How can you flag a cell with fill colour
Modification of Recorded Macro
Marking owners sites & names
Cannot find part for the specified URI ....
DateValue gets wrong date number
Multiple users saving a form
PivotTable Events?
Case sensitive VBA Match
Variable Control name
Paste chart images macro fails
RE: combobox list of sheet2
DoubleClick mystery
FORMATING ITEMS IN A COMBOBOX !!
Desplay active and Hide sheets
How do I access different versions of Excel from one .NET executable?
Unable to Authorize Launch Permissions for missing "Microsoft ExcelApplication" in DCOM Config
loop selecting data
VBA code
File Size - VBA vs Excel Formulas
UserForm QueryClose
Copy formula
Find a row and move it to the end
Data Validation Lost After Clearing All Shapes
Printing to File (PDF)
e-mail a range of cells as the body
Prevent Extreme Zoom Out. Mouse Wheel Event?
why does the execution jump to another procedure?
Execute Codes after Sheet Deactivated
Cannot delete workheet
Adding An If Clause after Prompt
Delete Columns
How to unhide hidden Excel Instance
waiting for user response
ConditionalFormatting help
Excel
Schedule a macro on a specific time
Using com add-in vs digital certs for app
Compile error "Else without if"
vba, how to go to Col B in whatever row is active
treeview drag/drop problem
How do I make a button appear when the custom Add-in is selected?
Create folder macro or vb code?
Macro or formula to date stamp cell based on new data input
Help with Replace()
keeping track of parameters
Report Header
Subscript out of range?
how do i check system time zone from excel?
Excel bug?
using Networkdays formula in French version of Excel options
Getting a constant/variable from another workbook?
VBA/Coding issue
problem wtih worksheets activate
counting every 3 rd row
Repeat Label on Pivot Table
Display image based on value/status
Display image based on value/status
use of Case-Select, with on error
Properties returning object reference or value?
More elaboration on help pages
Run macro in background
Create folder, text file and vbs script from data in excel
code to shade row then return it to as it was
Date problem
When is a parent object required for a property?
Can VBA function be used to return value
Sort Rows into Columns?
File Listing in a Directory
do if cell not empty
Chaging pictures on excel
Auto Paste Values
if not empty do something
Saving all open workbooks as html
RE: AutoFill the data
Re: AutoFill the data
SendKeys
AutoFill the data
Match Values and Highlite row
exact match in a string
Macro to Paste Picture in email body from Clipboard
Excel locks when opening file not in focus
Tough one - Timeout doesn't work
Vlookup
Accelerator
Scatter graph with step wise data
Here is the syntax for TreeView.KeyDown().
can't sort a list
Application.Calculation = -4105 behaving strangely
Problems with sort
Help with getting filenames & then checking for new
opposite of dropdown in combobox
Am I an email enclosure?
Loop through Variables
Control Box assigned to multiple spreadsheets
Saveas Not Working
Avoid Type Mismatch Error when using CDBL()
vb code for time subtraction
changing the excel "color scheme" using vba
Using duplicate data in Dictionary or Collection
Re: What is wrong with this lin e of code
Re: What is wrong with this lin e of code
Use code in a modul
RE: Macro to define range names
Compare part of text cell to another
If product already exists continued
sumif/vlookup
Copy contiguous from one sheet and paste to another every other ro
duty numbers and names
Email only one sheet from a workbook
Loading Text File into Array
Fill in Text with blanks.
choose range based on criteria
Regex Multiple Match not working
VBA: Delete name range
employee excell dilemma
Re: Determine version of Excel in VBA
placement of error traps
How do I make a task calendar from an excel spreadsheet for work?
copy paste merged cells
2 Variables determing a lookup sheet to use
Copy cell data from one worksheet to another-TJ
Delete Rows and Sheets
ask user to determine email program
Pivot table help
macro security trusted sources
Initial Value=""
CF or VBA
Range name applies to list, or simply range; collection-index/member-ofprecedence
Help with count problem
Help with count problem
Toggle between True and False confuses me
RE: Determine version of Excel in VBA
RE: Determine version of Excel in VBA
Re: Determine version of Excel in VBA
there must be a more simple way of doing this?
VBA: Clear temp internt files every 20
Autofilter and cell check
Coding
loops
Possible Print If macro?
Help with VBA............Again.
Question for Office 2007 Users
First 3 characters
Hide Spreadsheets
caching in excel
dynamic size of label, and depending on size label position of tex
RE: Save As: change all control characters to an underscore
Copy from fixed range does not work
Web Browser Control and Javascript
VB to Notepad
need an average over 24 hours
Workbook_BeforeClose event - Cancel won't work
new row with data from criteria
Re: VB Macro in Excel 2007
Making a cell count the amoun of entries that has been put into it
Excel 2007 vba error
'Cancel' on User Prompt Box
Delete Certain Rows Based on User Input
Combobox release
Already Zoomed Out as Far as Possible
ColumnMatch Include Column H:I
Best practice in qualifying Excel worksheet function invocation
protecting a file
Change UDF to work as array formula
query afterrefresh not working
Hide a Password
Selected item in combobox at DropButtonClick
textbox's exit event
Lock cells after data entry ?
macros in my custom xla Addin - how to make visible in Macro menu?
trying to hide command buttons in userform if cell empty
Dim and Disable Buttons
Timeout of sql server in excel vba
Launch Macro By Double Clicking
I'm a nooby. VB code to filldown for varying spreadsheet length
count where item =x
Notes email.
Date Formatting Lost when multiple cells are blank
changing the source range of a chart
Simple Command Button
Pasted this morning, but not now
interactive databases
Overflow error occurs when multiplying integer constants in excel
VBA selecting a range
Back color on a multipage
make autofill code conditional to avoid runtime error.
VBA keywords
Add Yes/No stops in VB script
A taxonomy of methods and properties
how to build a dynamic array and search it for a value
The Range property
using a macro to map a shared drive
Help in Getting the File Name from a path
ComboboxStart item
Match statement that displays result
Command button caption from cell value
auto date reminder in excel
send email when changes are made to a worksheet
Formatting a comment using code
using Excel 4's REGISTER command
Expanding selected ranges that are changing next time (with vba).
Help with VBA
Summary sheet
highlighting intersecting Cells if ColumnName=Value in an other Co
Create organizational chart with VB
Disable formula Bar in Option Menu
How many words can we save in Custom Dictionary of MSOffice ?
[Excel2007] How to obtain provider name for ADODB.Connection
Copy rows if
i would like a code for autosort left to rigth
Range with "Large"
Who Can Expand Chip Pearson's procedure ExportToTextFile?
Associated fields coming into a spreadsheet
RE: End(xlDown) function
Re: End(xlDown) function
postion of dropdown list with sheet combobox
Today only
Form height and scroll
Label in a form
Re: Vlookup in VBA
Is there away?
CSV-file as semicolon se
autosort
How can this be???
Test if clipboard empty
LINE INSERTION IN TEXT !!!
Vlookup in VBA
Copy certain cells to a "backup" sheet using VB
combining multiple rows into one row
Re: Where was I called from?
Using xlDialogFindFile to get filename and path.
Re: Where was I called from?
Re: Where was I called from?
Re: Where was I called from?
Matching/Finding/Search Array Element
Re: Select Case "Procedure to large" Error
macro to hide empty rows
maximum of currency array?
Re: Conditional Number Formatting
File opens slow with digital signature
Re: convertion form number to words
Server timeout expired
Flashing cells
"Caps Lock/Unlock"
If Product already exist then overwrite that row
Quicksort for multi-columns
Adding data to a cell next to another cell with specific value
HELP!! Download data to workbook
Using Variable array in Excel VBA charting
Calendar 2
User Forms and Date Formats
bug: Worksheet_Change clashes with dropdown list validation.
Highlight active cell
How to insert variable into link path?
Create a simple menu button
Add new sheet automatically every data.
foundfiles bad result
Help my please: VBA code for "Find" function
mysteriously enters into break mode
Read Only Files - Part 2
compare pairs of columns
Weeks between two Dates
Pending Records
Variable Range & Sorting Macro
Macro to automatically hide rows based on 3 cells
Download data from secure website into new Worksheet
Use a Variable to Reference a Check Box Object
fill down range starting at last cell
OR options in IF statement
activate userform when a worksheet tab is selected
Read Only files
How to code ReDim Preserve when "ReDim strArr(1 To 100, 1 To 3)"
Re: padding cell with up to 3 zeros
Code stops while Userform Shown
padding cell with up to 3 zeros
How seperate text with comma in a cell into seperate rows
VBA code to get the Html code from the IE
Programmatic row insertion error; KB211769 no help
Can Checkboxes trigger the Worksheet_Change code?
change all specific row references to next row available in fill downformula
Copy hidden worksheet
Macro Assist
Why is this code not working
Sorting worksheets by name AND colour
Find last row in column and past below
Re: Combine Two Worksheets
Format row based on value
Today's date
Spin Buttons
problem formatting lines around cells
inserting range value in call
Re: TextBox validation code
Delete Line
resize comment box with vba
auto open workbook to make read-only
How does this work?
Re: Colour rows based on value
launch macro in other workbook
Colour rows based on value
XL2002 - PivotTable 2 to Match Pivot Table 1
File name to Cell
Prevent scientific formatting when creating excel sheet from vbscr
Re: Importing a string as columns.
Re: Importing a string as columns.
Importing a string as columns.
Change a Macro - Copy in Columns instead of copy in Rows
RE: Command Button to export a worksheet as a .csv file
Command Button to export a worksheet as a .csv file
EXTRACTING SUBSTRINGS !!
Selecting a Range
RE: TextBox validation code
VBA Changes
protection
Macro for copy and paste function
Locate source data on auto refresh
display time when macro was last run
"String" manipulation for a Case clause
load user forms
group all sheets after
Run-time Error '-2147417848 (80010108)'
disappearing macros
Secure FTP (https) and VBA
Macro and Macro Button
within my existing code, check for blank cells in certain rows. Ifblank, exit sub
Data Validation - I Think
Inserting a symbol
Passing a variable into a subroutine in a different open workbook
Use cell value to adjust date range
Excel images
user form, set values
Project is unviawable
ComboBox Help
Color text inserted into other text
2003 - MS Calendar Control VBA weirdness
Working with ListBox with frmListStyleOption set
RE: Friday of a given week
RE: Friday of a given week
problem coping data from 1 sheet to new sheet
Re: Friday of a given week
Re: Display VB code result in cell instead of message box?
RE: Display VB code result in cell instead of message box?
Friday of a given week
For Rick Rothstein
Lock lines together to creat pivot table?
Display VB code result in cell instead of message box?
Macro to add column and insert date then in blank cells copy fromprevious cell
user form, code placement
SEARCH function
Temp variables in formulas?
causing the bakground in excel to flash on an event
Column Match
Connect & disconnect dial-up connection inside Excel Vba
Userform
popup immage
Re: VBA Training
RE: VBA Training
VBA code for Timestamp
THE "INSTR" FUNCTION !!!
Named Range not appearing in names drop down
VB Code for summing control check boxes
RE: Copy to an existing wb or create new wb if it does not based on ce
Copy to an existing wb or create new wb if it does not based on ce
Maintaining position and Value of certain cells when inserting inf
Dynamic charting; Diff between exec 2000 and 2007
Activesheet question
problem validating list
auto/conditional formatting
Data Entry Form which updates several worksheets
Please help with OLE object and text box content!
Lookup for a value in a table
Msg Box to appear when page selection changes in a Pivot Table
Excel is running too fast
Pivot field data disappears
RE: range shift
range shift
Lookup Return Multiple Values in VBA
Data passed to spreadsheet from Form. How to reload the spreadsheetdata into the Form?
Rearrange data into Columns in same row
Change Cell Color Dependant On Date Range
Column Rearrange same row
Using a text editor into a userform
xlCellTypeBlanks
Passing Data from "Form" to Spreadsheet
button and Excel and VBA
Sub or Function not Defined
Looping Every Nth Row to Copy & Paste Special
Count unique instances of text in column
click on calendar control calendar but want to return the DAY of
My unsolved mystery!
Need XML export solution (Excel 2003)
manual and macro run differences
Re: Office SP2 - Problem with macro assigned to a button changing,Worked with SP1
Web Queries
Convert Range of Years to Individual list (integers)
Re: Is there a way to force Excel 2007 to recalculate just one cell?
insert 1/3 as fraction
How to see worksheet changes while macro is running?
read from hidden sheet
The use of VBA function "Time" in an Excel Macro
Drop Down List - Other Cell Results
Text>Date ???
System Error &H8004111 + out of memory when using Excel macros
Loop through FTP locations in File Browswer
How to return Array() to range as variable?
paste range from one sheet to each sheet after
Problems Loading Large String Array into Array variable
Need to understand this calculation
Disable Alert
Re: Running total macro issue
Looking for a Form Control that combines ComboBox and CheckBoxes
search criteria - auto filter
Save only changes in a specific sheet, leave other sheets alone
Password on Command Button
RE: F2 Function key
Flashing cells
F2 Function key
Destination:=.Cells(.Rows.Count, "A").End(xlUp).Row + 1
Deleting Blank Rows at end of sheet
average on part of a column in VBA Excel 2007
Renaming styles
Error 5 on Shell Command
open workbook
Change Imagebox Property?
microsoft query
Event drivin copy and paste code
From active cell, select the next 10 rows down, 6 columns over.
Change Sheet Name
Defining XLApp as 2007 App on a machine with 2003 and 2007 loaded
Printing Invalid Data Circles
Open Access Form from Excel Macro
Finding month in mm/dd/yyyy format
"Trust Access to Visual Basic Project" checked but getting error 6
"Trust Access to Visual Basic Project" checked but getting error 6
AutoFilter-criteria with VBA in XL07
copy format to new sheet
Selecting between two ranges
ListBox error "Invalid argument"
Write in word OLE object
Copying data from different column
Re: Auto_open MAcro
Please tell me how to make this more efficient and repeatable
Font Style Properties
Adding dates within a comment
Data from sheet, through userform to text box on the sheet.
Code error
Cell Data Update
Colour numbers
Multipage and Global variables
Nobody can answer! Problem with commas and dots
Lock and Hide range of Cells
Clicking a picture
counting instances
send XL text to word
Trying the impossible
Device I/O error
text strings
Cells flashing
Assigning Functions to Toggle Buttons
How to Override a VBOKCancel button?
passing value to excel 2007 document solution on web server
Fourier, numbers-as-text, and macros.
Private Sub Workbook_newsheet
Creating sum formula using vba
Macros for copy and paste of a range
hyperlink prompt
Splitting Range into it's components
Submit Data form in one tab to another tab in same excel?
paste range to all sheets after specified sheet
Re: Please help me with VB Code
Delete Worksheets
Table using Excel range
RE: File size gets huge on photo insert
Need help with macro
Adding company to an Access table
Re: Please help me with VB Code
create sheets based on data in string and copy to
Please help me with VB Code
File size gets huge on photo insert
Can I paste number formats only?
Double Quotes in MsgBox!
How to save a worksheet in a project as a SEPARATE FILE
Font Color
Deleting Sheets via Macro
I have some code which loads a form in Excel on startup
Macro not copying (or pasting?) content of all cells
Is there a GPS coordinate converter in Excel?
RE: How do you run an add-in?
trim not working
Linking cell through variable
If Then Code Question
Launching a Macro bt Double Clicking
One letter per cell
Hiding Rows and Columns in code
Calendar Popup
Update Date Cell
Compile Error
Shouldn't have to ask but..
How to set up macros that will work when aditional data is added
How to build / refresh pivot table without ODBC??
Label caption change on opening of form
Getting unexpected gaps in a spreadsheet
TextAlign in List Box
Use a shape as a gauge.
List Box
InputBox Choices
VB for Different Excel
RE: Password entru code
Code Stopped
Password entru code
Marco to change formula according to what is written in the cell
Buttons
XML schema import problem
Music in Excel
QueryTables/ListObjects and QueryType/SourceType
Re: function LINEST
pagebreak
Extract Chart Titles from graphs
2003->2007 xlsm->2003 loses worksheet commandbutton functionality
LOOP HELP!
RE: fetch a value from a w/sheet to userform.
ActiveWorkbook.SendMail Recipients
drop down menu with option to add values to the list w/ new entry
Need Help Matching 2 Lists of data
Regex as replace function
Moving Part of Column
Custom Toolbars in Excel 2007
"Enable background error checking" on/off in Excel 2007 SP2
Help Modifying Macro
Referencing command button on worksheet from VBA
Initiating a Custom Toolbar
if student number repeats move all data for that number on to same
Execute code when grouping buttons used
Toolbar Error
Need a little excel coding help
Import Access data to text file rather than Excel
Strange Problem with excel 2003 compared to excel 2000 in using theboolean variable
Making a process faster
Macro for Hiding one column at a time in a range
Share Excel Worksheet
disable option button on user form
Group function with hidden rows
using vbCrLf in email body does not work with HTMLBody
A macro that will inable/disable input message boxes by a cell'svalue
Stuck - VB Help needed
protective measure
VB Help sought with some code
How to Detect when third part application releases my WorkBook
Where to put PERSONAL.XLS
Address of a Cell
XL2007 .CodeName bug when copying sheet
very confusing
Module
Format Code - Joel
how to separate text and numeric data in the excel or text file.
Date Marco
Adding controls to a userform at runtime
Userform-font change
Macro to add data once a Pivot Table has been refreshed
Re: Step Into (F8) causes faded blue-grey screen with gears
Excel 2007 - macro for formatting worksheet?
Repeat Range for select Records
RE: Step Into (F8) causes faded blue-grey screen with gears
Re: Adding Leading Zeros; Formatting as Time
Re: Step Into (F8) causes faded blue-grey screen with gears
Help with Custom Tool Bar
Adding Leading Zeros; Formatting as Time
Vlookup and Sum
Protection in VBA.
Insert Photo - error on cancel
Resize Range for Column
Question about AdvancedFilter
Re: Simple example of a range argument to a UDF?
Find Merged-cells
Auto Filter List
How to check for the existence of the Temporary folder namedTemporary Folder a , 2 and so on before deleting as the name is not fixed
How to check for the existence of the Temporary folder namedTemporary Folder 1,2 and so on As
MULTIPLE SELECTION !!
Type Mismatch
Upgrading to 2007 - Object library invalid
Linking added sheets
word to excel format change
Excel & Access Tables
Thankyou and Thankyou
Reference Textbox from cell
Cleaning up Macro to Copy Word Formfields into Excel
Help with Macro
How to Get External Data from a Service created in vb.net --> WCF
Changing Hyperlinks
moving active cell on another sheet
Templates in 2007
calling sub from other workbook
List files in a directory
why cant my workbook total data from worksheets?
insert name paste for ranges
edit ribbon image ?
problem writing an Excel file on server using Microsoft.ACE.OLEDB.
Check for Duplicate
Run Error while protected
Choose picture to display
RE: Macro Error
RE: Macro Error
Macro Error
If cell contains AlphaNumeric "True"
How do I call Fourier Analysis in Excel2007 in a macro?
Find Matching Zipcode Range for Address
Wildcard to activate another window
Re: Open a CSV how God meant it
Re: For a website, are Excel scripts better than other programming language scripts?
Macros Stop Working
Setting a public variable
XL2003 Userform; cmbbox uses named range source, changes unexpecte
Menu creater - Jacob Skaria
How do I make VBA code usable on all worksheets of a workbook?
Column width and Row height test?
Function doesn't work - Boolean, Array, Select
Determine Max and Min date in Column
Re: Has Text Enough Space in a cell
having problems getting a c# excel add in deployed to other machines.
Re: code back to worksheet
workbook code - new sheet created...
code back to worksheet
check entire column value
Get text & background color with single button click.
Convert table to range
VBA Help
GetSaveAsFilename not responding
Determine if a chart exists
Initiating a Custom Toolbar
RE: For a website, are Excel scripts better than other programming lan
Option Private Module
checking and setting a value to a range in VBA
Help Defining a range using variables for column
Help to find a code
Adding documents to Lotus Notes Database via VBA
RE: Is there a better code to do this?
Re: Is there a better code to do this?
RE: Is there a better code to do this?
Is there a better code to do this?
RE: Cell data change
VB code to insert page breaks for Duplex/double-sided Printing
Cell data change
Export from excel to Access
Auto Fill fomulas
Re: Conditional formatting of a Row
RE: Conditional formatting of a Row
Conditional formatting of a Row
RE: Macros will not work when sheet e-mailed
Read Only
Macros will not work when sheet e-mailed
adding/appending comment by code
Menu creater - Dave Peterson
RE: Select method of Range class failed error message
RE: Select method of Range class failed error message
Select method of Range class failed error message
Loop and running total
VBA compatible code - PC to Mac
SpaceChart - can't see the chart
Help requested to finish Array code
Macro to filter two columns
Code help
functioning XLL not loading properly on other machines
Creating an Excel Pivot Table using COM in C# producing 0x800A03EC
file names with full path
Problem using group function with hidden rows
Reading a text file from the web
Initializing a custom toolbar
Losing my array from one sub to another
Error on IF statement
delete all rows except
Print To pdf Wait For Save As Completed
Application.GetSaveAsFilename question
RE: Pivot Table Field List
Pivot Table Field List
Trying to create a formula in MSExcel 2007 (DATE based)
User form close
Workbook with macro
Checkbox displays 'check' instead of the assigned caption
import from excel to access with macro?
VBA: Code to Clear IE Cache
Application.GetSaveAsFilename problem
How can I change Format Axis Scale Units of a chart ?
paste data from web to next available row
I need to check for a number in a column before continuing on
Converting Excel 2007 sheet back down to Excel 2003
Re: please explain
RE: please explain
Sending Email using Lotus Notes
Cell Filling
Setting maximum and Minimum Scale for the Category axis
please explain
Right aligning labels
Visual Basic Editor Window Opens Automatically
Unhiding rows
Out of Stack space error
Userform Textbox to Worksheet Textbox
vba code to replace first row in CSV file
Form Control Text box
Worksheet_BeforeDoubleClick()
Do not save macro with workbook
How to change linked source Worksheet
looping on excel files in directory
Un-Delimiting
change color
how to merge two ranges
Code no longer runs
Colour format code
Testing for a string of zero bytes
Format text using VBA
VB Format command fails
SET THEORY & VBA ?
Ontime problem; variable not passed from Workbook_Open to StartTim
Documentation on programming Excel from Vis. Studio StandardEdition.
Call macro from other workbook
Re: Pause Macro for a while and run the rest of the script later
Pause Macro for a while and run the rest of the script later
Is it possible to validate excel cell against sql table query
Save as Macro Enabled or not
IQY File: Invalid Web Query
GoTo cell..
Determining programmatically if a project is digitally signed
Code Error
Public Variables, Class Modules and Standard Modules
Detect file.
Macro to Print Pages 1 to 5 with "5" being a reference to a =count
Export unlocked cells to file
upgrade to 2007 excel
Help with SAVEAS
Variable in SQL
Timer
Here is a stumper for you (programming).....
Macro / VBA Help
Lock Range of Cells
disable combo change event temporaraly
replace text with a loop
Advanced Filter - Named Ranges
Calculate the number of Columns apart
handling an error in IF ELSEIF statement
handling an error in IF ELSEIF statement
handling error in IF ELSEIF statement
Editing items in a ListBox
Re: Export/import sheet ends up in Class Module