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 |
- ADO read of Access...
- Cannot get message box to show
- Investor's Knowledge Analysis
- Opening a file from another file
- Search for calculated duplicate using worksheet events - Possible?
- Re: calling xlfEvaluate/xlUDF in an xll
- Copying Worksheet from one workbook to another
- Copying Worksheet to new workbook with VBA
- Unique combinations of records in a list
- position of inserted picture files in Excel 2007
- Copy & paste rows after found text to different wb and delete them
- Extract Comments to Cell and search with AutoFilter
- Another 'Last cell in column' question
- System Date - Network
- Excel2003 - possible to lock/protect individual cell(s)? maybe wit
- Pulling text from the right end of a string
- Copy charts to powerpoint
- Sub Total in worksheet or SUM IF function
- pulling in a table with formulas
- VB Cond. Formatting of Formula Cell
- paste into destination w/o overwriting existing
- How can I specify which cell has focus?
- Strange error when changing locked status of cells
- Color Index for light yellow & Code Help?
- Finding and highlighting duplicates across multiple worksheets
- Upload Data from Sheet1 on Local Machine to Sheet1 on LAN
- Puvot Refresh
- Moving from VBA to VSTO
- VBA Book
- Adding many textboxes on Form
- display problem with listbox
- Excel bypassing Word password
- Bug in Excel 2007 using Names/Ranges?
- Bug in Excel 2007 using Ranges/Names?
- Unprotecting a Workbook before exiting
- Open file ready only
- Count font colour in a cell
- Dynamic property names
- Wookbook speed
- How to email an embedded object
- Change A Line in A Module Using VBA Code
- Run a macro if file is a template
- Chart Window's class name in Excel 2007
- Re: Locking cells in Auto filtered list
- Range statemeny query
- Cleaning file
- Re: Locking cells in Auto filtered list
- Public Variables
- Need Help to Control the UDF from re-calculation
- Pulling cells from multiple reports into a new column
- Enabling Turst access to Visual Basic Projects
- Locking cells in Auto filtered list
- Update links automatically when opening file
- how to call excel.range.errors in vc++
- Returning the name of a module
- 'Trusted Publisher' under Vista
- Macro attached to Menu Command Button
- File opens another file runs macro and closes
- E-mailing a worksheet only from a workbook
- Drop Down Box
- Separating a master file into many workbooks
- Total or summing in a workbook within a folder
- Charts
- Move row of data from one worksheet to another
- Creating CSV for every Excel Tab
- registry setting to disable save warning for csv file
- Conditional formatting
- How to find all folder and/or files in a specific location
- Help with VBA programming for a new user
- Excel Formula's
- Report of Margins and Worksheet Setup?
- Pop-up
- Tools->References greyed out
- Why won't this sheet delete?
- Cell content limitations...
- If filter results in blank cells, skip to next part of program
- out of memory errors
- Switching sheets while timer running
- nested if not working not sure why Help!! Please
- Creating spreadsheets for managers with mutiple tabs
- Finding every instance of a value in a multi-sheet workbook
- How do I change the reference in a formula based on a logic test?
- Bracket
- Run code on "IF" formula result change
- Add Hyperlink
- Read cell value of xlVeryHidden sheet
- comparing times
- Count cells every 12th column?
- Used range row count throwing up a wierd result, slects wrong as well!
- .ldb question
- Interier Worksheet Formating for Rows.
- Arrays
- show intersection of data
- dropdown control
- Macro to change file properties
- Need to skip warning
- Globally Named Range Problem
- Copy Insert Paste into all Workbooks in Folder
- Moving an entire range and a for loop question
- Macros and merged cells
- Sync Button
- ByRef Argument Type mismatch
- Conditional Formatting- Refresh
- Copying filtered data
- Excel macro is recognised as a virus
- Run-time error '1004': The PivotTable field name is not valid....
- String Comparison
- Find and copy down Macro
- Cursor Shape
- Pop up reminder when closing Excel
- why xlcShowToolbar cannot run succeed?
- Problems with Trigger sequencing and disabling events?
- Textbox inserted on an Excel sheet does not allow TABINDEX or SetF
- Find/Filter highlighted cells
- Checkbox
- How to populate a Pivot Table using VBA code?
- Show all data in Pivot Table
- Problem with Workbook Protection Excel 2007
- Macro Question
- How do you give a user the choice of printer
- Copy and paste formatting and values only
- File size and pivot table refresh problems
- File Search
- Run a code on a workbook?
- !
- Excel automation: How to access XL sheet as the second task?
- Which ComboBox?
- Interior and font color change based on value
- Adding Menu Buttons
- Installing unwanted Excel features during automation
- Scroll Wheel, Excel and VBE Weirdness
- Delete columns
- Before Workbook Event, Custom Calculate a Specific Worksheet
- more on interior.colorindex issue
- grid lines
- For Each...Loop using Pages in a Multipage Control
- Input Box
- Case query
- increment cell value based on another cell's value
- Re: User defined function
- Activate?
- Automatic Protecting Question
- How to transferred data from one workbook to another
- Reference to Sheet Name When Copying Worksheet
- empty range causes error
- Range Reference When Copying Sheet fm One WB to
- Hyperlink Help - want to link to diff sheet, looking for name cursoris highlighting
- Copy
- Trailing number on Named Region
- Automatic Return When Choosing Drop Down Menu Sleection
- Delete cell entry and default contents are restored, for multiplerows
- Adding Data Fields to Pivot Tables
- Unhide depending on selection
- Close button on form
- formatting cells with boolean values
- Copy .xls betwen local disk and https:// location
- placing limits on ubound, and lbound
- passing array reference to sumproduct formula-???
- How do I create a formula to add hours to a mm/dd/yy h:mm format c
- Automatically show Standard deviation in a selected range
- Add comment, and move up
- show value of formula
- Abandoning changes in workbook
- Return name of excel addin .xla
- Worksheet name in cell
- Need help with Excel worksheet
- Case sensitive VBA function
- gray - blank sheet issue
- Defining array size when it is dynamic
- typing in one cell automatically brings up something else in next
- DIR fn when filename has non-ANSI characters
- Save workbook inplace
- Changing Orders
- Change properties of a multipage
- Fill ListBox as per number of Records in the sheet.
- Help needed with Macro designed to compare data...
- How do I adjust a combobox once I've Programmed it?
- Simple line error msg
- Tab Code Retrieve a Value
- Compile error: Automation error in Excel 97
- Help with Code
- Vlookup Help :)
- Mouse using "Right click to paste"
- Finding next empty row
- Excel and SQL question
- call to macro in xlam from macro in xlsb
- Follow up question. Get value of closed file.
- vLookUp return several columns?
- Jarek, almost there...
- Copy data from one tab to another based on cell value on one tab
- ReadLine in Reverse
- Combo Boxes as data source for a grapgh
- Test if a file has a password
- screenupdating=false not working
- HELP=>What Is Wrong With This Code ?
- Kill all files in folder
- Tab sort
- run-time error
- Moving Information from AD to Excel Using VBScript
- Macro to copy A1:d1 if Column A has total spend
- Using the calculations of excel in a word macro
- macro to delete certain results
- A Dave Peterson macro
- renaming a Named Range in multiple workbooks
- Excel 2007 PrintPreview
- how to make a cell value increment every time a new worksheet is o
- VBA code for moving data from even rows to columns after data in oddrows
- Userform in Before close event of workbook
- Nothing happened while trying 2 export Infoworks Reports to Excel
- Worksheet Linked with flags
- Object Required Error
- Macro will not work in protected Excel 2003 Worksheet
- Finding a matching value in another file
- Macro stopping and starting.
- looping formatting multiple sheets
- Macro speed change when closing file
- MACRO
- Play wav file / comment displayed
- how to add comma to a formula
- Multipage Pages will not show controls when enabled
- Event after update / calculation
- Solver
- message box choosing a date
- When excel launched through automation, not running custom toolbar
- Formula in pivot table
- How to get looping VBA code to respond to events on worksheet
- Comparing several rows of data for 1 record
- Copy a page from an xla file
- Messege boxs
- Problem protecting workbook
- Macro to hide rows based on criteria
- Bad PasteValues Operation with date
- Word Wrap In UserForm TextBox
- Help with Pivot Table
- Error 9 when launching add-in userform from Ribbon in Excel 2007
- Carriage Return Characters - Chr(10)
- Suppress display of Print Control Characters
- EnableDataValueEditing=true and copy & paste
- PageSetup is slow: Revisited
- Re: Integrate Outlook with Excel
- Enter Today's Date In A UserForm TextBox
- Match a cell in a range to a value from another sheet and select r
- exporting to Excel without overwriting the macros
- Setting Cell Values???
- Data Validation - Dependent List
- Copy Range to new Range and keep DATE format??
- Entering value into cell via VB code if cell is empty
- Defining a range
- Partition data range by an indicator variable
- search and replace data
- Re: Strange problem with HPageBreaks
- HELP => VBA Code To Import Worksheets Into A WorkBook
- Highlight certain text for the entire workbook.
- Beginners help
- unload userform
- Macros Disabled
- Pass a cell address - Modify interior font
- How to get user to select cell
- Mass change Hyperlink reference
- Color cells if
- Not getting ".0" in tenths in calculation?
- Print the WebBrowser Object
- using a macro to edit the data range of a chart
- Copy Fomulas down
- naming sheets
- Has anyone developed or is using inkeeping templates?
- program ok command button
- Office 2003 SP3
- Office 2007 SP1
- close/open workbook without prompts
- VBA limit from sheet to several ranges
- Textbox
- Prevent code running
- How to desensitize the "X" on Inputboxs, Textboxes and other gui's
- How to desensitize the "X" on Inputboxs, Textboxes and other gui's
- Select cell after last row in selection?
- XLL Help
- function doubt
- Help Required 4
- code for a formula
- Search and change font color to Red and bold it
- Macro to delete ROWS in a spreadsheet using Text file
- Problem with pivot table when workbook is protected
- Reference books
- Delete text when font is color black
- VB Array - Select column
- delete coding for excel 2007
- Passing an array in a user defined function
- square root
- How to get a reference to the Excel application inside a classimplementing IRTDServer
- Loop through worksheets
- Load Values from a Range into a List Box
- HELP W/ VBA: SELECT RANGE, ALLCAPS, CELL COLOR, RETURN TO BLANK CELL/PATTERN CELL
- Comment / wav file
- Excel VBA reference docs?
- Re: Sendmail and Lotus Notes trouble
- How detect if any workbooks are open?
- MOD function results
- Send Data From Active Sheet to Closed Sheet on Network
- Re: Sendmail and Lotus Notes trouble
- interior.colorindex does not work?
- how to find URL in Excel 2007
- RE: Macro Not Running in Excel 2007
- email
- Re: Macro Not Running in Excel 2007
- VB script email
- How can I execute Shape drawing Excel 2007?
- Quick Help!!! - remove character at position "X"
- Using a WILDCARD (%) in the SELECT clause
- Macro runs faster when VB code window open
- Using Get with very large file
- Calculating Number of Rows for Merged Cell Text Wrap
- Re: Paste Value into separate workbook
- Re: PivotCache.CommandText
- pdf to excel
- Re: Macro 2 insert formula if part of cell contains specific text
- Followup to Dave Peterson search routine from 4/15/08
- Can I change the format of numerical & specific word referenceswithin a cell?
- Returning FileLen with very large file
- formula
- incredibly dificult formatting problem
- Re: Generate Excel Scatter Diagram
- Re: VB Chart
- abt computer operator
- RE: ClearContents terminating macro - using 2 workbooks
- using if formula on page 2 to post answer on page 1
- RE: Find 2 values in adjacent columns simultaneously
- XLL help
- Average of cell values - Ignore if 0
- Other program disabling my custom toolbar
- Dual Code
- Conditional Formatting for a row
- select case issue
- Move data from text box to cell
- Microsoft Excell
- Re: Generate Excel Scatter Diagram
- Get data from browser
- timer issue
- Re: Problem with find function
- Re: Macro 2 insert formula if part of cell contains specific text
- How to set primary key property in a column
- Re: Stop / Pause a Macro using Pause button
- Re: RegExp & VB Noob Qs
- Loop not working properly
- How do I get this macro to start the search in the second row
- Export Excel Data to Xml Output
- Excel - oleDB - DataSet
- Gaussian de-convolution
- Stop looping macro
- VBmodeless user form errant behaviour
- Set an Add-In to This Workbook module
- Command Button
- Find top 10 items in a range
- Custom Toolbar Add-in
- Here's a big ask
- Excel with OLEDB and Ado.Net - Single quote problem(')
- Filter First Record
- Putting text together from 3 cells
- Call Outlook Contacts from Excel Userform
- Excel spreadsheet still pointing to old server after server move
- Error 1004 after copying 84th worksheet to a new workbook...
- Macro: how to create label forms inside the worksheet not userform
- save\change sheet name
- Automatic GETPIVOTDATA formula generation from within VBA?
- Excel 2007/Excel 2003 compatibility
- Ignoring cells using IF
- Text String
- Copy two ranges without the interval rows to the email
- Select the current region excluding the top row
- Changing colour bases on another sheet
- Any help is appreciated Creating New files from One File
- Comparing data in columns for Non-Matches
- Problem with Subs and If's !
- Learning VBA-don't understand error message
- macro opening too many files at once.
- Inverse prediction
- Array() function whacks out Excel 2007
- finding duplicates
- Accessing the excel 2007 context menus...
- Help needed with Modifying 2 Macros
- Merging cells
- Best way to wait
- Countdown Timer Followup
- Permission denied when copying file
- range row
- automaticaly change script
- Automatically hide/unhide rows
- Cell Reference Changes According to Project
- Clean up code and port to Mac
- Access converts "!" to "$"
- Ignoring Cells through IF Functions
- Automate Excel export to a CSV file
- Update a range in a sheet click event (Excel 2003)
- Multiple criteria for moving a row to new spreadsheet
- fix basic macro to filter blank data
- Copy active sheet tab
- VBA and Office Question
- Paste just the Value
- Name Issue
- Has the Excel 2003 OLE model changed over SPs?
- Large & Vlookup functions
- Icon on Taskbar
- Concatentate A1:AZ1 separated by ~
- Hiding Data points Equal to Zero
- Help needed with Very slow code Please
- Adjustable Axis in Excel 2007
- Visual Basic Chart Objects array
- Delete all Blank Rows from data table
- Combining multiple like's with Or?
- Understanding R1C1
- Found a workaround
- Merging two files with different time stamps
- Sorting numbers
- copy data from new worksheet to master list
- Sorting text strings
- Clear status bar message in bottom left hand corner
- worksheet_change help
- Importing Sheet
- Importing Data into an Excel sheet-template
- Copy cell based on unique value - alternate rows - into 1 row,....
- Copy cells up - based on ID??
- How to search for "#N/A" in Excel VBA
- Excel 97
- V2003 Macro not working in V2007
- Copy rows with today's date to new sheet
- VBA Excel range name test
- How to sort
- Want to auto filter with date on daily basis
- Controlling Auto filter
- Data need to be copied as per sheet name
- SaveAs Type Problem
- compatibility issues w Excel 97-03 to 2007
- Changing color
- Halt / Stop processing when a user selects Cancel
- About Application.OnUndo again
- Re: PageSetup is very slow
- Auto Right Click
- Custom Right Click
- VANILLA ICE FANS ONLY
- Macro for event procedure
- Drop down menu / list
- separate data with extra column
- Naming Of Sub Procedures
- Pulling data from Access
- Maximized Workbook
- Unique records excel
- Greater than less than in a find function
- Xors and byte arrays
- Need equivalent code for 2007
- Excel App gets focus
- named range/offset
- EOMONTH not allowed in Array Functions?
- How to do something in an VBS script for all worksheets of an Excel file?
- how can I delete rows based on column value
- Followup to RonDB "Modify Copy4" discussion from June 19th
- Selecting data in tables, if not given then interpolating
- sum true/false
- My Macros will not work after I protect my document.
- Deleting pasted HTML controls with Javascript
- DNS-Less Connection String
- Watch Window disappears and not available but Immediate and Local
- Huge spreadsheets, anything I can do?
- foce region to print on one page
- Copying modules from one sheet to another, in code?
- loop?
- Can excel convert a date to text
- VBA code for check boxes in a form
- Refedit
- Closing application problem
- adding bold to formula cell
- Using IF to refernce another cell
- Application event for Chart selected/activated?
- Radio Button Selection on Auto Open
- "If" Formula in VBA
- Dynamic Range
- changing constants
- Dim cht as Object Constant Declaration
- Reason to Answer Questions in this Forum
- is there an easier way to update?
- Opening file cause rows to lose
- Close UserForm by pressing Esc key
- Create Function which returns an Array
- Worksheet_Change
- Blinking Text in the UserForm
- Convert numbers to words, 3=ship, so if I enter 3, it says ship.
- Reorganising Data
- How do you trigger an "On Click" event programatically
- Need help converting macro from 2002 to 2007
- Conditional Borders through a Macro
- VBA - entering a formula in excel
- Macro to copy from another workbook
- Userform
- Fill Color
- conditional formating bold is true not bold false how
- Test if macro is called by another macro
- How to search in VBA?
- Macro Textbox accross worksheets - wont work!
- subquery to keep maximum date
- Activate Condition When Another Cell Is Selected
- Dynamic Sorting Lists
- text wrap is not stable
- show all data issue
- VBA help for simulation
- Having trouble changing the Locked status
- Excel VBA help to test the activecell.value
- Option Private Module
- control excel in c++
- Problem to use Excel remotely
- VERY tricky timer question
- Full Screen
- ADO read to and array
- Update database from ODBC query (or another method)
- How to Remove Duplicates and Replace with Blank cells in excel ?
- Unable to set the Visible property of the Worksheet class
- Need help reversing a formula...
- Help With Pivot Tables
- COMBINING WORKBOOKS
- ControlSource question
- Prior macro not working in new location after some alterations
- Force a SaveAs
- Calculate age in years and month or decimal
- Need urgent help with VBA 2007 CHARTWIZARD method !!!
- Hiding rows with merged cells
- Excel files
- Userform and textboxes
- For/Next Loop
- search method
- Rows won't hide?
- Application 1004 error
- Inserting colon as text
- If Function ignoring rest of formula
- Hide Every Thing during UserForm Loads
- Code fails after upgrading to Office 2007
- COM Shim in VS 2008?
- Radio buttons: "mutually exclusive" property?
- Calculating average of percentages
- Simple Chart name modification Not working
- Calculating once, daily
- Copy conditional format from one sheet to another using VBA
- Changing tab color continued
- Extracting values from Freeform shapes
- Option Buttons and Combo Bars
- Makro from value in one cell, hiding columns in another sheet
- I have no idea how to start this.
- Looking up a table value based on two conditional option buttons
- Calculating Difference between ranked values within random range
- VBA help
- No idea how to start this.
- Delete worksheet if cell is empty
- Requiring "Explanation" when changing number in cell
- Workbooks.Open using Dialog box
- How do I change the dates?
- Macro to change color of tab based on color of cell
- Default autofit contents for comments in excel 2007
- Center Text on Point
- dependant summing
- how to Hide/delete dynamically created button?
- can excel automate text-based screens?
- Close a particular Word file from Exce;
- Another User
- Countdown Timer
- identify selected worksheets
- Two Monitors
- HLOOKUP problems
- Worksheet_Change event problem
- Simple Macro help
- How do i copy a sheet from one workbook to another using VB
- Workbook_Open operates correctly in single step but not when run
- Selecting Contiguous Ranges on a Sheet
- Mapped Disk Full Error Message
- Automation Interface use
- finding transverse cell in excel
- splitting a string
- Input box question
- Pivot Table Type Mismatch when More than 65536 rows
- Chart Axis Modification
- Addition of user functions in function wizard.
- Look up - HELP!!!
- BubbleChart XP vs VISTA
- Sheet Within Sheet
- repair hyperlinks / testing for invalid address
- How to programmatically add a non standard custom cell format
- debug automation add in written in VS2005 for excel 2003
- cycle through checkboxes
- Displaying possible combinations
- Pivottable refresh problem
- how do I get formulas to recognize case sensitive text
- calling a worksheet function from another worksheet in same workbo
- HOL for Excel 2007 Programming
- Pivot Table selection lists retain old values and are not re-sorte
- Refering to a particular cell in a Named Range
- increment time
- Visible countdown timer
- Excel Header formatting with a programmed field
- Spreadsheet column width from html
- month name
- insert picture
- PHP script
- Draggable Navigation Map
- Macro/VBA code to compare lists & highlight similiar items
- Dynamic Sumif of Sheet1 into Sheet2
- Excel-Auto Sort and Paste to new Column
- Big SUMPRODUCT problem
- Advanced Filtering and Data Entry
- HELP -> Perl 'Hash' Functionality Required In VBA
- Check Digit formula
- worksheet change event only if cell was blank
- Crop pictures in excel,,,
- Disable a message box
- Re: Save to CSV macro crashes Excel 2003
- Re: Save to CSV macro crashes Excel 2003
- Sort an array to use in a listbox on a userform in Excel 2007
- need help formatting text in macro
- login userform with change password
- PDF Object Model in Excel 2007
- AUTO FILTER WITH VALUE IN CELLS AND COPY FILTERED DATA TO NEW FILE
- how do i auto filter with value in a cell
- auto mailing of selective range as attachment
- skips controls
- Good article on Microsoft
- Suppress Delete Sheet Warning
- Clear Contents Macro
- Automation add-in (UDF) not loading when Excel invoked programatic
- Look down column and enter blank row and color grey
- Array Declaration Problem ??
- Interactive spreadsheet column select
- Re: Data update
- color row using macro..
- How to delete the content of Excel cells from VBS script?
- is activating a hidden worksheet a no-no?
- Dependant List
- include links/css in web page?
- How do you insert rows in a sheet that has a PivotTable
- Is there a write-multi-cell-at-once function in VBS for Excel?
- Error 2042
- Macro to automate simple routine
- what does this mean?
- InputBox Cancel Button
- can someone tell me what this means?
- Progress from Stored proc in Excel
- getting value of named range
- Fill in zeros within a specified range
- Hide Column based on Cell Value
- Merged Cells Causing Problem in Macro
- Combining Data from Multiple Worksheets into 1
- GetSaveAsFilename - file name is blank
- How to proceed
- Conditional text boxes on Form
- Userform appears behind other application
- CutCopy mode goes to False
- Excel PivotChart Field Buttons
- Pound NA problem
- VB6 COM Add-In Ribbons defined in customUI XML not appearing
- Save as from right click menu (a bit off topic)
- Print Page Set up
- Timesheet Date Populating Problem
- Excel Automation
- Sumif Range to new Worksheet
- Dynamically Changing Pivot Data Fields with a Macro
- Workbooks.Close
- Matching Ranges
- Disable or hide Cancel button on Save dialog box
- A formula that's different on every row
- Como se realiza isso?
- Loop through image controls on worksheet
- Transpose paste with space
- Changes to Excel 2007 VBA
- "Condition" format based on Font color
- CommandbarButton.Execute method not working for drawing shapes
- Find Value of cell in another sheet
- Cancel save dialog box
- More about trying to automation multiple Excel instances
- EXCEL PROGRMMING OR MICROSOFT PROGRAMMING QUESTION
- Saving file overwrites AddIn
- Copy Patse Macro
- Click the Step Into button via code
- IF AND THEN Statement problem
- Posting in each row of a Summary sheet the sum of corresponding itemson another sheet
- In VBA, bump to next row each iteration
- Arrays
- insert cell value into string
- Application.FileSearch 2003 vs 2007
- Adding date to a column in Excel
- Clear a sheet.
- Managed UDF Cannot Call WCF service?
- Hooking the FileOpen Event from the OfficeMenu in Excel 2007
- CommandBars in 2007?
- Need help w using custom image for custom toolbar in Excel 2007
- TreeView - How to add + and -
- Close a form when you click outside of the form
- Code to list concurrently open workbooks
- Duplicate Rows Based On Cell Value?
- How to click a cell with mouse and have a different tab appear
- Data validation on combo boxes
- Chart Macro Problems
- Undo a Worksheet_Change Event Causes run-time error '10'
- Creation of a form in Word and save the data to excel.
- Textbox Formatting Trouble
- Conditional Formatting Code
- create loop in macro for a list
- When I rename a module the keyboard shortcut stops working
- DDE Links
- Accurate vertical scrollling?
- How to traverse subdirectories
- transfer the name of combobox to module
- dates to text
- save as error with no click
- SELECT * INTO[Text;DATABASE...
- modification of auto-multiple workbook macro, Ron DeBruin (Copy4)
- Code takes a long time to process
- Macro that needs user input to import excel files
- QueryDef; Error 1004
- Making a Summary from multiple worksheets
- Using Add-ins
- Table range coordinates?
- Hyperlink All Column Values
- Macro in excel
- Pushing/Writing data from one cell to another
- How to Dim Hummingbird HostExplorer
- Insert Column to the left in a list
- Range("A1:A10").Interior.ColorIndex = Xlnone
- SUMPRODUCT in macro
- How can I use "VLOOKUP" with different Table Arrays
- Dynamic Visibility of Charts Through Checkbox Selection
- Simple Excel 2003 macro not working in Excel 2007
- ThisWorkbook.FollowHyperlink....
- Macro for duplicating rows based on cell value?
- Make Enable Property = OptionButton.Value for all Controls in Fram
- OptionButtons with same GroupName not working properly
- Re: Move a file
- list the pivot items into column a:a
- How to get the folder name of thisworkbook
- Worksheet arrays VBA
- rng.Count ====>results wrong value?
- TABLE filter net zero amounts
- Productivity tool for managing numbers in Excel
- Excel 2007 error after close down
- Dates and Times
- GetActiveObject("Excel.Application") for multiple instances of Exc
- Combo Box
- Cond format if Len() is greater or equal to 255 in a code.
- Insert Text to the cursor position of a Text box from another cont
- .Font.ColorIndex Delay Question
- If statement to add picture based on cell value
- How to keep Excel from formatting columns?
- Re: Settin up the default application to open hyperlinks in cells
- Creating a new worksheet and naming it according to a specific cel
- Macro to update hyperlinks?
- Enabled property failing when code tries to set it
- XL2007 Save Thumbnail
- RE: How can i get xCellRef.val.sref.ref.rwFirst?
- Could this issue be specific to Excel 2003 ???
- Auto save at specific times with changing saveas name
- Refresh a cell that contains a formula
- Select Variable Range paste last row + 1
- How do I set up a weighted percentage formula in Excel?
- Compare value in column AP with value entered into one of COLs D-
- RE: Followup To Jim Thomlinson macro
- Status Bar more complex
- Find a cell value then read the next row as a record of columns
- PivotTable & PivotFields/VBA
- Combo Box value is null
- Find previous active cell
- Adding page breaks conditionally
- TrimAll ; $nbsp; alt+0160; Cell View Add-In
- Stopping Find from wrapping around in code?
- Ignoring errors?
- VBA Combo Box for Excel
- Insert picture using Macro..
- Define a Variable
- Staus Bar
- Non-Sequential Count
- Number of colons
- A macro that counts cells when the conditional formatting formula =True. i.e. the cell is colored other than white.
- Pivot tables map to network drive?
- Data Type Declaration
- Re: Concatenate the lookup values from all occurences
- push recordset from excel to SQL server
- Data Validation
- Access Query from Excel VBA
- Fastest way to reference a particular cell?
- Re: controlSource ques
- Print macro Excel 2003 used to work, now crashes
- write data to a closed file on network drive
- How to apply vlookup formula dynamically to a worksheet
- Text alignment in User Forms
- Re: Deleting rows
- How to make a macro run every fifth minute
- Re: Strange behavior in Excel 2003
- Hide All Excel Toolbars, Menubars etc when UserForm Loads
- Prevent worksheet Rows to Delete.
- Call sub from Personal.xls
- Re: Multi Select List Box - Checkbox
- Need to clear a fielf in Excel 2k7
- select case multiple conditions
- Splash Screen Timing
- Re: Update workbooks in folder, new name and save in new folder
- RE: Controlling Entire Worksheet with VBA Function
- Find, select, cut and paste
- RE: Multi Select List Box - Checkbox
- Coding UDF's with VSTO
- vb Code
- Protected Formula Error
- Timer on Userform
- Processing Time Varies
- Merging user forms with spreadsheet
- Advanced Filter works in recorder but not while running macro
- HOW TO CHANGE RESULT WITH SAME MACRO CODE
- Irregular Shape - Follow up
- Convert xls to pdf
- EXCEL MACRO HELP
- Problem with RegEx and matches
- Who opened the file
- Save to pdf and make filename
- type mismatch error
- Clear pivot fields - please help
- ListView Control
- hide columns automatically
- Entering value into cell in macro
- VBA Debug Mode : How to I enter it after executing the nth data row.
- Combobox
- Start up security
- HELP radio button not functioning in Excel 2007
- How do I use WinHttp within Excel 2003 Macro?
- Running balance table, monthly/year grid
- Header & Footer text
- Run Time Error 9
- Problem with password security
- Looping Text Import problem
- ListBox Conundrum
- MACRO ACTIVATED AUTOMATICALLY
- Saving as PDF and printing in a macro
- Sorting issue
- Export Excel Data to Xml Output
- Automatically change the line thickness of a row
- VLookUp
- InputBox
- General VBA Question Help.
- excel 2003 very unstable after copying a worksheet
- Can't manually open file after coding.
- Vanilla Ice vs. MC Hammer
- I Keep Installing Ubuntu And Vista And Windows 2008 Server, Just FYI
- need help; unprotect + unhide + save with certain name
- Mouse Coordinates
- Date Validation
- Break Links But Keep Formulas
- test for number
- Problems using FormatConditions.Add with an Expression
- Selection.Sort problem with formulas
- How to programmatically set ControlSource?
- save existing file name, different format.
- Open All Files that Meet Condition and Save Renaming
- How do I retrieve data for the last 90 days?
- Macro to group data in pivot charts
- Sub to clear pivot filters
- solely search certain cells
- Macro which inserts new sheet name
- Hide row from Autofilter
- assign formula to variant range of cells
- Trouble positioning an autoshape object using .Top in Excel 2007
- 2007 PivotTable Type Mismatch for records more than 65536
- Calling a function from a Sub
- Need sample for reading value from and writing value to cell E53 from outside Excel
- Same Contents, Regardless of Order
- State Validation
- Embedding an OLE Object from DAO Recordset
- target cells in solver
- Send email from excel with image
- Missing objects in worksheet (e.g. command button)
- General questions about VB6/2005 and Excel 2007 compatibility
- Reconciling Lists
- Select all Matching cells
- Variable Declaration
- SIMPLE way to call code in one XLA from another?
- command button can't be clicked
- VBA empties clipboard
- Formula Problem
- ado copyfromrecordset and nextrecordset
- Printing-don't need half this code but which half?:-)
- Open workbook and pass info
- help! macro textbox
- operate macro across multiple sheets, error, cannot locate solutio
- Getting text to overlap into other cells
- Help with a Macro
- Writing Macro in Excel 2002
- Complex Summation
- Stop Macro if file is already open
- transfer a macro to the personal macro worksheet
- Frame
- ShellAndWait Query
- Variable Row Numbers
- Send Values from TextBoxes to Specific Sheet on Network?
- If active sheet and cell reference
- Returning result as 0 from #N/A
- 2008 East Coast US Excel User Conference
- Jet 4.0 ISAM Error
- Reminder or Buzz in excel sheets
- Excel crash while expanding object in watch window
- Vlookup - error handling with VBA
- Code to close and reopen file
- SpecialCells method of Range class failed
- OLEObjects
- Want to Copy and paste to new sheet range except hidden rows.
- Little help with filter Please please!
- Excel 2007: Error 400, Excel 2002: OK...
- Prompt for password
- Getting Unique Data Only!
- Format date in Multi-column listbox
- Can I add an item to a PivotCache with VBA?
- VBScript to set conditional formatting for cells
- Open a UserForm when a Tab is selected
- Custom Function displays as #NAME
- Excel document (with VBA and Macros) TO standalone app or Web
- Excel Add-In Using ADO to retrieve database records
- Excel hangs when switching focus
- Pivot table grouping
- changing formulas across worksheets
- working with format 01-01-08
- Test for color of sheet tab?
- Can you use UsedRange.SpeciaCells() to loop through all Cells?
- Macro Problem
- Insert Pictures using Macros
- Data delete and mass copy/paste with macro questions
- Setting the view area
- Sum an R1C1 Range
- HOW TO PROMPT MSGBOX JUST ONCE
- Detecting which Windows is running
- multi text boxes validation
- textbox validation for date and condition
- Auto-Numbering fails
- grouping in Excel
- Convert Number To Word ?
- Creating User Forms
- Keeping a log of activity in a worksheet in a second worksheet in same workbook. Phew.
- HOW TO PROTECT SAVEAS FILE
- countif / sumproduct or something else?
- Overwriting data
- find row number of next empty cell in range
- calculate direction
- VB code to move text cell
- combining integer and decimals
- Nested IF functions
- Use UserForm to Access Spreadsheet on Corporate Intranet?
- How to set a tab stop for a command button
- How to translate Excel formula function name to another language?
- Date entry mandatory
- How to set the range?
- Zoom event in VSTO 3.0?
- move and then unprotect
- Protect all cells but allow data validation dropdown change
- value is changing at the end of Call Sub
- Need help with data validation
- Excel to Auto Recieve an Email
- Adding todays date to new records in Excel
- Textbox date "oddity"
- Sending Excel Workbooks to Outlook people automatically
- Textbox date "oddity"
- VBA - Active Printer Port Problem
- column count
- Starting Word from Excel
- How to Auto populate dates from a given start date
- Excel 2007 macro gets workbook name and path from temp file
- ADSysteminfo
- How to refer cell E53 from the previous (=next left) worksheet?
- Clarify this post
- macro to unmerge cells
- Auto Cell Color using VB
- Delete Rows
- Cleaning up code
- Why does this work now?
- Easier Way to Macro Total
- Prevent Right Click Menu
- Error 0:
- web query - strange behaviour (HTML instead values)
- Formatting/Merging Cells from XML Publisher
- taking "strip html" to the next level
- Clearing the interior color properly?
- Looping a Macro
- Help to the first sheet
- Cursor information from a graph on a sheet
- Importing text from clipboard into a sheet
- Adding formulas to cells dependant on data in another cell.
- Printing macro i network
- for small project management which is the most suitable software
- Change view without activating sheet? - Repost
- Hide blank rows - what is wrong with this code ???
- need to get several formulas to change chronologically across shee
- Using Solver in VBA for excel without cell references
- Makroprogramering
- Change view without activating sheet?
- Excel VBA 2003 Addin trying to map Context id to .chm file
- Trouble Sending emails
- Remove Alpha Characters
- problem running macros on a file from server
- is current cell within a named range
- use data in cell as a formula for another cell
- Web page will not reveal its secrets
- Values for charts
- In an Excel formula can the clock be used to measure time?
- Re: fill a web form from excel vba
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.