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 |
- Change Link Source
- search in define name window
- RE: Slow sheet data entry?
- back to previous sheet
- RE: Code not work Take same action on all wkshts or selected works
- Change cell value based on other cell value
- If Yes then...
- Adding right click menu item to insert a blank row
- VBA code for inactivating button
- How to protect a range of cells but permit highlight
- How do you set up a month of supply formula?
- Re: Delete duplicate data based on date of data
- Solver: Can't add constraints when they are above/below certain va
- RE: Forms always on top
- add a letter to contents in a cell in excel
- Re: Nested Forms & SendKeys
- Select dynamic range
- ComboBox "Not In List" Warning
- Re: Print all (except one or two)
- Macro for sequential numbering
- Re: SHOW Userform
- VBA, Yahoo ichart csv file
- Delete Blank Columns
- Re: Worksheet_Change event
- Search and replace on the worksheet
- Extract data from Pivot table with VBA
- Re: Slow sheet data entry?
- Excel to TTwin
- pasting changing data to a new worksheet
- VBA Inserted Data Validation Fails
- Re: how can i record how long a workbook is open?
- Re: Do Until Loop not functioning properly
- Index/Match/IF
- Something Wrong With Posting?
- Re: Sum row using variable
- Needed - Collaboration with VBA programmer.
- Re: Putting a value in specifc Excel cell from Visual Basic
- Re: Using Code to Change Password for Protected Sheets
- Re: Array handling error
- Search for formulas in cells and apply to new record--no data form.
- Seeking some VB code help.
- Formating textbox's on a userform
- updating caption of added control
- Filling ListBox another excel file
- Re: HELP!
- Re: Get Query String from Access
- Re: insert today's static date dependant on a condition
- Default Folder for Import/Export Module
- Capture a number from a cell containing numbers and letters
- code to intercept 'printscreen' key?
- Executing two statements in a for loop
- Excel VBA Help
- Excel VBA Help
- Two questions on worksheet protection and hiding formulae/ functions
- Adding all numbers in a given range
- Re: Change Event
- Work-around for exporting sheet contents and removing code
- Re: Change Event
- Adding a C# method as an Excel function
- Transpose Function
- Re: Macro fundamentals
- Changing a Macro to fit new use
- Can links created in a text box be conditional?
- Re: Macro fundamentals
- free programming resources.
- distinguishing between cell formula, and the resulting text in cell
- User Defined formula
- Delete the contents of a cell if (REVISED)
- Macro with an option to attach emails or not
- Link to specific record
- Why does this code not get updated
- Re: chart text position
- Re: CustomDocumentProperties disappear after save
- Merging Cells
- Reading sheet names in closed workbooks - Is it possible?
- Re: Copying and Pasting in a Loop
- Re: Print all (except one or two)
- range names
- CommandButton to Exit a Macro?
- Copy/paste number as text
- Excel(2007) crashes on quering for DrawingObjects selection
- Re: ALT-keys in User Forms
- Re: Adding Worksheets without Switching to it
- Image control with PNG support
- How do I add commandbutton in spreadsheet using Visual Basic
- Code for sending mail from Excel
- Calling DLL function
- Re: Searching csv files for particular string
- Why does this code not work across all designated sheets now ?
- help making code more effecient
- adding tabs and naming them automatically
- Sheet Calcuation Issue
- Simple question
- Excel keyboard shortcuts
- Re: Countif on non adjacent rows
- Re: Macros in Excel
- Format an Excel Column in the window's short date format.
- Lookup and Mean
- Locate a word and add the next (below) cell value to the totals
- Clipboard Question?
- How to simply export a single sheet to a new .csv file?
- Email Error
- Re: Change text in rectangle shape
- I need your help Dear Vba Guru's..."Creating range in a variable data.."
- Re: VBA Code to automatically reset the Freeze Panes settings
- RE: Change text in rectangle shape
- Finding a date rather than text
- Re: Working with geographic coordinates
- Error putting a formula in a cell with vba
- Re: Working with named ranges
- Re: Change text in rectangle shape
- Re: changing the way buttons look
- print macro base don tab color
- Regular Expressions
- Calculation woes....
- Excel Lists - Resetting Filters
- Excel Macro Security Problem - Trusted macros not running for users (but do run for domain admins)
- ensuring at least one checkbox is checked from a group
- SaveAs no question...
- Menu problem in Excel
- VBA or VB math function
- Help with some code that Martin wrote
- make table to row column
- ? VBA to insert formula if a column is blank or not ?
- Re: Working with geographic coordinates
- export chart method error - excel2003
- Re: Sumif not equal to
- how to make a table to row column
- Re: SQL string
- Creating auto-update ability
- PrintQuality in Excel using VC++
- I need a Macro
- Retain cell formatting?
- Re: Open File then Set as
- Re: Adding blank rows every 3rd row
- Help with recurse subdirectories code in excel file index sheet
- Delete the contents of a cell under multiple conditions
- Pass object by value not working...
- Inserting Code within ThisWorkbook via Code Q
- Automatically keeping cells together when printed.
- DynamicSum with counters??
- Code not working
- Re: Codename conflict
- Iterative creation of Image objects?
- Sort Column Script
- Copy between spreadsheets
- Re: Count visible windows
- Excel 2000 -Revise Dim
- Excel 2000 -Simplify macro
- Excel 2003 - Combobox.AddItem type mismatch
- Values of non-contiguous cells
- Re: Moving for selected cells
- After running Find, need to goto column A of that row
- Re: Working with named ranges
- Re: Working with named ranges
- Saving data as *.txt file
- Re: Working with named ranges
- Text to Display
- Differrence bewteen Rows(X) and Rows(X).EntireRow
- Simple Export of worksheet contents to text-file.
- Re: Logic problem
- know row index via Cell
- Excel 2000 -Range
- RE: Dates
- SORT not working
- Userforms: I want one form to lead to another, using a next button
- Re: Dates
- Re: Dates
- I want a special Sum function but I need help with that
- Searching csv files for particular string
- Select a drop-down box
- Replace Hyperlink Addresses Help 'Dim OldStr As String, NewStr As String
- RE: delete dynamically created combo box
- Delivery number for all dates in delivery period
- Complex comparison of Columns of Data: Extracting unique records after comparison on 4 levels
- Concatenate Text Statements
- ActiveSheet.Next with hidden sheets
- More complex macro can anyone help
- Easter day formula
- delete entire row based on conditional test of column A
- Re: ADO connection Steps
- Load Object
- Compare 2 Columns in 2 Sheets that are Not Ordered the Same
- enable/disable checkboxes based on other data
- Add 1 to cell when another cell changes
- autofilter
- PHP Excel generation libraries
- finding records
- Excel VBA tech interview
- Range name problem for DA
- A Little Favor for a Friend
- Data validation and lists
- Function not completely volatile help
- syntax qustion
- Filling Textboxes from Combobox selection
- Calculating Standard Deviation while ignoring Zeros
- RE: For Ron Bruin Please
- Will not copy to City-Panmure
- Excel-g ?
- How to know the windows language
- Re: Call up form calendar form VBA
- Connecting lines
- if Cell B1 = "Day1" show chart
- Parse data from string
- How to stop a macro at a Shell line.
- Hi,
- Argument
- Insert row after last (filled row)
- modify size of calendar control
- Need help on generating non-duplicated result
- formulas for conditional formatting
- paste - skipping cell
- summ aumont with interesec two index....
- Copying cells- the cell references don't update
- Index function in VBA - on Multiple cells
- summ aumont with interesection with two index....
- =VLOOKUP validity
- I need help using the Assistant.NewBalloon feature.
- Matching Value placed in next column
- Re: Page Break Preview sliders not working
- Re: Send to function
- Stop the _Change event? Is there EnableEvents for Forms?
- Re: Excel and "send to" function
- Having issues with .SetFocus after msgbox...
- Re: how do I get a visio pic on my worksheet on a form?
- Excel Timesheet Counting problem
- Selecting Next Worksheet
- Select Data by Date Range, Delete Rest
- Re: Better way to delete rows wiht #N/A?
- .PageSetup on multiple sheets in workbook
- User-defined formula (VBA) that can convert a text value into MD5
- Call Add-In Macro from VBA
- Re: Reading Chart Coordinates with Mouse Events
- Re: link chart axis title to cell?
- calling macro from another instance of excel
- Re: Counting Formula
- Macro - Loop/automatization problem
- Add-in
- RE: Excel Worksheet Select (Activate ?) in VBS
- If statement to move data from one column to another
- Re: array
- Change color of Shape based on condition - Macro?
- Simple Print Macros
- think i need sumproduct help
- grouping large pivot table columns
- grouping large pivot table columns
- Disable Workbooks_Open() Macro when opening from VBA
- How do I convert text to numbers in excel?
- combine change event codes
- or operator
- Userform Q
- summ aumont with interesec two index....
- Save as DBF in 2007
- Missing VBA Code in Excel 2007
- for next question
- CSV file has ,,,,,below last data row
- RE: AutoFitMergedCellRowHeight
- RE: How to invoke a user form from a custom button on the menu bar
- Re: User Form Input mask
- Re: EASY QUESTION: Formula to add filename to cell
- Re: Report on missing numbers
- Dynamically populating a 14-column listbox
- Put CommandButton1 code in Module1
- Programatically Delete command button and code.
- RE: Error 1004, Looping Error?
- Passing variable to worksheet function
- Re: Appending Filename in Macro
- RE: Error 1004, Looping Error?
- RE: Error 1004, Looping Error?
- VBA, Reading File As Binary
- Increase in the size of Excel Workbook.
- Increasing a cell value by 1 each day from date in another cell
- Standard PivotTable report selection format
- Re: Office 2007 + VSTA
- Re: active offset
- Re: Better way to delete rows wiht #N/A?
- Re: Email with Notes
- Re: Office 2007 + VSTA
- Scrollbars
- Macro to Perform Same Function Across Selected Sheets
- Excel component references in .Net
- Putting cursor in cell A1 for each worksheet
- Putting
- Macro to rename Excel files in a folder
- Re: Help needed - populating comboboxes from list??
- Where does excel store the pictures of a userform's 'Picture' property?
- Determining Variable Declaration
- Excel references in .Net
- Textbox on user form type mismatch
- Textbox on user form type mismatch
- cell locking problem
- Clearing Comments?
- added a range of data
- Count the number of characters created by string text
- RE: array
- Display a value in a column
- Error 1004 : function returning a Worksheet
- Getting Column *Letters* From Range Objects
- 2 questions, one difficult.
- Hide rows based on colour
- VBA get ColumnName
- Re: Changing Transparency of User Form or Splash Screen
- Re: Macro not allowing inserting cells/colums/rows
- Please help debug this macro.
- Insert Bullet in E-Mail text
- listbox events
- Pressing a CommandButton on a Userform via Code
- conditional formatting formula
- Re: Data overrun
- Re: Help needed - populating comboboxes from list??
- Re: De-concatenate but maintain relationship/record structure
- entering new data thru combobox
- formating cells with procedure
- RE: Convert text to hyperlinks
- Modify language options from control panel using VBA
- Re: Using Printout with Adobe PDF as the printer
- Reverse Frequency
- Re: Excel 2003: Control tab in "Format Control" doesn't show up.
- VBA Passing information from one worksheet to many others
- Re: Excel cannot complete this taks with available resources... why?
- Help with colums
- Re: Using Printout with Adobe PDF as the printer
- Re: How to sum 2 +2 = 22 in Excel?
- Re: How to sum 2 +2 = 22 in Excel?
- Find/Replace in VBE takes focus off window Excel 2003
- Help with code
- Combine cell contents into a text box
- Re: Save worksheet to a unique filename after worksheet is printed
- Excel 2003 Suppressing Errors
- Re: Simple "If" statement ?
- Excel ODBC Data Connection
- Re: Calling? Invoke Public Function
- Parsing data into seperate sheets
- Need help comparing & flagging email lists in separate worksheets
- Re: Create personalized toolbars in Excel 2007
- Re: Excel 2003: Control tab in "Format Control" doesn't show up.
- Re: For Ron Bruin Please
- Log-in Screen
- Re: Can I make a cell into a macro button?
- Copy Formula without changing cell refence
- check if name object exists
- Values of Variable after Project has Run
- Running macro with different references
- Hiding Unused Rows
- Re: setting a file with variables
- Excel will not open
- Increment a variable?
- Increment a variable?
- Run bat file from excel macro
- Re: locating carriage return within cells
- Re: locating carriage return within cells
- Re: Control which sheets get Recalc?
- Re: Replacing Sheet references within formulas with VB
- Part Time Job Opening At Purdue Campus
- Re: vba error
- Delete Function:
- I just want to select the first word...
- Password/UserName
- Re: setting a file with variables
- Help on Dictionary datatype??
- Re: Hide ribbon or menu bar in Excel 2007
- problems with a localconnection to a cub file
- Re: find
- Re: find
- Inserting a Static Date and Time thru a Macro
- Use module, not thisworkbook
- Re: print hidden range
- msgBox after update cell
- msgBox after sum values
- Command Button Request
- Apply Formula to Selected cells
- Cannot load Excel 2000 Addin from Word (and that's so weird!)
- Command Button
- Copying sheet containing GetPivotData, new sheet references old workbook!
- Display WorkSheet data Size
- Excel format Cell
- Re: Need ComboBox Help
- Can't get PageSetup to work
- Re: Position the shape
- Re: Macro - Issue with cut and paste if a column is blank
- RE: No Worksheet Range Object in VSTO?
- Re: ControlSource Property Throwing Errors After Changing Regional Settings
- Dynamic Creation of list box on excel sheet and handling events
- Subject out of range
- Userform formats time incorrectly
- ADO get data from Oracle by SQL field type missmatch
- Re: Storing XML In Workbook
- paste special all and column widths
- Re: database calls
- Re: Macro - Issue with cut and paste if a column is blank
- Re: No Worksheet Range Object in VSTO?
- VB in Excel 2007
- Number Matching, one to many
- Import Module to New Workbook
- Excel COM application hangs on Workbooks.Open
- Worksheet excluded doesn't exclude
- Re: Public?
- Object doesn't support...
- Macro to sum sheets in a folder
- Re: Importing into Access from Excel
- Excel Looping Question on multiple ranges...
- Log data from timecard into table in separate worksheet
- Do not let user save template if it has been been modified
- Programming Outlines (expand/collapse rows) in Excel
- Re: For Loop
- Help with UDF
- Help creating an Excel Add-in using VS205 in either VB.NET or C#
- Re : Date to be placed into Column "C" with matching value in Column "B" in same row
- Extracting Cell Data Based on Input Mask
- Extract Numbers From String
- Re: Range Selected.
- A macro that can delete the contents of a cell after a delayed interval
- Re: Converting a string of numbers to decimal
- Excel Application.Quit problem
- Re: Converting a string of numbers to decimal
- Run time error 1004 When running in 2003
- User Specified Grouping
- userform, StartUpPosition
- Ignoring End Statement
- Application.CalculateFull
- Re: help with code
- Hiding unused rows
- Adding Several Rows at a time and Asking for User Input
- add worksheet checkbox and change parameters
- Re: database calls
- Excel VBA question...Need help..
- Re: ActiveX Option buttons
- Re: ActiveX Option buttons
- Re: ActiveX Option buttons
- Trying to hide all rows where no data is in columns AQ-AV
- Re: problems when moving code from Macro to Command button on sheet
- Re: help with code
- thanks 2 everybody here who asks questions & answers them!
- Re: After Paste Value and Replace
- Re: "Application.ScreenUpdating = False" on the intranet
- Re: Macro to run everyday???
- User Name/Password
- Re: Return column numbers where word appears on row
- Re: Compare two lists and producing a third list
- find text delete row
- Sheet name = cell value
- Re: Change cut/paste operation to cut/insert operation
- Merge data from one sheet to another and print
- Re: Can I make a cell into a macro button?
- VBA: How can I check if an array is declaired with a dimension?
- Asking for better logic to avoid multiple if's.
- Re: Can I make a cell into a macro button?
- Re: Dead screen for a periode ???
- macro runs when workbook is saved, but only with vba change...
- Re: Data validation when pasting data
- Re: Daylight Saving Time (DST) and calculating time difference.
- pasting excel range into a Word doc
- Re: Temporary borders appear
- Save as single file webpage
- Stop Loop
- Date to be placed into Column "C" with matching value in Column "B" in same row
- SendKeys Help
- Disable Select Cells Q
- Extract Info From All Files in a Directory Q
- Search Excel and copy result into word
- VBA randomize vs. srand
- go over all the rows in data of autofilter
- Hyperlink Screentips
- How do I make this happen?
- Random Tab Color on sheet creation.
- Split last word into new cell
- Stop for input
- Re: xlExcel9795 Not Supported in 2007? 2003?
- Enabling a list autofilter in a protected worksheet - Excel 2003
- Copy Headers based on id# and data
- Cannot open PivotTable source file error fix
- Re: VBA Project Question
- copy method of worksheet class failed
- Re: Code not working
- RE: VBA Project Question
- Change the formatting of row by select a single cell & Editing should be working
- Too much nesting in if statement
- Add-in stopped working
- differrent fonts on parts of text
- Re: Find first unused cell in row
- Extremely slow macro
- Protecting Data Validation List from being modified in the formulabar
- Re: automate cut/insert tasks
- Change Cell Value when autofiltered
- Re: Hyperlink Macro
- Re: xlExcel9795 Not Supported in 2007? 2003?
- Menus using VBA?
- Rounding up to nearest 10 when "Enter" is pressed or user has clickedoff the cell
- Re: How do I program a macro to unlock and relock an excel worksheet
- Re: How do I program a macro to unlock and relock an excel worksheet
- Re: Excel report which excludes the blank rows?
- Re: need code to run when user changes value in cell
- Hide Macro's
- Re: need code to run when user changes value in cell
- Re: saving data in notepad
- Re: saving data in notepad
- COPYING A CHART!
- Always have cells add up to 100
- Re: Checkbox detection in macro
- Re: Daylight Saving Time (DST) and calculating time difference.
- Re: charts with calculated cells
- Re: Module question
- Re: Declare RegExp from Vbscript.dll
- Re: POWERPOINT IN EXCEL
- change of date format in footer
- Limit data entry to one of four cells in a row
- Menu for favorite macros in Excel 2007
- Workbook.Open fail in 2003, good in XP
- Define Names in Workbook through Code
- Re: Another Multipage question
- 'ThisWorkbook' Macro Question
- Deleting specific rows after an autofilter
- Creating a list of workbook users
- Re: Help with worksheet protection
- Re: Form Checkbox Updating
- Cancel Printing Except Q
- Textbox on user form in Excel VBA
- VBCRLF not doing anything
- jamping to another file excel2003
- Delete all code in VBA module - error?
- Dynamic Optionbutton Captions
- Delete all Range Names Except for 1 Q
- Searching Phone Numbers Online
- updating external references to cells, sheets etc.
- Hyperlink
- Re: VBA Project Question
- Select OR Activate ? Which when and Why?
- Convert date like string to serial number
- Handling Database connection error
- Need to buy a book
- listboxes
- Re: operation macro by clicking on cell
- Need code to convert files
- Issue on Close Q
- Problem finding pagebreaks
- Can Excel 2003 VBA work in Excel 2002?
- Create a function that sums based on two or more criteria
- Re: Play sub by clicking on cell
- Excel 2007: annoying pop-up msgbox titled "Name Conflict"
- Populate ThisWorkbook Q
- run macros local and on the web
- Checking for File/Directory Permissions
- reference to FileSystemObject
- Excel2003 in WindowsXP only 20% performance of Excel2K in Windows2
- Msgbox in worksheet activate event if design mode is turned off
- Automatization routine
- CustomTaskPanes and VSTO SE In Excel 2003... Where Is It!?
- Look Up Functions
- Change event --> cell colors change
- RE: Copied function is not working
- userform textboxes saving numerical data as text in worksheet
- write data to two excel sheets
- Quit Excel if ONLY Workbook Open else Close Excel instead
- Now() to be placed in Next Column ?
- Range Reference
- Drop down list of Macros
- Still Stumped
- Using Excel VBA to control Word (open document)
- Re: Never tried this location in excel
- Re: POWERPOINT IN EXCEL
- Re: Module question
- Re: problem with moving controls
- Update "button" references automatically
- Restore users Text to Columns settings -HELP!
- Numbers Only in input box
- RE: If found Then move to new sheet
- e-mail from Excel to outlook
- Re: VB macros & "relative positioning"
- RE: POWERPOINT IN EXCEL
- Automating Excel Visual Basic to Schedule Outlook Events
- Delete comments in the workbook except few cells: CODE given
- Need assistance to populate sheet from Userform data
- Pivot Table Code in a For loop
- Importing data from Access to Excel 2003 for Invoicing
- Importing data from Access to Excel 2003 for Invoicing
- I can't figure out the correct syntax for referencing a workbook.
- Re: Never tried this location in excel
- Re: Changing cell colors in a row IF...
- Re: Semiautomated Saving of workbook
- Newly created Get Function is not working when I copied the syntax from a working function
- Re: Changing cell colors in a row IF...
- This should be so simple but it's not working, please help
- Automatization of data entry (and return of data)
- Adding a Name Crashes Excel
- Re: Nested If
- Re: 3d range names/references
- delete module
- using a workbook to open more workbooks with filenames stored in cells
- Re: Macro for printer selection
- AddFromString Code -> Excel crashes ... Why ?
- data ranges
- vba code to insert an range of Excel cells into a Word document
- Macro to autofill formula in every row
- Dim as Point
- Re: Line up graphs
- Change Font Colour in VB Q
- Problem with counting characters VBA
- Re: SkipBlanks doen't
- Re: Email message from Excel with Hyperlink to the file
- File and Don't save changes - Read Only File
- Re: every quarter
- Re: Characters in Strings
- CMS script into Excel
- is hyperlink valid ?
- VBA Code for deleting rows with specific value
- Re: array lenghts
- Jumping bar at bottom of screen
- Copy / Paste between workbooks into a specific worksheet query?!
- Question re random addition
- Protect via Code Q
- Re: every quarter
- Application.Visible = True and focus
- Nothing, Empty and Null
- Totals across increasing number of Workbooks
- Totals across increasing number of worksheets
- Summarizing the files in 1 folder to one file
- Stupid logic is messing up again... < = > Statements crapping out...
- Using dcount function within user-defined worksheet function
- macro code to find last record in excel
- stop for input
- Error in code
- Custom Menus, Toolbars, etc
- Determine if Excel App is shutting down w/VBA
- Multiple Selection of Non-Contiguous Data
- TextBox9.Text = Range("J:J") --- New line for each cell with a value?
- Excel VBA Class Objects - Parent & Successor Objects
- Format Pivot Table Row Where ...
- How do I getting data from another worksheet?
- RE: Calculate manual spread sheet
- Help needed with multi-sheet routine
- import csv
- If statements, conditions and cell display
- Conditional Formula
- Run on Opening Workbook Q
- Handling grouped groups
- Day-planer
- Create a new file, name it and overwrite an existing name without confimation
- Any good books?
- Taking 10 lefthand characters in a cell
- Change Password from an Array
- Changing the Zoom Property of a WorkBook without using an Array
- Copy Range / Including Adjacent Cells - into Existing Worksheet.
- links to word
- Setting range for the VALUES obtained from formula
- 2 lists - extract from one all matches, edit in a new list then re
- Activating macro by leaving a spreadsheet
- Re: Keep Custom Toolbar with Worksheet
- getting data from another workbook
- Excel VBA Code Modules
- PasteSpecial problem
- how to send message to multable recipients
- Re: Finding first blank worksheet
- Using command buttons change the value in a form text box.
- Populate ThisWorkbook via Code
- Populating worksheet from userform combobox
- DDE links not updating after stepping into VBA code
- Re: Can I update vbaproject.bin in a package?
- Import Oracle Dbase over 65k rows
- Opening filenames from a list in a spreadsheet
- Re: Object variable or with block variable not set - what's going on??
- Re: Drop-down menu referencing another drop-down menu?
- Is it Possible to Deny Access except to specified
- Re: Addin Locking Excel
- sheetname value
- Do 3 Tasks on Opening File Q
- Is it possible to have different pop up messages to appear
- Name Range
- E-Mailing a File but property set as Read Only
- ComboBox – Used to Score
- Subtotal Report: Creating new sheet(tab) for each group?
- Please help! This problem is driving me crazy! Workbook sample provided!
- Drop Down Menu on tool bar
- Copy and paste to corporate sheet
- font color of partial cell contents
- Re: Addin Locking Excel
- delete rows where value of cell "starts with" something
- Excel VB User Form Using Vlookup?
- Take all unique values in sheet and place in 1 column
- Trying to delete rows and it's not working
- Re: Error Handling in Macros
- Replace font of one character in a string
- Re: Tough one; determine if an Access file is open
- Search/replace returns Formula too long
- could someone look at my code please and tell me what's wrong? tha
- Could someone look at my code
- Able to preserve value of variable after closing excel?
- Copy internet page excel
- RE: Need Help with Macro
- Email is a wonderful thing?
- Email is a wonderful thing?
- Excel crashes with a WebBrowser in it
- How do you do this? Uncrosstab
- RE: Referencing worksheet just by its name
- RE: moved vba code from macro to command button, now won't work
- MsgBox cancels "Step Into" Mode!
- Timer Event
- Link Excel 2003 named range to Access 2003 Table
- Re: Excel checkbox date question
- a simple date match?? |:(
- Re: formula for aquiring a gestational age
- RE: formula for aquiring a gestational age
- question on horizontal tab
- Re: Delete All Sheets Except "X" and "Y"
- copy all text files one by one and run a code.
- Re: Control on worksheet
- enable or disable a workseet control
- Re: Drop-down menu referencing another drop-down menu?
- Sorting
- Re: deleting empty rows within a range
- Re: turn off pastespecial warnings
- Trying to set a pivot field to a subset of values listed in range of cells
- Trying to set a pivot field to a subset of values listed in range of cells
- Using the Now() function but I dont want it to update every time the spread sheed is recalculated.
- Re: Have Excel file close itself
- Transferring Large Amount of Data from Excel 2003 to Access 2003
- Querying and Updating SQL Database Using Excel
- Re: Phantom VBA Projects (again)
- Re: macro to crack passwords
- Getting rid of "#VALUE!"
- Re: How can I pick up a two digit Month?
- Whats Wrong With This
- calling a method on a object that you know the string name for.
- calling a method on an object created in a different addin
- Re: Send Chart report by mail using VBA
- detect all printers in networks
- Re: Lookup or maybe Vlookup
- Re: Send email to multiple recipients using VBA
- Re: Fixed Text-Private Sub Worksheet_Change(ByVal Target As Excel.Rang
- Is it an IF statement?
- how can the necessary information be extracted?
- Re: Phantom VBA Projects (again)
- Re: copying worksheets
- Re: Object variable or with block variable not set - what's going on??
- Re: Run time error 91 ??
- Adding data from Form to empty rows in spreadsheet.
- Re: Object variable or with block variable not set - what's going on??
- Copy from here to there
- Transpose from Col to row
- About Save Workspaces
- Re: turn off pastespecial warnings
- Re: macro to crack passwords
- signed project drops signature when a macro creates a new sheet.
- Why did this code stop working ?
- Issue when accessing the property/method of a Calender control
- Problem with calendar planner date ranges
- Re: Macro written with VB in Alphacam. How do I put that in Excel?
- Re: Disabling Macros
- Re: Excel and Class, Function Structue for .NET
- Update MS SQL 2000 from Excel
- Re: Problems deplying a fix to a C# Excel add-in
- input
- Updating 0s in front of the number values in the column
- Wierd Bug with Format Date VBA???
- Count occurences of string in cell
- RE: How to hide/show a textbox depending on cell value
- RE: Command Button
- Finding MAX Value of Part of Cell Contents
- field names
- Re: Set Variable equal to........
- .PrintPreview ONLY Page 1
- Need help extracting data....
- Issue saving file in excel 97 SR2
- Re: Help Needed! VB Code to "Save As..."
- Find Selected value to .Offset from
- Re: Help Needed! VB Code to "Save As..."
- Dropdown List Syntax
- re: Worksheet events...Why doesn't this work?!?! So confused!!
- Using worksheet templates with named ranges
- Re: Array of UDT
- Re: Extracting text before a known character
- userform to remove from view
- Spin button timing
- Deleting Rows based on multiple criteria
- Problems running Excel under IE
- Is it possible to change the behavior of "paste" control in Excel?
- error 438 on ActiveSheet.Columns(16).Hide?
- Re: Problems caused during/after printing
- Re: Tough One - search for string and BOLD it.
- Procedure for SPECTRUM ANALYSIS of FFT coefficients???
- Re: If..Elseif...Else...EndIf
- Re: Automatically Update Tab Names
- Re: Workbook_BeforeClose in Personal.xls
- Re: EXCEL WEB QUERY PROBLEM
- Re: VLookup behaving strangely..
- Custom function acting weird
- Re: Testing if Directory has read/write access
- Error Auto Fill Method of Range Class Failed
- Re: Finding elements in a collection
- Re: Finding elements in a collection
- Re: Looping
- Re: Quality Control Macro -- Formula Anamolies
- Re: passing a cells content into a macro
- Resize Listbox Colums to match array fileds
- Protection Properties on WorkSheets
- Re: IF Formula
- If Active Sheet on Opening is X then do Y
- Re: Is there an ActiveForm command?
- Etiquette for borrowing code from a post by Harald Staff
- Hyperlink
- Re: Programmatic access to visual basic project via Visual FoxPro
- Re: Array of UDT
- Re: Array of UDT
- Re: Saving as a worksheet as a CSV file
- Re: Creating a macro where values are copied and pasted into a sheet
- Re: Macro references
- SelectRegion Loop
- Automatically have Named Ranges recognize New Data by way of Headings
- Re: Menu Bar Problems
- Dataform opening on startup, and validation list in form?
- Is there any easier way ?
- how to list calls to macros?
- Textbox macro - update problem
- Re: Delete cell names
- Delete cell names
- Button Visibility / Selectionchange Problem
- automatically updation of the excelsheet if i add new files in a .
- Modify code to Add ComboBoxes instaed of Textbox values on Userform ?
- CODE given: Please help to rectify the error
- hide ,unhide columns on protected worksheet
- Excel to have User Name and Password?
- is there a way to program my Excel file to do a loop?
- RE: Formatting Loop
- Re: Cell access within Selection.Areas
- find doc
- Re: Creating a macro where values are copied and pasted into a sheet
- Re: refresh calculations and external data
- open web page by clicking label1 of the form1
- Re: CASE STATEMENTS
- RE: hide one column skip two column and unhide one of 11
- Re: Copy cell contents?
- Re: auto-resizing UserForm window
- Re: Data Validation List Sort
- creating a spreadsheet function program
- Re: delete extra lines within same cell
- I am seek for powerful program for SEO!!!
- RE: Excel 2007 Functions
- Re: code for dragdown, minus one
- What is "my" cell?
- The date ??
- Re: consolidation of tables
- Re: Converting cells from text to number format
- Re: How do I save an XLS without saving my macro with it?
- Use real time clock within a spreadsheet?
- Re: Can you check the coding here please?
- Re: passing a cells content into a macro
- evaluate and variables and loop...
- Re: Find and move base on value
- Re: Application.Run correct syntax
- Function Help Please
- Making email button work after email
- replacing range of cells with text
- Excel Macro / VBA to pull up the protect sheet command
- Name range visability
- Recognizing Smart Tags in formulas
- Transfering Info Stop When Null
- Fonts and Userform and VBA
- Re: Programmatically Name a Range
- Re: Deleting cell value
- Re: I'm not sure it can be done but....
- Xcelsius Resource Needed
- programaticly filling a cell with a formula
- Re: Set of varibles produces one output. Need series of output.
- popluating a list box without having duplicates
- Re: Vertical PageBreak not Working
- formula determinate problem
- Re: formula help needed for averages
- Re: formula help needed for averages
- Re: formula help needed for averages
- Use variable to reference a range?
- Re: delete extra lines within same cell
- List Outlook tasks from another person's shared task list
- Re: simple addition
- Re: Why does my file say it has macros, but I can't find them?
- Help with Macro (networkdays function especially)
- Re: Why does my file say it has macros, but I can't find them?
- Re: auto-resizing UserForm window
- Cells with Values Edit
- randomizer
- Hide columns and rows then separate the spreadsheet into different files
- Re: Why does my file say it has macros, but I can't find them?
- Populating Comboboxes
- Macro Button reference
- Running totals from timesheets
- Weighting Costs Across Multiple Months
- Re: Unprotecting (with password) the activeworkbook
- Re: Nudge graphics down and right
- time stamp based on action in column.
- Re: Error '7' Run out of memory while filling in a cell with a formula
- HELP WITH LOOPS!!!!
- Test Cell for Alignment
- password userform
- How can I check if a pop-up menu exists...
- Re: Begins with
- non-expanding range, and also a VBA Sort error
- Why does Last Cell Reset to last cell available?
- Changing the name of a variable using code
- password as ********
- Re: Begins with
- Re: Begins with
- Pasting from Excel to Outlook with VBA code
- Inserting rows from "unstable" csv
- Re: Removing Comma's
- Using vb to paste records from 1 sheet, to related records in another
- Methods .Save and .SaveAs throw run-time error '-2147467259 (80004005)'
- RE: Find duplicate and append
- Re: Removing Comma's
- Automatically Append New Data in Unknown Addresses into Existing Ranges
- Worksheet Change - Help!
- RE: Conditional format via VBA
- Can I enforce Goal Seek to perform one iteration only?
- The Print # command print not all rows from excel sheet to file
- Hyperlinks
- Excel 2007
- Insert picture based on cell value (unlimited)
- Run macro by day --- but only once per day
- Re: Prompt user to select a printer using a checkbox within a user
- Enter data and press enter to move to specific cell
- Re: Controlling Visio from within Excel
- After entering data, press enter to move to a specific cell
- Customise Button on toolbar
- vb code help needed
- Paste area Error on my macro
- Re: temperature reader
- Refrencing Diffrent Tab.
- Refrencing Diffrent Tab.
- Cell variable name
- Re: xlPolynomial trendline
- Weighting Costs Across Multiple Months
- Add a live clock to Excel and change values accordingly
- Using Find or search for Cells with <3 Characters?
- How do I have Excel Macro write a open ended formula?
- xlPolynomial trendline
- test
- Re: Check to see icon exist in command bar
- Compare data from different sheets and total how many times it appears
- Bug in a built-in VBA date function?
- Re: Can Excel automatically shade a subtotal row?
- Excel and Outlook linking
- Syntax for Application.Ontime incl Variable Parameter
- What is the output of this code (CODE given)
- Re: Tiered Pricing
- Excel4 PAGE.SETUP?
- Re: How Do you Sort Worksheets in a Workbook, Alphabetically
- Printer/Driver
- Re: Create invoice from excel worksheet data
- Re: Formula in a Macro
- Arial pt. 8 ONLY
- Re: Assigning Macro by using code
- Re: Need a code to print and save file as
- Re: Macro How To
- Re: Importing file envelope infomation
- Re: Deleting a range
- remove name of addin in Tools menu: "Document Project"
- how do i delete a macro
- Re: Deleting a range
- Re: Removed digit from excel spreed sheet
- Re: Removed digit from excel spreed sheet
- Saving question
- Re: Follow up to unselecting cells question
- Functions that return a Range
- Replacement for Dsum - calling countif from aVBA
- Having different Y-axis
- Conditional Formatting using VBA Case...
- Macros the same but not acting the same
- delete modules and sheets
- Re: dynamic worksheet select
- help References in a User Function
- RE: copying by formula....
- Re: copying by formula....
- FileDateTime help
- What's up with VBA (?)
- Dynamic Graph
- Change Validation list in the adjecent cell on the Basis of Value in the Current Cell
- Re: Varying length records to be sorted
- This should be easy
- Creating listbox
- Deploying templates
- Disable the 'Send' button in Excel 2007
- Help required with VBA program to automatically enter data from a validation list.
- Transfer the colorindex of a cell to another, without using paste or pastespecial
- VBA for Excel
- Macro Issue with loop
- Keep value after deleting original information
- Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's)
- Getting RSS feed from Excel file
- How do I have Excel VB write a open ended formula?
- Sum the remaining rows and place the result in the row below the last
- how to make macro to combine text from 2 cells?
- Re: worksheet change
- Moving Complete Folder
- VBA code for message box and focus on a sheet
- unselecting or uncopying or whatever in VBA
- Omit Date from Blank Cell
- Why does the date change from "January 07" to a numercial value of "39038 "
- help with defining column only from range of cells
- Odd date parsing issue
- using a variable for MOD Statement
- Input Box
- Re: Increment number on command
- Corey.....certain cell protection.....
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.