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 there a "ChangeCell" event?
- Run code from within a UserForm
- Testing for Digital Certificate in VBA Project Programmatically
- List unique values from multiple sheets
- What’s wrong with this countif procedure ?
- PDF file size
- Can you auto populate a cell by clicking on it?
- for x to - next x question
- Combox Help!
- Using Text in a Formula or FormulaR1C1 property
- Running macro from another sheet - VSTO
- How do I create a macro to remove blank rows...
- Delete Specific Rows Using VBA
- Macros
- Importing Data from Access Query to Excel Sheet
- userform combobox rowsource from database
- need code to copy text from workbook and paste it in a new outlookmessage
- Accepting solver solutions automatically under VBA
- Go to top left cell of selected range
- Disabling "group edit" mode in Excel
- how to clear my content in cells but keep the conditional formatti
- programming etiquette
- RE: Button Text Gets Smaller When Button Clicked On
- Looping through a listbox
- Dynamically create drop down box when cell value changes
- Triple Number
- Data Validation doesnt work with Copy/Paste
- Close Match
- VBA and loading forms (Excel 2002)
- Create new pattern in Excel programmatically
- Can I create a new pattern in Excel programmatically?
- if formula
- Querytables.add with sql query text stored in separate text file
- Redim preserve does not work for me
- Sum the Variable Range
- Securing codes by corrupting the file (Leo Asked)
- remove space
- Custom Number Format
- Add new Patterns to AutoShapes in Excel
- Security
- Seks v polnolunie
- Seks v polnolunie
- how to clear my macro tabulate content?
- Copy/Paste Problem: Runtime error 1004
- Which references am I missing, to call Outlook from Excel VBA?
- Pivot date, that's all
- Can read all threads other than those I want
- Fill in of cells excel 2007
- Step thru a function procedure?
- Determine if Sub Exists
- loops
- Number pad onkey IDs
- udf for returning names of wrkshts in active workbook
- Finding the Max Number in a Table based on Other Criteria
- HELP: Error Occurs With Macro Making a Pivot Field Visible
- macro issue
- Automated google search
- Auto fill cells
- Using a Form to control variable fields.
- Time Tracking problem.
- faster method to delete rows
- Public Range Constant - how do I?
- IF HELP
- assigning macro
- Need help with merging a range of cells
- ELAPSED TIME BETWEEN TWO DATES
- DETERMINING NUMBER OF DAYS / MONTHS / YEARS BETWEEN TWO DATES
- Match or Lookup
- Test if an element of array is empty
- Embedded chart alignment
- Input format
- Using flowchart in simulation
- Shift+F9 results differ from Sheet.Calculate
- Reference for Trim$ ???
- Sort Macro
- tabulate output data from different combination of input.
- change image in picture object
- display pivot refresh date?
- A bug : Run-time error '1004'
- Clear value if cell changes
- Java screen
- F9 not working
- Re: Lookup dates
- Job Ideas?
- Finding a specific text
- macro adding
- Message Box - Yes/No
- Lookup dates
- a doubt
- conditional formatting
- Autofilter used programmaticaly causes error
- Auto emailing of files
- Exiting listboxes in a userform
- Making cells mandatory to fill in
- Match Files
- Date/Day VBA Calculation
- Excel 2007 Custom Right Click Menus for Connectors and Shapes - Re
- Macros 2
- Change Control Toolbox Button Caption
- how to catch these events?
- (Repost) new order of table
- Macros
- rows to columns
- Quotes and CSV files
- Importing Text File problem
- Include function arguments (like range finder) in Add-in
- string manipulation
- Teach me to Merge Data
- How to call GetPriorityClass,GetThreadPriority?
- DEC2HEX
- OrderThenFindEmptyCell
- Find and Delete
- Count every group of numbers whose sum is zero & put number next toeach number
- Using a variable in an If statement
- ADO to XLSX file from Excel 2003
- Pass a worksheet as a parameter to a function?
- Remove custom menu
- sum a range
- Text Box not showing inputted value
- How can I align pictures to the columns in code
- Macro to Copy Defined Name range as a Picture file
- Chart Source when copying sheets to new file.
- Clear Contents of Specific Cells in Last Row
- Open Document Format (ODF) and Office Open XML
- Formatting Macro using rowcount
- Macro/Trust Center Settings
- Cell reference in code
- Synchronize sheets by row?
- VBA - Programmatically Open SP Files
- Clear a range of data
- Password To Run Macro?
- FormulaArray in Excel 2007
- Copy range values in C#
- VBA Check Spelling doesn't highlight misspelled word
- Autoamate Concatenate Function
- gallery in 2007 UI Ribbon w/xml
- Variable menu with single "on-action" procedure
- Excel 2007 Custom Right Click Menus for Connectors and Shapes
- pivot table show items with a value
- assure that calculates ends before save to pdf starts
- Create list of duplicated numbers
- filter and delete
- Lookup closest to
- How to assign a macro to a pivot in Excel 2000
- Match file names listed in column with file names in folder
- customised userform
- Merging data
- how to get excel to combine numbers to a given total
- VB for Chart Axis
- How do I reference a Worksheet from a Form (Add-in for Excel 2003)
- No Index Violation when adding data in Acccess from Excel
- progunta
- Automating Excel from Word - How to Sort a Range of Cells
- Macro to Open excel file when file name is entered in cell
- Extract Data Code Modification Request
- Reporting Service
- Add Number to variable date
- how to access data from excel to/from another program using Vb
- VBA Quick Question
- Enter
- Named Range or through cells
- How to stop Macro warning on opening workbbok
- Excel 2007 Print Preview
- Why does this not stop when I push "yes' or "cancel in the message
- Problem opening folders with hyperlink (URGENT)
- Check Refresh Status of External Data Query
- Import URL picture into Excel cell
- Save Method Of Workbook Class Failed
- Strange cut and paste result between worksheets
- Find a sheet within a workbook (If/Then/Else)
- Form temporary variables
- MsgBox
- Format Text Boxes within A User Form
- Multi Select check boxes and drop downs
- Delete Specific Contents
- Problem Opening Folders (again)
- Excel Spreadsheet
- Upload Excel formats to database
- Offset Ranges
- display text when mouse passes over a line
- change line colors on multiple sheets.
- Run a Macro within a Macro
- Import data from multiple files
- For each worksheet in workbook problem
- Opening a folder with VB
- Cross Excel Updation
- copying blocks of data from one sheet to other sheets in same book
- Adjusting a Macro
- Compare and replace if equal
- Message Box Warning
- How to close Immed Window in odd situation?
- Jump to Yahoo Mail with Active Cell Contents, and then perform asearch in the Search Mail Box
- Import picture into Excel cell
- Vlookup error in VBA, 2042
- MS Excel MVP?
- open email template
- Index is not in range
- Matching !!
- define UserForm properties
- Sum Function
- Workbook Summary Sheet2
- Getting Excel to Logon to a Website
- Retain value of userform option button
- Workbook_open not executing
- How to set up a delay to Private Sub Worksheet_Change(ByVal TargetAs Range) event
- ActiveCell offset delete
- Userform Terminal Error
- Item rows into order sheet
- how to calculate set theory in excel functions
- Save a File with a Password Q
- Automatically clear web query message "unable to open http:"
- Sorting and Filter in Multiple Sheets using Hyperlinks
- Two File Dialogs
- Exception from HRESULT: 0x800A03EC - COM Exception Unhandled
- Why does timeGetDevCaps fail?
- Assigning a button to SAVE a sheet
- Random Copy Paste
- Data from cell viewed in message box
- Compare the number of elements in two different arrays
- Userform - what am I missing?
- Copying a row from a table
- Dynamically adding ActiveX controls via VBA kills global VBA heap?
- Excel 2007 vs. 2003 differencies for custom format [h]:mm:ss
- RibbonX ToggleButton Pressed State
- Advanced Excel to pdf Automation
- VBA pull an online .Dot Template?
- Identify months/periods applicable to Date range
- Lookup Table
- Detect Autofilter Change Event
- Assign macro
- keep objects from overlapping
- Macro to delete lines
- Extract Duplicates to create another list.
- Variable sorting
- Importing Data from Access to An Excel Sheet
- Find the Empty Cell Macro
- Warning Macro
- delete line based on combo box
- Change Code to Match Tab Name? Is this an okay idea?
- help me to look the following code
- Function Shift Pressed not working in Excel 2007
- Auto refresh data once a day?
- OO programming in VBA - VBA equivalent to the "eval" function
- pallet building??
- Run-time error '1004': Application defined or Object defined error
- Record line number in macro where error occurs
- how to select a shape obj on the sreen
- new order of table
- Hidden rows
- Lock Cells based on Data in another cell
- Swap 2 lines
- copy formula across while skipping columns
- Capture Filter 'AfterUpdate' event in Pivot Table
- How do you use a button to launch a macro?
- Using Column Name
- Excel Macro Using "Like" comparison
- Run-time error 438
- Workbook Summary Sheet
- Enable to hide Worksheet Menu Bar
- Copy List Columns
- Need simple macro to copy and paste values
- Create Word Docs From Excel Cell Data
- Use VBA to create new sheet with event handlers in sheet's code
- Hide and seek
- Protected Worksheet Permissions
- Create multiple dropdown list for multiple colums; select more tha
- array values not matching
- One to Many data
- Export store list to new workbook
- Worksheet program to convert parent/children data to string(s)
- functions in personal file
- Range Link and Chart Link Macros
- Run macro when user selects a different sheet
- Quick Method to Find Chart Sheets?
- macro problem
- Loop macro in selected range
- Refresh Query Table causing debug error with Background Refresh pr
- keep formatting
- VBA working with excel
- How to Pass a Form to a Function - 2007
- array - type mismatch
- Office Basic vs Pro
- UserForm remains visible after Unload - 2003
- Are rows hidden
- Followup to sheetname object questions
- Is there a way (encryption type) to really protect my worksheet???
- Filter Macro
- Copy, paste, transpose depending on variable
- Pivot Table
- rearranging a table
- File not found when opening
- Correct VBA for DO WHILE i.e. X=X AND NOT RS.EOF
- Compile error
- sum a range in VBA
- Re: lookup
- Excel 2007 Pivot tables
- Question for Joel
- Advanced Insert Cells Function?
- Saving with toolbar macro
- Size of file changes when saved
- Appending a file
- Excel 2007. Trust Access to VBA Project Checked, still not truste
- AppActivate for IE not working
- lookup
- Finding source data column of pivot field
- Select the next item
- Populate userform combobox with option button
- Lock userform for editing
- VLookup in two Excel 2003 workbooks
- Inconsistency in Macro Speed
- Aligning Pictures to a cell
- MACRO for cell protect after a date is reached
- Add and summarize function
- Excel 2007 hangs on programmed file close
- Excel 2007, Custom Right Click Menu Doesn't Work in Table, Help!
- PasteSpecial (format only) Selection is too large
- Runtime Error '9': Subscript Out Of Range
- Macro to Print Active Pages in the Worksheet
- Adding selected items from one list box to two different list boxe
- WeekNum Trouble
- Is this Possible
- Multiple Sheets / Pivot
- rename active sheet based on cell
- comparing two files
- Help!! Copying/pasting
- extract a portion of data from a cell and paste back into same cel
- Analyzing data in collections of classes?
- Assign function return value to an array
- PrintTitleRows 2
- advanced VLOOKUP command?
- Print Macro
- Inserting cells in MS Excel 2007
- Unable to make my custom toolbar 'float' in Excel 2007
- Trying to disable a custom commandbar button
- How can I find Pivot Table Sheet for Pivot Chart?
- Stop Excel From Formating Text Starting with A Zero
- Activate .. Select .. Initialize
- CPSCount
- Complicated Lookup Code
- Need Excel Macro to Find Specific Text and Characters
- Shortcut key for add-in macro (Excel 2007)
- Designer
- Copy used range from one worksheet to another (and lose the pivot)
- Cell Lockouts
- Finding automatic page breaks in new, blank worksheet
- Screwed Up my Right Click Context Menu, Please Help
- MsgBox "Choose one ", vbYesNoCancel, " Three Options. "
- Filling Blanks only with ABOVE nonBlanks
- Cell reference for year in formula
- Send unattended email from Outlook using Excel macro
- conditional formats using named references
- Fill with random numbers
- Deselect Row in ListBox
- How to change built-in shortcut for "Save As..."
- Command Bar
- PrintTitleRows
- UserForm Keyboard Control
- Trendline on only part of the data.
- copy one column of data after another
- date entry stumped
- Excel 2007, adding a macro in an add-in to the ribbon
- no page break in named range
- need a Timer in an Excel Form
- Filter by predefined list
- Excel 2000 compatibility
- Why R/T error 1004 - 7 rows from the end of this code
- Delete Rows
- Hidden sheets
- How to use auto fill in a macro
- Two good URL ...
- Returning Data From ADO
- Open File Macro
- colors in a listbox
- Clustered Column Chart Containing Stacked Data
- END IF in a macro
- refedit controls and R1C1 notation
- Error with code that paste on next available row
- Conditional formatting based on numerical values of adjacent cells
- Macro?
- Saving Workbook with Password using SaveChange
- MSCOMCT2.OCX error
- if header row leave a statement
- VB.NET: How to declare a parameter in a worksheet-function
- Prevent copy of filename
- Hiding rows
- Change default F12
- Variable range union
- VB Date Format
- Invalid characters in cells
- Passing Arrays to a Sub
- Cell formatting when converting from DataGridView to Excel
- code for overlaping time
- Working with tables in Excel 2007.
- Populating Validation Lists
- Format cells using C#
- Adding a column to a table
- autofill without a destination range
- print titles
- Make zeroes in Selection nothing ""
- macro to search & open file
- Copy user selected files to new folder.
- Getting Automation error
- Can you calculate the Median without each value in separate cells?
- SubTotals
- Type mismatch error
- Type Mismatch error
- string compare to array
- VBA code to open web page then enter number and postcode then subm
- Column Offset
- Barcode suffix & Prefix
- Macro to delete unwanted colomns
- macro creating new pivot table
- pull down menus in spread sheet
- modify existing macro
- Macro that worked stopped working
- Removing the Sub-Total Levels
- Add code to paste data to next available row
- Sorting a Workbook w/ Links
- Excel 2007,
- Placing a regular excel function in VBA code [HOW?]
- Issue passing data from sheet into userform
- Macro to Find File in Subfolders and Open it
- Question What determines if publlic variable content is destroyed
- Date/Time Question - After 5:30 PM?
- Help With MS Excel 2007
- Sorry My PA was on.
- Excel IF/ELS to all Macro
- VBA Editor Window(s) size challenge
- Reduce sheet size
- Pivot Table - change page field help
- Copy range if match
- Indent and fill color based on other columns data
- Avoid using macro's from other workbook(s)
- Automatic email to recipient
- Context-Sensitive Help
- Code Interpretation
- Getting elapsed time
- Application.Wait Not Working ???
- Combine several like rows
- Assigning AutoFiltered Range to Range Object
- VBA code in one Module referencing Public Variables Declared inanother Module failing
- ListFillRange
- Protecting a VBA project
- How to enter in Edit Mode programmatically
- VBA Convertors
- Delete Blank Cells in a Row
- Deleting a row
- Error Handling function
- Copy Non-Consecutive Rows and Paste in a Seperate Worksheet
- Selecting columns
- Grouping data in excel 2007
- print 4 pages on 1 page using vba
- View Columns with filter enabled
- How do i get a MonthView or DatePicker object in my VBA toolbox?
- Event Handlers & Validation Lists
- Print Button Macro with Multiple Conditions
- Filter a List
- How can I create a list of links (A to B) & search for both A & B
- Possible to automate copying active cell in Excel, and pastingcontents into Search box of webpage
- CopyPasteCode
- Macro Takes Long Time To Run
- retaining variable values across modules
- Worksheet Jump
- Recordset - Urgent help need
- Print using ExecuteExcel4Macro
- Taking value from one array and assigning to another array
- Printing
- Setting up a Login
- Lines user forms
- Reading Excel 2007 Rows in C# / .Net
- delete unwanted colomns, empty colomns
- Printing
- "LARGE"
- Loop not working properly
- Exporting data from MS-Access to Excel
- select pivot table range
- pivot table?
- How do I hide a cell's formula?
- Yield VBA function missing in Excel 2007
- Running macros automaticaly
- How do I unhide all sheets on the left of Excel
- Cancel if the first one is found
- Conditional Formatting - 6 conditions
- How can I format a cell to automatically assign a new number?
- TTF File
- Arrays and Macros
- This must need some VB programming.
- How to put lines with certain text (from a file) in an array
- display a timer while an ODBDC connection opens.
- Leaving a blank row
- names of variables in array
- Determine if filter set on specific column
- Runtime Error 32809
- Recording Macros
- Find duplicated values and paste range results on next sheet - nextavailable row
- RESIZE range to exclude totals row
- Change Button Color
- Formula needed for date range report - Excel 2003
- getting data from two excel file
- copy application path to clipboard
- Problem programming a formula
- MS Query + last 5 instances
- Value not matching
- Formula error; was working
- Use one Macro on multiple workbooks
- Automate Data-entry in IE application
- ADO Recordset
- Compare and Merge
- Macro creation help
- Listbox Value = Null ??
- Retrieving Data from another sheet
- Help whith Data parser
- Macro pack
- Set value of cell to calculation
- Joining SQL Server Stored Procedure to SQL Server Table
- Alphabetize Columns
- Toggle between original background colour and none
- decimals: in Europe they use a comma
- Create and print simple maths problem sheets for kids.
- Pivot Table problems Excel 2002
- Time, Distance, Speed
- Problems with date format when reading external excel sheet
- add cells value base on word's color
- getting value in one cell by typing such as like 'M' or 'F'
- GetOpenFilaName
- Data define and search function request?
- Combo box source from other workbook
- Print referenced file
- ERROR HANDLING question
- Need Help writing Print Macro
- Attach files in an excel spreadsheet column
- ERROR HANDLING
- VSTO Excel Rows to SQL Server 2005
- Problem - Lookup returning value of last cell in range when no matchoccurs
- prevent creating a copy of file
- Need User Name
- Need macro to move cell contents from one sheet to another
- creating new function in Excel for Medians
- Substitute Programme
- passing a value back to original routine
- Re: Find date of 3rd Wed of month
- Copy a procedure from one project to another
- Basic user form question - hjow to write to a text field
- What proportion of users on each version of Excel
- Download #1: World's Major Stock Exchanges Tracker
- Find date of 3rd Wed of month
- Formula
- Excel waiting for OLE action - driving me crazy. Help appreciated
- Consolidating via vba not updating properly
- Highlight (ie Select characters in a textbox)
- Re: Problem with macro
- Opening subfolders in sequence
- Normsinv funciton
- Handling an array
- Sharing modules on Server?
- Adding hints to my vb functions
- [Beginner's] Increasing numbers in a table
- [Beginner's] Adding a letter to a cell by clicking the cell
- need formula for average of rolling 4 rows in excel document
- how to find value on the cross of row and column
- playing wma files
- Macro wont run on cell change
- prob in IF then else statement
- Personal.xls - File error: data may have been lost
- Problem with setting object using session ID (emailing ffrom VBA)
- FORMATING NUMBER FORMATS TO EXACT NUMBERS.
- Publishing XCL Range to HTML to insert into Email Body
- Inter Macro
- Reference Excel UDF from Outlook
- Runtime error on a PC: Selection.Borders(xlEdgeLeft).TintAndShade =-0.14996795556505
- xls name reference
- Visual Basic Excel How do I determine if cell is numeric or text
- Queing Math Problem using VBA and Dictionary Object
- How do I delete spaces that follows data
- Disable "Cut" and "Drag & Drop" but not copy
- Freeze end of mont results
- Input/combo box
- Worksheet Change event on different ranges with data validation
- calculating nonblank cells with conditions
- SQL Server Stored Procedure
- Launch a program from Excel
- Embedded blank rows
- How do I filter 50,000 rows with out frozen the screen.
- Format
- Copying Charts - Memory Leak - Excel 2003
- NEW Worksheets - Limitation on Creating and Deleting (-fes)
- COMPILE LOG FROM INFO WITHIN MULTIPLE TEXT FILES
- MAKE A EXCEL LOG SHEET FROM TEXT FILES (10000+ FILEs)
- Worksheet_Change after validation
- Using a different Comment Indicator symbol
- in-cell on-the-fly list/combo box
- Unknown sheet in Project Explorer
- How to upload data from a spreadsheet to a Enterprise Managerdatabase
- Set Find to look in Values instead of Formulas by default?
- get rid of slashes
- The Dear x at the top is formatted as times new roman font...why?!
- Workbook_Open - AutoCorrect Routine Doesn't Work
- Comparing columns for no match
- Automatically updating MS Query Tool results in excel
- Making Find ignore parts of a sheet?
- Exporting Data from MS-Access to Excel
- sort dates
- hiding a row
- Error Handling then continue running
- How we resize image in harddisk ?
- delete row
- xls to exe
- Do not Run Macro
- different text colours in listbox
- How to get e new line in html email (Ron De Bruin's code)
- Compare Kotak Credit Cards
- match
- Allow paste special only to one worksheet and not to all
- finding matching cells (Excel 2007)
- Can't create sheet when importing Excel
- Problem with .send from microsoft example for vba send mail from excel code
- Run-time error '1004': Method 'Range' of object '_Worksheet'failed... again!
- Macro loop with messagebox
- Create Appointment in Outlook
- Run-time error '1004': Method 'Range' of object '_Worksheet' failed
- Excel VBA Array Function...What's wrong?
- don't allow row to be copied twice
- Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard
- Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard
- Advance filtering Update
- Input box copying the wrong rows
- Dynamic sum
- App.Datevalue function not in VBA
- Excel application for backup and sync of files between folders and computers
- How to add username in excel
- excel.interop insert a column in between existing columns
- loop issue
- filldown with formula
- Macro Keyboard Shortcuts
- How to store the reference of Workbooks in an array.
- How to find max cell location
- dynamic pivot table selection
- Macro in one workbook that names a range in a different workbook
- Excel VB to open Access DB
- Hard code Listbox Header Text
- How do you get a parent collection object to listen to all if it's child objects?
- XML Maps and List of Complex Data Structures
- How do I find the first unfrozen row in Excel using VBA?
- Calling Embedded Object macros from Excel VBA
- Keyboard alternative to 'break'
- Macro for pasting on active column
- Merge data with Multiple-to-1 relationship
- filter macro
- Error -2147418113 (8000ffff)
- RE: Invalid or unqualified reference error
- RE: Invalid or unqualified reference error
- Invalid or unqualified reference error
- Invalid or unqualified reference error
- Invalid or unqualified reference error
- Invalid or unqualified reference error
- changing the default background color of selected cells...
- Change Pivot Table PageArea Selection
- Copying exact formula from one worksheet to another within a macro
- copy external data
- InputBox doesn't allow non adjacent rows
- Disable Userform Events
- I want to change Excel, not just the current Workbook
- Forgot where I put the Select all VB code, help.
- Splitting records
- Conditionally Hiding Comment markers.
- ChartAdd event for embedded charts
- Storing data in an add-in for use later
- in range
- TextBox gets contents from dynamic user pick?
- How to set Optionbox value from code?
- programmatically edit workbook internal data conn. file location
- copy from external sheet
- Show "Summary" when macro has run
- Conditional Protection
- Fill 5 Column Listbox from Range
- Userform loading, but Content (Inside border) is BLANK?
- Running a formula & For...Each
- Delete enter key rectangles in a cell.
- Remove add in from inactive list excel 2007
- R4 ds/dsi firmware-drivers de R4 Sdhc. R4 ultra, R4 new, R4 III upgrade, R4 v3
- error when running an excel 2004 macro in excel 2000
- Mac Excel 2008 Problem Using Excel 4.0 XLM Dialog Box Option Buttons
- Command button position and screen resolution
- WinSQL Query - Syntax for use in Excel
- Bold font in shapes
- Referencing cells in another worksheet
- autofilter on a protected sheet
- Word wrap and cell size
- Interactive Code2
- Switching workbooks with Personal.xls
- How to code macro to shut down my computer?
- Positioning a Comment
- date stamp
- End of Column
- Excel waiting for OLE action - how to resolve
- Macro Dialog Box
- Opening files with variable names
- List all files in a sub directory
- Help With MS Query Sum Distinct
- Macro Security
- MZ tools Msgbox uses "Call"?
- Transpose macro
- select rows & copy into a different sheet
- Assistance with code
- Enter VBA multiple sheets
- Trying to make loop to create series of charts in Excel 2003
- What formula should I use?
- countif for multiple criteria?
- Calendar Function in Excel
- Unable to Record Macro in 2007
- Speech.speak Can I change the voice in code?
- Run the macro once the cell value changes.
- ISNUMBER Logical test
- Help with Excel UserForm
- Writing Changes in XL Worksheet to AccessDB
- Re: Excel 2007 - ADO - More than 65536 rows - Problem ?
- Objects, Cell Referencing and Sorting
- MSG BROUPED BY GROUP
- Accessing Excel Documents on a SharePoint Site
- Print Dynamic Report: Macro
- close form
- Running a SQL query off an excel table of data
- Excel 2007-Pivot Chart Expensding data source
- chartobjects.activate fails
- Paste Once No Format Change Help
- Filling in a chart from a list
- Run-Time Error 1004
- Require answer dependant upon earlier cell information
- Macro to print series of dates
- Resize CurrentRegion by 2 rows at the bottom
- Excel 2007 - ADO - More than 65536 rows - Problem ?
- e-mail notification via Outlook
- how to get the value object back from 'customproperties'?
- Reset Followed Hyperlinks
- Print Preview
- Transferring XLOPER from VC++6 to VC 2008
- Macro for displaying formula
- how to send key "press" a key in a dialog?
- chart - in order of high to low
- How to remove last character of each value of an array
- Formula issues
- Workbook backup macro
- Help with random numbers in gaming system
- Auto file naming with macro
- Copy row grouping from one worksheet to another
- SPC XL and VBA
- Another VB Code Question
- Using SQL command to access Excel
- Data storage in arrays
- Macros in Excel 2003
- VB Code Question
- Allow Macro to Work by Selecting Cell Description
- Tell whether or not Sub B was called by Sub A?
- Cut off end of a string
- Is it possible - find all of a named range?
- Unable to set the LeftFooter property of the PageSetup Class
- Switching between open windows
- Last Column
- Link PivotChart to PivotTable, whilst hiding fields
- Assign Range passed to fuction to an array
- Array assignment
- Macro to delete duplicate cell
- RE: URGENT! Range.find not working...
- need help fixing macro
- Get Part of String
- Conditionally format header when column is filtered
- What is the VBA for the Excel 2007 "Switch Window" command button?
- Wildcard Usage in Combo Box Programming
- Simplify code copy based on condition
- xmlHTTP.Send Questions
- Excel waiting for OLE action - how to resolve
- how to call a vb.net dll from VBA
- WorksheetFunction.Index producing error
- combo box control source
- Problem with Worksheet Activate and Sorting
- How can I read an Excel database in C#
- Fill Listbox Columns With Other Userform Control Values
- Delete Entire Row
- Updating
- Making the source of a Hyperlink the Active Window
- VBA to pull information
- CuteFTP
- VBA Excel 2007 SQL query
- slow macro help
- Sending a variable to another workbook?
- Excell VBA Macro with Symbols
- Macro to insert a cell after the selected cell
- Range on Userform only if on worksheet
- Userform design
- record cell activity
- VBA Excel: Trigger a refresh upon data change in sql connection
- Progress bar & explanation of code
- Run Time Error 1004
- Deleting macros by running a macro?
- Emailing a Hyperlink of an Excel Workbook.
- Macro to copy cell contents to comment
- add-in timing problem?
- Excel Versions
- Linking cells between worksheets in same workbook
- Slidebar (scrollbar) insertion through VBA
- Difficulty with Arrays in Excel's DECLARE statement
- How to print LinEst result to a spreadsheet using VBA
- "Out of Memory" error
- How can i include a .vbs file in another .vbs file
- Adjusting the size of a picture
- SelectionChange problem
- Wait with TimeValue using the seconds from a worksheet cell
- How to disable a workbook?
- Excel
- Hoe to disable a workbook?
- edit range name
- compare two Excel files for differences
- How to add Chart_Activate code using VBA
- Japanese in Macros
- Shortcut to compile VBA Project
- Return to UserForm
- RE: Exporting to another excel file
- Format Row Conditionally
- Variable number of copies to print
- Unable to read cell value when cell contains a string using CSharp
- If ODBC DSN connection fails
- Add-in to improve goto->Specials
- Difference between xlSheetHidden and xlSheetVeryHidden
- detect userform
- Sum row totals for multiple items in a worksheet
- How do I use VB to adjust text box internal margins?
- Where I can find a list of all office com Interop errorcode?
- Print Setup Not Set
- Grab the right please
- Exporting Code
- Excel Import
- This seems like it should be so simple! (PivotTable "Show values a
- Freefloating ActiveX comboboxes
- code for box
- Tom Hutchins macro- Filter
- problem with macros using Excel 2007
- How to launch a live map application using selected Excel data
- Accessing SQL Server in Excel Macro
- Setting cell colors using variables
- Prompt user for file to be opened
- Changing a menu button in my XL template
- Find Replace Visual Basic
- Excel Macro user function used in several sheets in same workbook
- Access doesn't always close (Excel VBA) & passing parameters
- Splitting cells
- Interactive Online Statistics Courses start Friday
- excel button to save sheet contents to new workbook
- Column Split and Extraction
- Email Multiple Files to Multiple Email addresses
- Launch an .exe like notepad.exe with a macro?
- Delete Rows for given conditions.
- VBA .activate
- Code lost when email to another site
- sum value of four textboxes into another text box
- Conflict with Valid Range Reference Error in Microsoft Excel 2007
- How to display alert message in Excel 2007
- Vista HP + Excel 2003 code = Lost VB Project
- Print rows with special value only
- Insert excel sheet in a powerpoint presentation
- Sorting with worksheet activate
- User Defined Functions in Automation Addin behave differently in 2
- Lookup, match dates and confirm fase
- 0x800A03EC error during Application.WorkbookOpen event handler
- Copy rows that matches cell value
- How to store a reference of a excel workbook in a variable in vbsc
- Condition formatting
- Need a hand with date calc
- protecting multiple shts with separate pwrds
- Set Rng = Range("S2:S293")
- sharing a file b/w different users
- new to date
- When Class object get created
- Range into ListBox excluding blanks
- Positioning the selected row in a listbox
- Hyperlink in Commandbutton
- Formatting values populated by VB Code
- Screen tip indicators missing - Row Height, Column Width
- Csv date format problem
- SumIf ( range, criteria, sum_range )
- Com Interop Errorcode
- How to copy only one value from range to worksheet
- Need assistance with code, please
- wrksheet selection change
- Remove row in list based on user input
- Re : Excel to by-pass Private Sub Worksheet_Calculate()
- Telephone and Floor Plan help please
- Disable Button When Worksheet is Locked
- Cells.Clear
- Broke my Beep
- How to copy Range and Paste as Values (from hidden sheet)
- How to copy range and paste as values
- Custom CommandBars
- GoTo won't work - why?
- RE : filtering problem
- Looking for a more elegant way to program code
- What are VBA consequences of moving workbook?
- Value compare problem, As Single variables Feb09
- Creating an array of strings
- Textbox linewrap with vbCrLf problem
- Abbreviate Workbook/Sheet/range
- moving to new cell and scrolling
- Macro Copy cells and Insert/shift down
- Tab functionality in VBA form in Excel 2004 for Mac / Macintosh
- GetSetting and SaveSetting
- Cell referencing in Macros
- Excel 2k7 VSTO Addin
- Deploying Excel 2007 VSTO Addin
- Click on a hyperlink to hide or show a spreadsheet
- Data define and search function request?
- Pentium serial number
- How can I save variable when 'end'? The user then reactivates the
- .ReferenceStyle=xlA1 Converting Relative to Absolute References?
- Internet Exlporer and Vista
- Time format
- identify first macro run
- Context Menu Customising
- DeleteModuleContent doesn´t work in some computers...
- Testing parsing of code tags to newsgroups
- Copying Cell Conflict with Worksheet Change to UpperCase
- Auditing Excel sheet - Message Box on exiting excel
- VBA code causes Find and Replace dialog box to lose focus
- Horizontal Scrolling
- Interactive Code
- Auto pull data from a website
- Realign Comments
- =hyperlink causes file opening to change window size
- Pivot Table VB code?
- Need a click, beep, or a burp
- Need a click, beep, or a burp
- file converters
- Conditional Formatting Macro within a Chart
- moving charts
- Greater than Less than question!
- Reselect a TextBox
- Can I Sort (A-Z or Z-A) Pivot Table Data or Fields using VBA?
- Excel 2007Chart updating problem
- dispay dates return in cell
- Text wrapping
- Logic statements/Pulling data
- Deploying an Excel 2007 VSTO Addin
- How do I add Microsoft DAO to the referenced lib in Excel 2003
- Verify Canadian Postal Code ~ make the code work
- Check if file is open, if yes close woorkbook
- How can I change the Macro Security level in Excel 2003 viewer?
- array error
- show sheet1 on startup
- Temporary Files While Importing Data In Excel
- Supress message window
- copy/paste without highlighted cells
- Clear value in cell when the "enter" key is pressed
- DSUM I think
- combobox in user form
- Macro to paste value to a file same as A1
- Excel value onto word userform
- Unzip message box supression
- autofilter macro
- Original read only file not closing
- User Form Flickering
- Select Named Range in Worksheet
- Bubble Charts - Series and Bubbles Missing (sometimes)
- Macro Help
- disabling automatic startup of macro in vba
- missing library makes Format() disappear
- Row Deletion
- how to reference selected cells in SourceData
- Web Import
- Controls
- Command buttons DEAD
- Function to calculate dates
- Pivot tables - edit pivot table and updating master data
- Refresh CRM data in Excel 2007 using VBA
- Looping Through Worksheets Given in a List?
- Load Behaviour of Addins
- Button Event Handler in Excel cell
- Strange exception when automating excel
- how to remove the outlook confirm window when use excel to send email from outlook?
- listing excel file in a folder
- Printing a Page Automatically When All Cells are Filled
- Save As Help
- Userform help please
- Macro to take cell ref of the object
- Export Large Data
- Update Data in 3 other Workbooks via Macro
- Access to spreadsheets with VBA User Form up
- Toolbar to launch Macros
- dtpicker to display current date when form opens
- Ato move row and checkboxes visible by user
- how to lock/unlock certain cells
- Beginner VBA user asking advanced questions
- Recycle Bin path
- Save as
- RE: How do I set up a macro to help me to do bank reconciliations?
- RE: visible method of worksheet class failed error
- Count merged cells as if unmerged
- variable number of rows.
- RE: SQL statement not working
- copy row if contain keyword
- Best way to solve my issue
- RE: Respond to Excel message box from macro
- Respond to Excel message box from macro
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.