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 |
- Enhancements to Sub FillColBlanks by Dave Peterson
- To change Columns(4).Rows.Count
- Error sending sheet in mail body
- Unhide sheets
- sumproduct & dates & similar data
- How do I calculate at timed intervals?
- need an OR in the countif statement
- Excel Macro to choose a line
- PRINT command button
- Calling procedures of a different project
- searching cells with a macro
- Using Excel VBA to Make Edits to A PowerPoint Pres
- How do I only recalculate 1 cell
- sorting named range data
- Extracting 3 Arrays from 1 Array
- OR statement in a Countif
- Error in Retrieving Formatted Cell Value
- How to get specific cell data from one sheet!
- How do I activate the next cell in a selected range?
- Scan pdf417 barcode = is scanned, actually tab data to next cell.
- Simple use of ActiveX Command Button -
- Get last column
- Why Am I Getting This Error Message Please?
- Delete all objects on sheet except...
- Autofill today's date Everyday
- Copy from file1 sheet1/file2 sheet1 last blank row
- Macro hide rows with blank data in cells
- macro doesn't hide columns for an unexplicable reason
- pulling data from one worksheet onto another
- Functions not working in Vista... (custom defined viewable as modules with Alt-F11)
- Excel calculate the z factor automatically
- Bound Control On A Form Problem - Office 2003
- How to seperate measurements 1.375 in (35 mm)
- SQL connection string giving type mismatch
- sumproduct
- Range of cells seem to be initialized randomly
- Can a sub be deleted via macro?
- VLOOKUP
- Embedded pictures
- Pivot Tables using VBA
- C++ DLL from VBA
- Loading a Userform
- User Name
- get validation on a cell clicking a button
- ActiveWorkbook.Sheets.Select
- Tuition on 'copyorigin'
- Command button on worksheet
- Name of cell range not accepted in Conditional Validation
- File opens second copy of itself for no apparent reason
- taborder on Excel form
- turn off error handling
- New array with old array elements
- Lookup second/third values
- Down One Row
- hide rows if cell in a column has no value
- Excel.Application error
- If X = Y then (when it doesn't have to be an exact match)
- How to Loop and Read the Cell until the end of worksheet
- Object: smart way to assign a value as for an array?
- Arranging data from different Column
- How to evaluate the size of each worksheet in a workbook?
- MsgBox using cell references
- measuring load time
- showlevels is very slow
- Copying sheet with hidden columns
- Missing Library Problem
- External data validation
- copy certain cells
- Computer "name"
- subtotal question
- Replace Contents of Destination Cells
- Closing WINWORD.EXE from Excel VBA when my main proc ends
- Looping a Macro
- Search in multi dimensional array - URGENT help
- Unfixing source data range for a pivot table using vba
- Advanced filter criteria for <>
- Adding a micron symbol to text string
- I found a bug
- Limitation to Collection Object
- values are decimal
- xy scatter chart using multiple dynamic range as source
- Data Validation List - Multiple Columns
- Instruction Delay
- Web Query
- dash ports
- Calculating speed
- last “Date Modified” of separate modules?
- Updating ExcelName Registry Key
- Excel Macros Disabled
- Prevent opening solution on other (older) versions (Excel 2000) et
- hide column script, range address?
- Excel VBA Compile Error when dimensioning jagged array
- question about creating variable from 2 strings
- Getting error with load/unload of UserForms??
- Excel Recent Files Issue
- Find-Copy and Paste
- Repeating Named Range
- Macros, Excel 2000
- ZOrder Behavior Changed in Excel 2007?
- ZOrder Behavior Changed in Excel 2007?
- Worksheet_SelectionChange question
- Help .. Lookup and match UDF/macro
- Copying Cells on Enter
- Excel 2003
- Does Excel have Threshold function?
- api - tracking LostFocus or Exit event of a combobox
- api - tracking LostFocus or Exit event of a combobox
- Catching RNG before getting changed?!
- Excel 2007 Bug - "Locked" Property is Broken for Shape Objects
- Excel 2007 Bug - "Locked" Property is Broken for Shape Objects
- Re: Email code Question to Ron de Bruin Please
- INDEX function issues
- lines
- Automate Access from Excel to run hidden
- equipment service tracking
- tabbing to textboxes in multipage tab control
- Work book with working days only
- External File Validation?
- Calendar poping up on form when not wanted
- Simple question?
- Interop.Excel Split and Copy
- runtime error #9 subscript out of bounds #4
- hotkey for command button on Excel form
- VLOOKUP and then some
- Speed up code Removing duplicate rows
- Can you change scanned input of an = to tab in excel?
- Matching multiple userform height and widths after resizing
- Calling a module only when a sheet is actually "activated"
- looping through questions
- E-Mail Sheets Q
- Error in external named range
- autosize cells
- ExPaste-xl2ppt, a powerful Excel add-in
- Import from Outlook/Contacts
- Copy worksheet to another file
- Is there a way to count how many elements there are in an array?
- Macro for copying cells above empty cells
- why it does not work????
- macro for copying cells above empty ones
- counting elements of two arrays
- List Box Head-Scratcher
- matching similar values
- Re: Help requested for conditional formatting
- Lower case "a" in "application"
- Network problem
- Delete Variable spaces at beginning of a range
- how to pause a 'save-as' and continue after input
- VBA find today's date in Column A
- Fill work day
- Amend Code Help Please
- Import Data button
- Range name Database only works on one sheet
- COUNTA
- Changing linked cell runs ComboBox code
- Insert picture with macro
- Excel slowing down....
- Excel VAB+ADO connect ACCESS with SQL
- Count Variable
- Worksheet_change error
- Unbelievable error 457
- Get last column
- RE: Macro for finding duplicate names(easiest way!)
- XL 2007: Conditional Formatting not saved properly
- Data Validation redux
- Calendar control
- Validation
- When changing document information how do you show the date and t.
- VBA Code
- Unwanted Procedure & Do While
- For each Workbook limit?
- How do I place a chart on an Excel VBA Userform & drive w/spinners
- Email Ron or Dave Please.
- Where to declare module-level variables?
- Formula returns "#VALUE"
- find the sheet of an active chart (VBA)
- Conflict in assigning values to a cell from another cell
- Dynamic scroll bar max limit
- Using a variable to determine row selection
- PivotTable: Excel cannot complete this task with available resourc
- runtime error 9 subscript out of range #3
- Need help with rounding in VBA code
- Using the data in the last cell
- Speech Activation for Messages
- Speech Activation for Messages
- 2 auick questions please
- Stubborn date format and range copy
- Macro to LookUp Data and Copy/Insert only Non-Duplicated Rows
- Re: Line under first menu item
- Copy a R1C1 formula to a user defined range results #NAME? error
- Using Certain Forms From The Pivottable Wizard in Excel VBA
- Automate Tab Color
- Sheets("Sheet9") Error
- Break on Calendar Year
- Execute a macro in another file with an argument
- Get data from database via web
- How do I calculate the z factor automatically
- Where are my custom toolbars in 2007?
- runtime error 9 out of range subscript #2
- how to assign contents of a cell to a macro variable
- RE: Offset(0, 1) and then Offset(1, 0)?
- How do I calculate the z factor automatically
- If sheet exists, delete
- Slow code
- runtime error 9 out of range subscript
- Copy to destination of "A50" + value in I12 (sequence#) A51,A52
- Re: Format Cell based on two other cells in same row.
- Automate MS-Access from MS-Excel
- Sort Worksheet Range from another worksheet range, Excel 2000 & 2003
- Re: Excel's GROWTH function?
- Disabling Specific Menu Bar Choices
- Rolling back 'folders delete' using VBA
- Replace old sheet with new without losing formula ref
- Excel 2003 ODBC driver without support for XML files?
- Re: Matric vba array
- Formula in macro with variable sheet names
- Copy and paste contents of one sheet into another
- Selection.Cells vs Range reference - strange behaviour (using 2007
- Nested With's
- Moving Shapes within VBA
- Upgrade options from XL2003/VBA/VB6 to XL2007/VB.NET ...
- pivot managment through VBA
- List of Fonts
- Run-time error after calling a procedure
- List box in tool bar
- partnumber search and select the cell
- define destination sheet
- OPC Data Collector
- Help to Break links please!!
- can't find macros in a macro-enabled workbook
- Hourly Refresh
- Hide rows using VBA
- Re: Excel's GROWTH function?
- Yield (ROI = Return Of Investment) issue
- manually run macro's
- Re: dynamic range counta error
- Retrieving Textbox values from another workbook
- Using formula in code...Part 3!
- Can you specify an Array as a Target??
- Compare cell contents in adjacent columns
- RE: Copy data matching date and retain information in a monhtly report
- Call Sub From InputBox
- Search and select a cell when pressing enter
- Dropdown Options
- Re: Using VB.Net, How Do I Put a Picture (jpg) Into a Cell ?
- Re: Changing the Font Size and attributes in a message box
- Re: dynamic range counta error
- Re: Selecting a file in Windows Explorer
- Graphs to eps image
- Can't Find Project or Library
- Merge two sheets into third sheet
- Numeric
- Re: Update Links Stopping Workbook_Open Routine
- Re: help on circular reference and MINIMUM value to be found
- Help with calling Data Form
- Data inputted accuracy check
- Using formula in code....Part 2!
- Copy a Sheet to New Sheet Q
- Edit Pivot Query in Code
- Re: pointers in VB
- Re: Comma separator for numbers
- How to set active cell range to an variable
- Re: How to Increment Time using EXCEL ??
- Re: location of combobox and chart
- Re: Fill combo box from range
- Re: merging all macros into one
- How to pool Print Jobs
- Help Please
- Run-time Error 1004 - retry x times or end
- testing efficieny/speed of a macro
- Office 2007 Filter Copy Issue
- Printing a certain amount of pages based on amount of data
- Concatenate cells in one column of value in another column is same
- Need some help with codes
- Combining logic IF with string searches
- Using ADO with INSERT query
- Using ADO with INSERT query
- Using ADO with INSERT query
- Error handling
- Macro save as from Template
- Read and write an Excel file
- access file based on last saved date/time
- How to make tab name match cell on another sheet?
- find question
- runtime error 9, subscript out of bounds error #2
- Can you use formulas to manipulate the fill color of a cell?
- RE: Can you use formulas to manipulate the fill color of a cell?
- waiting for another application to complete an OLE action.
- Help Needed With Message Box
- Date filldown
- Two Worksheet Change macros in same worksheet? Is it possible?
- Programmatically show and hide portions of worksheet?
- Problem Sorting Excel Range in VBS
- Macro Security to "Low"
- cut rows to another sheet if a specific cell NOT BLANK
- Code to add Range Value produces nothing
- Writing a macro in Excel that Refreshes External Imported Text File
- Code Procedure for multiple sheets
- Find existing number in another workbook
- List box to a Cell
- Issue with filenames using FileSystemObject
- AutoFilter Header Row
- How To Link To An External Dynamic Named Range
- Using a variable for the 2nd paremeter in a vlookup
- Can I end a sub on error?
- Left as a condition in SUMPRODUCT
- Finding multiple values
- Number of Worksheets in a Workbook
- Excel Printout runs off page
- Help with SUMIF in VBA
- Macro Control
- get application, object error
- Pivot Table with no "Blanks"
- List Box Setup
- Last cell with data in...
- Using If Then Else within a Macro
- Listbox Scroll Problem
- Prefill a text box on a form
- Match Formatting
- Excel Charts on Windows Forms
- Delete rows with duplicate information
- Test to see if Sheet exists
- Get data from Outlook Public Folders in Excel
- Highest Value In A Range
- Need code to close minimized workbooks in BeforeClose event
- dropdown value
- How to get the PageBreaks not to appear in the middle of the table
- How can I get a macro to know when it false and run a different ma
- Is there a formula that can display the Tab Name? If not can a Ma
- Defining an R1C1 style dynamic named range using vba
- Links and Add-Ins Error
- Entire Column - Dave Peterson
- Worksheet_Calculate
- Add-Ins menu in Excel 2007 diseppeares?
- formating a cell to pick current date and update daily
- Performing Data Transformations
- Rename a worksheet that includes a cell refeerence
- monitor a specified range ( OnChange)
- Debug to Output
- The "temporary" parameter of CommandBarPopup.Controls.Add
- Loop through cells in columns..
- Deleting #N/A
- Save on sheet shift
- Calculate cell once (on workbook open)
- HOW DO I FORMAT A CELL IN EXCEL TO PICK CURRENT SYSTEM DATE
- Last column...
- Macro Running Twice
- Copy data from one workbook to another existing workbook
- Find & replace string in text
- Function to display username/networkname
- Returning Image Details
- How to encrypt excel pki
- Hyperlinks from one excel sheet to another in VBA
- odbc connections in excel 2003
- excel 2003
- ScreenUpdate Usage
- Unprotecting worksheets only if you have the password
- run time error #9, subscript out of range
- Copying data from cell to other on click or color change
- VBA Functions
- How do I set up two cells with a reciprocal formula?
- Test Date of External Data Source
- How do I create a macro to add a zero to end of a cell? or cells..
- RE: How do I set up two cells with a reciprocal formula?
- Calendar control
- Dropdown Box Update
- Print to PDF
- Block Manual Entry
- waiting message
- Color Sort
- Calendar control
- Can you use FileCopy to convert a file as well?
- Determine what row is currently selected
- StrComp
- Question about a Variable being Nothing
- How to copy a drawing image between sheets
- Picture Problems
- if statement
- Use value in cell as numeric reference to a row, within a sum func
- Activating EXCEL window from PowerPoint
- RE: Picture Problems
- RE: if statement
- Run-time error '1004'
- RE: Use value in cell as numeric reference to a row, within a sum func
- cell comparison
- RE: if statement
- Problems using Worksheet_Change
- RE: Question about a Variable being Nothing
- RE: Can you use FileCopy to convert a file as well?
- Virtual AutoFill Macro
- cell comparison
- Make a particular tab visible on a forms tab control
- RE: run time error #9, subscript out of range
- RE: Color Sort
- RE: Print to PDF
- Excel 2007
- Can Excel XML validation be done on Web?
- RE: Determine what row is currently selected
- RE: Determine what row is currently selected
- RE: How do I create a macro to add a zero to end of a cell? or cells..
- Get column count used range from S to IV
- RE: Problems using Worksheet_Change
- Macro Not Completely Working
- Using formula in code
- RE: ScreenUpdate Usage
- Userform to size to display
- How to org my questions
- RE: waiting message
- Test For Add-Ins
- activate VBA
- Want VB form to show in Excel Worksheet
- Microsoft Visual Basic- compile error: can't find project or libra
- print/save macros
- Get outlook contacts from a Public folder instead of DefaultFolder
- RE: Use value in cell as numeric reference to a row, within a sum func
- RE: Use value in cell as numeric reference to a row, within a sum
- Adding a hyperlink to a macro generated e-mail
- Automating Refreshing Part (III)
- Need autofilter and data extracting help
- RE: activate VBA
- RE: waiting message
- Simple Custom Function???
- RE: Test For Add-Ins
- RE: Unprotecting worksheets only if you have the password
- Define variable from cell to open a file
- Copy/PasteSpecial Not Pasting all Formatting
- RE: How do I create a macro to add a zero to end of a cell? or cel
- RE: Test Date of External Data Source
- RE: Macro Not Completely Working
- rename message
- RE: How do I create a macro to add a zero to end of a cell? or cells..
- Filter duplicate data in excel spreadsheet
- RE: Question about a Variable being Nothing
- RE: cell comparison
- RE: activate VBA
- RE: How do I create a macro to add a zero to end of a cell? or cel
- protect sheet problem
- RE: activate VBA
- Same Office 2003 but different VBA Tools>Reference (object ref.)
- Excel 2003 hangs
- Changing Value
- Multiple Workbooks
- RE: Picture Problems
- radio buttons
- Need help creating VBA procedure for Open event
- RE: waiting message
- FIND Beginning of field and add C to end of the field
- Define variable from cell to open a file
- RE: Test Date of External Data Source
- screenupdating problem
- RE: Using formula in code
- RE: Simple Custom Function???
- RE: Define variable from cell to open a file
- RE: Same Office 2003 but different VBA Tools>Reference (object ref
- RE: Test Date of External Data Source
- RE: Picture Problems
- Copy Selection doesn't work
- Text output
- Programmatically show/hide portions of worksheet?
- listbox concatenate
- Hiding a From Button
- Non-programmer needs help with search function
- Immediately Entering Break Mode
- Obtain Path on open workbook
- Combobox which are dependent
- Check Box
- path problem
- sharing between spreadsheets
- =IF ..OR.. =IF
- Simple Text Editing Macro Help
- Deleting rows from mutliple sheets
- Macro help needed
- define variable range
- advancedfilter action
- Inputbox default Question
- path problem
- looping to through rows
- Subtotals problem - wierd!
- group/ungroup
- Distributing A Custom Menu
- Is there a way to give range names (especially with relative reference) for series names and series values in Excel 2007 graphs?
- Inserting blanks
- Copying
- Identify Shapes
- Merge (not consolidate) workbooks?
- EntireRow
- coding vba
- Ensure items in a list aren't entered twice
- Code correction pls help
- Partial find and full replace
- Opening new excel file & inputting data into cells
- Changing File Name
- Changing File Name
- Flash Screen/Timeout msg box
- Shortcut for Format Painter
- Combo Box Click Event
- Create loop to insert two rows after every row of data
- Code that executes against any Excel file
- Free Excel and PowerPoint Backgrounds
- VBA Combo Box
- embedded WindowMediaPlayer keeps resizing
- using checkbox to calculate another cell
- Custom Menu and Menu Items
- Button On Wowsheet
- Copy Data from one workbook to another
- password for end user
- Gray Treeview item in VBA
- PivotCache.Refresh
- Excel.Workbooks.Open behaviors differently in VBA and VB
- Dates and Combobox problems
- Concatenate non-concurrent cells
- Creating and accessing PDF
- Recorded single column insert in macro. Macro inserts two not one
- Qualifying macro run according to current selection
- Retrieving value from range name
- Outline level
- I need the code for Audio Warning!
- Hide a worksheet
- Can't copy and paste the comments
- Dynamic Range based on cell contents
- Sort works in 2003 but not in 2000
- Insert row and copy cells from the currently selected row
- LegendEntries
- copy cells to end of range in other column
- sum for each month
- move cell values over 2 cells
- Autmating CSV Import???
- Workbook_Open does not work
- macro button to unprotect entire workbook (used after password ent
- Chancing Excel worksheet
- EXCEL: Feeding data into model and recording multiple output value
- Comparing columns and intersection
- Using Solver with Named Ranges
- Looping through selected charts
- Automating Refreshing (Part II)
- Copy/Paste Worksheet to End of Workbook
- some code sets a variable to a sumif formula, offset 2
- Resizing Checkbox
- Routine procedures/formatting same as previous cell
- Macro pt.RefreshTable
- Determine last row while autofilter is activated
- Print condition and autofilter
- what exactly does Exit sub do?
- To set command for total amount
- Copy command
- Trying to import multiple text files using "fixed width"
- Help with paste special
- "Object Required" not displaying
- Problem with VBA Macro Consolidating data
- Finding a Sheet
- Button to activate a macro
- Macro Continuation
- Hiding/unhiding columns based on user selection
- Excel to Outlook email
- Delete rows where colums match
- ISNumber
- Macro Problem
- timer ticker
- Linking to cells on a spreadsheet with controlled access
- Can't find Custom Toolbar attached to workbook
- Sorting row data?!
- last cell without a blank
- Opening notepad file then sending to back
- Double click cell to execute macro
- formating RichEdit
- Closing Userform
- user interface only question
- i dont want vlookup to solve this
- mousedown in a graph
- Deleting first empty row along with the next 700 rows
- Search across rows
- Help with ActiveWorkbook.SaveAs
- I am looking for an Action Log format
- Check File Open Macro
- Select Case in ComboBox
- Using VB to auto generate email - unable to get stationery
- Copying data
- Form focus
- Focus in a form
- Extracting text from a string
- Office 2003 @ using 100% memory
- Row height & Column width locked?
- Excel equivalent to Eval function
- Look at numbers between 2 numbers and copy the complete rows to a worksheet.
- Access remote database with IP address
- VBA format for a variable cell selection
- Autofilter or SpecialCells-related bug?
- Establishing which rows are currently visible due to filtering
- programming
- Macro Recording 2007
- runnung word
- Disable "Move or Copy sheet "action
- Identify Blanks; All Listed in Column AX
- How can i secure excel files if copied from office server?
- Upgraded to Excel 2007 "Compile error"
- Append Excel Data from a named Range to an Exceldatabase
- Need to Loop some code based on a count of Cells
- Way to change or update the macro
- disabling custom menu upon closing workbook
- Macro for Deleting Specific Rows?
- combo box in several cells
- go to the right worksheet
- MultiPage UserForm - Need to Prevent Duplicate TextBox Entries
- VBA Code vs Public Function
- Stop Macro
- Search Listbox Values
- Combo Box Display Multiple Column Info After Selection Made
- Drop-down box & code
- Sending Excel ranges to Word as Metafile pictures
- AutoTextMacros.xlt: Solution?
- How to retrieve Excel column as a string (AAA instead of 703)
- vba browse button set to current directory
- Copy tables from MS Word
- Changing Cell Color by clicking on a cell
- Runtime Error
- Excel VBA macro
- Cell colours according to date
- Renumber "Microsoft Excel Objects" SheetN (XXX) ...
- Change Event
- Disable Copy/Paste
- Excel 2003 loosing Database Queries
- Clearcontents takes long, long, time
- Macro to name a worksheet with a date variable?
- Override normal VBA when clicking on a add-in (BEx) toolbar button
- BCC global distribution list
- Is it possible to make an excel macro to work with all sheets?
- Protocol in Immediate window?
- Open Access 2003 or 2007 from Excel
- Using LINEST with a sparse data row?
- Refreshing automatically
- Background in email
- Making a text box active when returning to a screen
- The Current .Net Security Policy does not Permit...
- how ot keep value and drop formula while copying
- control toolbar combo box and command button
- Editor Issue
- Creating function
- Error Not Displaying, Instead macro just ends
- auto insert worksheet name in dynamic named range
- creating a function
- Determine if template file is dirty
- how do i send a named range as the body of an email
- Save As name
- Populating data in ComboBoxes on UserForms
- Data Validation and Error Reports
- Addin conflicting with Workbook Module
- Find last row and delete from +1 to end
- open data form when worksheet opens
- Disable "Move or Copy sheet "action
- Modifying a Macro - Help Please
- Clipboard is empty or not valid
- Merge cells if value is zero
- stop auto macros running when opening a file by code
- Updating VB for info entered in a sheet
- Dir for folder name?
- Type of variable
- creating form/filter in Excel
- geo rectify coordinates in vba
- vba command
- Macro to create a schedule
- Please help me with running this macro in Excel 2007
- Using VLookup in VBA code with variable range
- Date ranges
- tabbing
- Multiple IF NOT OR
- extract data from web
- thanks
- Enter Button
- Print String from VBA
- Sort/Search Arrays
- Advanced Filter not working correctly in macro
- Accessing another workbook's data
- Sum the value of cells, when cells contain errors
- Sorting problem
- Macros
- locked cells and code
- Code needs tweaking :P
- 2003-->2007
- Stopping a Macro
- Place Cursor in A1 on all Sheets Q
- Enhancements to sub which writes cell value to comments
- 2003->2007"unable to set the Left header property of the PageSetup
- ActiveWorkbook.SaveAs in excel 2007
- Getting data from different worksheets in another workbook
- Referencing workbooks in macros
- Insert picture from filename & path in sheet's cell
- update
- Method proceeds but not taking action-Gurus help here
- VBA compile error with Split Text Function
- Extract Data from Text Files
- image1.bordercolor not showing
- Background Calculation acts as though it's disabled
- pass value to excel userform - is there a constructor? how to pass
- VBA code to copy and paste by values from one Excel workbook to another
- Worksheet Activate
- highlight a row when total is in column A
- run all worksheet macros
- Updating links in a spreadsheet
- Listbox Selection
- sounds easy but I can't figure it out.....
- I receive "isref" when i do an autofill in a column in Excel
- Let the user select a range from a window
- slower by 10 times by adding an easy function????
- Multiple Language in Excel
- Another Userform Date Problem
- How to break the rowheight limit
- Dynamic linking or referencing of cells
- Run-time error '1004' - The file could not be accessed.
- What can cause Excel to save slow?
- VB Script to Remove Letters from a number
- Can you ask a chart which worksheet it's data is located?
- Trouble Adding Worksheet via VBScript
- password recovery tool
- Parse Data - Code form Don G.
- Open XLS as though an XLT - unsaved copy in memory
- Link loses formatting
- Referencing Cell Location
- Define Range Question
- Test if Worksheet is not in an Array
- Add result feilds to a pivot table
- value doesn't get passed to a sub-routine, loop doesn't iterate
- Vlookup Question
- Date format problem on form
- Loop until X or Y?
- Copying non-contiguous cells
- is it possible to have excel insert zeros into data??
- Inserting a row in excel 2000 although the worksheet is protected
- Find Blank Cells and List Each Cell Address in Another Sheet
- sorting a worksheet with vb code
- Row and Column Reference 2007
- Selection.Copy throws an Object Required error
- Delete all cells in range matching certain values
- Validation Object error
- If the sheet exists...., then
- Excel running Access query
- save Changes and close book
- 2 problems with my vbs script
- Overwrite saved workbook in VB Script
- Real Time Graph
- How to use VBA to copy selected data from one worksheet to another
- Import Data from txt file
- Loop +2, +4, etc. help
- Receiving error 1004 - Method 'Rang' of object '_Global' failed
- Next Loop
- Time Sub
- Automatically Selecting "Yes" in an Externally Called Message Box
- Set Row Height depending on cell content...
- I want to put the text in the cell of column B in front of the the text in column D.
- reformat to get more hierarchical view
- Kill a file
- Goto in a sheet
- 2003-->2007"programatic accses to visual basic project is not trus
- Copy data and page break settings from 1 sheet to another
- Fill the cell in column D if column D is empty
- Pivot table Page field content display?
- Shell Script
- Use AddIn to Open an addtional Excel Workbook
- 2003-->2007 recognize if i'm in 2007 or 2003 via code.
- How to auto update currency exchange rates in EXCEL from website
- Insert line every x lines until end of data
- Automation error with XLA addin, fails on commandbarbutton onaction
- Help
- Data Validation blanks
- need to divide value across added rows
- inserting page-breaks
- Programming the VBE Find/Replace dialog?
- Duplicate value are not being removed
- label position affected by wide screen?
- for next loop problem
- Insert image from Cell value
- Worksheet printing
- How to Differentiate between a Student's Score of "0" and a Score of Null?
- run macro on other computer but not this one (workbook open event)
- Connecting to SQL -Looking for best methods
- Debug.Print convert vba
- Debuging Macros
- Probelm with Application.Run Method
- time question
- Re: Special SUMIF Formula
- Going from total to details
- Supress Confirmation Prompt
- Auto_open to check for folder
- copy columns paste in rows
- use of variable in array formula
- reverse or flip rows
- Sub to write formula results into comments
- run macro in workbook open event once only
- saving web pages
- Multiple fonts in a VBA UserForm label (to make XL 95 form non-modal)
- Reverse Values in an Array
- Save Control To Userform Toolbox
- How to find the most common pair and triplet numbers?
- deter worksheet deletion
- Loop Until Last Worksheet in Workbook
- How to tell if xls is open?
- if any range on sheet2 change put "a" in sheet1 cell a111
- Data validation
- Stopping the confirm popup on file save with same name
- Help including exception handling - try block
- Importing JPEG data into spreadsheet
- Problems Adding Columns--but data close to IV and no hidden objects
- pass a variable to a public sub
- idea which I don't know how to work out
- Dynamic Charts
- why my excel data lost on cd ?
- why my excel data lost on cd ?
- Working with column and page widths
- array formula in macro
- Duplicate rows, based on date difference
- Duplicate rows based on date difference
- auto run macro on open of workbook if cell a1=A
- Invalid page fault in module RPCRT4.DLL
- Output 0 to 100
- how do I compile data entered using a drop down list
- Excel 2000 custom toolbar button macro assignment
- Help on adding the second trendline in a "lines on 2 axes" Chart by using VBA
- Excel 2007 – Error 400 from custom toolbar
- Function to return column where a date is entered
- Updating Pivot Tables via VBA
- help with calling a sub procedure, doesn't compile
- Can I convert years to months in the amortization template?
- problem with protecting sheet
- problem with protecting sheet
- Can Excel recognize code I didn't write?
- Move data from sheet to sheet based on ColA
- Text Box - Moving Formatted Text
- Import Data from Access/Query Criteria Not Enforced in Output
- Help with Saving to a Folder
- Userform TextBox
- shortcut key to macro variables
- Text via ODBC truncated at 255 characters
- Recording a macro to copy into a series of variable ranges
- how do i create a nomogram in excel?
- Read a Range into an Array
- VALIDATION USING ALPHA-NUMERICS ONLY
- VALIDATION USING ALPHA-NUMERICS ONLY - NO SPECIAL CHARACTERS
- how to programmatically clear Document Recovery entries
- FunCustomize - general how-to question?
- Syntax for getting value of named workbook range
- Dynamic Data from Excel to Word
- Replacing "IF" or "LOOKUP" formula's with VBA Function?
- Help! Can't find bug in program
- ComboBox Toolbar
- Copy button caption
- filtering out duplicate data values
- VBA and "If"?!
- highlight row / spin button
- Lotus Notes email from Excel - formatting body text.
- retrieving named ranges from another sheet
- generating random cash flow with same IRR
- RTD only alive when Excel is active app?
- VBA small code error?
- hide row + buttons and password protect
- Error trapping is not working for errors related to files
- comparing a date range within another date range
- spin up / spin down
- Macro - cell content left then....
- Can this be done with coding?
- Help, Query Refresh windowm appearing....
- Validation of the First Character entered in a cell.
- decimal places????
- Incorrect data when using xlset with autofilter
- list box / scroll bar
- Replacing "IF" or "Lookup" formulas with VBA function
- UDF with IRR
- How can I parse time and address from cell with non standard extra text?
- VB Programming for Excel (and Office in general)
- Macro Looks for Cell Contents & Performs Action
- Custom Filter loses blank rows
- excel search function
- Saving Files into a Folder
- controlling the Range.Replace method.
- Re: If certain text is in a cell . . .
- RE: Cut & Paste data in new Worksheet
- RE: If certain text is in a cell . . .
- RE: Search and replace using a named array on another worksheet
- Macro security via Windows login name (or other)
- Specified dates within a date range
- Toggle Button Caption
- An executable file to run a VB script?
- newbie c++/excel issue
- VB to find text and delete that row and three beneath it
- reset checkboxes
- How to improve my code?
- Forms and worksheet focus
- Improving this code
- Auto select when using Combo box in worksheet
- SPC XL2000
- msoControlComboBox Value
- Does this code Delete pictures or simply makes them Invisible
- add in, ribbon, tab menu problem
- Relatively easy data comparison Q?
- Checkbox Name Change?
- Help in calculating # of columns dynamically
- Excel 2007 Error
- Excel._Worksheet.SaveAs
- Filter and Move Row Macro
- Find end of column and paste formula in adjacent colmn
- How do I set up a formula for greater than but less than in Excel
- Capturing cell address and contents
- A formula that evaluates the value of a cell relatively addressed.
- help with inner loop to search for matching strings
- Open text file as text not numbers
- Recalc Alarm
- User Data form and populating a worksheet
- Copy sheet--Some cells more than 255 characters
- Double Vlookup Problem
- Permission to print from batch job printing Excel spreadsheet
- need help on inner loop
- commision on multiple invoices with sliding scale.
- xlDialogOpen
- Applying Bottom and right border
- End of data
- Incomplete query return, who can help?
- look up multiple fields
- VALIDATION USING ALPHA-NUMERICS ONLY - NO SPECIAL CHARACTERS
- Highlight the row and the column that the mouse pointer is in.
- Capture name of last worksheet opened
- Saving Files into a Folder
- Export from Access using vba
- macro button
- Testing for a value's inclusion in an array
- Please help! Data Validation is Suddenly Acting Strangely
- remove little green error triangle - how loop through to ignore er
- finding minimum value
- construction billing
- Conditional Formatting
- Detecting a single quote from a cells value
- Macro to find end of column data
- Macro to find end of column data
- Multiple Target Addresses...
- Copy / Paste Errors
- Protect Drawing Objects bug in 2003?
- Sub or Function not defined
- printer exception, error handler, need to loop through network num
- SaveAs matter: How can I save the worksheet on an external .xml keeping the .xls opened?
- How to make code waiting until Outlook finishes its job
- Data Validation, Dynamic Named Ranges, and Dependant Lists
- LINEST & How Nonlinear is it?
- Macro Import Excel Sheet into Excel Sheet
- Access to Excel
- Simple popup box question - font size change
- error handler, goto errgetfile
- Autofiltering macro does not work correctly
- Conditional Formatting / Positive vs. Negative
- Searching VBA Code
- Macro Selects Directory to Save File Based on Sheet Criteria
- How to output a sheet as PDF file
- pop up box
- Using IF statement
- Conditional Testing Glitch
- Copy and past as values
- Converting CSV text
- Set Document Focus to Top of Datasheet
- how to reduce execution time of my code?
- Text boxes and Spin buttons
- Macro question.
- Updating pivot items on 3 pivot tables contained on one sheet
- Value or Value2
- How to copy part of a sheet as a new sheet into another workbook?
- Sort by two columns using VB Script
- workbookbeforesave
- Bloomberg-Daten ber ActiveX herunterladen
- Importing Soccer results from Internet Site
- Need help saving an image from webbrowser!
- Send an email from Excel VBA
- Date Format
- Still retuns to begining of range, Please Help
- Duplicate a Formula in 1000 Spreadsheets
- Determing closing method
- Excel memory leak?
- Summary of Different Workbooks
- Combine data in two columns into one and sort the combined column alphabetically..how??
- MS Windows Common Controls-2 6.0 (SP4)
- List box in tool bar
- Encapsulating Communication Between Objects
- Re: VB to identify and delete any text box on a sheet
- Programming Solid edge with VBA
- VB to identify and delete any text box on a sheet
- Answering an Excel generated msg box Yes
- Returning to first offset point.
- HELP!!! Macro doens't run on clients maschine
- copy and paste problem
- Macros detached from buttons on charts
- Case Statement with multiple checks
- How can I find the rowheight and use it in a formula?
- Issue with command button visibility
- Command button
- Add a Pictures File Name and Path to a cell ?
- Hiding entire rows
- Merging Access e-mail field into Excel worksheet
- Run a macro when I open any file
- Help! - Need help with combo box list
- numbers change to text
- Object doesn't support this property or method (Error 438)
- Macro and Today's Date
- VB Code generates error on another machine?
- Delete a cell when found
- VB6 faster than VBA in Excel?
- Find All Instances of a Value
- Cancel Print
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.