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 |
- uncheck a checkbox with a macro
- Excel 2003 Add-in with C# and VSTO 2005 doesn't show custom menu
- Stop the macro at the end of a certain column #2
- Saving Add-in in Excel 2007 (Global Macros)
- Calculating Age In VBA (Chip Pearson)
- Value in column
- find / findnext question
- Copy selected sheets to new book
- If a cell in a worksheet is less than Q...
- creating number sequence
- NEED MACRO TO GET BALANCE
- Autofilter - delete filtered selection
- How to paste clipboard into textbox sheet?
- Loop Help
- Faster way to read data from old file to new
- Help with passing data
- Trim Workbook Path?
- Find Executable Path with Excel
- Re: Min If function by Part number
- Re: DataBase worksheet function
- Find specific values in three columns of a ws
- RE: DisplayFullScreen=False not working
- Copy logo from sheet1 to new sheet3-10
- Open PDF located in excel with macro
- Update Link Continue prompt
- Need help with IF
- Date in formula
- Printing last entered values
- Re: WorksheetFunction.Match applied on an Array
- Re: WorksheetFunction.Match applied on an Array
- Re: Problem copying from a hidden worksheet (data is copied, but alsoadditional sheet info)
- VBA code with and / or statement
- Converting Excel to TIFF
- Re: Problem copying from a hidden worksheet (data is copied, but alsoadditional sheet info)
- Excel 2007 Range.ServerActions Property displays read-only data
- Protect sheet and still copy
- Range Name
- Re: DisplayFullScreen=False not working
- Re: Difference Between Range("SelectedRange").Value and ActiveCell.Val
- Re: Image Loading
- Copy values only
- Re: Code to find specific number and calculate
- Re: DataBase worksheet function
- find max value in one field, return values in other fields in same row
- Can I create a file to send to other's that updates module 1?
- Hiding "modules"
- NEED MACRO OR FORMULA
- timing sensetive code?
- Passing ParamArray to another function converts it to TWO dimensions.
- AVERAGE FORMULA PROBLEM
- return the number of rows
- excel to sql server (frequently)
- Run-Time Error (8000500d) - The directory property cannot be found
- Using parts of a defined range for UDF
- How to "Quit"....Input Box
- Add sheet
- hide worksheet tabs
- Macro to select files and then run different macro on selected file
- Select Method of Range Class Failed
- MACRO OR FORMULA NEEDED FOR CALCULATION
- Mouse Wheel Control with Combo Box
- Calling Excel using DCOM
- Quicker Counting
- Can't Display Userform
- Need help with handling localized currency formatting.
- How to keep a formula from being over written?
- Why does this macro fail (1004)
- Change a field and delete row
- Gauge/Dashboard Charts
- Macros deleted from an Excel,but I keep getting security warning
- Code for Error handling using F5 from debug mode
- Is it possible to send a "variable" to a userform text box?
- please help! Replacing blank cells from a userform textbox
- Pole value of Option buttons
- Template Question
- Combo Box
- find and replace name of links
- Macro or Formula for Calulation
- Click to show value in active cell
- Show which entries in Search Table duplicates or triplicets
- cell update includes original text
- Update excel
- excel update graph
- User form programming help needed?
- How to write data in array to range on worksheet
- Bypassing Excel's FTP login/password dialog
- Sharing/Exporting a custom tool bar
- Programming the Command button
- Fixed or floating command buttons
- Hide sheet
- hide sheet
- Custom CommandBar visible dependent on active sheet
- cell value from different worksheet
- ComparingColumns
- "can't enter break mode at this time" message when adding a projectreference
- Copy & paste...if
- Need assistance with simple Excel macro or code
- c.column returns a number - I need an "A" or "B" or...
- Probably too easy...change range to be one row down.
- Incentive Spreadsheet Problem
- Insert Autoshapes in excel
- Validation list functionality disappered
- Macro to export data to fixed width not saving right justifcation
- Select sheet based on cell value
- no empty values in inputbox
- Deleting a textbox
- Formatting a textbox
- Code not working correctly
- Request for Responders to Posts
- Dynamically load data into a pivot table
- VBE question
- LOCK THE CELLS
- copy cells contents to access form
- Reference to free-form textboxes
- Looking for Help in modifying a code
- Importing from Excel sheet with unknown name
- Adding a macro to copy worksheets
- Execute a Macro from one excel Application to another Application
- Copying of consecutive Rows, one at a time and pasting it in onelocation
- How to count number of different cell formats
- count of dishes that contain specific ingredients
- Ribbon UI onAction causes macro to run twice, with warning
- Hide Column without data
- Looping question
- tabs
- custom error messages
- what is wrong with my fun ,thanks
- Help needed with Error Handling
- Macro links to other workbooks
- Msgbox freezing in beforeprint module
- Essbase Add-in
- Issues with Combo Box change event
- SheetChangeEventHandler Problem
- scroll records with distinct value in column
- Inser row with the format from the row above.
- Please need your help
- Macro help needed
- Excel sheet protection
- limit on the delimited list for Data Validation.
- VBA Coding Question
- Copy Sheet into another workbook
- Sheets.Add Function
- cut and paste into cisco device (equivalent to pasting into notepa
- Create a report page???
- PivotTable: Need to detect when user selects new value for dropdow
- Excel spreadsheet to talk to mainframe
- Cost Sheet
- Excel and Visual Basic
- disable "unprotect sheet" in tools menu bar with VB
- issue when opening a workbook through a macro shortcut
- Macro to delete rows with matching Credits and Debits
- VBA Mod, Excel Floor, etc.
- Macro work - but don't think it is very efficient
- A Two-Level SOLVER ??
- Determining the number of open workbooks
- Accessing Outlooks address book via VBA embedded in Excel
- Options for replacing toolbars in XL 2007
- editing data in a database from a Userform Textbox.
- Calendar on userform is blank
- .IQY loop in VBA?
- udvidelse tabelmatrix
- vlookup or index match
- VBCompononts.Name...
- Stop baby eating in CHINA
- Cell Auto Fill from Range of Cells
- Error, Excel 2000 & 2003
- csv file convert to excel file
- Trouble opening file
- formula for vlookup 2 cells
- BeforeRightClick
- Check last two characters of a string.
- Color rows by "group"
- Macro ends early without error message
- Trying to delete existing unwanted horizontal page breaks
- need Macro
- Macro appears 5 times
- using named ranges in vba
- cells not registering as blank
- Specific use of INDIRECT inside VLOOKUP...
- Min IF Function Needed
- Need some help with this code:
- Hide all Sheets in Workbook then Close Workbook
- creating a macro to print PDF
- excel2k FormatConditions question
- Problem with code - Help
- How to clear Immediate Window programmatically within a procedure?
- Macro Properties Password Popup.
- How to see value of UDT variable while single-stepping?
- RE: macro does not work inside Excel 2007 #2
- COM Addin function
- Migration Project
- Help with Error
- "Object required" error
- Rosh Hashanah and Yom Kippur Holiday Dates Revisited
- sorting in multiple sheets
- Listbox finding the adress of the item
- convert hyperlink to email address
- Txtbox set focus
- creating a macro to add text to existing data already in cell
- Value not shown on selected ActiveCell
- Iterate over a Range of data - create arrays or ranges
- How to prevent Excel to paste data in separate cells
- substring check
- Using range names in SQL query
- protection not working
- Info onto Web page
- MACRO
- Looping Paste Special Value Transpose
- Receiving 'Error 1004' with VBA program
- Block Of Numbers Repeating in a Formula
- Status & Formula Bar Disabling Prevention Among Other Opened Workb
- don't allow excel event kill
- Hyperlink to TIF File - Not Trusted
- 2003 vs 2007
- Alternative to ShellExecute
- Creating task in outlook from a particular row in excel
- Range Selection help (Formatting)
- Sorting Question
- Use Code for Demo
- Protecting worksheet
- UDF returns #VALUE! when regional language setting not English!?
- Input Box Default Value
- Dimming Toggle Button
- Code To Send Mass Email
- Multiple Goal Seek
- Setting up a per unit bonus formula
- MIN IF Function
- Tools Menu disappeared??
- Autofiltering and copying selection to anotherworkbook
- command button invisible upon opening file
- Re: Updating Properties of a Control on a Worksheet - THANK YOU DAVEPETERSON!
- Prevent "Add-Ins" from appearing in Ribbon
- LookUp?
- Cell name
- Saving a single worksheet
- Creating multiple emails from one Excel file.
- How to make this fire at every page break??
- Stop the macro at the end of a certain column
- How to create a list of dates (not including weekends)?
- Userform TabStrip questions
- is it possible to pass a reference to a function as an argument
- checkbox property
- indirect address offset in array formula
- IS there a way???
- find a value in a column, if it matched, highlight that column
- Cursor Position After Sort Operation
- XLL programming for Mac.
- Exists similar function to the PROC but that it returns the super
- Write text data to text file without quotes
- Existe uma função parecida Ã* PROC mas que devolva o valor superior
- Command button "selected"
- Drawing a Circle
- User selection from a chart
- Copying from one cell to another cell
- Copy + paste macro
- Updating Properties of a Control on a Worksheet
- Excel 2007 - Drill-through action called via VBA locks the workshe
- Min If
- Need help in Excel Programming
- MS Query and Integer fields
- Update links & calculations upon command
- Problem copying between worksheets
- Create muliple event procedures via VBA
- want help
- How to copy this to another cell exactly?
- Find a textstring in a "Range" - and then return a value iftextstring is found.
- Auto complete cell from a list of choices
- How can I send file by different email address (to; cc and bcc)
- What is planned to replace VBA?
- Insert Row without affecting page breaks
- How do I create an alert in excel programme
- Searching and adding in a closed file
- Naming modules
- Macro for copying and pasting values based on criteria
- Make global Macro/Add-in for all active Workbooks/Sheets
- checkbox1 linked to sheet1 a1
- time elapse on userform label caption
- Find number - where did I go wrong?
- Macro If Then Question
- Losing Module Level ENums in Excel 2003
- FileSearch to locate the latest (last saved) file
- capturing current range of cells
- Special effect on User form
- Custom Worksheet Collection
- For What kind of computer was Excel created?
- Drag picture
- Anyone know how to program transfer of CSV data to web page form fields?
- Displaying published htm file from remote share
- Sum after every blank cell
- Pivot Table Refresh Updating all to same data
- Case Statment in Err trapping
- display userform4 for 30sec's
- Macro
- Displaying question
- Range VBA: double entry table
- Range vba: double entry table
- Function to find last value in a column
- function to find last value in a column
- GetValue from closed workbook
- tutorial needed
- Two short questions
- Type Mismatch
- link checkbox to cell
- Renaming individual columns
- Please HELP me!!
- Zoom in/Zoom out picture
- if internet on then ... else ...
- stop command does not trigger
- Workbooks.Open oddity
- Print user form and add menu bar to the form
- UserForm ComboBox
- Range as Variable
- Excel data types
- addition to a remote cell
- Make PivotCaches.Add(SourceType:=xlExternal) from VBScript code
- Autofilter Check
- Format a number field as text
- Turn of Autofilter Arrows?
- PivotTable with all row label visible
- problem with Excel file created programmatically
- Stop Recording Macro
- Summary based on field indentifier?
- Update check box from cell
- range and variant
- Prevent Copy action Q
- Allowing xlBook.SaveAs in Access code to overwrite existing workbook?
- named cells
- VB code is not shown when recording drawing objects
- Update from Excel 97 to 2007
- Type mismatch error only on the first run
- calculating working hours between 2 dates
- How to suppress XML import error message
- Image (Picture) from Excel Cell Data?
- Define Print Area using Variables
- security Level settings in Excel
- Placing a formula in a cell of an unconstant row location
- Context sensitive hekp
- can't undo Full View with macro
- Performing a Macro within a range
- Before Print Problem
- Discontiguous Chart Source
- SQL.REQUEST in Excel 2002 not supported in 2007. What is new func
- making listbox without horizontal scrollbar
- Process a range from bottom to top
- launch excel, auto-open second excel file
- Different Macro behavior when called from Immediate Window vs. She
- retrieve data from web
- Another Excel Problem
- Feed Multiple Comb Boxe with same list
- Hiding a PivotField
- Hide or delete "Add-Ins" in ribbon
- Call to Sub Routine which exists in seperate workbook
- Code Help Needed
- how to test if range object target deleted
- Macro Enable after Disabled
- Force cell to have Accounting Formate
- Keeping whole formula constant to new workbook
- Progress Bar
- replace string
- Problem with locked file
- confine cells to two digits
- vacation.pto calendar
- Excel 2007 VBA - Run-time error 1004
- still having trouble
- Odd Save As behavior
- Row number of cell containing specific text
- Need to move last number in a column
- vba Cancel Save As
- VBA Sum returns Wrong Format
- Select a Range By color
- The name ... either conflicts with a valid range reference or isinvalid for Excel.
- Excel 2003 Dates - Strange behaviour
- Excel 2003 Dates - Strange behaviour
- Alphanumeric Recognition
- Find Text, Add Border 6 Columns to Right
- Add Item to Recenly-Open Files
- Locked for editing problem
- Build a Worksheet that pulls info from other Worksheets
- Excel to Schedule Task in Outlook
- Closing temp worksheet without saving
- Shell Out Failing
- Need Class Module examples...
- Persistent Storage for Add-Ins ?
- Starting Excel and doing "stuff"...
- Power API
- Variable File Name Activation
- XL2002 - trigger sheet event BEFORE deactivating
- saving open workbook to text string in cell
- Excel 2007; OutlineLevel-Problem
- Run macro in background
- Remove a line from a text file
- Delete defined text in a column
- Chart sizing
- Master's please help me with my code; Doing a loop to copy valuesfrom a series Sheets of another workbook..
- Avoid displayalert message while opening file
- No double space
- "End" Button for Error Messages
- combobox change fires on workbook close when textcol <>1 or -1
- Teaching Excel
- Add Userform Image from Cell Picture Address
- Find a string within a string
- Set EnableAutoRecover to False
- Display alert if data exists
- totaling criteria
- Re: How to make a selected row visible in the Window?
- offsets - using ranges
- Selecting range of cells to copy using a variable
- IsEmpty - what's the opposite?
- Lookup in VBA
- Last Used Cell
- Rosh Hashanah and Yom Kippur
- Variable causing subscript out of range error
- Delete Sheet without Warning
- SP3 and RefEdit Control
- Create header/footer txt file and link to Excel worksheets
- Macro copy of variable ranges in one sheet to table in another she
- defining a variable containing quotation marks
- formula
- Adding a WHERE statement
- Named ranges and links
- Selection.Copy used in a variable.
- Function used in conditionnal formating not using good language...
- Dba query filter taken from Excel
- userform
- Custom Save As
- group (add) numbers without exceeding 168
- SaveAs produces subscript error
- Hide Buttons When a Cell is False
- Delete Last 10 Rows in Worksheet
- Check if workbook open (Not working)
- Excel Problem
- Selecting a dynamic name
- Isolate group of names from Drop down list
- Custom Save As
- Using Variables in R1C1 formulas
- VBA solution required?
- Capture Excel close
- Sheet Tab Color, Excel 2000 & 2003
- vlookup in VBA - 30 sheet lookup
- using a formula in a program
- How to update Shape pictures
- List objects and Buttons
- date function
- Type mismatch passing arrays via COM
- Excel Shapes selection problem
- Before Close Event Hide all Worksheets then Close Application
- The Great Gatsby- Importing multiple external data files
- force a selection from a list of words
- SQL Problem
- vbMsgBoxSetForeground
- Unable to loop on Excel collections. Error 451.
- AxInterop.OWC11.dll license question
- 2007 cannot enable macros?
- manipulating arrows
- Re: How to make a selected row visible in the Window?
- sheet selection via user click (yez)
- Double Click Event Error on Worksheet
- Selecting only some characters, using "characters property"
- Excel Add in - VSTO on Pocket PC/Windows CE
- security warning
- Opening/Closing Large Files
- Lock a named range
- INSERT ROWS
- Help Fixing a Macro
- Combine several macros
- GetOpenFilename and filter "*."
- How to make a selected row visible in the Window?
- Export comments to document
- How do I link Excel to a dynamically column named access table?
- Macro does not work inside Excel 2007
- Cannot Edit Active-X Control
- Code to check errors in excel 2002
- Calculation/Number Bug in .xls? Any ideas?
- Re: Seeking advice for complex charting algorithm (16K attachment)
- Opening Word Docs from Excel VBA With full path and name > 255 chars
- Handling Errors When Opening Word Docs From Excel VBA
- Code seems to have not copied fully
- Importing data seems to interfere with auto-scheduled macro
- Issue removing leading and lagging spaces
- Sort by changing number
- Set CommandBars Dropdown value
- duel criteria seach
- duel criteria search
- 2 parrameters to filter
- Create named ranges in Column on worksheet
- RE: Programming a macro to draw info from a list of links
- Excel ScrollBar - Don't Move or Size with Cells ...
- Can't create workbook with VS.NET 2005
- How to add the same cell in multiple worksheets (with VBA)?
- checking a range for at least one
- Can you copy a worksheet from a workbook wothout opening it?
- CutCopyMode -- What workbook was copied?
- Passing Null Value to Range Property
- Re: Copy specified columns to another sheet
- Can't get the macro to continue through a range
- RE: Updating Cells after comparing two worksheets
- Vba Vbe export
- Help with macro comparing data in worksheets
- Re: Enter the result of a formula using VBA
- Determine if Carriage Return or Tab key is used
- editing data in database from Userform textbox
- active workbook/sheet
- Custom Header
- Copy/paste new worksheet to master worksheet
- mail sheet as body from userform
- Math headache
- RANGE MACRO
- New funny recruitment video for Microsoft..
- Schedule downloads in VBA
- RE: Form not found
- RE: Form not found
- InputBox buttons
- Find checkboxes and then check them
- workbook_open() sub does not work
- Connecting to Access
- Re: PC and Mac
- Macro Fault on Custom Ribbon
- Error Msg when opening Excel 2007
- Selecting a range after activating a worksheet
- Code loops to death every time I attempt to add a string to a cell
- RE: PC and Mac
- Create a user-defined function
- xlDialogImportTextFile txt file name
- Macro to format text
- having trouble disabling "save", "save as" (2003)
- add names
- RE: Date Format
- Formula to VBA function (if and lookup)
- RE: loading automation add-in for an instance of Excel
- Taking info from all sheets and compiling it without spaces
- Copy/Paste Charts; Define Destination of Charts in PowerPoint
- Groups in Option buttons
- RE: Using autofit on cells which include ASCII 10 (LF) character
- RE: Examples of "Front Office" usage of Excel
- Next Worksheet in code
- Determining if Button on worksheet is hidden
- macro comparing values from 2 worksheets
- E-mailing from Excel Q
- disable shortcut key from menu control
- insert rows programmatically with formula change
- Vlookup to VBA
- Entering text in Excel cell
- Vlookup syntax format
- problem uninstalling an add-in
- Unable to access any Programming capability
- How to start Office application in Automation mode via Office itself?
- Why does this code not work for me?
- moving excel 2003 data to sql server
- Copy from cell above
- error opening a workbook
- Using macros to condense a template
- Sum Visible Cells Only
- record the maximum value in a cell
- Folder Contents to Excell
- Error '' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
- Placeing data from sheet1 to sheet2 via a form button
- Placeing data from sheet1 to sheet2 via a form button
- Placeing data from sheet1 to sheet2 via a form button
- Excel 2007 XmlMap.ExportXml producing empty string
- Macro for copy
- Are we back on line?
- Data Fill in Visual Basic
- Please HELP me!!
- Auto Start Macro in Excel
- Programming Outline Expand(+) / Collapse(-) Functionality
- Copy IF condition exists
- Inserting a row
- Paste Special MS Excel Worksheet range selection into Outlook Task
- Interior.Color from a function yields Error 1004
- Insert a row
- Create a task from a userform
- Excel/SQL Problem
- Need to get value of last number in a column
- Macro works but is there a better way
- XML Mapping - Update Schema
- DsoFramer and Excel
- finding charcters for UDF
- CHRW
- Export To Xml
- select the data and copy in another sheet
- Insert new column and paste formula
- disable a menu control short key
- How to Diagnose Why "Code Execution has been interrupted"
- Referencing a named range in another workbook
- Using the name in a cell to open/activate a workbook
- VBA and Password Protection
- Need value of last number in a column
- check if excel sheet in manual calc mode
- check if excel sheet in manual calc mode
- Excel files linked
- Disable all toolbars apart from custom toobar
- Moving Spreadsheets with formulas attached, between workbooks.
- Type Mismatch error
- Check cell address for double alpha characters
- create outlook task from excel
- uninstall-add in
- SQL and Excel problem
- Code for running macro on save
- uninstall add in
- Alpha/Numeric help
- search column and display results in msgbox
- uninstall an add-in
- Find String in Cell then Paste Sum in Offset Cell
- vb code for data transfer
- Date Picker Behaviour
- paste special excel worksheet range into outlook task body
- Copying a range to a separate excel database
- Number format
- Search from bottom of column up column and delete to top
- Code to run macro on save
- Form keeps the focus unable to get to code - HELP!
- Nested If's
- vlookup on changing range
- selecting target sheet as an input
- data arranging
- Visual Basic Form
- Files linked to one specific file.
- about data copting
- question on scope of a global variable
- range as listbox column
- Chartspace Data Source and Connection String Problem
- Schedule Downloads
- Schedule downloads
- importing more than 65536 rows from .csv file
- Schedule downloads
- Changing cell color based on a value in another cell
- Given Address, find named ranges that contain it
- Alpha Numeric help
- clearing duplicate values in Column A
- Finding Maximum of Two Numbers in Array
- touch screen with excel
- Need help to have macro populate a column with formula to end ofcolumn.
- If data exists in column J, put formula in column K
- Select Case
- Excel Controls
- Calculating column based on formula
- CAN ANYONE PLEASE SOLVE MY PROBLEM
- formula
- vlookup working in one instance, but not another
- Copy Chart and Insert in new Sheet as picture over the same location
- Paste special function in macros fail if we disable application cellDrap Drop
- Understanding and comparing stock market figures
- Exception when adding a array formula
- CORRECTION NEEDED
- Text upside down!
- Strnage bug when pasting charts
- Running a Macro from another Macro
- Value NOT placed in 2 sheets, but in ALL others
- Everything You Need To Know About Printed Lanyards
- Speeding up slow code
- Next Without For Error
- creating sheets macro crashes after 26th sheet
- Multiple IF Statements
- Excel 2003 / VS 2005 Automation Add-In
- Changing cell color based on value in another cell
- SheetSelectionChange when modal form is shown
- macro that identify the newest file in a folder and open it.
- Programming SendKeys
- Query SQL Server with concatenated text from Excel
- Help Number formatting of actual data not just the view
- Vlookup to VBA
- setting a list in a combox doens't from a range
- cell color condition
- Data Retrieval from spreadsheet
- Pivot table help
- Find Text the Insert Sum
- Cascading Combo Box & Content Filtering
- Find Text the Apply a SubTotal Next to Text Address
- Excel Chart Macro Issue
- Digital clock that continuously updates from NOW()
- Add line in existing macro to use template
- Right Click menu doesn't appear in Page Break View
- Query Update from Access: Re Ordering Columns
- Excel 2003 vs Excel 2007?
- show Comment using INDEX
- Numberformat applied but does not change data
- Defining a variable range
- setting variable direction in visual basic
- Capturing Undo Values
- Adding and removing extra pages
- Automate Data Entry from .xls to IE
- Run Time Error 1004
- Reading Values Between Sheets Based On The Condition
- Code for export
- Insert Symbol in VBA
- How to capture the cell above
- automatically input data into SAP R3 from Excel
- find own user posts
- Reset values in a combobox
- take user clik as an input
- Set array of objects to nothing
- Macro to copy/paste
- Copy to datasheet -Message for Ron De Bruin
- Exiting a Sub when called from another Sub
- Serial Order
- Macro with vlookup with variable sheet
- user can't use workbook when already open
- Check/Option box from Excel list
- Building a COM add-in...
- Macro stops for no reason
- Logical tests
- Error: If Range("AZ" & intCounter).Text = "" Then
- Data from Excel to Word bookmarks
- Compare Two Rows Directly
- close file -> open and save
- 2008->2003 incompatibility
- EMPLOYEE WEEKLY SCHEDULE
- zoom in &zoom out in VBA User Form
- print each row in the list in the combo bos
- Disabling the "Design Mode"
- Select an empty cell
- PasteSpecial issue
- Code to get Max Value in a perticular cell in ALL Sheets
- Userform problem
- Tools/Customize question - toggle Show/Hide Comments without a macro
- Shade cell if No value in offset cell
- hiding rows with merged cells using macros
- Using formula in a macro?
- change event
- using rowsource to fill a combobox
- Day of Week
- Control Number - A better way
- Cell Update on Paste
- Shortcut Key Assigned to Imported Macro (i.e. in personal.xls) Does Not Work
- Should TD be HTMLTableCell?
- getting the entire range before be filtered
- Loop through table of columns and rows
- additem removeitem
- Macro to schedule downloads
- Help me to first row matching First date and last row matching lastrow
- Excel workbook save behavior using VB6 very confusing
- Delete Specific Sheets
- How to Place a Drawing Object on a Worksheet as a Control?
- Macro Copy Excel Chart Sheet to PowePoint - Mod of Jon Peltier code
- DialogActiveCellFont
- Need to paste/update info to correct row.
- Return Control to Userform
- List Box Highlight Selection from Sheet
- How to populate web page forms from Excel or DB? Is this possible?
- Match function not wokring on 2D array
- automatically create list of the worksheets
- Issue with marco for entire workbook
- find error
- How to install missing DBNamespace 1.0 Type Library
- Find first empty row in a range
- automating (alt & f11)
- Automatic Toolbar
- Stripping HTML tags from excel
- Set message subject here ...
- Excel has encountered a problem and needs...
- macro to return value of worksheets
- writing a text file in the same folder as my program
- referencing to external name range that would update automatically
- Sorting problem
- Linked file Excel 2007
- Excel file linking
- Excel tables vs. system tables
- Running macro in one workbook that refers to variable in another
- Delete Row Select Case
- I have the slowness problem also
- match function - date and time
- Subroutine Summing and Outlining
- Getting a range using row & col numbers?
- Retrieve selected data from Network file
- Error Handling Help
- Re: Need Help Converting Date & Time Stored as Text
- alt & f11 via macro
- too much space
- User Form
- Cannot hide columns/rows
- combobox dropdown
- how to identify a shape as a picture in excel from VB
- error 70 permission denied in excel
- prefix in text box
- E-Mailing macro font options
- Formula for day of the week to relate to corresponding date cell
- Checking Web Queries
- add total from 6 textboxes and put in label
- last cell as label caption
- show userform/hide workbook
- Naming Ranges with code
- Displaying programatically worksheet errors messages in a cell
- Insert Row & format as per other rows, above/below
- manipulating Query data 'on the fly'Question
- lastcell
- "Toggle Switch" help needed
- force text/numbers in text box
- range value as label caption
- Addins - number of columns & rows in running version of Excel
- Re: lable caption
- Triggering macro
- Select a series of cells
- Searching for a value for and then replacing when found.
- Concert number to time
- Ok what's the trick to do this?
- How to extract aggregate values from PivotTable
- Cancel Button on file save
- test
- recently used file
- Saving multiple worksheets to a master file
- Excel Macro: Selecting items from another worksheet withoutactivating it
- loop help
- Loop help
- Add dimesion to Array already populated
- Sort Data auto on cell range when updated
- Help! Refrence a userform element from a textbox?
- Help with code
- Help! Refrence a userform element from a textbox?
- Create VBA function that returns many values
- Shell Command Fails (sometimes)
- Atofill Questions
- Passing result of multiple split function results to 1 Array
- sheets
- How to copy from each sheet and paste to a summary sheet
- Prevent a Worksheet from being deleted
- Get Save Prompt when closing workbook immediately after savingworkbook
- how to save a file and overwrite existing file
- Date and Time
- MS Excel 2007. ActiveChart.ApplyCustomType
- Restore "Delete..." and "Insert..." shortcuts
- Using Excel Interop via VS.NET 2005 to create and save a new Excelworksheet.. please help!
- "Call" Commandbutton1()
- Excel 2007 VB function call return value syntax question
- Office 2007 VBA Compatibility??
- Filter and count hidden cells problem
- Set position of non frooze rows when panes are frooze
- Extracting Text between 2nd and 3rddelimiter
- Multipage Tab vs Regular Userform
- how would i wrtie this formula
- VBA for Exporting to Text file
- Opening workbook in same directory
- passing an argument
- Show Time Stamp in Cell when Command Button Clicked
- dynamic source range change in pivot table
- Copying across values based on criteria
- every fifth line
- Macro triggered by date
- error
- Connection problem using DAO
- Using Outlook Express for this Newsgroup
- Delete Row if value <>
- Delete a workbook...
- Excel Addin Install via Registry
- Leading Zero in .csv format
- copy cell until data doesnt exitst anymore
- can I copy "2" different Ranges from closed workbook (VBA)
- Open, print, close multiple pdf's from macro
- If JobNumber = Val(field(7)) Then Query
- Userform Programming
- hyperlink to sheet with name in cell
- Change event for several Textboxes on UserForm
- Advanced Filter Error 1004
- Search a column to match textbox value from a form
- Macro to merge text and delete rows
- Combobox drops down blank row
- Zero values in Pivot Tables
- PivotTable Show Properties in Report - stange behaviour
- Macro for export
- Updating workbook from protected workbooks...
- Input box
- ListBox
- Force CAPITAL LETTERS
- Problems printing Webbrowser Control with a worksheet.
- Print To WorkSheet
- Excel Macros sending attachments to multiple e-mail addressescontained in one cell.
- Automating excel though outlook
- re : Copying a range from WB01 and pasting to WB02
- date and time
- How do I GetCurrentDirectory in Excel?
- Count Sum Problem
- Re: UDF that returns a date
- RE: Worksheet Change from Add-In
- how to add
- Re: How do I create a Graphical Report from Survey responses in Excel
- Re: Worksheet Change from Add-In
- Microsoft Office 2003 Web Services Toolkit 2.01
- Worksheet Change from Add-In
- format cells so they do not resize
- Re: default fill color
- Re: UDF that returns a date
- RE: default fill color
- UDF that returns a date
- Send parameters in worksheet button > 255 characters
- default fill color
- How do I create a Graphical Report from Survey responses in Excel
- cell is merged and contains "something"
- How to create .HLP for my VBA project
- Excel Macros: Sort which is not Worksheet Specific
- Rows & Columns Disaggregation Help
- Making code global in workbook
- Excel file open in memory?
- How come VBA if clause fails?
- New user and need help
- consolidating workbooks(not sheets)
- Linking rows on multiple worksheets
- Check column for a value and if not there execute series of functi
- Pasting while in edit mode
- Protection on a sheet type thats new to me!
- Is Active Cell in a Range?
- UDF and dynamic range
- select and delete all pictures in a given range
- Skipping empty cells for a Range object?
- Indirect.ext Function Isn't Working for me
- How to create msg box if a cell contains value < 0
- Run procedure from worksheet change event
- Can a For statement work in reverse (from 40 to 1)
- multiple if then statements
- Analysis of 2 groups?
- Digital Certificate Question - Help
- Running total of Found Substrings in MainString in Big Loop
- Copy data from Microsoft Word form into Excel
- cell data
- Re: Prevent Text to Integer conversion
- Can't save any more in Excel 2007 Compatibility Mode
- VBA code executes fine, but compiler throws error. Huh?
- perform the same calculation in several spreadsheets
- Comment Automargins property
- User form
- Print causes crash
- F9 not working with SumByColor
- Run Time Error '91'
- Newbie floundering in the VBA code
- Another runtime 1004 error
- InserPictureInRange method for excel VBA
- Blatt-Schutz und Zellen formatieren
- find a string in one cells
- events
- DAO Syntax Problem
- VBA to delete leading space
- Disappearing Userform Label
- Help with VBA runtime error
- Activate an variable located workbook and copy 2 ranges?
- GETPIVOTDATA with date in referenced cell
- Email .From
- ComboBox search for variable...
- Logical functions AND,OR in array formulas work ?
- Creating Outlook Task from Excel
- Executing a macro
- how to display cell value in formula
- searching for shapes
- On Cell click, start macro
- On Cell click, start macro
- .NET and Python Programming with Resolver One Spreadsheet
- VLookup if criteria matched
- How to concatenate in macro across sheets
- Pivot Table Deconstruction
- Protect part of Insert comment
- Pay Reconciliation
- ask user to select a target sheet as an input for a macro
- vlookup - table array in cell
- 'Moving cells'
- Scroll function in VBA
- Retain focus of IE using DocumentComplete
- Is there a fancy way to open a workbook in a minimized window stat
- trouble loading a range into a comboBox
- Reading data from PPT and purge data to Excel and image
- still get runtime error 424
- Is Pivot table the way to go?
- Dumb newbie Q re. passing cell addresses to a UDF.
- Access Fields in Lotus Notes DB Forms
- run time error 424 object required - how to load control on Userfo
- Open "Insert Hyperlink" popup window with VBA?
- Prevent rows from being selected
- Delete Rows based on cell value
- Excel spread sheets do not close from vb.net
- Pivot tables - how to hide the total row?
- multidimensional array
- Excel Macro Help for Charts
- Fill down a row
- Excel Macro for Charts
- getting Runtime Error 1004
- Cell Content
- How can I see assembly code for VBA routine?
- Custom Cell Format Question
- Simple Code but slow
- Looping through a range
- Using Case and referencing a cell instead of a value
- Covert Columns to rows Macro
- Unwanted recalculation of UDF while running a Replace-statement
- Conditional Formatting in a For Each Worksheet Loop
- DAO connection problem
- Dynsmic Charts
- Macro Help - ASAP - Please!
- How do I change Date Format ??
- Autoformat screws up with FormatConditions?
- VBA to create button on sheet after copy and to change the caption
- is blank
- Re: How to tell spaces between values in saved text file from theorig
- VBA code to find macros associated with command buttons in an s/s
- conditional formatting
- Combo box help
- Track Changes Data
- copy a dynamic column range in macro?
- Lookup in numerous sheets
- Re: Autofilter Question
- Find end of number and copy/paste 5 columns
- Coping Range from another Excel file
- Excel automation on server
- Macro codes automatically opens when opening a excel file
- assign value to cell on different sheet
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.