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 |
- Footer Picture
- importing custom files?
- Autofill Until
- read multiple line
- VBA - Solver use on arrays
- second worksheet change
- Connection String to SQL to run Stored Procedure
- Dailog Box Q
- highlighting rows when a value has been found
- finding empty selection
- Runtime Error "7": Out of Memory
- VB 2005 Express and VBA DLL´s
- error when sheet doesn't exist...
- selecting a chart
- Formula using a SUM of 3 code-defined cells
- Recommendation for XML Macro language person trying to convert to
- programming
- Question on Application/Workbook
- accessing .mpp file using excel VBA macros
- Document merging
- Request help
- interior color of a cell
- Compare rows to col
- How to protect a code with password to avoid mishandling
- How to find Watch window in Office X VB Editor (Mac OS X)
- Rejected Safe Mode action : Microsoft Office Excel.
- How can I do this with VBA?
- Tab Names
- Type Mismatch error in VBA code
- Check - Similar Row contents - Different Sheets
- Trouble with types...
- Multipage control question
- macro's run but spread sheet does not updata
- I need a way to password protect a combobox?
- Help with tidying up code please
- userform memory
- Type mismatch !
- hide rows based on value
- Need help with auto selecting cells
- Insert Median Automatically
- Data searching between sheets
- Color cell text based on date
- Copy and Paste Cell
- RE: Copy and Paste Cell
- Path/File access error (Error 75) using Name Statement
- dget or dsum, that is the question
- RE: Color cell text based on date
- Path/File access error (Error 75) after using Name Statement
- AddItems to a list box
- RE: Color cell text based on date
- RE: AddItems to a list box
- programatically change the data source of Pivots
- New guy with a tricky question
- Which is unsupported?
- Possible to reference column of named range in array formula?
- Command Box jams macro
- Help:loop on two workbooks
- VBA & Excel: Concatenation problem
- Macro to copy sheets from several files into a new workbook.
- Querying an Access Database from Excel VBA
- How To Q
- Worksheet Change Event
- ado connection with excel pivotcach-problem update/delete,etc database
- Dynamic print area
- Its so simple! Why won't it work!
- Tom Ogilvy
- Faulty Averaging Formula
- formatting the target cell
- Simple recorded macro crashes on playback. Why?
- Macro entering an infinite loop
- Pull drive information into worksheet
- Modify a data query ??
- ActiveSheet.QueryTables.Add
- RE: ActiveSheet.QueryTables.Add
- Extract a date for formula
- End sub early if mismatch
- Please, help with concatenation
- Macro Button does not work on second click
- How do I use the font as a filter
- updating wbook from other...
- Sum on Multipel sheets
- Solver Add-In not installing...
- Why must I click twice?
- Code to view and Print several documents
- last char of a string
- Use variable as email reipient names
- Command button and msgbox's
- Excel Solver Programming Error
- How do I set a price minimum in a spreadsheet?
- Copy-Paste a Row via a cell reference
- Copy File without opening
- Code to get data from webpage into Excel
- Progress Bar
- How do I update a ODBC query in Excel using pivotTables in VBA?
- Highlight Cells
- can I get the printer options to display with the print icon
- Pause Macro For Start Row While Parsing a Text File
- Update Named Ranges
- Function Help
- Question
- IF statement that looks at part of the contents of a cell.
- VBA format function Win2000 and WinXP
- If two lists don't match
- Range Total
- Deleting rows between
- writing data to a tab delimited text file?
- label effect
- Compare and report differences.
- Adding Cells in two different Workbooks
- relative time
- Fill the formulas at adjacent columns by VBA
- Conditional Autofill
- Open a protected XL file
- macro security & digital certificate
- Matching values in 2 columns
- Macros disables under medium security
- Textbox input control?
- Binary sorting?
- VBA to find account number that resides in one of several files
- How do you hide macro names from showing in "Tools"?
- Automatically Printing Autofilters
- Opening password protected files
- if duplicates then add quantities?
- Cell value changing automatically
- Last cell and first emty???!!!
- Toolbox gone funny
- Macro, how to protect sheet, but allow pivot?
- how to create excel file when clicking on the button.
- Tidy up of data within Excel Report
- "save as" macro help
- Delete a ROW in EXCEL
- INDIRECT COUNTIF's??
- Relationship between CHR alt Alt-XXX on the numeric keypad
- Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use:
- without opening excel i want to save the excel in some specified location
- Using excel in .NET
- Wrapping cell contents in quotation marks
- update wbook from vaiuos...
- binary sort?
- Lookup and store in array
- from rows to columns
- User Guided Button???
- excel to word help
- Hide Column - With text in cell
- Obscure userform problem
- clearing a selection
- Macro Bombing out - Leith Ross
- Automatically run a macro in time that user wants
- help with code to paste from another workbook
- question for Tom Ogilvi
- conditoonal programing
- Hide Column Condition
- what is the code to delete row&column.
- Make worksheets transparent
- Rename Worksheets excluding Weekends and Holidays
- how do I get my 2003 excel to recegnize my pocket excel worksheet?
- scroll rows up or down
- Userform Help
- Percentage difference between numbers in 2 cells
- Hiding rows based on cell content
- Due date changes when new value is inputted in a different column
- Specifying Range.Select in a loop
- Schedule Print Excel Document
- Change date with KeyDown
- Custom function - Help please
- beginner question
- RGB values
- FIND function not defined in macro
- FIND function not defined in macro
- Can't edit Excel worksheet with picture when automating Excel
- create a form for search text in active sheet then got to selected
- Anyone help please
- asynchronous Procedure Calls
- Need code for simple IF-Then
- How to crop only numbers from a string?
- Compare and update arrays
- How do you "Find" on NonActive Page & Return Values?
- Combo Boxes
- formatting the target cell
- Comparing two lists
- Keeping VB Window on Screen
- VB Help to Look at Next Row
- Sendkey
- how to subtract a range from another?
- Using a Form in a Macro
- Runtime Error 1004
- convert excel data to 2-D array using macro
- CreateObject("Notepad") ?
- Quick and Easy from Checkboxes
- how can I display memo data type in excel form?
- Move some data to new workbook - my attempted macro is no good
- Adding Cells
- Not rounding numbers in VBA
- VB Code To Conditional Format > 4 arguements
- VB Code to Conditional Format a Cell Range
- automatic import of .csv file into access database
- macro to unhide row
- Sort on Protected Fields
- name a backup file
- what is the best way to find a value in a sheet in VBA?
- Programming Excel with VBA: How to make Selection Nothing
- Align multiple MsgBox lines
- Error when checking field for data
- Header/Footer horizontal margins/text positioning
- Conditional Formatting for True/False
- Showing selected cell value
- Trend funtion
- Array <--> Range Error
- Array problem?
- Variable in more than one module
- Userform input into a particular cell
- Error messages: Program
- CANT SAVE TOOLBAR CHANGES
- Request code help, sorting array in memory
- Range variable not being reset
- Text Box in Chinese Under Excel 2003
- Pasting with Dynamic Last Row
- calculate number of business days between the 2 dates
- Quickly Update Range
- run macro only if condition is met
- Can I program Excel to open a workbook to a default worksheet?
- Chart disappears in Excel 2000
- Run SQL Server stored procedure in Excel macro
- Autoshape textbox
- Catching max iterations Stop of Solver in VBA
- cannot maximize or minimize
- Excel - Access
- Saving Reloading
- how do I calculate difference between two dates and times
- Anchoring a chart to a certain area
- Please add a "sheet" function like "row" and "column" functions
- difference application.quit & application.close
- Remove Error
- VBA macros to check a blank
- Deleting Rows
- putting a simple calculation in a field that may change rows
- SendKeys - Right Click?
- I need help -extracting specific data
- Help with entering data
- Column ROW CEL range vba
- MailingAddressesToColumns
- Can't get Find Box
- identical macros run fast and slow
- Appending special characters
- Turning off alerts in VBA
- Importing from multiple text files
- For Each Next returns "Empty" when Data in Cell
- What is function to select only not empty cells in a column (like SHIFT+END+ArrowDown or UP)
- Am I in the right place?
- looping a 'find and delete' code
- filtering CSV data
- Opening a .exe file from an excel hyperlink
- Circular referance problem
- How to color a row?
- Password - 3 chances and **off
- is there any sample of an excel dashboard ?
- Convert XLS to PDF
- Command bar diclaration
- Adding total over two worksheets based on date values
- Transpose and separating worksheet based on Input box name
- Make a list from a table of elements ?
- SaveAs with a pre-defined filename
- Form, SetFocus and AfterUpdate issue
- Refreshing a database query
- Sheet protection altered when saving
- XL2003: control button not visible
- Moving between a column's cells
- need some code help please
- Changing the macor button color
- Creating local cube using PivotTable
- all the messages in the thread
- Help with my user form
- count number of "D"
- relative sheet pt2
- [Help]Excel mouse select region
- Need Help Pls..... Urgent!!
- Array problem: Key words-Variant Array, single-element, type mismatch error
- LAddress of last cell in worksheet
- Array problem: Key words-Variant Array, single-element, type mismatch error
- How to show a progress bar in sheet calculation?
- saving and reloading the contents of a userform
- Just curious about Excel copying dates between workbooks???
- Does Sheet exist? If True Use If False Create
- comparing vertical list on one sheet to horizontal on another
- And another puzzel
- Msgbox not working
- Copy formulas exact without references changing
- Using Subtotals in VBA
- Copying template to workbook but user form does not copy?
- Closing Applications
- Refreshing Charts inside a Macro
- Hide & Unhide Charts
- How do I set up a daily average of unit sales formula
- Multiple For/Next
- Excell macros(need help)
- advanced filter macro to locate values via multiple criteria
- preventin links from updating
- Excel XP incompatible with Excel 2003
- Looping statment
- Macro to compare cell contents and make calculations
- NETWORKDAYS problem
- Which is the good PERSONAL folder in XP Pro
- Using automation to add xy scatter chart
- adding link to chart title using VB
- Finding cell address...
- % Change calculation
- Addin Modified date/time
- Checking if Workbook is Open
- Sumproduct With Dates & Text In Same Column
- Error Trapping when getting external Data
- File Save, yes, no, cancel macro
- big problem !!!
- Flip Letters and Numbers
- Problems with Combo Box
- Invert Picture
- link excel to paradox
- easye compile question
- Nesting Autofilter functions
- paste values
- Who can tell me where I go wrong?
- question error handling
- Getting Current Link Value
- Logon Screen
- relative sheet macro
- VBA Lookup
- validate lists
- I want to count rows between the occurence of one word.
- Running a procedure in a module on graph change
- Macro to hide rows
- open worksheet
- place pictur underneath tabs on multipage
- place picture
- Programmatically check cell formatting
- Range of Worksheet Function Max
- Wierd Msgbox action - Can anyone see the fault?
- why error in.... send xls
- Excel, Microsoft Jet and OLE-DB
- Using FIND in Visual Basic
- What do I not see?
- Can VBA Match?
- Unlock cells in other open workbook
- Top 50 Customers
- Works using XL interface but not in VBA (err: 1004)
- If option button not selected
- error problem
- Custom Menus in Chart Sheets
- VB error, runtime error 13 (type mismatch)
- Data Bound Controls in VBA??
- Trust Access to Visual Basic Project
- dynamic userform
- Remove Formulas, Keep Values
- excel hide and visible problem
- combo box using input range
- FileLen with very large files
- UserForm Templates
- autofiltered cells
- udf to convert <any text> to range name
- Import A Crystal Report into Excel
- Building a Pivot Table where column headings will change
- building code for an individual report
- COMPARE 2 WORKBOOKS
- Cluttering Clip Board - Excel XP
- Select Merge Areas
- Clearing what you have previously selected
- HOW CAN I DEFINE A RANGE IN LOOP
- changing row color
- How to align entries in columns so other columns will follow ?
- rename file
- Worksheet Functions that Change Other Cells
- ASP
- Password and view of spreadsheet
- Selecting sheets with unique names
- How to use a combo box
- concatination of cell contents
- RE: Worksheet Functions that Change Other Cells
- input box
- generating passwords question
- % variance calculation - amended
- input check in cell question
- % variance calculation
- How to glance at other workbook while remaining in MyForm.Listbox?
- Command bar diclaration
- How to "visit" other forms properly?
- Macro to copy and paste special values
- Macro to copy and paste special values
- Moving records from a sheet to another
- How to change Macro security level very high to low...
- Excel 2003 VBA: Detecting and removing toolbars
- any variable size
- Save As Dialog does not prompt for Web File Properties
- using an input box to allow users type in the differnt fields name
- Fill a cell in orange if the result is negative, help please.
- Single Space in PRN
- Simple problem
- Re: print column labels with one row of data at a time.
- Percentage Calculation using VBA
- Data validation on form
- Insert quotes around a lookup value
- RE: Insert quotes around a lookup value
- Macro error on MS Excel 10 for Mac Release 1
- Protection within Macro
- Forms
- Possible to have a named array formula?
- How to make excel to treat values in cell as a number?
- Deleting a row based on a value in a column
- String to number
- How to get a sheets name or list.
- Use CopyFromRecordSet to insert named range formulas? (Excel 2000)
- clear format from RichTextBox
- Maximum number of characters in a cell
- Fill blank cells
- Generate specific matrix
- Custom Icon for an Excel File
- Writing an array(2d) of user types to a worksheet
- Re: How to calculate with years....?
- Re: How to calculate with years....?
- How to calculate with years....?
- Argument help for UDF's
- How to make scrollbar disappear after clearing textbox?
- Urgent solutions needed to resolve vba coding
- conditional formatting question
- Userform with logo and without closebtn
- Worksheet function Vlookup
- Changing Values of a list
- UserForm referring to another excel file
- Script to increase font size of cells
- Deleting Command Bars on close of a workbook
- how can I use access forms in excel2003
- Multiform Tab Colours
- Fill two column combo box
- Importing Web Data
- How to run sub?
- MSQuery settings? ConnectionString?
- how to consolidate sheets
- AfterUpdate Event not Running
- Breaking a link.
- VBA Question
- Passing a Function name as a procedure argument
- get cell of function
- data from exel to visio for timeline
- Lost the menus on right mouse click
- Identifying the user's drive letter
- where can I learn indepth how to use class modules in excel vba
- Worksheet Question
- Flip comment to left
- Textbox Question
- Position menubar
- Macro to insert this formula automatically on start up
- On Form Start Up
- how do i build the macro i need?
- easy vba question
- Formatting Textbox, passing values to worksheet
- trigger database query on cell data input
- difficult function
- Auto Userform Picture Change
- Calculating hours between two points in time
- Parsing Huge Files of Text
- SpecialCells Method Question
- Recognize first emtpy Cell in column
- Code for reconizing a empty textbox
- Year question
- can someone help me with this formula
- Excel VBA: calculating checksums
- CurrentRegion less one Row
- Popup opening a spreadsheet
- How to reference a worksheet which name is specified in a cell
- Specifying range relative to activecell in macro
- Coping from existing spreadsheet
- Using the value in the inputbox again
- Turning off screen update while macro runs
- adding formulas to blank cells
- System Tray Notification/Alert
- How do I publish an entire excel workbook on the internet
- please help
- combobox problem
- Taking control of an existing instance of Excel
- copy column
- resizing excel window
- Help with referencing variable range
- Help with referencing variable range
- Input data from file to Excel in Column Format
- How to Put Conditional Sums in macros
- Used Rows Range?
- Import from another excel workbook on open
- Macro timing might be the problem
- quotation marks
- multiselect remove
- Maximum filename length. 218? 211?
- More formula help
- Sizing Autoshapes based on text length
- OLEDB - INSERT INTO Excel FROM Stored Procedure
- Reginal issue(Please help)
- Create filepath if it's not available
- Adding input to macro
- WithEvents of MSForms.Textbox
- Formula Problem
- Advanced Filter stopped working. URGENT
- text files
- VSTO: ConditionalFormatting not working
- following web link that are not hyperlinks
- Treeview, avoid selecting node on keydown or up
- Greying out the OK button
- web, querytable &jpg
- Use of SUMIF possible?
- Problems with Auto_Close when opening spreadsheet from a macro
- Creating an AVERAGE next to the top of a selection
- Formula in VBA
- Need MACRO to search for date
- How to install MICROSOFT FORMS 2.0 OBJECT LIBRARY
- Create an e-mail with recipient, subject and text
- Macro not running when cell value is updated
- Autofill until blank cell is reached
- Using variable name as a value for inserting a row
- How to evaluate string?
- Transfer Data to Customer Database
- Moving / sorting sheets in VBA
- Validation List Box
- Automatically Save and Route Code
- Conditional Auto Fill in
- many similar event procedures
- Run A Macro Against a Table Until it gets to bottom
- Filtering TIME/DATE
- Form displays but no text
- check if in list else quit application
- Re: Button to email my spreadsheet
- CSV separator in macro?
- File protect via extern USB crypto modul?
- Progress Bar
- Pivot - limiting user access with VBA
- How do I simulate a cursor down in Excel Macros
- extracting a string from a cell
- How to choose a folder
- please help me with folder and subfolders
- mbv vba-programma subfolders aanmaken
- Replace C/R with @@@
- Change - Status bar font
- Setting spaces between text in a cell
- Save "speed up"
- mutlipage in the center of userform
- create button in excel toolbar
- Draw a cirle
- User Defined Function Problem
- don't forget to keep up with excel 12
- How to select a specific file type
- Select rows using a variable
- VB Find String located after "/"
- Quick Search Loop
- change event procedure
- Import emails from outlook folder as TXT
- extract string
- Run Macro if
- sheet copy method fails...
- runtime error 1004
- determine if cell address is within a range of cells
- Automate Autofilter Results - Copy to New Sheet
- input box - I don't need the "cancel" button
- VBA Hangs
- ADODB Connection Problem
- Sharing data
- Open DialogBox in VBA
- Label minimum value in Chart
- Using CELLS function to define RANGE funcion
- how to add text to a comment in VBA
- Print selection in one page
- Saving picture in clipboard into file
- Deleting Columns Based upon Heading
- Help - Problem with date precission
- Copying a Variant Array to a worksheet
- Need to disable a prompt in Excel when trying to programatically update links in a PPT Presentation that is linked to Excel
- Getting Notepad.exe text in Excel including leading spaces
- VB Sum n+1
- Return key to "OK" a DialogBox
- Finding equation between two sets of noncontiguous data
- Defualt Formulas?
- Nested Withs of Multiple Objects (Parent-Child)
- Used Range of worksheet?
- Arranging data
- retrieving "Records Found"
- Sorting with code
- How do you link 2 drop-down menus?
- VSTO PasteSpecial
- Copy paste a formula in multiple cells
- Macro - Selecting Next Available Cell
- sendmail question
- Re: PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic
- Error trying to run a query in Access from macro in Excel
- help with macros to protect different sheets
- Reference problem
- end with loop question
- Disable Excel Program Messages
- Copy paste a formula in multiple cells
- Conditional Row Deletion
- BeforeOpen Event and Data Validation annoyance.
- Syntax To Link 2 Workbooks
- Re: "tab" thru cells in a specific order
- Protect/Unprotect Not Working
- Hide row if column does"not" contain
- Compressed folders
- Range of Object Global failed
- Error 1004 in search/copy
- can I set up a sort command to happen by clicking on a table headi
- If Cells.Find can't find anything
- Running a macro
- aligning textboxes on worksheet by cell reference?
- Userform close button
- Worksheet name
- split?
- Accessing Columns by name in a Row loop in VBA
- Quick Copy
- Button on toolbar for AutoCalc
- Retrieving contents of wildcard match in search and Replace
- Creating a pivot table automatically
- For each workbook
- Problem w/ Macro after move to Office 2003
- Rounded-off number
- Excel should let me fill down when I right-click
- Code to copy formula to variable range
- Splash Screen
- Autofilter and Cell Count
- Paste Special
- Help With Formula To Calculate Commissions
- Clear Columns Content
- Find, Copy and change from row to column
- Running Totals Formulas
- Calling a macro on a change of Field Button in Pivot Chart
- Selecting a single row range
- Delete current month using AUTOFILTER
- Cell Referencing
- Find the user of an Excel file
- No Blanks
- Return value based on certain criteria in multiple columns
- Stuck with script - Help Please
- how to request Code-signing certificate
- Margins control to VBA code
- Help with code
- Excel-created Word instance hanging on thru Outlook?
- Code Execution Has Been Interrupted
- How to open an external tool directly from an Hyperlink?
- Call subroutine from another workbook
- working with excel from visual studio 2005 express
- Excel VBA/Listbox Query
- How do I activate an facility from inside a macro?
- Recording a filter which then doesn't work.
- deleting all macro/codes from workbook
- How do I move a macro from 'personal' to a specific excel doc?
- Need to do a fancy string copy plus
- Urgent Help needed with macro
- Reflecting info between an excel file and a word one or two excel file.
- Macro Sum of Cells
- Refer to a hidden sheet using a macro.
- Accessing word documents from Excel
- macro to insert lines
- detecting data in a range
- Display AutoShape in UserForm
- Finding a string in a cell
- How to make a routine that will automatically print a word file after it has been changed via an ole link to an excel file?
- Relative columns in range vs absolute columns
- "Move Method of Worksheet Class failed"
- Running Watch in Excel
- Protection killed by sort button
- Problem SelStart and SelLength
- Help with For Next and Exit For
- userform fullscreen
- Selection.PasteSpecial with Office 2003
- Problem with "#N/A" after vlookup
- Truck loan spreadsheet
- Autosize textframe
- Filling down formula to cover complete range
- Rename Sheets based on date range
- How to change Macro security level very high to low...
- executing an add in
- import text file
- pass cell value as string to function
- dates in pivot not coming up with years
- Updating Macro's in Multiple Workbooks
- pivot date field range
- Formula
- Display Alert
- How do I simplify a macro in excel?
- Finding a row number
- javascript causing web query problems
- Concatenate a string when cells are not zero
- Insert Literal in Access Table using JETSQL
- Sorting number as text
- initialize userform, using a sub
- using text in an if function
- VSTO 2.0 vs Excel VBA
- Why Is This Crashing
- sumproduct in VBA
- Excel formatting should expand to other cells
- Run a macro when a cell is changed by an outside source
- How do I change color of cell or of character in a cell?
- copy range and paste to new worksheet
- Event priority
- Auto save at intervals to new filename in excel
- Activate code from another VBAProject
- Select text from a field
- Help with Date Reports
- Cells.Find problem
- Deleting data below last row in a determined range
- Deleting data below last row in a determined range
- outlook profiles
- Create a collection of controls
- Macro VBA, Drop down IF statement
- Macro VBA, Drop down IF statement
- Excel Data Merge
- Append columns to existing worksheet?
- Anyone know how to enter Info in a web page through VBA in Excel
- Automate Opening Files
- Hidding columns not working
- SQL query
- Excel and DDE CPS Plus serial data acquisition problem
- Why this basic LOOP does not work!
- How to: obtain the filename that a module exists in, via VBA?
- VSTO column insert shift to right
- "tab" thru cells in a specific order
- New menu items
- How to test if a range is with in another range?
- set print area based on selection
- set print area based on selection
- (EXCEL) HOW TO PROGRAM CELL SO DATA WILL POP UP IN OTHER CELLS
- Macro to paste in another workbook
- Vlookup top to bottom & not left to right
- Instert Rows Based on Cell Value
- Instert Rows Based on Cell Value
- Letters = Numbers
- Letters = Numbers
- Mirror/Flip Axis/Chart
- Mirror/Flip Axis/Chart
- Select paticular cells
- finding cell value when formula
- Automate Password log-on
- Copy Contract Number to CenterFooter on multiple sheets
- Comparing Absolute Column on multiple rows
- Creating Pivot Tables with macro Problem
- ChDrive error (server path)
- Macro to Recognize Dates
- How do I, in a marco VBA, code to take data from excel and append it to Access?
- How do I Append excel data to a Access database table in a excel macro?
- initializing multiple comboboxes
- Using Date$ function in file name
- Using Date$ function in file name
- Find last populated cell in a row.
- Creating Pivot Tables with Macros Problem
- userform in a separate workbook?
- How do I deal with several workbooks that are open in the ActiveWi
- Vlookup to closed workbook ?
- how to format a Docmd to pull in an Access file in Text format
- how to format a Docmd to pull in an Access file in Text format
- finding next empty row from bottom up!!
- finding next empty row from bottom up!!
- Problem with coding a msgbox
- Problem with overflow
- Macros--user choices
- onMouseOver Highlight Rows
- Error with macro-it worked now it doesn't
- saving file name and location with excel macro
- Filtered worksheet is frozen
- IsDirty
- problem with formatting text in every worksheet same workbook
- VBA syntax
- security for folder??
- excel lookups
- Pasting Tables from Excel to Word
- First Business day of the month?
- "grouped" footer changes
- Estimating costs
- Appending to Access table
- Appending to Access table
- Focusing on open workbooks
- Focusing on open workbooks
- Excel Spreadsheet troubleshooting
- For Each Statement still not working
- Help with Vlookup to several workbooks
- How to control the user can or cannot select? Selection filter?
- Unlock VBA project or Copy Sheets
- VBA Insert Stement for SQLServer
- SetFocus: conditional use of
- SetFocus: conditional use of
- Slecting worksheets one by one.....possible?
- Evaluating files without opening
- AutoFilter criteria
- Why No Work?
- For Each Statement not working as expected
- How to program a code to die
- How to program a code to die
- Putting Formula in Cell
- I want excel opening path.
- I want excel opening path.
- Close Internet connection
- Accessing excel 2003 from visual studio express edition
- Form.Show Problem in Excel 2003
- Mark a range from activecell
- Mark a range from activecell
- Replace formula with IF(error(formula;"";formula)
- highlight text in userform textbox
- btnUpdate_Click() Question in VBA
- error handling
- Hiding columns
- Prevent users from deleting the first row of a list
- Can this be done? Type of lookup
- data analysis toolpak
- data analysis toolpak
- Code for optimization, ReDim Preserve not handling it well, HELP please!
- Learning Excel
- mailing
- mailing
- double data
- double data
- Clarification on "Application.Worbooks.Count" proceedure
- VBA Print set up very slooooooowww
- Copying between Workbooks
- Re: Split Function gives rn-time error
- Lost Macro Control Characrters for Macros in Excel
- Add Dynamic Array to List Box
- Write Unique Values to New Worksheet
- Add .LOG to .txt file on creation
- Add .LOG to .txt file on creation
- Split Function gives rn-time error
- Split Function gives rn-time error
- Reset menu wanted
- quitting worksheet then excel if....
- Copy paste manually
- "tabbing" from one element to the other
- "tabbing" from one element to the other
- VBA: Object variable or With block variable not set (Error 91) - ???
- What's the most efficient to check a file name is valid?
- Copy last row with data to next empty row...
- Copy last row with data to next empty row...
- Setting EnableResize = False
- Cells(i, "B") not working
- Using my own dll to my excel code
- Invisible the Customize item in Execl
- Why am I getting a "Type mismatch" Error
- Copy only some existing worksheets to a new workbook
- Macro to change filename of the Hyperlink
- Multiselect ListBox - Active/Inactive Items
- Mtge calculation (Dly compound interest and multiple interest rate
- how do I prevent a workbook from being saved?
- using xlDialogChartSourceData
- Auto_Open Workbook_Open
- formula problem
- HELP WITH WORK/EXCEL MACRO
- type mismatch on saving excel calculation mode via VB app
- Re: formatting columns with formula results
- How to copy to cashe?
- How to delete spreadsheet if wrong password entered?
- Automate "Allow Users to Edit Ranges"
- Hyperlink to an external program
- XML Source Borders - Any known bugs?
- Protect Excel VB macro
- combo box multiple workbooks / sheets
- Usage of SUMIF formula in the VBA code
- Is there any way to switch among different sheets in a workbook while an inputbox is popped?
- Sub Totals with multiple rows and columns
- show form yes/no... if anything other than no, close appl.
- only letters in text box
- XLA add-in Abort load on Auto_Open
- problem macro to show a warning sheet...
- Stopping automatic macros
- error in attempt to warn about macro security
- Open / Run Application using VBA
- Converting Dates Problem
- Macro to copy excel and paste in word
- api fileopen dialog - lpstrFile size limitation?
- How do you turn a grid into columns?
- Help with formula
- Detecting if workbook running in IE or in Excel
- How to force VBA to create an Excel.Application object of specified version of Excel?
- Menu of sheet names
- Create New Sheets from Filtered List using Template
- Can Excel or Access activate a sound file based on a cell value?
- Data Flipping - Approach with formula?
- Close file automatically
- start application / macro warning problem
- How do I change the color of a cell depending on the result of the function in that cell
- Shelling out to DOS
- Data Flipping
- selection.interior
- Easy-Selecting "No" from message box
- Count between Values
- VBA: How to pass arrays in Function Calls?
- Auto Select from list of values
- blank filling remaining characters in a field.
- Assignibg a value to a property from a cell
- Resizing my range - End row
- Help with looping
- Delete Row based on cell contents
- Buttons & Timers
- Unusual excel behaivor causes crash... Magically linked worksheets?? Why?!
- .dll error message help needed
- Userform - Move to next textbox field by hitting enter instead of
- Excel data to SQL Server
- How to judge wheter an object is existing or not
- how to cancel the right mouse button
- VBA - Check for password protection
- Wait time variable
- Sorting and Filtering out data
- 'If' Statement - Must be a Better Way to Do This!
- Disallow Continuous String of same Character
- Can't Find Excel Interop reference
- how do I choose only certain names from a long list in excel
- XML Mappings to VBA
- Dynamic range (object variable error)
- ListBox external source
- Run-time error 9 Problem
- Use ADO to access SQL Database
- Calculate a suspense date of 90 days.
- What parameter changes upon new workbook Save?
- shortcut keys in VBA
- UserForm ListBox Events
- Why doesn't "Resume Next" work?
- replace text in files within subfolders
- Checking the status of a checkbox in a user form
- Date function: 1st, 3rd and 5th Mondays of a month
- Copying values between sheets
- How to ensure a VBA sub is run before closing a workbook
- Protect a worksheet but allow column resize
- copy subfolders, replace text in files and save files in copied subfolders
- invoking music through VB code
- Is this possible?
- Macro from a different xls file run, still says file in use
- convert american dates from a query
- convert american dates from a query
- Old Format or Invalid Type Library
- Choosing different cell values by user clicking a button
- sumif or sumthing else?
- If statement with cell validation
- how to combine 2 or excel into 1 excel file(different sheet)
- Automation object question
- damaged file
- Format a number to display as alternative text
- userform error
- mail
- Copy rows, but exclude blank rows
- Vector addition and polar plot... need help
- userform controls
- Copy and paste between sheets
- Re: Sort method of Range Object Failed
- Programming Chart Series
- Detecting when Excel user inserts or deletes a row
- error with userform, "unable to create embedded object"
- Code to Enable Macros
- RE: Using Array variable in FIND function
- RE: Using Array variable in FIND function
- Re: Name a Chart so that I can adjust it's position on the worksheet(programmatically)
- Text Box lost its leading 0 - need help
- Move Data
- Validation eradication
- need list of unique values from array in memory
- User Form Caption controls beyond formatting
- Help - PasteSpecial Method - Not Working
- Copy Problem
- Userform Question (Load/Unload/Show/Hide)
- Row number for End of Template
- "FIND" function
- VBA to Protect Worksheet
- Search for word(s) in several sheets
- Calculating a date within the OLE DB query
- Hide Macro Process
- My links in excel keep changing when adding another link?
- Help: Compile error: type mismatch: array or user defined type expected
- Text to Date
- FIle Open/Browse on Macintosh
- ~Help~ converting Excel equation to vba function
- Find and Replace several items
- check for certain dates in excel
- How To Reference The Previous Or Next Workbook s
- How to copy a sheet from a workbook to another in different folder
- How to transfer info automatically from an excel data base to a word document OR an excel
- Add standard button on custum commandbar
- VB to print one sheet twice, double-sided?
- excel spreads
- Combobox / Data Problems
- What does Excel97 not like about this Code Q
- DYNAMIC RANGES
- Transfer pivot table data to another workbook
- Range - Application Defined or Object Defined Error
- Selecting a file from dialog
- Macro doesn't work
- how to call subprocedure from within procedure?
- Transfer Excel Worksheet to Access
- Export As Gif
- SaveAs and always overwrite?
- A script to write in missing text
- A script to write in missing text
- TreeView for Dummies
- Parsing for middle initial
- attn: Tom Ogilvy re: cell data in header
- Looping thru all rows with instr() test
- Excel2000: code too slow
- how to validate excel spreadsheets
- Save file without a password req
- Conditional VLOOKUP?
- Replace formula's in two columns with the value's with VBA
- can we upload files in google group
- More info
- Copy Rows if Cell F? contains
- Controlling MS Word from VBA Excel
- Excel distributables?
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.