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 |
- Solved
- Ranges into an array.......why doesn't this code work?
- Problem copying from protected sheet
- Re: Pivot Table data based on user input
- Re: Conditional Formatting a whole line based on cell value
- Excel Charts and VBA
- sheet1 tab staying still
- One button, one macro, several sheets
- Delete File(s) over a certain age
- excel sheet dirty read and dirty write?
- Excel Publishing option
- Converting a file to text
- I create sheet using vb codes after that i want change sheet name
- Selecting a cell during a macro
- Can i send a message in communicator using an excel macro
- Re: UDF that participates in circularity always dirty
- Re: Application.FileDialog(msoFileDialogSaveAs)
- Create Folder
- Reposting -- no response yet -- issue with removing validation in
- Find character in string
- Find character in a string
- Adding Shapes: Position changes when running code a second time - Why?
- Re: Can this be done better? - 'selective protection'
- Outlook to use procedures written in Excel VBA
- stop redundant calls to UDF
- Using Commandbutton for different ranges
- Events in another workbook.
- Re: Writing a Formula or VBA
- VBA Macro
- Looping Through Combobox
- Formula/ Macro to combine data from multiple rows
- Help needed for Visual Basic 6.0 Macro to rename an Excel WS
- Paste special transpose macro
- Combobox & Addresses
- Calculation Time
- Control Toolbox vs Forms
- Re: Matching data in spreadsheet columns
- Formula calculating very slow
- Last 4 tests
- Helo with Justify macro
- Count values in different columns
- RE: copy csv file to Excel
- office 2007 and C#
- inputbox, color of default background is black
- Refer to a control inserted in chart
- Re: Data Entry and Protection
- Re: Procedure too large
- Macros and VB in excel
- Creating many worksheets with text from initial worksheet (and mor
- Macro/VB issue with Microsoft Excel
- Sending Mail from Lotus Notes
- Re: run sub routine with multiple conditions
- Pivot Table Macro
- Worksheet activation on Opening Workbook
- Re: Store Current Selection As Range Variable.
- batch process to covert file to excel file
- command in filter, then save as individual workbook and print out
- SaveAs problem in Excel VBA script
- Using SendMail through Access - Excel Automation
- Re: sending automatic email with VBA-Excel in Vista OS and Windows Mail
- Re: AllowedEditRange
- Re: Matching Records in two tables
- Re: User Defined Type not Defined
- Search Functionality
- Re: Userform Control Enter Event
- RE: Copying a Named Range with changing cell references
- Re: Print with no line feed
- Re: Page break macro based on cell content / formula
- Re: How to disable close button in userform?
- Re: Issue with ComboBox on a UserForm
- Re: 2007 Ribbon control disabled by Excel when sheet is protected - Override with getEnabled?
- Assigning a Range to a dynamic array
- RE: Procedure too large
- VBA Command - Not Familiar With Program
- Re: Tweaking to pull a local HTML page instead of a server page?
- Re: C++ Excel automate, add hyperlink
- Re: How to employ ExecuteMso Sub in Excel 2007?
- RE: Ref Commandbutton
- no custom button in ribbon
- Get First Letter of each word
- Data Validation Dropdown bug
- Copying from dynamic workbooks
- RE: Ref Commandbutton
- Excel date fields to MS SQL Sever via OLE
- Re: macro command "definitions"
- ODBC connection trough Visual Basic in Excel 2003
- RE: Array problems
- variable
- Re: List help with sumproduct formula
- Code from Powerpoint VBE not Working in Excel VBE?
- RE: Help – I need to extract information from………..
- Re: Help – I need to extract information from………..
- RE: Two-way data comparison help please
- Command Button Drop Downs
- Copying out corresonding values
- Setting row height to 0 in the visible celss of a range
- how to use MZTools to get a calltree?
- Why does this Worksheet Calculate Event run so slow?
- how to sum values of an unkown number of cells
- Creating a Project Schedule, displaying the hours per day.
- Case Select
- VLOOKUP Help
- trying to write a tab-delimited file
- Sort and Renumber
- Speed
- Regex syntax request for help
- Insertion of Excel plots in a userform using VBA
- cell already referenced
- Path Issue
- Matching a date or value
- Remember Last Cell
- Userform
- get other workbook objects values
- RegExp information
- scheduled tasks
- Macro for PPT changes the object number when looping over 42 times.
- xlsm
- change cpu used
- "Web Services References" add-in
- Copying text within text box and having scroll bar appear
- What determines the language of MSGBOX's Yes , No ?
- Process monitor macro needed
- Having trouble formatting paragraph in text box of form
- why,,,, dificult??
- get value of a known cell
- Help Using Excel 2003 to send emails
- Accessing groups of option buttons
- Invoke hyperlink
- Create a chart from a "txt" or a "csv" file
- Keep track of OnTime macros
- How to activate a worksheet at a set time
- Export Multiple worksheets to text files
- Type Mismatch Error in Excel VB on RowIndex
- How can I change the case of letters without using function ?
- Cell to indicate protected sheet
- countif from whole row as range
- How to use MS assistant instead of drop down list in excel
- populate text boxes from data in worksheet
- Generating password-protected PDF using Excel VBA
- 1.04 Mb with nothing in file ???
- help with a worksheet needed
- If then else assistance - conditional "deletion"
- Run-time error 1004
- excell error on close with commandbutton
- Compare and Count data in worksheet rows.
- check that active cell is within a range
- error 1004
- Setting Pivottable RowField Width
- Counting based on characters.
- Text box
- Custom zoom
- VBA enhancements
- using rons email but need just printrange to mail
- Application.Sheet1.PrintOut = property not suported
- checkbox & controlsource
- ListBox Value
- "Run-time error 429: ActiveX comonent can't create object" MSComm
- Why doesn't this simple macro work
- Excel 2007
- Accent / Diacritic word search
- EXCEL 2007 / RS 232
- Defined named range (Array list)
- VBA help: need folder names
- Data from SQL to Excel in a formated manner..
- Error when trying to remove Validation from cells
- ActiveSheet.Pictures.Insert problem in excel 2007
- Match 2 cells and total another
- Match 2 cells and total another
- Run Code on Cell Select
- find cells that match in column
- I have 4 columns, I need to match col. a & c, then sub b from d
- Excel 2000 clocks -- Excel 2003 works fine.
- needing help with replace(c.value
- WAV Files
- Help, please. Anybody?
- Type mismatch error
- Type mismatch error
- Unique Values
- Re: copy worksheet tab data into one sheet
- Custom Sort a Pivot Table (possibly w/ VBA?)
- how to generate date error message
- Using a text cell reference as a variable in a macro...
- Insert Row after Specific Value in Previous Row
- Goto last cell
- find
- Using VBA to send a javascript:opendocument command, then grab information from the active IE6 window
- Workbook Open
- msgbox
- highest used area of an array ("uBound" of used area)?
- Info on UserForms and command buttons
- sort within a sort
- Looping or Repeating on all worksheets
- Add-in macro button assignment spontaneous change
- Combine column data into one
- Active Cell
- RefEdit error
- Cell Value
- MERGE ROW CELLS BY MACRO
- referencing a Drop Down Menu
- combo box value
- Worksheet_Change not repetitive
- Macro Question revisited
- Application.Wait information request
- Problem with that PPT changes an objects number during macro in aloop
- SaveAs dialog box
- How to save data back to databak
- ListBox Execution
- Slow Macro Issue
- Copying the last used cell only
- Call Macro If x 2 Q
- Closing an Excel Spreadsheet via command button
- Re: Copy worksheet tab data into one sheet
- VBA Code for pop confirmation box
- help modify code
- MERGE CELL BY MACRO
- VBA Lookup with Find method
- Prevent selecting filtered rows in AutoFiltered Range
- Items received vba
- stop formula recalculation when formula contains UDF
- Stripping Formating from Header/Footers
- Get cell reference as parameter in function
- Linked File and Range
- Sorting file names
- Strings
- Select Case Not Returning Correct String
- Retrieving OptionButton Control Value
- Copy data in multiple worksheet tabs into one worksheet
- IF Cell contents = "a" then hide row
- after click a button(commandbutton), getting the button name
- variable names stop to adapt to changes
- Find Worksheet
- MACRO TO INSERT ROWS
- Calendar
- İki eksenli grafikte y ekseni sabit x ekseni iki değer nasıl oluşt
- Uncheck every Check Box Q
- select range...
- Columns to rows
- My file is 28 MB w/ code & forms; ~40MB with data - is this too bi
- intersection point
- How to have multiple values in a single cell?
- Fun with GetOpenFilename
- BDP/BDH/BDS functions in Bloomberg
- Issue with workbook not being selected when form button is clicked
- Macro to create a varying named range
- 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
- How to traverse cell.Dependents
- Page Header: Setting using InputBox for LeftHeader
- SetFocus not working
- Correct structure
- Formatting the Formula Bar
- Single quotation mark prefix
- macro OK in Excel 2003 but NOT in Excel 2000
- compile error with FaceId
- PivotTable filter ordering
- using the WorkDay function in VBA
- Calling function from non-referenced add-in
- Delete entire row if column B shows -
- Macro to update data
- copying macro to multiple excel files
- Range properties from Array variables
- Add Tab names to Userform
- Recursively scraping web pages for embedded links and files
- find values and add them
- Create Multiple Dynamic Ranges in a single column
- print to pdf with vba
- Complex Graph
- XL2003: VBE Project Explorer not showing folders
- Formula in a Text Box
- Using "Undo" with bound ListObject
- FIND function i VB
- Improve speed of data transfer loop
- alphabetize within a cell
- Copy/Paste Multiple cells from Excel to Word
- Combinations
- Using Excel for statistical analysis - a question for problem-solvers
- Assigning cell values with VB
- VBA or Function Required . . .
- problem with background query
- Kill a Macro?
- Matching user input to number in range
- Create list of different columns
- Delete the active wb
- Detect Excel service pack
- make hotkey in commandbutton1 on userform
- Programing - TEXT - EXCEL
- if value begins with "" then
- Pearson and Peterson are Genuises!...er...Genii!
- subtract date and time between columns
- Excel Cell Display window blanked out
- SLA - Downtime calculation
- How to protect worksheet?
- How to stop a VBA Module from opening
- Chart Question
- Send email in a different way
- Adding Time to a Date
- Callling Word fronm Excel
- OLE Object on Sheet updates Value in Code but not its Display
- Setting up Classes
- How to detect cell content modifications?
- Spread Revenue Over Time - Excel Help
- Web site plus excell
- runtime error 9 in my macro
- How to set Cell Format using VB.NET
- Search and change text color or style only
- Copying Data between worksheets
- Filter Pivot Table
- sort (ascending) data while worksheet is protected
- activate
- How to create Loop
- How to create Checkboxex on the fly
- PLEASE HELP
- Date Serial Problem
- delete row on basic of cell
- Deleting a row in a message (opposite to VbCrLf)
- Macro to do numerous tasks
- Loop
- Autofilter over 255 characters in a cell?
- copy range to Text (Tab delimited) (*.txt) file
- Help creating a custom function in VBA
- Retrieving a value at some cell from another Workbook
- XL2007 - Known problem? - Driving me crazy.
- Form Actions
- Worksheet_change event assistance
- Data comparison
- WORD ART WITH EXCEL 2007
- Clear Method not working for a ListBox clear
- A formula for birthdays
- Run-time error '1004'
- Unwanted "Flashing" of screen
- enable and repurpose the Spelling control?
- Macro launched from another file only partially works
- How to change debug.print font?
- Listbox Output to Individual Listboxes
- Formatting cells with VB
- Exporting Values into Microsoft Word Form Fields
- Specifying cell in Worksheet_Change even
- Dates
- Excel 2003: VBA - Hide Rows process now too slow
- find
- Textboxes remembering previous entries
- excel crash on workbook_open userform.show
- countifs
- Declaring arrays
- Private sub Worksheet change question
- delete empty space after certain characters
- If texbox value begins with "E" then send to another sheet.
- Macro gets lost
- Sending email routine, tweks needed
- Multipage control
- How do I protect my code?
- Insert a number rows according to a cell value
- Scraping/listing document URLs on a server that don't have web pages/existing links?
- application.EnableEvents = false not disabling events
- VBA syntax to check between two time frames i.e. 2 PM thru 5 AM?
- Find using a variable value
- How to obtain superscript and mixed font info when read from Excel?
- include date and time in email subject line
- Grouping related ribbon tabs
- How do I plot two curves on a single XY scatter chart?
- Textboxes Not Calculating Properly
- Macro to delete with filters
- Find something
- What are the options in the print macro?
- Halting Execution -- A Newbie Question (possible repeat, sorry)
- Cell Error Markers
- Macro to mark a column where text in row (or cell) is as specified
- Can I switch to my custom Function category ?
- Stopping Code Execution -- Newbie
- hide formula bar (and menu bar etc)
- If find function to not find anything
- if multiple conditions are true, then copy the row to a new sheet
- How do I track down 'invalid references'
- opening workbooks in subfolders
- Shadow Menu
- Programming Shapes
- Clearing formulas
- Compare Columns, Find Matches
- MultiPage Page Order
- Add custom icon using VBA
- Reading Directories
- Extract data from seperate files-macro
- ADODB Connection in Same Excel File
- Identify defined name range by another cell value
- How to create pivot table from web query
- Formula for list summary
- MACRO TO BRING WORDART ON CELL VALUE
- Invalid Precision: cbColDef value out of range
- find
- Selecting dates from current week with Macro
- try to email with vba, but more than one sheet and convert to pdf
- Problems with an if (using rng Nothing) - only to produce sheet giventhat it doesn't already exist
- Make excel Worksheet as data base
- How do you programatically format embedded charts
- Restoring the Macro Recorder to Default w/ relative references sho
- Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range)
- Last cell with constant in a sheet
- how do I disable spell check in email sent from Excel macro
- Auto Number Excel Forms During Save As
- Synchronize Combo Boxes?
- Listing installed COM add-ins
- Deleting Duplicate Rows In a Selection with a True Statement
- Making changes on "grouped" sheets via code
- SQL with Excel ranges
- Inconsistent behavior using VLOOKUP
- vba editor comes up everytime this specific macro is run
- Determine if a shared workbook is open
- vba editor comes up whenever macro is run.
- VBA and Excel 2007
- Plot Area Changes Automatically When Updated
- Sum / countif data range
- pulling apart a field
- pivot table order
- return to first column of next row
- Invalid Precision: cbColDef value out of range
- Limit Dates in Pivot Table
- Numbers Not Calculating Correct on Userform
- Formula to add a date to a cell that is 6 months from today
- Maximum number of named ranges?
- Adding validation fails with automation error
- Goal Seek with dynamic Goal Seek
- ExportAsFixedFormat for Multiple Sheets in a Single Excel File
- Configure Built-in Font Color Command Button?
- align and resize controls
- Conditional Formatting and Text Alignment
- If column = value sum another column and place result in cell
- From VB6 how to determine if an Excel cell string containssuperscript?
- Pivot table from xml data
- No... while trying to update to Excel file
- COPY FORMULA TO THE LAST CELL
- Code for file download
- Code for file download
- Save As PDF / XPS
- Range is nothing
- Replace last three characters
- Zip and mail more than one sheet from the ActiveWorkbook
- Display formula result in a popup.
- disable clear all using VBA
- Time conversions from data dump
- Integartion of BDC into Excel services
- Help passing Range to Class Module method
- identifying the end of a data column
- Vlookup and #N/A
- Text Box
- VBA block cell copying.
- Multiple Windows in Single file
- DATE IN COMPUTATION
- most efficient way to filter out and iterate through XLS databases
- Loops stop working and presents "1004':
- SumIF
- EVALUATE method returns zero
- Custom menus don't appear under custom ribbon tab
- Adding AUTOSUM to Cell menu in Excel 2007
- Loops stop working and presents "Run time error '91':
- Variables in Variables
- Conditional Format
- Filtering one or more items in 2 columns
- Need help to enter text in Polish language
- Re: How to see cell value exactly as Excel displays it?
- How to see cell value exactly as Excel displays it?
- Workbook Open bypasses Query Refresh
- coding for variable rows
- Why is my vbasum(F1:F45) called 46 times?
- outlook express 6 glitch
- Message Box Help
- return row header as answer
- .Formula vs .Value?
- Check cells in row for last cell with data to use as multiplier?
- Set Formatting Menu Font Color with VBA
- UserForm and user input
- For Each ws autofill
- Create worksheets based on value
- How to refresh a pivot table that uses changing source data
- Bloomberg API: Preserving Values?
- Sending Email to non-standard address using CDO?
- return chart's source data location/range
- Random phantom breakpoints and random bogus compile errors
- Record Not in Access DB
- Importing Specific Data From Multiple Pages From The Web
- PLEASE HELP!!
- How can I hide contents of a cell and password protect to reveal
- VBA 6.5 on older systems
- GetPivotData - Why does the reference not change when I drag theformula?
- format in VBA
- Subscript out of Range
- Obj Variable or withblock variable not set?
- Save Copy or Cut Reference
- Use criteria in an Advanced Autofilter's single column
- Transpose 3 columns into Single column
- Return the first 2 letters of a Cell Value
- Vlookup across workbooks
- Inserting rows if a particular item is chosen from a list
- copy formulas on a weekly basis to next available
- having trouble with a chart range
- Excel runs much slower in console app
- Zip and mail more than one sheet from the ActiveWorkbook
- How to run a process in the background?
- Multi-level User Definet Types
- respostX2 - deleting blank rows after macro-generated pivot table
- respostX2 - deleting blank rows after macro-generated pivot table
- VBA Error
- Passwords on files used in calculation
- Macro to Transpose All Items in a Vertical List, and Add a Comma
- Downloading into a column
- Which cell is calling a user-defined function?
- Getting/using the File path of a spreadsheet
- Help needed with macro
- Excel program
- Look up data.. help please :-)
- Referring to merged columns in range object
- Re: transpose loop
- count column c with condition in column A
- Using the result of an input box
- Creating a line break (newline) in a cell with SpreadsheetML
- Reset of radio button values without calling _Click() function
- Custom Context menu (Right click menu) not working in sheet changeevent.
- Copy worsheet from different files in to one file
- Crash on ActiveWindow.Close
- Variable not seen
- Simple question
- exclude holidays on UserForm Calendar control
- application.filesearch error in excel 2007
- Sheet Select
- Look Up sheets
- Unable to view search results
- HELP Debug
- Code for a Macro that allows a Pivot table to be repeatedly run (fora dynamic rows in a table, but static field names)
- application.goto reference using references in the worksheet
- Converting a number todate
- Macro not running when Image/Button Object is pressed
- delete all rows where cell is not date format
- if cell is not date format delete row
- if cell is not date format delete row
- if cell is not date format delete row
- Scrambleing data when refresh
- Combobox that populates text boxes on userform
- help with "Goto" command
- Reactivating file based on text value producees subscript error
- Combo Box Wont Show Values
- Help with autofiltering a list based on criteria
- How can I tell the shape of a Variant containing an Array?
- Calendar using TODAY function
- Re: Automate Monthly Task
- Insert "/" into cells that contain data, using a macro
- app.quit
- why would a large addin save in 2 seconds or 18 seconds
- run code *after* drop down list choice
- page header multiple rows
- wait function
- if - then actions
- Changing a horizontal axis crosses value using VBA
- circular argument
- Re: Conditional Formating
- check column -A- and fill out column -B- by vba
- Re: CC Field Q
- Ranges in VBA
- Writing text at end of spreadsheet
- user form tabs
- Filtering Data Based On Different Criteria
- Programmatically adding code to worksheet
- Pivot Tables
- Concatenate Rows depending on cell value in rows
- What does it take to get class functions to execute?
- html help and custom msgbox
- Page Fields Converting to Text
- Using calculated fields to count unique items in a pivot table
- getting data from website's url and webpage
- Rename worksheet tabs
- Copy a Range that matches Todays date Q
- v lookup problem
- cell top of screen
- How can I sort contents of one column based on the contents ofanother column?
- Dialogs(xlDialog...).Show arguments usage
- getformat
- Pivot Table Macro - How to describe the Active range (so that themacro can be used on new sets of data)
- Why doesnt this work?
- AutoShape Macro Help
- Filter Data based on criteria
- Seperate letters and numbers in a cell
- Protect workbook when saving
- Excel Automation
- Adding Cells and Indexing
- ScreenUpdating Not Working
- delete rows where value in Column B=0
- Need loop guidance
- Using Cell Numbers in a range
- Row number of filtered row
- Variable value
- R1:C1 format
- Function
- Using ADO from Excel form to relational Access Db
- Referencing two versions Object models
- Copy/Paste data based on a criteria
- Locking worksheet based on the cell value
- array formula to extract members of list A that are not in list B
- How to include field name in CopyFromRecordset
- Filesearch error in Excel 2007
- Find first empty cell in range and paste formula??
- Control don't refresh
- How to add a text box with scroll bars in excel 2007?
- Minimum references required
- Count items in a column
- Excel Functionality
- Code Help
- Code Crashing
- use option button background color to format cells
- Value cells
- Skip part of macro on re-run?
- msgbox
- worksheet as data entry for Access database?
- Increasing and decreasing cell values
- Copy and pasting based on criteria
- Coded to delete extra rows after pivot table
- Open And Close Form
- Adding a second line in a header or footer through VBA
- How can I change the caller cell's format into "mm/dd/yyyy"?
- Paste not working again
- Macro to split data
- Passing Parameters to an ODBC
- Opening files from Excel
- Accessibility of a server
- What programming to use in VBA to convert in to number?
- lost reference to activesheet when opening workbook inside IE
- OUT OF OFFICE IN OUTLOOK 2007
- read Matrix
- Copy to
- Query refreshing inside a loop - out of memory
- Getting error using Month()
- Asian file names
- Macro freeze up
- Totally Lost
- blank display while macro runs
- Excel 2007 filesearch
- Instr
- Excel 2007 ambiguous name detected:Worksheet_Change
- links
- Need help with a macro that takes information from another workboo
- Can Not Complete This Task with Available Resources
- Import text files to cells
- Copying a chart included in a range
- Counting Octals.
- Userform
- How to put a button on a cell and assign macro to it?
- Looping through columns
- Deploying Excel 2007 VBA Project in an Office 2007 Standard enviro
- AMENDMENT IN MACRO
- extract certain values from multiple workbooks into a new file
- calling .net exe file from within SSIS script task
- highlighting rows
- Summary page
- Getting #VALUE! while entering UDF as an array function
- Activating a workbook
- Custom Toolbar question - newbie
- userform closing after input
- Code that searches a column, then copies and pastes any matches intoa new Spreadsheet
- Setting a variable = ActiveWorkbook
- code to delete all rows beneath and columns right of pivot table
- peraphs impossible... order line base color...
- Copy data from worksheet to another automatically
- Closing VBE systematically
- Remove/Inactivate "X" in UserForm
- Pivot Tables: Hide detail for a RowField via code: Get an Error?
- Exclude rows with result 1
- Calling a user Function in Worksheet
- If cell value = x or y then perform formula set else skip
- How to read in cell border?
- Copy Error
- Average - without zero?
- Best Substitute for Range(cells(),cells()) in worksheet
- Windows API - File Menu Processing...
- Easy Question: Cell Value
- Bloomberg download
- Image in Userform looses quality
- Excel 2007 VBA - Can't type in VBA editor
- Automatically populating new rows with formuals above
- Forcing cell value update/refresh
- Add Column at the end with concatenate formula
- Count CheckBoxes in a Frame that are True
- How to set Range variable to point to End(xlDown) cell?
- Conditional Formatting
- Advanced tool uses TrueType fonts to represent tiny charts
- Filter out Non-Number (i.e. Text) Cells
- Combobox
- VBA, copy lines with specific value
- Save Changes to Add-In
- VBA Project Passwords
- save and add to CSV file
- save workbook without code
- How to get the last valid (non blank) cell index?
- how to detect if macros been disabled
- Copy & Paste...if
- Import from Excel to an access database using Jet in vb.net
- hide name box
- IF statement for lookup matchup
- Excel Error
- UDF Function or Macro Needed
- Updating Listbox in Excel Form
- Updating Listbox in Excel Form
- Updating Listbox in Excel Form
- Public oMyClass As New MyProject.MyClass
- best way to get an updatable SQL Server 2000 recordset into Excel?
- Not ScreenUpdating with PrintOut Property
- Enter Key Press Event
- Using VBA to change the color of the active cell if the value in thatcell is less than 15%
- How to automate Print Zoom to fill page
- An old macro needs updating
- Macro's
- drop down change event
- isblank macro
- DELETE ROWS ACCORDING TO FIGURES
- Run time error 2147319765(8002802b)
- Setting cells to change colors as a date approaches
- Shopping Cart application
- protect my sql query
- range with variable row
- Checking Data, Help Please
- Information dependent on other information
- Block games in Excel
- Deleting Worksheets
- Questions on Ron de Bruin's Excel Email Macro
- hyperlink follow through and save file
- If Then else
- 0E560 = 0?
- Withdrawing a template from "Data tracking"
- Change the date when there is a change in another cell
- Hyperlinks with Cells(r,c).Value reference
- Need help with MAcro for Multi-value cell and row processing
- Excel 2003 and 2000 and VBA Macro
- XL2002 - Worksheet_Activate Question...
- OLAP cube DateTime dimension
- import multiple text files into single sheet separate column
- Custom menu groups don't appear on ribbonX when no workbook is ope
- Re-Arrange Tabs
- Big excel file
- Subtotals
- Looking Up Text entries
- SQL and Excel
- Ribbon stopps working after Save
- GETPIVOTDATA help
- Pass criteria in Microsoft Query
- Subscript out of range
- depedent drop down lists
- Run time error?
- Programatically filter a protected shared workbook
- checkbox value unavailable?
- Putting zero value within a specified range, help please...
- Buttons
- 3 dimension array using Excel names
- Replace Dialog Box Keeps Moving To Bottom After Replacing Text
- User Forms & Checking Inputs
- Excel Combobox keystrike
- break into an invisible instance of Excel
- How can I set a text box or label to show the vaule of a spinner?
- How can I set a text box or label to show the vaule of a spinner?
- Macro to give different outputs dependent on result
- Excel 2007
- Hide a cell so that users can't see the contents
- Loop to tidy up my code?
- Doing a LOOP for multiple columns, help please...
- if then multiple sheets and values
- Unhide rows error
- Column value
- Listbox Properties
- Adding current date and contents of a cell in the footer
- Sendkeys to paste excel worksheet object to powerpoint
- Fixing Rows...Help please..
- Paste from Word to Excel
- suspend processing for TextBox_Change events when initializing a f
- SaveCopyAs changes SheetName
- Excel formula that adjusts to new columns as entries made in cells
- Combo Boxes
- Filter and Delete all rows with a date greater than or = today
- Reference value plus 7
- intersect
- adding code lines with vba code
- How to get the last row in a column without selecting
- Mulitplication within an "IF" statement.
- Creating a procedure using VBA Code
- Auto Update files for just this run of code
- Accessing External Module
- Wizard pages not hiding when go to next page
- Passing criteria from one Excel Query to another
- Shorting the Code
- PICTURE TROUBLES
- Copying sheets without copying named ranges
- Save As File Format
- Specify chart template size
- Rename a worksheet to use with a pivot table
- Paste object from excel to powerpoint
- formula with percentages
- Calculate text strings
- Merge several fixed width text files into one
- Is Excel compatible With VB 2008 Express Edition
- Cells.Find
- Conditionally Disabling Optionbuttons
- Calculate total days
- IgnoreRemoteRequests & multiple Instances
- VBA Code to Insert Borders Along Automatic Page Breaks
- Removing duplicates
- items in pivot's page section
- Resolving "File Now Available" Read-Write dialog at end of code
- MACRO FOR DELETING DEBIT AND CREDIT FIGURES ROWS
- change email page color
- Advanced Filter is unstable HELP
- Form Control Drop Down Lists
- Copy from an application
- Disable Paste in Excel 2007
- SetFocus method
- Using "Custom XML" as a datasource
- Video tutorial for programming Excel macros or such
- HELP! Writing Text file from Excel Spreadsheet.
- Copy data into blank cells
- Protected cells in Protected sheet
- Name of the current pivottable from active cell
- Changing Category (x) axis labels for radar charts
- Reference Sub from another workbook
- Variable variables and sub routines
- Problem with Error handling in loop (with find)
- Trying to copy data from one workbook to another
- Creating a macro to paste in a specific cell
- counting filtered items in PivotTable
- VLOOKUP works but gets #REF when macro changes formulas to values
- Excel Publish Event
- IFERROR(Vlookup) question
- macro queries
- MACRO TO DELETE ROWS
- Will accounts 2008 export data to excell as well as import
- Recording a Macro
- Changing Toolbar Image
- IF(NOW()
- Excel automation using VB Express
- subtotal bold
- Whats wrong with my code? This is a real challenge...
- Setting a Control Variable for a listbox
- Calling a macro in excel
- IF statements
- Download a spreadsheet with VBA
- Run Time Error, FormulaR1C1
- CopyPicture method (# 1004) failed
- Protection Macro
- Retrieving Pipe (|) delimited text file into ADO Recordset
- Dbl-Clicking anyfile.xls = excel basic grey screen
- Saving a worksheet to a new workbook
- Macro to display pictures
- checkbox1 value = true if range got data
- Excel to Access
- Delete Duplicate Rows, by Date field
- Error in loading DLL
- Re-entrant call to VBA
- put textbox data in sheet (sheet name selected in a listbox)
- label caption
- Macro writing formulas
- Use workbook name in Connection
- Search multiple strings in one text file
- UsedRange and LastCell feb08
- Can UDF modify worksheet(s)?
- list sheet tab names in listbox
- link textbox to cell
- Macro to Convert Data to Different Format
- Excel Autofill Showing Mondays ONLY in a calendar year
- Has Microsoft fixed Excel's Dependents bugs?
- Paste Macro
- VBA Click a link
- Triple Filter
- Formula Madness
- Automatically starting macros
- Oracle ODBC driver password
- 2007 Status Bar in Excel 2003
- FORMULA TO MINUS TEXT CHARACTERS
- reference to another sheet not in wkbk brings up dialog box
- cell range
- Calculating column 'J' and offsetting result in column 'L' on nextblank row (continue to end of sheet)
- macro question
- Stop VB from deleting modules from wrong file
- Selecting current range for pivot macro
- Why does a find wrongly return true when I search a variable?
- Code execution error
- im sorry to even go as far as asking
- worksheet cells displayed on a user form
- Export/Import custom toolbar
- Links to Update every 10 seconds...
- Changing of Sheet Codes for the worksheets...
- transpose cols to rows excel 2003 looping macro help please
- View a non-Excel file whose name is in a cell
- WAV files
- 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
- Select all rows in a date range
- Active Workbook
- excel help with min() fn reference
- Pages
- Convert GEDCOM file to excel lists
- Data form errror
- Identify a change in computers
- Average row of Data using VBA
- to print or not to print...
- unlock cells if value is...
- Macro runs in another workbook if you open simultaneously
- How do I get Excel to stop publishing?
- Casing of built-in property Font.Bold
- is it possible to have a common macro for Multiple workbook
- Form in excel
- Macro to delete 2 rows every 500 rows
- How to return the color of a cell
- Insert value in text box based on previous tselected value.
- Help with code
- Prevent Worksheet from being deleted
- how do I reference a cell in a previous sheet not by name, by orde
- Using VB instead of function for INDEX
- Is this macro scenario possible using VBA?
- my first macro - super simple for any veteran... help appreciated!
- Cancel Key Press Event
- Adding a Name range with vba
- give value of next column
- DirectDependents not working properly.
- Worksheet add
- Restrict access to only one sheet
- Set up shared bililng spread sheet
- What's the difference between .Dependents and .DirectDependents?
- Creating a truncated range- Speed issue
- Animated Gif89
- Control desktop Icon
- vba problem when grouping sheets
- Count mails in Excel
- How to Create an array
- Chart VB Code Syntax
- Printing x amount of pages if cell is greater than 0
- How to save existing Workbook with a new new name, without changingthe open Workbook name?
- RangeName Define Limitations
- Find and Replace
- How to undo ClearContents?
- dll File
- NumberFormat
- Worksheets("Sheetname").Select refuses to kick in from User Defined function
- Loop to Filter, Name Sheets. If Blank, Exit Loop
- close pdf file before closing excel
- Loading a formula from VB
- Paste a function using a Macro
- Code failure with different partitions
- Copy pasted name range
- Set Visible Cells To TRUE
- Application.AutomationSecurity stops calling macro
- Creating a button to execute a macro
- Type MisMatch with Set Statement
- Quick sort problem
- Looping thru sub-level of controls on userform
- Macro on Hidden spreadsheet
- Calculating Column and off setting calculated value to another column
- Error when opening up file in Excel 2007, but not when opened withExcel 2002
- Range help
- Include Blank Value In Validation List
- a slight syntax error...
- Help with Calling a subroutine in the ThisWorkbook Class
- Macros acting on a filtered list
- cond. formatting - border thickness
- How to "Scrape" currency conversions off web... Maybe using Google
- VBA Help
- forms toolbar greyed out
- Coverting strings to numbers and trimming trailing zeros
- IF formula?
- Get text from clipboard to string?
- Export to CSV via macro does not use local regional settings
- Macro Doesn't Run With Command Button, But Does Run With F8 Key
- Help to align FORMAT
- auto inserting thumbnails into an office program for web use
- Determine drive
- reference for OpenFileDialog
- Hyperlinking cells and macros
- How to feed a userform a variable to display in a textbox?
- Copy an entire row based on value in one cell
- Command Buttons
- Opening a csv file stops macro
- Compute length of a string in points depending on current font
- Protecting VBA (Excel) code
- How to interrupt code
- Need event for selecting a series on a chart
- Emailing a userform with its values
- Concatenating and Copying columns from 30 sheets
- Changing Excel charts pasted into PPT 2007
- Re: Chart Text Box
- Two macros at startup excel?
- Adding Column A for All sheets : Please HELP
- HOW TO MAKE A LIST OF WORK SHEET IN WORK BOOK IN EXCEL 2007
- 'INDIRECT'ly referred cell's own simple formula fails....
- What is VBA equivalent to Tools/Auditing/Trace Dependents?
- Add new record to Access using VBA in excel
- find location
- Relative cell value in function
- trading system and filter test
- Excel 2007 Print Preview button disabled
- Re: Quicker Counting
- calling VBA from EXCEL
- Vlookup that checks against two values
- Trying to Send a Keystroke to a specific Window
- tuncating a table in sql from excel
- Restoring Attached Toolbar
- Copying headers and footers between sheets
- Data to be transferred to new workbooks
- How do I create mathematical links from workbook to workbook?
- vba password protection
- Populating Values In One Table With Values From Another Using VBA
- import .pdf file to .xls
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.