View Full Version : Excel Programming
Pages :
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
[
22]
23 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
31 |
32 |
33 |
34 |
35 |
36 |
37 |
38 |
39 |
40 |
41 |
42 |
43 |
44 |
45 |
46 |
47 |
48 |
49 |
50 |
51 |
52 |
53 |
54 |
55 |
56 |
57 |
58 |
59 |
60 |
61 |
62 |
63 |
64 |
65 |
66 |
67 |
68 |
69 |
70 |
71 |
72 |
73 |
74 |
75 |
76 |
77 |
78 |
79 |
80 |
81 |
82 |
83 |
84 |
85 |
86 |
87 |
88 |
89 |
90 |
91 |
92 |
93 |
94 |
95 |
96 |
97 |
98 |
99 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
112 |
113 |
114 |
115 |
116 |
117 |
118 |
119 |
120 |
121 |
122 |
123 |
124 |
125 |
126 |
127 |
128 |
129 |
130 |
131 |
132 |
133 |
134 |
135 |
136 |
137 |
138 |
139 |
140 |
141 |
142 |
143 |
144 |
145 |
146 |
147 |
148 |
149 |
150 |
151 |
152 |
153 |
154 |
155 |
156 |
157 |
158 |
159 |
160 |
161 |
162 |
163 |
164 |
165 |
166 |
167 |
168 |
169 |
170 |
171 |
172 |
173 |
174 |
175 |
- Is it possible to assign 'Ctrl + D' to a CommandButton
- Validate Cell Character Length with VBA
- Cut merged cells
- how do I use VBA to set background of a cell
- Hyperlink in cell to path/file name
- Find number of lines ?
- protect sheet in 2003 vs 2007
- Worksheet Object
- Excel using VB - save problem
- ComboBox still shows data when linked cell is empty
- Constants as arrays?
- Problem getting results of RefEdit into a range
- deleting text
- CONCATENATING CELL CONTENTS !
- offset merged cell
- using alise
- Detect Option Group Value in VBA
- How best to parse string lists of numbers
- RE: Getting data from a worksheet
- RE: Getting data from a worksheet
- Getting data from a worksheet
- Phantom sheet protect
- Test for empty array is 'UBound(AName) > -1'.
- Time Macro
- Addin
- Problem with ListBox, List Index
- 52 Firmware Drivers R4 Dsi. R4i Dsi 35292
- Check cell status on Calculate event: resource issues?
- 12 R4i Dsi, Drivers Firmware, R4 Dsi nintendo Dsi 95827
- What does syntax '_Object' mean?
- Programmatic export/import code modules
- Formula help pls
- Test for membership in sheets collection
- Excel 2007 VBA Label Control
- Need a control to pick worksheet cell ranges
- Switch ribbons programmatically
- Problem with creating Worksheets with Macros
- using a variable length list to poplate a List Box
- help with textbox tabkeybehavior
- Expanding =HYPERLINK() functionality in include BODY
- Convert Worksheet List to Named Array Constant
- Trigger inserting Date (again!)
- VBA in Counting Unique Values
- Extract data from one range and place in the same sheet
- Auto numbering
- Dictator program question
- Variable in call statement
- creating a UDF for copy
- How do I change the forecolor of a CheckBox when True
- Save As Name To Change Cell Value
- 0.3395604 Now Look Here ... 0.45301
- Duplicates
- Called procedure ignoring "With Sheets" command
- CountIfs
- Macro help
- Find Month - Help with VBA
- Embedding an Excel sheet into a Website
- Dim ChkBoxes() As New Class1
- Call module
- Normal.dot Error
- Find Date and Paste Data
- #DIV/0! Error
- Help with Delete Macro
- How to find the most common numbers?
- Combobox rowsource from non-contiguous cells
- Check for Compatibility Pack
- Convert text to Long
- Copy/Paste Template to New Workbook
- Date Time Picker
- copy rows to new sheet
- code for sort until cell equals...
- Time Marco issue
- Move Worksheet
- Utilizng full AutoFilter features while specific cells are protect
- Help with Range Probelm PLEASE !
- Chose a product and update related product variables
- Get External Data From Access
- Re: Copy Conditional Formatting w/out the CF Coding
- Trying to "clean up" some code...
- Edit names
- is there a way to use the WorksheetFunction.Min function
- Pivot Table in Protected Worksheet
- Copy Conditional Formatting w/out the CF Coding
- RE: If for word in sentence
- Re: Activate hyperlink based on cell value
- If for word in sentence
- RE: Activate hyperlink based on cell value
- can VB ignore capitalization
- Copy worksheet from one file to another
- Activate hyperlink based on cell value
- Multi-editor sheets
- Does anyone have a League table calculator?
- Class Modules and Userforms
- Need Help with a Macro
- How do I move an ActiveX control (command button) in a worksheet?
- password to open a work sheet in a workbook
- Headers
- using dir to get folder names
- Can Worksheet_Change be placed somewhere "universal"?
- Please Help Me Annotate Subroutine
- Point me in the right direction
- Put data by matching cell value with sheet name
- Calculate data for previous 7 days
- Combobox Populating from recordset
- Put the same number in A1 for 160 rows and change..
- Excel crashing
- Opening workbook in invisible mode?
- Clear contents of cells hidden by autofilter
- Compare blank cells in a column
- Copy Worksheet
- Run macro on exit by red cross
- Working with most recently used colors
- RE: exporting data from My Excel to my Web
- WorksheetFunction.Left problem
- menu commands of excel disabled
- Add a picture to a cell that only appears on click
- Is there a way in VBA to check if a particular Sub exits inThisWorkbook?
- Hide a textbox on open of Excel
- Pulling a currency variable through my arrays drops 3rd decimal?
- Excel to Access
- Looping within a loop
- Save
- macro needed to fill down base on condition
- Pivot Table Programming
- Instead of Range please.
- Converting Indents to Outline
- Writing a challenging macro
- Activate workbook using partial name
- "File cannot be accessed" when trying to click macro button
- How to calculate Min,Median,Max values in non consecutive rows via
- Dividelink
- Running a macro when a cell in a range has changed
- ODBC MS Query - comparing dates
- Help with listbox from pivot table with dynamic data
- Textbox Validation and Associated Checkbox
- Mercy - Need help with Copy/Paste VBA
- How to modify the Query Tables attached to a sheet in a excelworkbook
- setlinkondata code error causes multiple event firing and locking upcode.
- Print function parsing help
- Bypass Workbook_Open event when opening Another WB
- Change font size based on value of a cell
- VB - Macro to list all controls in the Commandbar.
- Charting error message
- xlt does not contain new data from source spreadsheet.
- auto save when form is closed
- Row Increment
- Plotting duration of activity on a graph
- Excel 2003 Pivot table: creating Fields from Consolidated muti ran
- "Out of Memory" Excel 2007 Vista 64
- EDITTING QUERIES RELATED TO QUERY TABLE
- macro to find the closest value
- Need to use excel from a web page and return the result to that pa
- Copy Down
- Index - Match - Vlookup Error
- Excel Command line
- dynamically naming ranges
- Re: Identify the numbers that make up the average
- Delete all non-numerics
- data entry validation
- Copying Filtered Data from multiple worksheets
- troubleshoot column formula
- How are cube and queries related to excel templates coding
- Help on macro error when arranging pivot rows
- SQL Server
- while my c# code running ,clicks on excel document interrupts code
- Relative range syntax
- PivotItems for a Specific Filter
- Simple workbook Protect
- Macro Runs Twice
- validation rule
- Public function returns error intermitently
- Disable copy and print command
- Help repeating formulas with skips
- Worksheet Chnage....still need help please
- what is the best way to loop through a 2-column range argument ofnumbers in a UDF?
- Trigger inserting date
- inserting page numbers into a column heading cell
- prompt a msg in loop code
- Store data in array
- Worksheet Change events not working properly
- Need help converting number string to number
- UDF returns #NUM! with F9 or Application.CalculateFull if sheet notactive
- Test for value and hide or unhide based on result
- macro to stop numbering when a letter is found in cell
- macros in ribbon no longer work
- Unable to get the Add propert of the addin class
- Return Font Property
- Control User Form object properties from VBA code
- Macro Help!
- Refined Sort - Sort within a Sort
- One more time (I hope)
- Dynamic Data Exchange (DDE) getting rewritten on save.
- Is there an easy way to tell if array.column(x) has any contents?
- Select Case Type Mismatch
- Formula concatenating date & text converts date to number
- Turn off all code (VBA, VSTO)
- Hide and unhide row when asking a question
- WSS and Dashboard Creation
- change a tool tip
- Programmatically hide an object - Excel 2003 or 2007
- Bombing on final sort command . . .
- Subscript out of range error?
- Highlight a row using conditionalcformatting
- Error in row -2147467259 calling sql stored proc from excel 2003
- Access mysql longtext field from excel
- Looping through a range..
- Using Debug.Print with Range Variable with more than one cell
- Notification
- get rid of single quote in field from Access export
- RE: Problem with Set stmt in Workbook_SheetSelectionChange event
- View by User
- using variable in setting and ActiveCell
- Add-ins in Microsoft excel
- trick validation to take values from vba formula
- unprotect worksheet error
- Can program go back to userform to give user another go at it?
- tool tip
- Excel 2003 crash
- tool tips & custom buttons
- Need to return to display
- Create workbook based on cell value change in column
- copy rows
- select from list
- Indenting and sorting
- Code for Selective Printing
- VBA - Corrupt Excel Load
- Trigger macro when range entry complete
- Populating a multi column listbox with ADO Recordset
- Pyramid
- Err number 6 in my first macro written! Drop down box not working
- vba for Today()
- an addin installation problem on test machine
- Copy and Paste web page using Vba
- Copy and Paste an HTM file with Vba
- Column Heading Loop
- Cell Population
- Hide Menus
- macro to unlock worksheet
- Capitalise
- RmDir
- Workday Function in VBA
- Problem with Populating Data Validation
- Need code to loop through columns and enter formulas
- Entering date and time on VBA Form
- Re: Error
- Re: Error
- excel formatting for .net
- Paste With A Custom Format
- Re: Useform displaying all columns with data.
- Re: UserForm ListBox
- File in Use Error Message
- Condintional Format Entire Row based on Value in Cell
- String as date
- Get macro to run on all sheets not just the active sheet
- Enable Copy Paste in automatically selected cells
- CONTROL SHAPE COLOR
- Relative Copy Range setting
- Intellisense, Object Browser, Code Issue
- Customizing a message with msoFileDialogOpen ?
- Checking for Errors
- Check boxes with assigned values
- Creating a range name from Selection.CurrentRegion.Select
- transfer data from one workbook to another.
- UserForm Option Button
- It seems so simple...
- Re: Run Time Error 91 in Thisworkbook
- Macro Command Button to Sum specific cells in a range
- How to Hilight Chart's Source Data?
- Trigger Macro with keystroke
- Find > in a string
- Creating Match-up formula to return value
- Find Contents
- Convert RGB to Red/Green/Blue component
- Macro to search through macros (?)
- Marco code needed to find contents of cell a1 in entire workbook
- Confused with If s and And s
- FUCNTION THAT SOUND AUDIO ALARM WHEN SPECIFIC VALUE FOUND
- Create active timeline graph
- RE: Creating Messages
- Docmd.Transferdatabase error
- Drag and drop
- Re: Adding Sub code in Function module
- xl constants
- Re: Want to modify this VBA code snippet
- Modification to SUMIF code request
- XML - reload source data from a file
- Re: How to make it work for "WHOLE" workbook
- Worksheet Change event not running a macro
- Automatically saving to someone's 'My Documents' directory
- Re: International date format and user form
- rank scores show ties and add top four scores
- Copy Range to Another Workbook
- Trouble Setting Range
- public variable declaration, memory efficient?
- fill a shape with pictures based on the shapes boundries
- Another Question about Date Formatting
- creating a excel sheet and have it print out and also load theinformation into another workbook
- Re: UserForm ListBox
- Automatically close personal.xlsb
- Re: How to launch Macro/Code form command line
- Re: Macro for splitting lines
- Can't see Modules and Worksheets in VBE
- Do Not Print Blank Sheet
- Protect multiple selected sheets?
- error in loading dll/missing Ref Edit Control
- look back period
- toolbar macro on template
- excel, dataset and .net access problem
- Group Name from a macro
- .find query
- Help with VBA & Macro - Trying to auto-create a "form"
- Re: Reference Cell in VLOOKUP
- Joel - Importing multiple text files to 1 spreadsheet, now importing from excel files
- Where (in which folder) are macros saved? And how to change location?
- Getting Creative
- Format a textbox
- Selecting Certain Userform Controls
- Want to modify this VBA code snippet
- are there skins available for excel?
- Multiple maximums in column
- Setting the last row in a sheet
- FIND FIRST AND LAST
- Copying Conditional Formatting With Icon Sets
- Relative and absolute references in Macros
- Formatting numbers
- Automating Pivot
- Re: How to remove the spaces in currency format?
- Re: How to remove the spaces in currency format?
- Re: Creating Code??
- RE: Creating Code??
- security constraints when you a excel scripting macro?
- Excel working with recording macro in excel
- Re: How to remove the spaces in currency format?
- Re: Command Button color
- Re: Make sheet change stick after Application.Inputbox
- Macro to move item to a folder
- Selecting data in ListBox
- Lost callbacks(?) and now custom ribbon doesn't work
- Disabling drag and drop - paste problems
- Copy non blank rows only
- Launch IE and scrap data from the web site
- How to handle user input error
- Autorun a macro on save
- Coding Question
- overflow error
- Analysis Toolpak Problem
- Index-Match Formula Promblem
- apps pros
- Show full Combo List at once
- Help on Worksheet_change (I think!)
- MC3
- Immediate window can't be found
- Target
- Problem with .Update
- how do i get a column format to follow me from one cell to another
- Range problem
- Vlookup with mouse over definitions
- Runtime-error 1004 (excel 2007) when selecting validation list optiontriggering worksheet_change property
- Target Macro
- Move and Link3
- Increase
- Double Delete
- ConsolidationReference pointing to current file in xml
- Target Macro
- UsedRange?
- Protect worksheet cells but still allow macro to edit chartproperties
- Autofilter on hidden sheet
- number format?
- ElseIf question
- 2007: Disable printing but still able to view Print Preview
- HOW CAN I USE VLOOKUP
- Macro Modification
- Run-time error '-2147221080 (800401a8)': Automation error
- Filter and unfilter
- date stamp to keep date
- SQL ODBC MSQuery in EXCEL
- 2007: How to disable printing when a specific cell is blank
- dsofile.dll and Excel 2007 file format
- On an invoice - with sums equations - don't want zero values to sh
- Validate Textbox/Userform Number Range
- Validate Textbox/Userform Number Range
- Name all Sheets except first one from a list
- variable not set
- #IF Statement in Excel
- Creating an Excel macro library
- Workdheet.BeforeChange
- Find empty cell
- Unwanted Querytable Autofilter on ODBC Import
- Privacy warning in Excel 2007
- Search up from last row
- Table Style dialog
- Formula function for ignoring cells/results equal to 0 (zero) ?
- DYNAMIC LISTBOX
- Loop syntax help
- .net data being formatted in excel
- VBA storing and accessing larger texts within spread sheet
- MCount2
- Combine workstheets of multipel workbooks into one workbook using a macro
- Help with ComboBox in VBA
- How do a logical test on times in two different formats?
- Changing Font Color to White if Background is Black
- Array Dimensioning
- Read Order When Using Tags on UserForm; Typename
- How can I prompt user to select item and use as a variable
- Automatically execute Excel Solver to on a change of input
- Text Export macro modification?
- Unzip all encrypted files in a folder with known passwords
- Saving userform code
- Save As HTM with "align=Left" in HTM file code
- Want a leading zero on a number
- Goto Reference:="abc" where abc is formula result
- How to Copy formats and formulas in vba?
- autoresize of cells (height)
- Showing all info under subtotals with large listings
- I need a variable name to contain the values of several cells
- Macros and user-defined functions used in several workbooks
- Worksheets events
- Can the last two if statements be combined together?
- Change default number to default text?
- Force display to round down
- Help on animation
- How to check if cell has conditional formatting
- Button Programming
- error; " 'Range' of object '_Worksheet' failed"?
- excel macro stops
- updating shared files
- How do I relate column data?
- FileFormat List
- What is the wild card for an Access query (MS query) parameter?
- Creating a loop in a Macro to do through data
- April Fools Programming, anyone?
- Variable types
- Check if a file is already open
- How to set a gradient stop position
- IF NOT between
- Insert multi spreadsheet
- time format
- "Cannot shift objects off sheet"
- If Worksheet Active, Go To Cell A1
- user form with conditions
- Major help needed - Iterative Functions
- Adding 2 arrays, then use in worksheet function
- Validation Dropdown Font Size Change
- Help with Loop Please
- Time calculations
- Paste data of a cell to another cell by just selecting the source
- Carriage Return and Line Feed
- How do I insert a Filter range result into a ListBox
- Return unique values from 2 different ranges
- userform code for timestamp on w/sheet
- Macrocount
- How to Find the Column address from a Range Dimensioned Variable
- Combine files as tabs in a single Workbook
- How can I make this macro works
- How find elements NOT common to two ranges?
- Pause for thought!
- avoid recalculating user-defined function when file opened
- Tricky Formula
- VBA to copy an htm file into excel
- Pull Recipient from Outlook Address book
- conditional format column
- Macro to Unhide MulipleRows if Cell B10 has a "X" otherwise hide c
- X values on a chart
- I'm looking for an operational ROI to use in the tourism industry
- Help using ListBox in VBA
- Macro: Code for skip a row
- Code window changes case and throws error
- vbscript to open worksheet, insert data on first opencell....HELP.....
- Find and FindNext...from Excel VBA Help generates 91 error.
- complex numbers with excel
- Adding cells from different sheets of same workbook
- Move and Link2
- Re: Recording Historic Trend Data
- get cell value and use it in vba
- Pivot table cell format
- Re: using Outlook Redemption - help needed with some code
- Strange behavior with old macro now throws error with "Application
- NEED HELP! Macro loop
- Find difference in min and max value
- Move and Link
- Copy structure chart
- UDF for Sumproduct
- Syntax errot
- Naming Ranges to use for Solver
- using Outlook Redemption - help needed with some code
- PROBLEM: ComboBox text size increasing every time box is selected
- RE: Help with hidden columns
- Following Hyperlink
- Recording Historic Trend Data
- Re: Help with hidden columns
- Shifting cells to consolidate record rows
- Sorted data macro not working. Advice request...
- Help with hidden columns
- Please help! Macros
- Add a message to this array.
- Excel animation
- Data Validation
- Computer lock time
- Excel Creation/Manipulation Programmatically in .NET
- Multi macro inputs
- clock use
- Reading From & Writing To an Excel Database
- How to format a line between two points on a line chart?
- Naming a listbox as a string
- Select case question
- Delete rows based on results of cell tests
- VLOOKUP help
- R/T error 5 - invalid procedure or argument
- Lock cell if based on value of corresponding cell
- Workbooks_open()
- Variable declaration in Excel 2007
- New Spreadsheet Created Based on Value Column "O" (alpha)
- What is wrong with this For Each statement?
- VBA
- Selection multiple ranges with Cells property
- I need to add column based on two conditions using Excel 2003
- Select Case question
- right click menu
- Resizing points
- Can anybody get this code to perform on the correct worksheet?
- Last Row Code
- Assigned Macro to button
- Change the size of the font in office programs
- chart error bars
- Determine the best km/h
- Test if cell value is in an array
- Getting to the right worksheet
- Filter by macro
- Excel 2007 | Add-Ins Ribbon
- delete picture within a specific range
- Variable column problem
- retrieve specific info from different 'groups'
- Searching Google for NG postings
- Save as, changing default fileformat in Excel 2007
- Lost post Re VBE
- find/delete row when cell has less than 16 alphanumeric characters
- Excel 2007 Add-ins
- Programming resource
- Command Button & Font Size
- 4 Macro inputs, 1 out
- VBA to add one to columns on condition
- unmodifiable comment macro
- Eliminate resizing points
- Date Modified and By Whom
- How to add Checkedlistbox Control to VBA?
- can a macro be run from within a formula, if so how
- Cut and Paste dark blue and red text
- Vlookup & ErrorType
- Copy sheets to mulitple workbooks in a directory
- Printing Macro
- Add up to zero
- Excel function to update time every minute
- Not able to copy a VBA array with formulas into an Excel range
- problem with UsedRange
- DATA LOGGING
- Hidden VBA Code
- Test for Optional and Asign one Range to another
- Microsoft Security Warning
- Ecape key to close/exit sheet
- Help Pls - Changing Txt on Msgbox button
- Can VBA use array constants
- Test for condition before running macro
- Excel-2007 problem while closing the files
- Module / procedure name detection
- Recording macro usage
- Time
- Looping through delimited text and using VLOOKUP
- MATCH and INDEX combination using multiple criteria?
- excel 2003 output file
- macro
- vba versus vlookup in excel
- Excel 2003 with 6 Conditional Formatting
- Start when open file
- 0.6237571 Look Inside Now ... 0.2499105
- 0.2718226 I Want To Look In Here ... 0.2651864
- Case sensitivity
- achieving sequential numbering
- Copy PIVOT table?
- Loop thru a Validation list
- animation
- HUGE macro
- Delete rows if not as range
- Go back to update my data with my data entry sheet
- Simple formatting question
- Stored procedure in SQL + vba to return a subset in Excel based onLIKE %varchar% clause
- Calculating Due Date
- Data Validation - 1st or 16th of the month only
- format code not working properly
- Form shows in the vba
- Avoiding an extra sheet when creating a pivot table
- How to fix mystery sheet
- How do I count the number of rows selected?
- Input Box Q
- From Excel 2007 to 2003
- Sort Macro
- Multivariate statistics
- Filling out forms and make one cell entry appear the same in anoth
- fin last row withtin a range using built functions not VBA
- HELP: Is it possible to use VBA to update links in multiple workbooks?
- Autofilter on Day
- recalculate hyperlink location
- Message Box on Input
- How to format ListBox columns
- Plot graph depending on drop down box selection
- How can I indicate in a macro to which last sheet to return ?
- macro
- Repost - XL Project Protection
- Type Mismatch Error in Array
- Missing Control In Addin
- Create validation list with Worksheet_change
- Enabling libraries using VBA? Can this be done?
- Creating Formulas using BV
- I want to sum all data values in a row EXCEPT the lowest two
- Copy range from workbooks into one master sheet
- Extracting data from consecutive rows into every "nth" row
- programming
- Import txt file with fixed length from VBA
- football games
- Programatically Export Excel Chart to Graphic in SharePoint
- using user input as search criteria
- copy range using
- Expected expression error help
- XML API in VBA under Excel?
- Display New Table Style dialog
- How can I make clickable boxes for cells?
- Sum columns of data in vba
- Macro files will not open
- Loop a specific number of times
- Remove Formulas then Delete Cells based on conditions - XL2003
- Populating a Cell by Choosing from a Pick list in another Cell
- Run-Time Error '1004'
- saving a copy without formulas
- Excel Add-in problem
- Find value and move to end of data in same row then move values in
- Add one to Column numbers
- copy range using last active cell reference from 1 wkb to another
- HOW DO I SETUP NUMBERING INVOICES
- Reproducing sheets with values only
- Convert date to serial number
- Reuse xmlMap
- Excel Macro to Compare two Columns and write to a third
- Create WorkBooks based List
- Print hidden sheets
- Find a blank line and put in a formula
- Need help writing a macro to Save changes in a worksheet
- Replace cell formula with revised text as noted within a cell valu
- DoneX XCell Compiler
- transposing data question
- Printing Excel to CutePDF
- Ball bouncing
- Re-numbering Excercise Using VBA
- Select Case or If - What's the difference
- Select Case not working - Why?
- Add image
- VLOOKUP
- RE: Printing a hiden excel sheet
- Drop Down Menu - Data Selection Request
- Re : Excel FilterMode to Trigger WorkSheet_Calculate()
- Counting rows in a column
- Excel Calculation Problem Formula etc
- Help me in printing a hiden sheet
- what formula would I use to add information in a range of dates?
- Copying data from 100 tabs to one summary page
- Copying data from 100 tabs to one summary page
- Copying data from 100 to one summary page
- Copying data from 100 tabs to one summary page
- ecm2001 crack torrent rapidshare download 14150236317832207766
- Changing Sheet Cell Formula Reference
- Copy a row using VBA
- Moving to newly Saved Workbook
- Automated Sheet
- Changing Do Loop to For loop
- Bin2Dec
- Picture dimension
- Run-time error: The object invoked has disconnected from its clients
- Need Macro copy range of cells
- Email specific addresses
- Capturing YES/NO from two option buttons
- if and statement
- Macro Printing
- DateDiff() problem
- Excel 2003 macro won't run in Excel 2007
- Code jumps to WS_Calculate on a different sheet
- Removing a macro button after execution
- Display an array in a MsgBox
- Userform Listbox subcategories?
- Excel not showing steps as I F8 through each line of VBA code
- conditional formatting test
- conditional formatting test
- runtime error 3343
- Obtain User ID
- ranges
- Conditionally-like formatting just a part of a cell
- Email with mailto equivalent
- Sort single column
- Code optimisation
- find wildcard text between {} cut, and paste in another cell
- Return Rows from another workbook
- Powerpoint and embedded Excel sheets
- How to count # of dates that fall between a start and end date.
- Date Variable
- Password protection worksheet
- a deployement problem
- Macro Help
- Copy cell contents to access form
- Excel 2007 Import .txt file error 1004
- ActiveX control causes "Reset project" notice on file open
- Editing Text File Without Opening
- Creating a collection of visible worksheets
- UDF + managed code
- cells that are outside the range of cells defined in
- Retrieve cell value & format at the same time
- Expand selected Rows
- Dynamic Link Library
- Excel Macro not running after enable trust.
- Enter File name in cell
- Determine user's Email Address
- Comments
- Populating one cell using multiple checkboxes
- Excel Waiting for Another Application to Complete an OLE Action
- Type Mismatch (13)
- Comments
- Calculate phases of the moon
- Userform combobox: best match on partially typed content?
- Range to an Array doesn't contain values
- vlookup help
- T-SQL with a added field
- Vlookup error
- finding and summing case-sensitive text
- Referring to column or row grouping using VB
- macro to save as
- adding row
- adding row
- run-time error '1004' general odbc error
- Stepping through VBA code, Excel not performing actions on split s
- Last cell touched on sheet
- post to different sheet
- Cut Contents and Paste
- Code to split Worksheets into seperat workbooks
- Macro to compare two columns and if condition is met write to a co
- Application_defined or object-defined error - Run 1004 error
- Activate Excel when double click
- Scroll specific columns only
- How do I Match Data usign criteria from 3 columns?
- PDF
- Excel 2003: Help with Drop Down List
- Macro to Insert Unique Password for Multiple Excel Files
- Insert Table into Shape
- Get data reference to last row
- Combine Duplicate times and SUM values v2
- Combine Duplicate times and SUM values
- Condition formatting problem
- Date Variable
- Use late binding to get at the FORMS library
- worksheet_calculate
- convert text to number - performance problem
- assign macro - toolbar
- Filtering For Data Using Macros
- How to Post data to website to VBA
- Restricting sheet_selectionchange code to just one column
- How to Create Unique Reference Numbers for rows of information
- I want to define title rows -1004 ...
- How to restric another excel app to attach to the created applicat
- is it POSSIBLE to create a Database in excel using VBA...
- Formula to get number + 80% from previous
- Scatter Graph - bring line to front
- Screen tips
- Autofilter - Contains
- Auto open Data Form
- csv data into forms
- Vba Formula To Include Activesheet Name
- Can I assign a formula to track when another cell is changed?
- Printing integers from a userform
- How do I run a macro from another file?
- Help With Macro - Cannot figure out what I am doing wrong
- How to copy worksheet from one excel file to another
- Finding an exact string in a range
- Pragramatically grouping items on form
- convert text month to numeric month
- if-then-else in VLOOKUP function
- Slow Macro - Formatting Macro
- Macro Digital Signature
- Can Relative dates be used in a query?
- Are relative dates avail in query?
- Virus Verification
- Code doesn't disappear
- Excel 2007 Save as .xlsm
- Re: Sorting dates
- How do I compare two sheets and output a report?
- Excel 2007/Vista - PastePicture Problem
- Why so many "Service Temporarily Unavailable" errors here?
- Printing odd and even page footers
- Printing odd and even page footers
- Excel Query Causes Access To Go Read-Only
- current year
- Pivot tables using multiple tables
- Multiple Data Sources - 1 pivot table
- Creating Ranges
- Default File for Excel 2007
- Controls on Sheet
- update of worksheet cell extremely slow
- vlookup
- source sheet name as a wild card
- Using Find to Cut & Paste
- (Excel 2007) Query Data in Database?
- How do I respond to prompts "Too many cell formats"
- End (xlDown) question
- Extract and summarize data
- Office 2007 Shortcut Menus
- Arctangent problem
- Programmatically list references in Excel
- HOW DO I USE EXCEL TO CREATE FILEs AND FOLDERS FROM A TEMPLATE?
- VBA SUM Function
- Copy
- Language independent formulas
- Apply maco to multiple worksheets request
- How to extract complete HTML code in Excel
- Export of select query data to excel in Access 2007
- 4.0 macros in Excel 2007
- Creating and transposing a multiarray
- Calculating Pay Periods
- Counting Macro
- Sort Pivot Table by Gran total automaticaly
- Pivot Table
- range selection object code
- About the need for digital certificates
- Date: Auto text entry based on aging
- WriteLine function
- Copying a differing range of rows to a new worksheet
- Change worksheet, two trigger cells on one worksheet, only one triggers correctly; using two If statements, do I need End If?
- NewsGroup - Windows Mail
- Finding a file
- reseting hidden shape counter
- Change date to display as # week of the year
- How do i enter data in different workbooks from daily data
- Option box text - linked to cell
- Controlling 3270 Through Excel
- column letters and numbers
- Deleting rows when certain cells are blank
- Office 2007 Shortcut menus don't stay on
- On event settings
- Creating an Excel combo list in VBA
- Pivot table help
- Content of Cell clicked in another cell
- Password Protect Unhide Worksheet?
- Minus Dates
- Summarize Data
- PasteSpecial values pasting formula also??
- Level of Indentation of a cell
- file size becomes very big after copy
- Trap Save / Save As for all Excel workbooks
- AdvancedFilter and setting the range
- How to add condition to coding?
- Export Chart as TIFF or JPG
- VBA just stops when opening a macro workbook
- VBA to center Selected Cell in Current Window
- xl to word procedure - troubles with references (xl2003)
- Multiple Object Right Click Event
- An Easier Way
- Refedit very serious/urgent problem
- Transposing in groups of rows
- Creating a range by going down a column until an empty cell is found
- Replace number in formula with ROW number
- Chip Pearson's DistinctValues function
- How to add condition to coding?
- Remove code from a worksheet before emailing
- Have TextBox display a dollar value
- Excel Updation
- Hyperlinks fail when constructed using Autofil
- Open sheets as per the range
- Remove time from date
- Find the first lowest value in a column that exceeds $foo
- RE: Macro to delete rows until a row contains a certain text string
- Pivot Table Range
- Can I change the reference to a named range via VBA?
- Text String (Edit w/Carriage Return)
- Combobox Dropbutton click event
- need a macro explaining
- Sorted range into collection
- UserForm MsgBox problems
- variable page breaks
- Add.item in combo box not working
- How to programmatically set Error Trapping in VBE
- Dim c as Cell
- Tricky OFFSET routine
- Sort Dynamic Range
- Run-time error '50003': Unexpected error
- Auto-expand/rich auto-complete option in Excel combo boxes
- Number of Characters in a Cell
- Dynamic Pivot Item Selection
- Delete All Q
- Column header letters
- Autofilter run time error 400
- Excel 2003 with SP" 1004 error
- Find. On other sheet
- Getting #ref error after row / cell is this a limit in excel 2003 tia sal2
- Picture alignment
- Macro to generate list of folders
- Conditional formatting ♣ ♦ ♥ â™* NT
- macro doesn't work
- RE: Small favor
- How to share macros from personal.xls?
- function runs in VBE, but not from spreadsheet
- SQL code pivotting
- Need help to increment default WorkBook name in code
- Why is search nonfunctional in this discussion group?
- multi level conditional formatting
- Macro to delete blank rows in a worksheet
- Conditional Formatting More than 3 with Formula
- Excel 2007 - Data Form
- addin detect worksheet activation
- Refreshing one cell
- Can you create Hyperlinks with Autofill function
- Macro to Update all worksheets
- Declare Non-contiguous Columns as Arrays
- Sort Pie Chart by slice size, don't sort data
- Need to move row from worksheet to another
- March Madness Excel Bracket
- March Madness Excel Bracket
- Getting #ref error after row / cell is this a limit in excel 2003 tiasal2
- Call .BAT file with paramaters using Excel
- Getting the sum from filtering
- Date Picker component
- Copy paste - Values - formula - Optimise
- Copy and paste a row from a table
- Macro to open view with a password
- XLM Macros: Problems With Custom Toolbar Buttons
- Find & Format Data Using VBA
- Userform Text box Format to Currency
- Refresh pivot data automation
- overflow issues...PLEASE HELP!!!
- Force to update textbox value to cell
- Importation donnée Web sur excel avec authentification
- Help on Excel Macro VBA
- Go To Worksheet.Cell Referencing Another Worksheet.Cell
- DateTime format
- Set variable date range in query?
- Frames on Form
- delete if contains
- Can Application.Vlookup access a range in a file which is not open?
- Sort and summarize code help request
- Microsoft.Office.Interop.Excel very slow and crash after writing a
- Using a Combo box
- a registry problem
- ComboBoxes
- Send Mail Commands
- Deleting shapes with VB deletes cell validation as well. EH?
- Controls slow down worksheet response times
- Cannot select multiple controls
- Textbox values
- Stopping duplications been entered into a listbox
- Worksheet_Change for Row Insert
- Worksheet Sort Order
- follow up to Gary's Student macro
- Clearing option buttons
- Workbooks.Add question
- Macro Crashing
- Link to cell from PowerPoint
- Sort selected range
- Looping Macro
- Deleting all code in new file only (creating using save as)
- Assign copied range to a variable
- How to set value of Textbox in loop
- Convert Date
- Macro to Auto-refresh a pivot table
- [Excel 2007] Maybe a bug with Dialogs(xlDialogSaveAs)
- Sort variable range in descending order
- User defined menu stops working when workbook saved with a newname???
- Set OptionBox value via VBA
- Command button to run a macro
- SQL in vba using excel sheet as my table
- re-setting view of sheets so A1 is top left
- Set all sheets to see A1 as left top cell
- Trying to copy data to a new sheet and row
- Msgbox Without ok button
- template path for active workbook?
- ?ÈZÈk ?ˆ¡??ˆra? ??ˆs?Çþ
- ?ÈZÈk ?ˆ¡??ˆra? ??ˆs?Çþ
- Jump from Excel to another application
- SaveAs
- Detect when Word document is updated
- Emailing Worksheet - adding muliple reciepients
- R1C1 notation in VBA code
- Excel 2007 Copy or AutoFill issue
- Where to post Qs about kernel32 DLL usage?
- Send UserForm Data to .DOT Template
- UIRibbon/VBA/XML question
- Add to CommandBars in C# without addin
- Add to CommandBars in C# without addin
- Add to CommandBars in C# without addin
- Add Menus to Application.CommandBars["Cell"] C# without addin
- Dropdown list of hyperlinks
- Macro not repeating output from search function
- Linking Cells Macro
- reading a string in a png image file
- Lotus WK4 Excel not showing pic images
- i need macro help
- Formatting a date from an input box
- General vs Date format question
- Using the Application.Caller function
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.