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 |
- Trap Mouse Move event for Images inside the shape or Image control
- if fuction in data validation
- Two dinamic graphs in a worksheet
- How can I covert Indian Rupees to Word in excel 2007
- Sub to open n close .xls files in folders
- Renaming worksheets taking REALLY long... any ideas?
- Dialog box for Inserting Rows
- Capture an event for hyperlink is Excel
- Shapes Fill
- Change SourceData with ScrollBar for SheetChart Type xlColumnClust
- copy method of range object
- Creating a ratings spreadsheet?
- Macro to insert row in protected sheet
- Very Unusual Sort Rows Needed
- MACRO - INSERT ROW
- recalculating RAND() inside a VBA loop
- Macro fails on 1 out of 4 computers
- How can I seperate Imported text with delimeter as part of the par
- determine current theme in xl2007
- Bolding a Cell under certain conditions
- Premium Solver Macro Problem
- Numbers in combo box
- filling a table depending on column heading
- Fill/Copy Up to fill blank cells.
- Is Sumproduct best for me?
- index and names of open workbooks
- Null value in excel
- Cell Reference
- More efficient code than this?
- How can I get Memory used by Current Excel Application?
- Automatically increment cell reference
- Get smaller range from within another range using VBA
- Excel 2007 Named Range - Naming convention
- Changing rows
- New to VBA
- Working with Excel via Visual Studio 2008
- disable macros in a worksheet
- Problems with ChangeLink Command in Excel 2003
- Excel 2007 - Workbook.Open Question
- Working with Excel via Visual Studio 2008
- Tick Quandry
- Fine Tuning
- Copy from Internet Explorer & Paste in Excel
- runtime error 13
- Export to Excel with different sheet names
- problems with calendar control
- need mulitple lines in a cell
- Are links relative?
- add 1 to the value in a cell
- enter check mark with one click
- Up and then down VB code
- Object Library References Question
- Excel 2007 Add-ins
- Columnwidth in cm?
- I need help creating a macro
- Program to insert pictures
- Need to you quotations ("") in a string.
- Method 'Range' fails while using AllowEditRanges
- FileSearch on a remote server
- Tiny Charts
- Event Change code
- userform question on UserForm_Click()
- Problem copying formulas using VB
- Hi, i need help whit macros
- Lotus Notes VB code (yes, it works)
- Batch Delete VB code
- loop though numbers
- Problem when copying a range from closed workbooks (ADO)
- Calling a function within a macro
- Userform is blank
- Macro output as Text
- Inserting Comments with VBA
- error 13 when setting worksheet listbox
- Keyboard shortcut values displayed on custom ribbon
- data validation (multiple options)
- macro needed for saving
- excel macro to copy the word document to new excel workbook
- How to run Excel Macro on all files in folder
- goto next if
- .Refresh BackgroundQuery:=False
- List Box Select All Values
- delete unused rows
- Modifying a LARGE text file
- Standard numbering
- Excel as a data source for Outlook to email Word docs
- Chopard Mille Miglia Chronograph Mens Watch 16/8271-95
- Cartier Santos Galbee XL Steel Mens Watch W20098D6
- Why is my UserForm event procedure disapeared?
- Knowing what Folder I'm in when I open from a shortcut
- Required Columner Data
- Date Diff Help
- EOF Parse Text file
- finding the next empty column
- average of column
- Count number of like occurences across all worksheet within workbo
- VBA Newbie
- Workbook closing
- Header horizontal margin seems fixed, won't move
- Make sure all items in a Collection equal the same thing
- images for user form
- How can I locate image code in a worksheet object
- UDF or SUMPRODUCT with 51 named ranges?
- Determine if particular procedure(s) exist in module
- CustomProperties
- Using VB to change a defined formula within a pivottable
- Parsing, mid, left, trim or right to find specific word in string
- Exposed Workseet names
- Move downloaded bank transaction to a specific worksheet in same workbook
- Custom View Macro for Excel 2007
- Variable equal to values in a list
- Variable Address in Pivot Table VBA code
- Disabling Function Results in the Function Arguments Window
- Copying an entire sheet from 2007 to 2003
- UNABLE TO IMPORT A TEXT FILE HAVING 30 COLUMNS. LOADS ONLY TILL 26column.
- Application on my desktop
- Excel VB ListBox 'Height' Problem
- relative path
- Excel import data from old accounting systems
- Named Identity
- Using Form Buttons / Objects
- Link source - Need change?
- Record Comparison Between Two Databases
- Output file to My Documents
- Prevent SaveAs on Protected Sheet
- Macro is choosing by tab name?
- Macro (Modle) naming insight
- Problem with "Call was rejected by callee."
- Run-time error '1004', the macro xxx cannot be found.
- looping down 1 column then start agian at the top of the next column?
- Checking for duplicates
- ISERROR
- Changing the "From" field in Outlook using Excel macro
- Convert Range to Array
- Prorgram doesn't work on different computer
- End loop
- Hiding rows
- Window Caption
- Cancel Toolbar load
- Delete rows based on more than one condition.
- FileSearch in Office 2007 generates an error?
- Deleting a Worksheet??
- Quotation marks in a string
- How to copy data from merged cells to their individual cells?
- doesn't read all data from cells into xml file
- VBA Vlookup
- PivotField CurrentPage Change Event
- freeze or lock rows when using Auto filters
- Userform - placing
- Using IF to decide action
- Autoname a range
- Color sorting
- Autofilter-sorting from specified cell
- How do I create an organization chart in excel
- Common set of macros
- How to use SUMPRODUCT or SUMIF with 2 criteria?
- Re: How to open correct Module window in VBE by macro
- Macro to copy active worksheet from multiple Excel files into 1 fi
- Relative Path in Excel to a word document
- Pulling data from mySQL DB to Excel spreadsheet
- User form bug
- Search Form
- Launching PowerPoint from an Excel application
- Write filepath to file
- Problem with Naming Cells
- Find variable in a sheet
- Command Bar Excel 2007
- EDATE & #NA Errors
- Music files
- Tags for worksheets
- finding numbers
- use only part of window name in a macro
- mousepointer
- Can you use offset and empty in the same code
- Can you hide and unhide rows with a macro based on content of colu
- little mistery..
- Simplify Code help
- Importing to Excel 2003 - Code from Jean-Yves
- Add two cells if one cell is greater than 0
- Surpressing a Message
- Multiple ADO queries at the same time
- idiosyncracies of user form
- Changing printer defaults in Excel Worksheets
- Need code assistance to update pivot table from an ADO recordset
- Regional Language
- Web Queries : Passing variables via POST method not working
- Converting xlsx to xl
- How to obscure functionality
- Help!!! Database lookup from excel
- VBAProjects still open for workbooks closed in Excel 2007
- Using Variables in ActiveCell.Formula
- help required to change format when converted from excel to xml.
- Mail with "Lotus Notes"?
- Auto Filter
- excel macro to copy the outlook mail body to a new excel workbook
- Macro to delete on condition
- Excel 2007 - Textbox Formatting
- Offsetting to identify value in header row
- Assigning value to text
- User defined range for vlookup w/ loop
- Inserting a blank line
- Fill series event detection
- and + or
- XML export form a Excel
- Open Workbook Empty?
- code instead of functions
- For Next If help
- howto: disable date recognition?
- Image Control Question
- Force Save Folder Location on Network
- File closes without prompt to save!!!
- using an excel database function in Visual Basic
- Open a workbook from a written path
- Selection
- Select locked/unlocked cells
- 32000 chart limit warning
- Wildcard use in comparason.. Please help
- delay in msdos batch file
- Using 2 cells in the same row within a form
- multi threading
- Writing Data to cells
- Re Excel 2007 Trend Equations
- why do I have to have the table files.xls open in memory to query
- putting criteria directly into a database query, dsum, daverage, e
- Excel 2007 Shell Command Runtime Error HELP
- a way to make this more compact ??
- standby for parts of code
- Creating an AutoNumber ID as a primary key
- Data validation list limit
- Search and Replace Problem
- Can't Unhide Complete Workbook after adding code to hide it
- take fields from form to report
- How do I pass a value from an event back to my VBA Programming enviornment.
- relative reference between two tabs
- Setting Up a Dynamic Print Range
- Trying to Mimic an Array Function in VBA
- Print selection using check boxes
- Macro to create different groups
- End without Next Error
- use different string variables in FOR loop
- Position a user form next to selected cell
- Find and Replace Help
- Inserting a value based on another value
- Find and Replace Question
- relatetive reference-to perform a series of cal and return result
- keep last row added visible on the screen
- find a value in another sheet
- Get value from one row to another
- Accelerator keys
- How Can Make equation With IF X>Y>z
- Changing BackColor of ToggleButton produces a muddy grey color
- File path extracted to the cell in lowercase and sometimes it does
- Convert numbers to HEX
- find by font size
- Fails then continues without error
- Redraw problem
- Hide rows of active selection
- Macros using drop downs
- Plotting a number of single point series on a scatter graph
- output unique records to a dynamic range
- Format Textbox on an user input form
- Max patient census by day by hr
- Adding selected numbers
- Select Case
- Looking for Input
- Macro
- using vlookup in a loop
- Filtering A CSV file during the import
- can you specify a worksheet during file open in excel?
- WorkSheet Change Event - Need Help With Coding Syntax
- simulate pressing CTRL and A
- PasteSpecial between workbooks
- Listbox with available procedures
- Need to Add Text to Control Text Box via Command Button code
- Permission denied code 70 on killfile
- copy to clipboard
- RefEdit
- Set print area based on last row with a given value
- Find text Sequentially Number
- When do AddIns load?
- Sum and Rank
- Excel macro Cc distribution list control
- How do I create a .bat file to create a shortcut on the desktop?
- Input on a user form
- Macro takes a while to run - should I be concerned?
- Final Days 2008 East Coast U S Excel User Conference
- Run a Stored Procedure from Excel
- Are there any other way to run the vba code than...
- Reading Data from an Excel Sheet
- Protecting an Excel worksheet from being renamed
- Long Shot !!
- Get a Date to show as a Date Format in Combo Box
- Macro to create charts - Points to wrong sheet
- VBA unable to recognize code after reinstallation of MS Office
- Pictures.Insert not working in Excel 2007
- Clear selection in CSV-file
- Software copy Protection
- Calling a public function from a worksheet
- Setting an array of text boxes equal to individual form text boxes
- [Microsoft][ODBC Driver Manager] error
- Can I use the address function as an argument in another function?
- Complex Count
- Cell justifcation
- Cell to display certain if an entry is provided
- "Move Several Cols Down One Row"
- Macro to execute at a set time, pull data off of a web page, and e
- Need help with formula to count currency of personnel between 2 da
- at excel start need macro to remove autofilter & apply sort mult t
- Merge Worksheets w/Comments & Hyperlinks
- multi-line controltiptext
- first user form.....
- Custom Icon
- Over-ride protection for one user - doable???
- How to make a custom function to work in another workbook
- ControlTipText
- Excel 2003 Pivot and VBA loop through each record to change cellbackground color based on conditions
- Newbie Needs Help.
- User Form - use of single form for multiple sheets
- Strange problem when running macro from PPT'07 copying ranges from
- Autofilter, protected worksheets, Debra Dalgleish's code
- Calculations
- Conditional format based on adjacent cell value
- Retrieving Part of a Cell Contents
- auto copying Excel spreadsheets
- Compare List A to List B, Return List B Items Not in List A
- Array vs. Collection
- Find Worksheet code names from PowerPoint 2007
- Trying to concatenate based on font color
- Linking Cell Data to Text Boxes on a Form
- Control scrolling in a TextBox
- Single hotkey to do a date time stamp into a cell... and then type
- create spreadsheet where all changes can be stored
- Cannot pass argument from control to sub and back
- Compare columns - weird baffling problem
- Print Worksheet by Page Number
- xlApp.Quit - Doesn't Close Instance.... Any ideas?
- Multiscaling the same graph
- Looping through multiple sheets and pasting data in first blank ro
- Excel 2007 - Legend.Position
- Pick data from web page (no query)
- macro to open the mail and copy the data to excel
- find text within string and then delete
- Link to a sharepoint list
- Saving a workbook using VBA
- Inserting getpivotdata formula using vba macro
- Trapping invalid dates
- Macro for Tab Changes
- stuck in loop
- Conditional Formatting Issue
- Hide Rows
- Time stamp with undo funktion
- ComboBox Queries
- Advice Sought
- Code to add attachment
- Select range
- Help with Debug issue
- Count number of times macro was executed
- test dbl click 'target' is part of named range
- some simple (?) simulation
- validation
- How to creat custom made error message in separate window
- lock a cell from users but not macros
- Worksheet change time format
- VBA code to select a cell so it appears in the top left of the screen
- Macro "out of Memory"
- Create Multiple Filter and graph data
- Unprotect Cells When Radio Button Selected
- Filesearch .LookIn fixated on MyDocuments
- Delete Workbooks
- Excel 2007 File Slow Response
- Call a procedure using a variable
- strange formula array issue
- I would like to block access to my VBA coding
- Excel chart data in Power Point
- Clearing contents from a range
- worksheet template
- drawing text on a worksheet
- VSTO 2003 deployment problem
- Compare two spreadsheets
- Macro Help Please
- Index # of selected embedded chart
- Macro doesn't work when Sheets are protected UserInterfaceOnly
- Setting cell colors using RGB( ) function
- using best approach for activecell property
- Application.Quit Does not Close the Application
- Changing The "Printing Sheets Per Page" In VBA?
- How to return query with out headers
- RE: Code to open multiple files from within a folder
- use information from an input box in cell reference formula
- Scroll bars and how to print
- Again, for Excel 2007, Clipboard image saving issues
- Using a Range variable to call a procedure with a ByVal statement...
- Macro to find and copy to another sheet
- using OFFSET to fine DUPLICATES in a list
- call Excel subroutine from Sql Server?
- Hyperlinks and Comments
- Set Priority for Conditional Formatting in Excel 2003
- Excel 2007 pivot tables - calculated fields and SSAS cube
- Programmatically copying range in design mode
- Scrolling
- Need to change the following code
- Re: copy data to one file from all files
- Error using Union in a Loop
- Worksheet_Change event not running from Form control.
- using loop in ontime
- PlotArea.Left Question
- command button not working
- Excel References Not Release When IDTExtensibility2 Used
- Macros assigned to Menu Items
- Please add a "Paste Value" Command to this macro.
- RE: Browse for folder - not selecting folder
- User-defined functions not calculating/recalculating
- User-defined functions not calculating/recalculating
- User-defined functions not calculating/recalculating
- Updating "active window" in Embedded Excel OLEObject in PowerPoint
- AutoFilter
- Use number in text box to look up value in a workbook sheet
- Re: Browse for folder - not selecting folder
- RE: Import data from web page into excel
- Re: Browse for folder - not selecting folder
- RE: copy data to one file from all files
- Re: goto next line
- Re: macro to save the file as per the path selected
- Re: Code to open multiple files from within a folder
- A problem with HPageBreaks
- VBA to create directories based on 'date picture taken'
- Listboxes Without User Form
- Array as defined list in sheet 'Temp'..
- List all applications running
- Excel Programming
- Clipboard images to Bitmap files through VBA in Excel
- click image in web
- Creating a que
- Accessing The Value Of A Merged Cell
- newbie
- Excel 2007 macro problem in editing a cell
- Dynamic Array Problem
- creating multiple pivots fails
- Drop down list
- Script out of range
- validate entry via messagebox
- Copy as Picture takes up to 5 seconds to copy
- Automatic Update links to web query
- Code to close many open workbooks
- Is it possible with a macro??
- VB Code to hide rows
- format issues
- Combine 2 Ranges as One and copy to another worksheet
- Create two pulldowns from another pulldown.
- Macro Help....
- Insert Macro into Excel Workbook using C# code
- Compile Error: Can't Find Project or Library
- Loop Macro
- how to disable Office alerts...
- Time to Unhide an Entire Column
- Checking Outlook Email Address
- How to catch events from an outlook mailitem object from an Excelmacro
- Control the OLAP Cube Value updating in Excel 2007 Workbook
- go to child window
- Scroll
- Classic PivotTable Layout
- linking worksheets
- Lock
- Format Page setup for multiple worksheet in a workbook
- Aboslute path to reference macro
- vlookup sub procedure help
- Lists
- Using VBA to Print duplex (two sided)
- Basic VBA questions....
- code to parse a multi-colum multi-select listbox
- Error trying to write array to range
- MAXA won't work with VLOOKUP?
- Sort Range by Font Color
- Excel 2007 VBA speed update
- Problems in macros after chaning Operating system to Windows XP
- Hiding Tabs
- Change VBE Settings
- RE: loop whole sub
- how to execute a stored procedure in SQL server from Excel 2007?
- VBA Converter
- can excel simulate three dimensional spreadsheets
- Error after code is run
- Winzip and email multiple files (RondeBriuins code not working)
- Modifying Ron's Sub Copy_To_Workbooks
- Change refedit control image
- Problem with RefEdit Control in VBA
- LoadPicture(FileName) with size?
- RE: Change the background color of cells once it being edited
- pivot table
- Searching for non null cells
- count cells in range
- Help with code to run macros from hyperlinks
- suppress Workbook_Open event
- application-defined or object defined error
- Macros and hidden worksheets
- Add a Image to sheet attached in Ron Debruin's email attachment code
- Extract a single file from a Compressed Folder (Zip file)
- Combo Box Data Validation - First Entry Blank
- Formula to sum up customers totals from other sheets
- VBYesNoCancel Modify the YES and No Text
- Last Save date/time and User for a specific sheet in a shared work
- Check if text box has more than one entry seperated by a comma
- Using Data Validation to Filter Lists
- Copy Paste Macro not Pasting Values when Blank
- Blank Cells
- I want to create lists from web pages
- #VALUE
- Excel rejects XSD from Visual Studio DataSet Designer.
- Read of excel spreadsheet with ADO recordset
- Putting a default nam e in a SAVE AS dialog box
- VSB more efficient then standard functions?
- Copy Paste from Class Sheet to Filtered List on Combined Sheet
- How can I make a cell to flash?
- "Counter" in macro
- Programming Invoices for Reports
- Edit Comment from UserForm
- Can you tell me the Print options for ExecuteExcel4Macro?
- Share workbook update changes setting
- filter the data and paste in another workbook
- Excel 2007 / application.filesearch no longer works
- limiting text entry into columns
- Delete rows based on text value in a range
- Run Procedure when The Value of A Cell Changes
- Excel 2007 losing cell validation
- Disable all Control Events on a Userform when it is Intialized
- Can I detect if user has Excel 2007 and display different pages?
- Excel 2007 Goal Seek Macro Running 7 times slower than Excel 2003
- controlformat.enabled failed in excel macro
- Filename in Macro
- pivot table; adding kolomns to the base-table afterwards
- Update sheet one if data is not present.
- Logic
- Select Coloumn Range based on cell value
- Refering to Codenames in Remote Workbooks
- Code in 2003 not working in 2007
- Transition Formula Entry and Copy of Values
- New Web Query, from very long URL
- Multi-column Dropdown combox on a commandbar
- How to move AutoCorrect entries between computers in Word 2007
- Macro Help
- simple vb question
- Copy all data into one sheet and insert origin data... code amend...
- Input Box w/Drop Down List
- Match Value in Range and Then Paste
- Protect / Unprotect Sheet in Share Workbook Excel
- How to Zip then emai 4 files please
- Count Different Values in a column
- Hyperlinks
- Removing text before and after word in cell
- Determine File Filter Selected
- Save As window with vba
- Static variable
- If/And formula showing true/false instead of cell value
- How to avoid arrey formula?
- Replace password with *** in input box, xlVeryHidden
- Auto_Open and global variable
- HOW TO CHANGE CELL COLOR ONCE ITS BEING EDITED
- Change the background color of cells once it being edited
- Forms Buttons on Sheet Frozen
- Word to Excel
- Prompt to Unprotect Single Worksheet
- ftp paths defined in variables are persisting. How to clear?(vba)
- Popup Window Containing Image
- Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet
- Manual Page Breaks in VBA
- Creating an automatic log of filenames copied to flashdrive?
- Select worksheet using a variable
- Find Value and Move Rows to another Sheet
- Create a vbCheckbox from code in vb command button
- complex column addition
- Accessing a Stored Procedure
- file size increases drmatically
- Subscript out of range
- excel instance stays open
- Compare several cells in row & output value for match
- VBA dates versus Excel dates
- Control Zoom for Print Preview
- String variable name is incorrectly used literally
- CONSOLIDATION OF TEXT FILES. DATA FROM VARIOUS COLUMNS.
- Loop to insert data from a form - Help
- Vba - Access Setup Question
- Help with paths
- Color gradient
- Multipage Name
- Remove the $ from a cell reference
- Help with Array & Split
- Making a spreadsheet lock up after a demo period expires
- worksheetfunction.match
- Merge a range from all workbooks in a folder with AutoFilter(RDB)
- Search Columns and return multiple rows.
- Calculating a cell
- managing time
- Picture property
- Solver Error with Function "EXP"
- How hold multiple versions of the same range?
- (no subject)
- Comparing lists in 2 workbooks and copying missing rows into new W
- vlookup in vb
- Database password
- Phantom workbooks in VBE in Excel 2007
- identify specific word in a range of words
- Create Folder Variable
- hyperlink - colors and macro question
- Book about using VBA to run SQL queries with results put in Excel
- Data Validation error
- Getting data from a spreadsheet without opening?
- How to zip an active workbook
- Find Posts?
- HELP PLEASE Any one Know how
- help creating a marco please
- Mail Merge from Excel
- Save worksheet after printed
- Help creating a macro please
- Macro help (not the sharpest tool in the shed)
- Merging two cells within the same table
- Clearing Hyperlink formating from undefined # of cells in a column
- Add a row with data
- Pivot Table
- Data Validation, Drop Down Lists
- This sub runs to a function in a Module. Why?
- Strange Background
- Very Slow reading excel data into an array (while opened in new xl
- Annotating charts with text from within VBA
- Filtering Data
- Macro for recurring formula; max of set of cells
- Design Selecting Controls
- sorting in a macro and defining last row into varible not working in
- how do i export excel data directly to my outlook agenda?
- Help adding a label to Total line
- Unselect option buttons
- Need Code To Run Always
- HelpContextID on a single field
- creating custom menus
- Help with annoying VBA editor behavior
- Protecting conditional formats
- Excel Instance Hanging Around
- Protect VBA Project By Macro
- format table
- REMOVING DATA BASED ON OTHER CELL INFORMATION
- Chart with a defined named range?
- REMOVING DATA BASED ON OTHER CELL INFORMATION
- Change the value of particular cells in a Named Range
- SetFocus in a custom dialog
- last date saved in excel
- those little "moving lines"
- finding control
- Prevent users from saving if cells are blank
- Event procedure or ............
- combo boxes again
- How to Determine group of numbers best fit into 1 number
- Import XML Problem
- Display Excel Data as a Calendar
- XML Importing Problem
- Update a specific worksheet
- Insert a symbol using VBA
- Using Form Combobox in VBA Excel
- Very basic question, please
- Help....
- Numeric representation of curve/distribution for resource forecasting
- Data Validation Error
- Change Cursor Image if Workbook is not the Active Window
- If - Then Code Help needed
- Sumproduct with A1 notation instead of R1C1
- Exiting a workbook
- Dynamic list based on sheet names
- Help! Cannot calculate 123 * 456
- Parse a txt file and save as csv?
- Filtering VBA
- Help with "floating pop up menus" (if that is correct)
- How do I decrease the value of a column by 10%
- Limiting number of characters in textbox
- Formatted Date in header applied with a macro
- Need help with hyperlink character limit
- Help with Macro
- Calling Excel methods from a different thread (COM add-in)
- Scripting Error
- **URGENT** Macro to find a Cell
- Userform causing a slip for Worksheet activate?
- What is proper way to Open Close Release xls files in VBA?
- Text and Pic pop-up box
- Format RowHeight question
- Script Error?
- Formating question
- need SUM code help
- Loop Through UserForm For Multiple Different Outputs
- automatic charactor replacement
- Order in a array / ListBox
- SpecialCells
- Need Help programming treasure hunt sheet!!
- Accessing the Bessel Function within VBA in Excel 2007
- Move one record to another sheet when I type in a cell
- How to control the OLAP Cube Value updating in Excel 2007 Workbook
- Referencing data validation list in IF Statement
- Get address from iFrame reference in page source
- Manage and run a WMP Playlist in Excel
- Multiple wrksheets same columns globally change order of columns?
- Macro in UserForm
- Split address in 1 cell into 4
- Disable AddIn via automation
- how do i run an external file
- Function Trouble: Not sure how to correctly reference my variable
- Input box
- match up columns and move data
- creating a pulldown based on the value of another pulldown menu
- Task Tracker
- Dynanic Print Range
- removing data based on other cell information
- Copy two summary ranges to master summary sheet
- Name/Description of error?
- Remember FLIGHT 93
- VB Command Button
- Name of Sub/Procedure?
- Execute an external file in Active X control Button
- Adding a selection of values and storing result in a variable
- Remove buttons from worksheet programmatically
- Kill Function by author
- Import "ThisWorkbook"?
- Search data w. use of msg box and copy results to new blanc worksh
- Put data from various cells to one cell
- "object variable or with bock variable not set" - quick reply greatly appreciated!
- How to access cell properties in arrays for automation?
- Clearing a listbox
- Time Format
- Hide/Show rows based on Conditions
- Problem with Updating data from several Sheets
- Problem in opening Excel which is already opened by VB code
- Error handling
- Strange validation list problem.
- Need to find macro
- Evaluate duplicate rows and delete information in specified columns
- Password Protection "Sheet 2" ???
- Search multiple worksheets and return value to main worksheet
- Activecell Count
- Pass Workbook Name Into Another Workbook As A Variable
- Line Charts - Is this possible?
- Creating a DLL for Excel
- Automatic Chart update Excel File 2003
- Compare Ranges
- Clearing data in a row when rows start to duplicate
- Placing cursor in message box
- Clearing data in a row when rows start to duplicate
- Populate combo box with external data
- Folder Passwords?
- Hiding Pictures "Run-time error '1004'"
- How to copy a part of a cell coming from a Web Query?
- Change Mouse Pointer Image in Workbook
- Condtional Formatting or VBA Code
- Blinking Scroll bar
- CONCATENATE
- Looping clmns, Copying worksheets, and Projections
- How to set a value in a list?
- Can sales register be linked to custom forms?
- Scroll bar
- Prompt for Save Path - Use Cell Content for File Name
- Start UserForm From Different Workbook
- Excel Sort
- Userform Commandbutton mousedragover event
- Convert decimal Englishpoint (.) to Swedish (,) (texts to digits)
- Nasty intermittent
- Image Property
- Macro to set print area
- XLDialog for setting the Print Area of a worksheet
- dyamic printing
- Excel2007 crashes while setting chart formatting
- Faster Pagesetup in Excel VBA using xlDialogPageSetup
- Formatting text that appears in messages
- Complex copy and paste looping VBA help
- Permanently remove rows
- error question
- Excel Expiration
- Display rows if conditions met
- Need Help with If,Then
- Excel 2007 Programming Error - 0x80010105
- how to copy matching data in next sheet
- How to get current information regarding a fresh query refresh?
- "collapsing" data--but only for certain rows
- Excel - PowerPoint VBA
- Copy/Paste in VBA fails?
- Sorting CSV Data By Date
- file resizing
- Last ActiveCell
- Value LIKE
- create text file
- How to enable / disable ControlButton added to Cell CommandBar
- 2008 East Coast U S Excel User Conference
- Determining if ChartObject is in PrintArea on Worksheet
- Problem with new programme
- Unable to set ColumnWidth property
- Reference
- Macro Sensitivity analysis Update table
- Colors on a pie chart
- macro delete rows <>1
- Using a Macro to Hyperlink to another Excel Workbook.
- Name of VBAProject ???
- Place formatted Text in Shape(textbox)
- Run-time error '1004' . Please help. Request for immediate attent
- number format
- Identifying duplicate entries
- Control Row Height
- Each cell in selected cells test
- Accounting Format Text in a Textbox
- Add Two Columns of Data into a ComboBox in Userform Initialize Eve
- Identify Smart Tag
- Find All Replace All
- Date & Time Picker Control 6.0
- Unlock Protected VBAProject via code
- Set DTPicker Date Value if it is not Visible on Userform
- string width
- list permutations
- Cube functions won't refresh when Printing
- WTF?? Stange happings with a VB code
- Automated Macro
- quickest way to find last "used" row in a 2D array? (repost)
- set command button on a worksheet
- Input Box Question
- Fill cells
- Icon Size in Ribbon
- Append Unique Records to Master Worksheet
- Stepping through v. running code
- xlDialogPrint
- Adding text to the start of a formula
- Copy/paste rows to new sheet based on cell value
- Cross Function when array crosses above another
- Data validation list box
- Referencing a cell as a row number
- Pivot table sorting - can I do this?
- How to change the font used by dropdown list box?
- list of folders and subfolder.; quit simple ..but.;
- Can't figure out how to do this loop
- I'm stuck
- Reset ScrollArea
- Time Format on Worksheet Change
- Excel API or documentation for ActiveX?
- Getting Underlying Data from a Pivot Table Cell
- Scrolloing
- Copy Contents from Cell
- Copy Autofilter Source Workbook A result in Destination Workbook BSheet1
- Bypas Nil Values
- in a columnGet to first positive value
- How can I time the speed of a macro?
- Creating a formula in Macro
- Entering two functions in code
- Cannot get accurate results from Hittest
- Sub Workbook_Open not called when opening spreadsheet
- Output sql query results to text file
- Why do I still need to cast "Range selected = (Range) app.Selection;" ???
- Limit Characters Shown in a text box
- Embed Command Button in Cell
- Cycle through Variables
- Embedded Combo box changes size
- Date Entry
- Copy History (recently opened) to Cells
- A macro solution - replace text given the values
- Create two combo box in a single worksheet
- Looping rather than code for each row
- Can I put a Formula into an Excel User Form?
- Start a macro when cell >=0
- Digital signature
- Time format via Worksheet Change
- Divide rows equally & extract first & last of each block... Possible?
- Copying data from different sheets to one mastersheet
- MultiSelect Listbox
- Modify to do to each required cell
- Time sheet in calculate per 15 minutes.
- Userform question
- Macro to show which cells have validation
- "deselect"
- Making sure the user is able to run macros
- Macro within a macro
- Allowing Hyperlink to Work on Protected Worksheet
- After Insert
- Sover -- how do you stop "The maximum time limit was reached..." b
- cannot see text box
- opposite of Union
- Passing Control Names in an Array to another Procedure
- Deleting characters after 3rd occurence of a string
- Create an Outlook Task
- ExecWB
- Can Excel capture a screenshot?
- Autofill down over blank cells until new data, and repeat.
- IRibbonUI error
- Pivot table filter - Selected Item Event
- AutoComplete Entry in Text Box or Drop Down List
- Excel Sort
- Exporting Data with Line Break
- formula to define the number of gallons used
- code signing - avoiding "enable macros" once digital signature expires
- VLookup in a Macro
- New Loop, 2 workbooks
- set range to bottom of sheet
- formula to blank cells
- Using variables within countif
- Skipping the "Overwrite" warning within a Macro
- MouseDown with an AutoShape?
- Find value copy and delete
- Freezepanes
- Re: Status Bar Message
- Cant set the date into a Date & Time Picker from Cell value
- Send Network Message
- add vbyesno to existing macro
- Macro Help
- I am trying to create a formula
- iterating through a Dictionary object
- Linking worksheets for updates
- Lock Position of Controls on a UserForm
- Last Row
- How to determine which columns are used in formulas?
- macro is slow when I minimize spreadsheets
- Logical statement: equivalent of an IN function?
- Formula not consistent
- Selection in a range.
- Change Mouse Pointer on protected sheet.
- Macro to select A1 in all sheets so that users always at top of sh
- Basic help with sheet
- Encrypt 2007 xlsx file using VBA
- Empty selection with vba
- Commanndbar and tooltip display
- Detect copy and paste action
- Cell formats change while opening the file via VB
- Multipage control
- For Don Guiilet,please help, 1004 error,1003 (type mismatch etc et
- Open workbooks in one click
- Is there public domain code to calculation cointegration coeffici.
- Re : Excel AutoFilter Detectable via the Most-Recent Activation of aFilter
- ListBox Condition Not working for 1st Entry
- Anyone had this problem
- Appending sheet
- Modules
- Displaing result in Entire worksheet
- Good reference books for Office programming?
- Copy, modify and save a spreadsheet a from web application
- Delete Sheets to the left
- Help with Instr function
- Form - Get Selected (true) value of Option Button
- Excel and Active Directory
- Global Variables
- Trouble referencing the correct cell. Function will not work.
- Re : Excel To Call Sub and Assign Arguments
- In Excel:How do I ? =N14 BUT IT MUST SHOW O14 IN D18
- color cells of period
- check digit scheme: mod 10 or what?
- Send network message
- Tools / Options
- Colors programatically
- Copy Rows based on column value
- Getting stock market prices
- Displaying the infinity symbol in an excel spreadsheet
- Print Preview Office 2007?
- Sorting a named range using first three columns
- Taking data from other workbook ina macro
- Unable to run macros...
- Controlling Change event when loading a form
- Run-time error '1004' . Please help. Urgent
- Change Font Color for Dupes on Selection Change
- Paste non-adjacent cell content from Excel to open Word document
- Next Line in Auto Filter Macro
- input box searching and adding values
- combobox
- Opening a Word Doc
- Color List
- Find if between dates
- Copy 3 columns become one column with macro
- dropdown menu accross row data as list fill range
- runtime error 9 -- subscript out of range
- One Variable Available In Three Workbooks
- InputBox Date Value
- UDF shows #NAME? when moved from XLA to XLL
- Dont know cellformat in vba
- batch file call from a macro - how ? and required batch format
- Cells.Find and PivotTables
- Open Webpage and Extrat data based on list in excel
- Autofil syntax to auto-complete the range
- Change all files format in folder
- Deleting number strings
- New Loop, 2 workbooks
- Links cannot be updated related bug - DA
- Sum based on mulitple criteria and show indicator
- Code to automatically close an Excel spreadsheet
- Creating a macro to sort a complex dynamic named reference
- Error handler not handling
- How to consolidate multi-row data into a single row?
- Percentage Formula Issue
- Creating new worksheets using data from a single worksheet
- Calendar Control (Embeded) - Populate thru a command button
- Combo Box Selection Changes w/o Input
- Reassigning a macro to an ActiveX button
- Simple GetData Question
- VBA help needed
- Graphing the sum of an autofilter result
- Copying workbooks
- VBA
- Formula help?
- Survey building and analysis tool
- Convert from "xls" to "xlsm" format
- Saving a file with a macro without a path
- trust access to Visual Basic Project checked
- Formating listbox columns
- No Excel Help Section for DTPicker and other code.
- Add range after selected cell
- html chart and table in outlook mail
- MMult function . Highly frustrating experience please help.
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.