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 |
- Automatically print many PDF-files based on a list in excel?
- Listbox selection creates form
- HELP TO COMBINE MULTIPLE SHEETS IN MULTIPLE WORKBOOKS
- Convert Percentage to number
- Sort Issue
- Calling same event for all the toolbox controls in the sheet
- Restored XLS password protected file, but now corrupt?
- Changing links when protected
- 0 entry vs blank cell
- Linking website to Excel
- Prevent other users from selecting next available auto-populate cell
- Break Scheduling based on Input of Calls Volume
- Reset data entry fields to 0 or nothing
- Increment Alpha Numeric Cell
- Compiler Going Flaky on Me
- Prevent Screen from flicking from one place to the next
- Color input vs formula cells with 1 click
- Auto_Open Frustration
- Exctracting Literal Value From A String Variable
- Exctracting Literal Value From A String Variable
- Compile error HELP
- case of the data
- default printer print quality list
- Open unknown file name
- Keep Before_Save from running
- adodb connecting to a server issues
- If one column is full, goto the next column
- macro to delete duplicate rows using Filter
- Input Title on MsgBox
- Stock Charts
- Increase date by on year
- Excel html workbook
- Comparing Dates - Generic Function?
- Data too large for Excel, need to query Access data for results
- How do I close a file system object?
- Copy Data From Cells To Array
- How can I modify the SELECT statement?
- Cell input mask
- Addin has problems with the ActiveX security warning
- Create Macro Dynamically
- can't delete columns
- Best practices for pulling data from a network Excel file (mult users)
- How can I execute this query?
- Exit Sub is workbook is not protected
- PivotSelect
- Validation not triggering Change event in Excel XP
- Can I merge an excel list to an excel sheet like mail merge in wor
- Pasting Dates from Clipboard of Web Page to Excel
- Validation not triggering Change event in Excel XP
- Range Name and VBA
- script to import parts of txt file
- EXCEL file corruption
- Function not working (but works as a sub). Any ideas?
- DropDown
- Summing multiple hits using match, offset and index method
- Change Range & Row
- Macros and Printing Footers
- Delete data if not within date range
- Return a row with the Min or Max funtion
- Quick Simple VB Snippet Needed
- Error Handling for Duplicate Worksheet Names
- Exit Sub if sheet is hidden
- Sheet code name
- simple excel macro Q
- Sorting an array
- excel not calculating
- Showing Userform
- Fixed Asset/Depreciation formula
- Programming question
- Multiple cells in cells function
- Delete all pivot tables on a sheet
- Visual Basic to Control a Citrix Connection?
- Open Excel using Access macro
- Copy data from IE to Excel
- Excel Automation
- Removing rows from a excel spreadsheet using a vb script
- Incorrect syntax near '#' problem when returning to MS Query fromExcel
- remote query & date range?
- Increase Column Heading Part 2
- Checking usewr has input a valid address
- Control WORD from VBA EXCEL. ¿How can I erase data?
- Reading data from a cell to a text box
- Checking user has input a valid address.
- Range issue
- Macro to create a comment with contents from Paste
- Increase column heading letters withing routine?
- How can I do amalgamate 3 select queries and then get unique entries from the result
- Have 2000 and XP versions on same machine?
- Error Message When Using Replace
- NEED HELP! - Excel Object Model & .Net Compact Framework
- Selecting the right cells....
- XML downlaod through visual basic - tag problem
- How to store custom data into Excel cell
- If cell is text, then
- how do I make a counter cell in excel
- Excel User Conference - Atlantic City - April 2006
- Passing arguments into function to bring data array from closed wb
- macro to display items of a same type
- Creating Pop-up Info Boxes
- Subscript out of range
- Fixed Length Text fields
- How to copy and paste number formats only?
- Sub halts with Run-time error '-2147024809 (80070057) specified value is out of range
- Creating Hyperlink in excel 2003 VBA
- hyperlink in excel vba
- Data validation within a userform
- Problem with macro to email file using CDO
- Pivot + Macro
- How to Delete a Range in Closed Workbook
- Handling 2 workbooks
- New to programming
- http post from excel - user authentication from excel to web
- Getting the image selection using VC++
- Summing with Dynamic Data
- Import => New web query
- How do I paste a source data reference to a chart using a macro?
- Connect to internet
- emailing using Excel VBA
- Display Alerts
- ActiveWorkbook.SendMail not working
- Column Searching
- UDF & Add-in Issue
- Duplicate Row
- automating flowcharts in excel
- underline size 1/4 point
- Run Macro after value change from drop down list
- Code Erasing Cell Contents Inappropriately
- Excel DataAlchemy Menu
- Loop using Month() and Year()
- Scroll bar increments select case?
- starting from bottom of range instead of top
- File SaveAs
- Fields in access database
- Fields in access database
- Multiple files question
- Version makes the difference?!
- Unloading a Form
- macro to control printer settings
- Save or SaveAs Macro
- Copy data from a range in a workbook based on a value in another
- Version problem?
- Adding time selection to pop-up calendar
- dates and times in excel
- Reserved Names in non-English Versions
- Reserved Names in non-English Versions
- Sum totals at last row
- Custom Checkbox control in Excel
- Re: copying worksheet
- Excel Calculation Question
- Increment Alpha Numeric Cell
- moving to next cell in range
- V Look Up Annoying Function Help Needed
- Combine csv files
- Reserved Names in non-English Versions
- Summing figures generated by formulas
- adding a page break in a pivot table
- Reserved Names in non-English Versions
- mouse click event?
- Find/Copy Variable length range
- The Monday of the previous week with VBA
- Need help with code
- Built-in for Selecting Ranges?
- Looking for a way to avoid many If/Then statements
- Reference A Combobox On The First page.
- Copying A Worksheet Only, Excluding the Code
- Save just a worksheet from a workbook
- VBA User Forms
- new macro problem with password protected worksheet
- VBA formula building
- Not understanding with/end with
- Adding More Conditional Formating
- Un hide non empty columns
- call a "dll" in Excel X for mac?
- range, cells won't work
- delete defined names
- Autotab does not always work
- error 438
- Great Code : Need Modification - VBA Save Button
- papersize
- Invalid Picture error for new users.
- Excel add-in with modeless dialog
- New to VB...any good books?
- Very new to VB...any good books?
- File name varible problem
- Sum Range and enter results in the last row of the column
- counting dates within a rnage
- Increase the date/time in a excel table
- Reading data from a list box
- Tracing problems with macros
- Excel automatically starts another sheet when calculating formula
- Multiple sheets, one user form, and a unique ID
- Stuck on Formula
- No toolbars when viewing through IE
- Function wont work!?
- trouble adding to list.
- Min but not quite...
- Drop-Down Macro
- reseting adodb commands? help please
- MsgBox in Enter event causes combobox not to run Change event
- reusing a recordset for a pivot-table?
- Bit of a VBA problem.
- Stopping a Macro
- UserForm Show problem
- formula in VB not working
- Changing digits in a cell
- Transfer to adjacent columns
- How to clear the clipboard contents in VBA
- Hit a button with VBA code
- Paste bitmap to Excel
- print macro
- Re:Creating submenus....
- I am new to excel programming, can you help please?
- xml bug
- create an outlook reciepient in excel VB without getting an error
- Import from Sql Server
- Fast Data Processing
- Move data from on sheet to another keep duplicate rows
- Change Macro
- Creating Submenus
- Creating submenus
- Cut, paste and delete
- XLL Memory allocation problem
- updating log
- updating log
- Worksheet function?
- Repeat macro for all open workbooks
- Excel / Word Interaction
- Count Data Within Range
- Getting user to enter file name
- Spreadsheet in a form
- Open Command
- userform and formula
- Lookup-function does not work
- Formula with arrays
- re: imitating cut and paste - #REF! problem fix
- Changing cell colour in Range
- SpecialCells and Names
- Error with calander
- Step by Step Macro Help.
- doubleclick to make cells move to another cell
- Refedit Control
- looking for an excel template that will simulate a bank account
- Row Color
- Data validation function and drop-down lists
- message for tom ol
- Calculator in Excel.
- validating numbers n text in same cell
- Inesert value of column B of the current row into active cell
- I try it again. Howto. Proposed Filename and path different by the default with VBA
- Simple request
- Script fails in Excel was okay before.
- 3rd Party toolbar to automatically enter code within VBA
- help on triggering macro if cells change
- Import/Copy some data from one workbook to a similar workbook
- Help Please - CountIf and Array formula
- Count question
- Adding a comma after an int field
- vb code to save a spreadsheet to file
- Error in Macro: "Method 'Paste' of object '_Worksheet' failed"
- search and deliver
- Expanding a Selection
- extending this formlar
- combining and copying
- Timed and blinking messages
- extract hidden date
- valadating a data match
- Can I use "or" in a select case construct?
- Date Validation for Date of Birth
- Page Setup.
- Filling Array with uniqur random numbers
- Help with a macro
- Protecting and Hiding Formula
- Class Module Question
- Working with dates
- Mysterious Error 1004 caused by AutoFilter?
- Detecting conditional formatting
- Machine work load
- question about exiting a procedure
- Copying Autofiltered cells
- change sheet codename
- Why does Excel ask me to save changes?
- copy a workbook outside of excel
- AutoFill on selection
- concatenating a number plus a formatted number
- Why WorkbookBeforePrint doesn't run?
- Excel should update trendline equations when data is altered.
- why If, THEN does not work
- Macro to identify year within a date
- Move worksheets to a new workbook
- inserting decimal two places from the right
- USING OUTLOOK FILED ONEXCEL
- Is the cell really blank?
- If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
- every nth value
- Help! with Macro - delete entire row
- VBA version of ISBLANK()
- how do I call specific worksheet
- ipf.value question
- Calculate the Number of Subsets
- import .wmf->Excel 3?
- Combobox rowsource
- Mailmerge from a button in excel
- See old posts
- Calling Bob Phillips - Please
- Worksheet Protection
- Listing combinations in excel
- Save options
- Choosing default path/filename in Excel with VBA
- Context menu of Cell
- Secundary Axis
- macro to find date in the string
- UserForm TextBox with fixed Width and dynamic Height
- macro to merge cell
- Listing multiple rows on other worksheet
- Opening an Excel file from a Userform
- Retrieving Values Saved in Names
- Find text in a string that matches value(s) in a range
- Locked Cells Problem...
- VBA Forms in Excel crashing on exit?
- Copying data from a listbox to a textbox
- Is there an easier way of doing this??
- Creating a Backup copy of workbook
- Checkbox and inputing answer into a specific cell
- Inserting cells
- Web-Based Pivot Tables Refresh Question
- Programatically creating a toolbar to run macros
- Create a subfolder
- xlstart folder
- Why do Template names increment ?
- Need help
- how to print list of all worksheet names in a workbook?
- Collection - object required message
- displaying data from a range
- Message Box
- Using FormulaArray in VBA
- MsgBox in ComboBox Enter Event does not allow update
- View limited sheets in workbook based on logon/password protect
- MSQuery Optimization
- Activating a macro after a cell is updated
- minor but irritating problem when generating Excel files with Perl
- Variant userform problem
- Stochastic function macro
- Data validation cell default
- Copy spreadsheet into another file.
- Programmatically determine Chart's data source
- reporting services
- Userform into Web page
- Application.Run and VBE "phantom" projects
- If statements
- Checking for open file
- Move to bottom of table
- Excel Workspace Save trouble
- How do I combine multiple workbooks in Excel using a Macro?
- Automate Excel upload into static Access Table
- Adding a folder with code
- Comparing and updating worksheets based on cell content
- Not finding value, range method failing
- Macro Help
- Excel vba print file to pdf (Problem)
- Application.FollowHyperlink Query
- formatting decimal places in code
- Key Press Event
- Get a specific Program files folder
- How to get print area borders - UsedRange not correct.
- Hello I am a newbie and need help
- Cursor Movement
- Custom textbox in Userform
- Compile Error: Block If without End if
- input of single value into multiple cells simultaneously
- emailing a userform during runtime
- Digital Signature Email
- VBA Project Not Viewable
- Hoping its an easy question
- 3D Sumif - help using!
- Using forms?
- worksheet function for InStrRev()
- Selecting data from another workbook
- Use VB in Excel to close open Word Document
- Create a toolbar button
- recognize a sheet
- Source for toolbar for code within VBA?
- Can I make VB programs external?
- Calculating ELO Rating (UDF Query)
- Workbook security question
- How do I generate a report in Excel?
- two questions
- Delete File in a folder
- 2-column combo box via code...
- April 2006 - Excel User Conference
- Windows File Dialog box problem from "Office 2000 VBA Fundamentals
- Copy from Excel to bookmarks in Word
- Select a column based on a index
- Copy method: How to remove dotted frame
- calling oracle stored function with CLOB parameter
- Msg Box input string
- Msg Box input string
- Need help with chart
- Circular reference in an open workbook
- dim statements for worksheets array
- Loops & Ifs
- AutoCalculate at Defined Intervals
- macros -"OK buttons" part way through ?
- Traffic Lights
- Problem with Lookup-function
- calling an oracle function from Excel
- getting a horizontal scroll bar in listbox
- Easy question
- installing an addin
- Pivot table refresh error
- Problem with application.getopenfilename
- line delete interception
- Clear Clipboard no longer works
- Create "Name" in UDF
- Problems with SUMIF in Excel
- Refresh of data
- How to get number of working days
- Problem:Query Cell contain Formula from QueryTable is always get old value
- Conditional compiling between Excel Versions
- querying a spreadsheet with formatted cells using ado
- Inserting a Value into a Range
- Macro / Sort error
- top 5 number is LARGE function with N/Afields
- Textboxes and ComboBoxes
- Wrong Settings Or Something Else
- Update data wihout opening the file?
- Digital Cert Error
- Revise Macro from Worksheet
- tutorial-venn diagrams?
- code with eomonth problems
- Application.FileSearch challenge
- formulas
- UserForms stuff
- information on protection for excel and macros to allow scroll bar
- A Huge Thank You!
- Code Conflicts With Worksheet Change Code
- Do I have to close an odc in a macro?
- Consolidate - edit code?
- Footer Page Number Question
- drop down list in excel
- Re: External query of SQL server
- Cell Colour based on text in Range of cells
- Re: Cell Colour based on text in Range of cells
- Clear a sheet
- Out of Memory Error
- excel freezing
- Need some advice on the following code
- Inputing a " within a "
- Hex2Dec and Dec2Hex don't work
- Preventing code continuing running
- Worksheet copy with rename
- Named range, maximum characters in RefersTo property
- get cursor position when clicking on an image
- Copy all sheets into 1
- Macro run from If Then function
- Copy contents only
- the ' symbol ends the SQL string, how do you replace it Excel
- Protecting Sheets, automatically protects the workbook
- excel formula
- XLL and user defined function + xlcFormulaArray
- Selecting columns
- Link spreadsheets
- Looping through each element of an array
- nesting for 2 dependents, and 4 formula options
- User forms help
- A computer with morals?...it doesn't want to "kill"
- Runtime error 1004
- Value over Mouse
- Unable to set the orientation property of Pivitfield class
- How to open the //Text Import Wizard// from within a macro?
- Word 2003 Find/Change Automation from Excel 2003 crashes Excel 200
- Again Filter:
- Moving some cells.
- Populate Range
- Refreshing Pivot tables link to a SQL Server
- Workbook size has grown
- how to identify a cell address
- 3d Sumif
- Using VB In Excel
- Keep macro running overnight?
- Macro to round highlighted cells to nearest hundred
- How change unprotected cell formats on protected worksheets?
- change fill color of a range of cells based on color of a cell?
- Elapsed Time in Hours, Minutes and Seconds
- Create/Write to an Excel File in a C# Windows Application
- Pivot row order query
- Insert Col data into single cell
- hide and show columns using one control button
- Check for blank arguments WITHIN Macro - how?
- Looping through Cells
- Project data exported into Excel
- Deleting Certain Rows
- Need help with Nested IF - How does Excel read
- Moving Data
- how do you get a drop down list to equal a value in a separate ce.
- locking vba code
- Help generating combinations
- I have been pointed in the direction of a checkbox event
- Week number converted to date
- using if statement to compare text
- Keep dbf format when opening dbf files in excel
- Code to protect sheets, protects work book also?
- massive sorting exercise!
- optional args in UDF
- Fill in the blanks!
- popup box
- Fill in the blanks!
- Fill in the blanks!!
- pop up box
- Sending Email
- Select Cell Range
- Excel VBA OR statement
- List all values of a column
- Save function in VB
- Help with range
- Disappearing charts
- extend vba code to other sheets
- downloading data
- excel add-in
- password
- RangeName blocks of data
- writing formulas in VB - referring to the values contained in cell
- importing .wmf from CAD pgm?
- go to today's date
- Centralizing Vertically of Label and TextBox
- navision sales data from excel vba macro
- Keeping an add-in loaded
- Form Tab to text fields Excel 2000
- excel macro
- Adding formulas based on range names
- referencing external worksheet (named) in sharedrive
- Return Exact Value
- Calling a worksheet via a codename
- Calling Macro from Workbook_BeforeClose
- If...Then...query
- Deselect cells with formulas in selection
- Searching for spanish/italian-translators
- Quotes in Macro Formula
- How to show help for functions defined in addin worksheets
- Adding values to a cell based on entered data
- How to check from VBA if sheet exists?
- Create non-contiguius range "IF"
- cell color macro doesn't work
- Search for specific value
- How to search for zero in sheet
- CDO Query
- help for macro for formatting pie chart
- Imbedded .pdf or .doc files
- Zoom in on selected picture
- Compatibility problem?
- Excel Pivots!!
- VBA Option Button question
- Using specific columns of a dynamic range
- Sub to extract path from hyperlink formula and insert picture into comments
- Mail Merge problems
- Save As File Type
- If workbook is open, save workbook?
- Return Path of selected item from dialogbox
- Execute Code
- AutoFormatting Style Selection
- onAction events on NewMenu
- sorting a listbox in a user form
- MultiDimensional Dynamic Arrays
- No of rows as Range
- A better way to copy and paste special between worksheets
- Incorrect resolution when printing.
- Position independent code
- copy cell
- Is there an easy way to make Excel update Access, and vice versa?
- How to import data from a foreign DB TO a combo box?
- Programmactically add calendar control to userform
- Help with VBA code
- SQL queries from CSV page in excel
- Getting non-Excel file properties
- How to know cell's address from Excel Query
- Deleting several cells at once causes a VBA error
- Manipulating Numbers
- Hardcode links - loop through sheets
- SQL stored procedure using values from cells into Pivot Table
- VBA password
- Calling macro from a different moldule
- Sorting database with images inserted in cells
- how to Run an Excel Macro from ASP
- how do i use array of values for dim statement
- search of first #N/A position
- Save active sheet into new workbook
- "Static" Behavior without Static Defn
- Copy data without opening file
- change cells on cell change
- Delete Worksheets Prior To Access DoCmd.TransferSpreadsheet
- Update Links - no prompt
- Update Links
- VALUE FROM DIFFERENT SHEET
- Array vs. Cells
- Stop code from running when I click "Cancel"
- Create excel chart from LotusScript, change xlLine line weight
- Use a macro to create a desktop shortcut?
- How read a csv file to load named cells
- Error Trapping
- VSTO running unattended
- xlDialogSaveAs question
- 3D Sum
- Pop up box/form before save
- Compare worksheets and populate based on match
- Auto advance to next field -tab key AND option button to reset fie
- Populate userform listbox from access db
- Working on FindPrevious command in a userform
- Conditional formatting
- combos and dates
- hex2dec
- conditional sumif
- creating userforms(urgent)
- In need of VB some assistance
- Deleting Rows
- Help understanding truely strange error involving access query and filling cells
- SheetChange event crashes using Range.set_value (C#)
- Output array to Excel blank rows separating groups
- Extensibility Library
- Error 400
- Sum of rows Column wise - Strange behaviour
- How to set the Column Header value for list box?
- SOS: Connecting to External Application (AS400C)
- Loop and AutoFill
- Create Outlook Distribution lists (default txt file) with excel
- F=$100, G=$-100, cut rows & paste in new sheet
- For, Each, If, Loop?
- How to use TreeView control
- How do I create a macro that prints to any default printer
- using the value of a macro variable in a concatenate formula
- who origonally wrote the workbook?
- Conditional formatting error, odd!
- Excel 97 - xlNoSelection - problem
- How do I hide the form?
- Sorting Data, Text and Numeric
- sumproduct using 3 columns and using (LEFT wildcard)
- sharing violation while saving file after adding this macro
- copying from multiple worksheets
- Try-before-you-buy version?
- Align labels and data together
- set cursor with api
- SQL question
- VBA with Select Case problems...
- Insert Blank Line after the Word Category is found
- Application.DisplayAlerts = False - Not Working
- Events in a Userform
- Help with a option buttons located in a userform
- Code will not fire
- Locking Specific Cells
- Text only in toolbar buttons
- Merge 2 pieces of code
- traverse until non integer
- Selecting a dynamic Range and sorting
- Split text , uniformly paste in rows and columns.
- Reading Excel Spreadsheets in VB.NET unattended
- UDF to compute using ranges
- Copy/Paste Macro
- Replacing
- Backward compatability
- Need a slight modification to code
- Avoiding sheet deletion by VBA
- Possible bug?
- Open Workbook using URL instead of network path
- Custom Sort
- Send mail problem in Office 2003
- Dreaded 911 cell character limitation
- Error 1004 occurs only in specific cases
- Last used cell in a column
- variables inside a formula??
- FileSearch behaviour
- Need to have control of the calculation to specific ranges
- Using common VBA code for a series of Woorkbooks.
- Replace pieces of text
- Code for Printing All Filtered Rows Separate
- VBA front end for Excel
- Why doesn't my simple macro work?
- Inconsistent Operation of SendKeys Command
- Protect Worksheets
- Excel User Conference April 2006
- Help! macro needed to join two worksheets, using a coloum on each sheet to pair entries
- Change cells inside a function
- Database library methods in Excel VB
- concatenate locale bug?
- Re: all filenames on A:\ into Excel?
- Calculate doesn't work right
- Hide Macro
- Define a variable for dynamic chart
- crate group of date, with Dynamic Range in Pivot Table but not wor
- counting cells using multiple criteria
- Hyperlink
- HELP! Calling subroutine in different workbook
- Deleting rows
- Custom function to simplify vlookup formula
- hOW to retrive the Data after did UPPERCASE
- Doesn't work as it SHOULD .. Rows.Hidden /with SpecialCells
- draw 999 x 8 random records from file with 8614 records
- Microsoft request for slow-calculating workbooks
- Custom FaceID's for Custom Menus
- auto insert
- Compare shapes for obtaining a value
- Header using cell data
- Eliminate DataLabels created upon eachother, not readable?
- creating controls using code
- How can i email the contents of a userform?
- IF function
- text to column
- Hiding blank rows
- automation error
- Find end of week and insert Data
- Register Calendar Control and Network Drive
- Calculate,Copy, Paste Cell Group Macro Adjustments
- VBA to Select All Visible Sheets
- formula help to get oldest date in column based off another parameter
- Best way to pause?
- Resize Named Ranges Help
- Enum type variables
- Excel "Insert Formula" dialog always call my user defined function
- Le dialogue de fonction d'excel appel ma fonction "user defined"
- received message: Can't enter break mode at this time
- create new column with last name
- Toggle Code Calls
- Status Bar Font/Color
- Copy data thru searching all drives in PC
- How to use more than one databases in a macro
- web query in VBA (format dates in url)
- Help with copying dynamic column selected based on remote cell value and dynamic formula fill
- Using CDO and trying to add multiple attachments...
- VBA code to check if another window is open?
- Need help with row color
- Save Cell Properties into an Array
- AutoExec Code to Open Template Dialogue on Startup
- copy from sheet 1 $a$1 and paste on sheet 2 $f$2
- Quotes in .formula calcs
- Rename active sheet to contents of specific cell
- Regular expressions
- How to define a range based on first and last cells with data?
- SHDOCVW in Worksheet
- What book is the most efficient one to study Excel VBA
- Hide the current month columns
- How to do this?
- Hiding row and column headers, scroll bars
- Looping across two parallel ranges
- Find next time in a range
- Identifying the first date(s) from a list
- Output the range
- Select failed?
- Sort hyperlinks by time
- Format
- newbie range question
- Format Subform
- How do I set up a macro to save an Excel worksheet as a .prn file?
- Command button help
- Write 1st and 2nd dimension array values to cells
- copy if checkbox checked to sheet two
- Subtotals in wrong positions excel 2003
- SCRIPTING
- How do I find max/min around the perimeter of a spud plot?
- Code for auto filling in Excel based on number of months, & start date
- Excel VBA to VB.NET conversion
- Excel VBA - Linking .hlp help file to Function Wizard
- Identifying workbooks with links to external file
- send all over to word
- UserForm when opening workbook will not fill screen
- Excel sorting in VBScript
- VBA Bypass Delete Sheet Warning
- Need help Editing Ron de Bruin Script
- Hyperlink to VB Module
- URGENT ASSIST NEEDED IF POSSIBLE RE VLOOKUP/MATCH
- Excel 2003 ListObject question
- Keyboard Shortcuts
- sending email with Outlook using Excel
- Error 0x800A03EC when trying to populate a worksheet
- command button that puts specific numbers in a range of cells
- need help with 'counting' between values
- VLOOKUP but return a different row
- Opening Excel issue
- vba user defined function help
- Save a workbook using FileFormat in .txt but with data in csv for
- Allowing user to choose what mathmatical operator macro uses
- Saving contents of a Userform to another file.
- Edit/Replace from Table
- Scroll bar starting at bottom of form
- Creating a conditional screen based on multiple criteria
- nested if
- Borders around cells...
- Import HTML table
- I'm trying to do a comparison if statement but it is not working!!
- Changing the Office Assistant
- Printing document from code
- Conditional Formatting Cells
- How to add a row
- Simple Count problem
- Ole Links (C++)
- Excel file access ole object
- Excel Not showing any result after Automation
- Accidents Per Million Miles - How do I write this?
- Event procedures for spreadsheet cells ?
- Back to original Formating
- looking for Excel VBA work
- Sheets Tabs Function
- Function for simple code
- Auditing cells: Find "dangling"cells
- problem with double value
- workbook_beforeClose
- Copying Macro
- New to macros, need to update worksheets
- Conditional formatting
- consolidation of tables in excel with text and figures
- is there an "if for each"?
- Using variables while running macro
- listing all sheets in all workbooks in a directory
- consolidate data, dynamic ranges
- Blank Cells when Sorting
- Saving file using Explorer Style box
- HELP!!! problem with list boxes
- Start a Macro within another Macro
- Please help
- query: print dialog with entire workbook set
- Can you filter sheet of data & on another sheet make four groups under each other?
- Paste doesn't work when module is created
- Can you create dynamic named ranges containing array formulas?
- Hyperlinking to a Glossary
- hi
- Using ADO with Excel
- Server swap & ODBC DNS refreshing
- Print a Hyperlinked HTML file
- Copy row to another sheet on each day
- excel crashing after deleting shapes
- Multiple print areas
- root file path
- On error...
- Unable to get last filled cell address from Range.End(xlDown) method
- Unable to use Range.End(xlDown) method
- Y TestBox don't Change?
- Loading information from a VBA project to spreadsheet
- Loading information from a VBA project to spreadsheet
- Starting Excel from Word
- Automatically update column with weekdays
- text to date
- Setting print area to text
- code to copy excel sheet from 1 file to other
- Regsvr32 + calendar control + network drive = confusion
- code to create new excel file
- select method
- what is itemdata equivilent (if exists)
- How to select a specific column with Excel VBA
- code wont compare negative numbers correctly
- Need macro to clear contents
- help! trouble with triggers...
- PDF. If you know.
- Zero fill, no decimal, need postive/negative sign
- Find and copy the row using VBA
- Hyperlinks to =Hyperlinks formula - Challenging
- link a graphic to a cell
- Range WrapText and AutoFit with Bold
- using both sum and average in subtotals
- Remove or Edit a set of custom preferences for Excel
- Setting PageSetup Properties in Multiple Worksheets
- How to access MSSQL table in a user defined function
- Formatting a List in a Combo Box
- Named Ranges
- Is there any way to change the name of a Module?
- Can't select
- Loop help please!
- Insert "Weekly Subtotals:
- Yet Another VLOOKUP issue in VBA
- Multiple parameter database query
- "trying to access e-mail" when worksheet opened
- Allows users to only paste in cell A1
- listing all sheets in all workbooks in a directory
- Showing Hyperlinks in another column
- Creating a "Search All" function
- Updating a dropdown list from SQL server
- Error when adding web reference
- Cell Text Search & Insert Value in Next Column
- Dropdown with all tab names
- Importing cells to new worksheet
- Need to consolidate multiple ranges
- Open a picture based on Excel Value
- Find last used row in Range with Data above and below.
- Deleting empty rows in a worksheet
- wage mulitplied by hours and minutes
- Prevent deleting spreadsheet
- I need to create a macro that extracts daily files data to a mont.
- Why is my code not working the way I intend it to?
- first day of the current month
- Simple Macro Needs Digital Signature?
- Can I code Styles
- Dynamic summary sheet for a workbook
- Copy
- Creating a menu in code
- excel>keypress retrn of simple hyperlink?
- How to shift the cell based on the location of other cell?
- Control Displays Number Instead of Date
- Excel and Access Performance
- Can Excel produce multiple profiles of charts/tables of row data?
- Problem moving data
- Macro Date Manipulation
- Pouplating a list from an array
- Display the Cell Number of Cell if Value =Value
- Convert date from dbf files
- Paste Append from Excel to Access
- Date Calculations
- Inserting Proc-Call Into BeforeSave
- Refresh Multiple Queries via a Command Button
- Navigate through Computer Folders in Combo Box
- paste a forumla and copy with a macro
- relative addressing in code
- VB type
- VBA showing a specific range on the screen
- How to turn off control toolbox while showing a userform
- Spinner, worksheet focus problem
- Compile error in hidden module
- challange Please Help
- Macros setup deployment
- Disable sheet copy/move
- Macro simplifying - copy rows to worksheets based on values in 2 different columns
- if then loop
- CreateCubeFile Method - RARELY Used - Need urgent help
- has anybody come across this before?
- relative path for const in vba code
- define relative path from xls to xml file
- Excel hangs on "Delete Comment"
- passing parameters to dos from vba..
- Is anyone on here with DVS Reporter???
- Combining all the excle files
- Passing Variable from Sheet to Userform
- Confused about referencing multiple object code rows in other worksheets?
- Display Text and Play Sound file
- Capital & Small Letters
- Activate a web page
- Worksheet exists
- ListBox Populate and Refresh
- Bar code into a form
- Converting Large Text files to excel
- Division
- Retrieve Sender in Calculate Event
- Problems with sheet unprotect
- Convert external links to internal
- exporting a macro
- Subtotals
- help with a macro
- Execute javascript help
- How can I make program of accounting in excel for small business
- Adjust Time
- Help with Visual Basic programming
- How to name a cell
- Is there a better way of doing this?
- select workbook to update
- VBA - Delete row if cell contents bold text
- Search Replace in VBA
- Is this possable
- Animation in Userform
- Formatting text within VBA
- what am I doing wrong?
- dynamic data capture
- How do I copy validated lists
- Commandbutton to Workbook Open
- Isnumeric
- Inserting row based on critéria using VBA
- Workbook Event
- Extract filter items from Drop-Down Automatic Filter
- How to handle automation error?
- Is there a "Select all Pictures"
- Auto populate a cell
- link word to a number
- help, please
- Nested IF statements
- Saving a workbook
- Format all pictures
- Defining a Label
- In Excel, how to select and then add up the best 6 scores out of 7
- parsing blocks of cells for charts
- Insert dummy variables
- Article creation
- searching data thru 20000 records
- Several questions about Userforms
- What is lifetime of public variable?
- Display Text and Play Sound file
- Maximise and Minimise buttons
- how to define a web query in Excel&VBA??
- Multi-page and Scroll bars
- Call SaveSettings
- offset cell position when there is value in a selected cell
- Sorting, one last time
- show icon caption bar in userform
- VBA
- Combobox values used in macros
- Unprotecting Question
- Sheets Array help
- File Extensions
- Picking text from a string
- sum cells in same column selectively based on value of different .
- Hide sheets when book is opened
- Userforms checkboxes and printing
- Integrating Outlook, Word, Excel macros
- subs or functions with user defined types
- If all cells = "OK" then.....
- can OnEntry be limited to certain cells only??
- Paste vs PasteSpecial
- return pageBreaks
- Paste-Special - R/T 1004 help needed
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.