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 |
- floating
- floating
- how can the lookup function work with two boolean functions
- Import and Split CSV - 2
- Closing a db file getting errors
- check for insert row action...
- Need to turn on ALT F11 on in excel
- Leftover formatting in code
- Re: Import and Split CSV
- Pivot Chart Help!
- Import and Split CSV
- HasFormula() vs. has a "numeric" entry
- Using the result of a cell's formula as an argument within a running macro? / More
- Please help
- Removing a macro
- Summation Formula Question (Code Inside)
- Find all rows of a color and copy those rows to a new worksheet
- Delete Rows
- City, ST ZIP need to separate into 3 fields
- how can I use VBA to format a column to currency
- Determining if column(s) need to be Autofitted
- xl setup and vb reference libraries
- Move Files from Folder to Folder
- Have macro run automatically as soon as excel is opened.
- How to return the result of a cell's formula as an argument within a running macro?
- Module to make all absolute references relative
- More problems witn Benford's law application
- Web Query Question
- Object Library References
- Change event due to Cut & Paste, Drag & Drop or Edit
- Upper Case Woes
- Error 2015
- Stuck in Design mode
- How to Print a File or Control
- is it possible to create a time-scale using charts?
- AGILE VBA
- Percent Based Off Last Row Sum
- Learning VBA
- BuiltInDocumentProperties
- Macro Help
- Macro to Print specific cells with formatting
- how to stop a hidden session from Excel
- Macro - Title - Input Box
- Printing Worksheets (Array)
- macro file name
- Hyperlink help
- Dropdown list to populate another sheet
- faster way to hide rows w/o using autofilter?
- VB form Newbie
- Module Numbering
- Test af fyldfarver
- dynamic fill of listbox - need help
- Looping
- Macro fails in network
- 2nd Post - Urgently need help on VBA Procedure
- Creating a folder using macro...
- Data Validation - Mulitiple Tabs
- PLease Help..Neeed Hyperlinks from cell values
- Macro Formula Reproduction
- How do I set up a greater than but less than formula in excel?
- Need to extract hyperlink
- Transpose
- Workbook_Open macro question
- how do I copy worksheets between workbooks without the macros?
- get_Range function throws an exception
- Formula Reproduction
- Combo Box - AfterUpdate
- ADO Record by Record
- working with links
- Selecting Column & Row contain text
- InputBox default value?
- Running a .exe from VBA
- Some VB coding required
- to find the conditiona format of a cell in vba
- Changing the code on an external link.
- No. of Columns
- autosize
- based on Cell/Column content ,cut one sheet's values and paste it in other sheet?
- Shortcut Attributes
- Find and copy
- changing find to for/next
- finding blank entries
- Unique Number
- Closing Within Macros
- selecting the currently active column
- select the contents of a cell
- Gant representation.
- Pivot Table Creation
- Using input box to improve my method
- Opening MS Applications
- VBA loops and Dolver help
- i entered this formula =Randbetween(B111,B110) but no number
- I'm Stumped
- Userform.Caption is blank when reference passed to class
- Macro help, populating excel spreadsheet
- Convert Date format UK to US
- Activate MS Outlook in macro?
- Automated contract received/accepted/loaded spreadsheet design HELP NEEDED
- Challenge experts will LOVE!!, can you get the formula??
- Using a formula in different columns, for corresponding data
- Generating 1004 error messages while running a marco
- Locating the row that has no values. Selecting that row till the last row after that and deleting it?
- copy two columns without blanks in the first column
- Make excel stop if the date cell is blank
- 2nd Thursday of the month
- multi-line text file import to excel
- Data save (data base)
- Advanced Filtering problem
- Force Save over existing file
- Cells(Rows.Count, "b").End(xlUp).Row
- Hyperlinks and multiple files to open
- Limit a calculation to a certain number
- Extract macro text out of Excel (Newbie)
- Seperating data from one column into two columns
- Combine several columns of different length into one single column
- One to many problem?
- code help w/userform
- Help with Recursive Call?
- NORMSDIST() and NORMSINV()
- Change Registry in VBA
- File size
- .SendMail Method into Eudora
- XL 2003 Graphs: Retrieving Point Name
- Transfer data
- type mismatch error in Benford's law macro
- How to determine whether text in cell needs to be wrapped?
- Macro to import text file and update calculation to include new co
- Returning the wrong values...but not in the Immediate window?
- Print area based on item list
- My first macro, uses Vlookup but doesnt update unless hit I enter
- List Index filtering
- Open Office
- Printing Problem
- need help
- CountIF in VBA
- VBA Command - I need help Please!
- Need to extract hyperlink
- Event trigger in Excel?
- Pivot Refresh over ODBC
- to Copy the Entire Row
- Pop up warning message based on a certain value
- Change #DIV/0! across a range
- MSFlexgrid in Excel
- FormatConditions VBA Bug?
- ComboBox fill ActiveCell
- Leftover Workbooks with Opening Excel in IE Browser Window
- MORE listbox code
- Excel 2000 - 2003 Compatability problem with pivottables
- VB editor bug?
- turn off link resolution?
- Sorting
- #REF! error with custom function programmed in VB
- Calling the "Duration" function in excel to be used in VBA?
- Workbook Deactivate event problem
- Problems with Excel 2003 - Dashboards
- conection with Oracle database
- Excel thinks 1900 was a leap year???
- How do I declare a function whose output is an array?
- Compilation error when using an English VB program on a French Exc
- Help with macro that gets fired with check Box
- Macro buttons need to be exorcised
- VBA Shortcut needed
- Adding and removing text within cells
- Summing a Field while Using an Autofilter
- set variable to activeworkbook
- I'm adding 1.5 & 1 and VBA is telling me its 2 ?!?!
- listbox code
- multi-function macro possibilities?
- Random Password Generator
- How to, check if a picture object exist
- VBA & Multiprocessor PCs
- I need your help. I want to add additional text within cells
- Date Problem
- Macro to delete characters in field
- lock cells
- Best way to "filter" an array
- how to delete different data from different cell at a time and lea
- macro launched when condition is true
- Conditional Formatting - Range of Dates
- Loop that finds blanks, then subtotals values into different column
- How many nested statements is this?
- Using variable for range address
- Min & Max of a dynamically updating cell value
- Slightly off topic - counting rows in XLS?
- Macro loops and solver (VBA)
- Can i use Paste Special in this way?
- Excel 2003: Files can not be found
- Help with Excel FreezePanes from code
- Delete worksheet - dialog box showing
- Copying UserForms & Modules to another workbook
- How to Combine or Merge Columns?
- Macro run from if then function
- Fomatting based on columns displayed
- How to use a macro from another excelsheet
- Re: Simple Loop Help Please
- Simple Loop Help Please
- passing arguments to events
- Range("A1").select doesn't work!
- Yes / No - Goto VBA
- VB's Command Button vs Form's Command Button
- Help Cleaning up Code
- macro does not work from commandbutton
- Help: XL & Outlook
- Automated Printing
- go back/previous cell
- Automated Printing
- Undo a Macro?
- Sum up a dynamic range
- Macro Names
- Specifiying a Range
- How to add shortcut to custom menu entry?
- help with copying worksheet (excel 97 vs excel 2000)
- Importing Text File
- Haven't fully tested my code - whats wrong with it????
- Removal red rows in excel
- Macro Drop Formula As Far As Required
- problem in deleting and inserting a row
- problem in excel
- Form, or seperate text boxes?
- HELP!!!! needed in Excel
- HELP!!!! needed in Excel
- based on Cell/Column content ,cut one sheet's values and paste it in other sheet?
- Immediate Window phantom entries
- Circularity
- Removing spaces and adding comma's using a Macro
- Filling an array from one sheet to another
- Excel - Date comparision in VBA
- Can anyone help with the following macro?
- Print Area
- programmatic advanced filter
- Just another listbox question . . .
- moving sheet changes object assignment?
- string function
- Macro issue
- Worksheet Coding
- CurrentRegion works different in the Editor than in the workbook
- Random Number Generator
- refering to details in another sub
- copy cell value problem
- Like with * returns incorrect sheet name
- Help with the old #DIV/0! chesnut
- Enforcing a Cell format
- distributing an Excel/VBA app
- Why does Range.Rows.Insert sometimes not work?
- VBA - Click mouse to change cursor to cross hair that spans the en
- VBA - Excel VBA URL's
- VBA - Internet Resource URL's
- Tom Ogilvy or anyone else who can help!
- Chart: range info from seriescollection?
- change cell values based on drop down box selection
- CommandBarButton onClick
- copy data from one excel to another in Visual C#
- Importing HTML File
- HLOOKUP, VLOOKUP
- Locate specific record
- Copy row from one sheet to another
- Creating Help Files with HTML Workshop
- hhctrl.ocx
- A Dollar's Worth
- Printing the contents of a text control on a user form
- InternetExplorer
- C# Automation Server and named range reference
- Read-Only
- customized chart-please help!
- Exit Sub
- Get text from a Html form
- VBA does not receive Excel Events
- Write Code w/VBA
- Limits to using Call
- user form input
- Specific Range Deletion
- .chm Help Viewer
- Need Help With ADO Recordset and Loop
- Deleting old workbook data
- Import text file and create new spreadsheet
- Vlookup
- insert user and pasword in a frame of web page...
- Count number of shifts...
- excel 2003 and c++ API documentation?
- Listbox data required
- Opening file with date tags
- lock cells until one cell is filled
- How do I access a "Global Variable" of one Workbook from another??
- Textbox problem
- Navigating with a macro
- Automatic Cell Population
- Message Box bleeds when dragged
- Re: solver.xla VBA bug?
- Problems with DAO and SQL Server
- need a way to create seperate worksheets from a master
- Hyperlink
- Viewing Excel through a web-browser
- Running an addin-macro from another Macro
- Macroo assigned to CommandButton
- Need assistance to write a macro that does the following
- EXTREMELY slow toolbars?
- SEARCH AND DELETE
- Excel & Outlook
- Unique Data Validation
- Fill empty cells
- Autosum function
- problem selecting a range using variables
- Disable creation of Enhanced Meta Files?
- Combine multiple rows to 1 row.... help
- I want to get the sum of a total number of fields on a weekly basis.
- I broke my Excel!!
- HOW DO I GO TO DIFFERENT CELLS BASED ON WHAT IS IN A CERTAIN CELL
- help needed trying to find autoshape/shape name
- Creating a Workable Space With UserForm
- force to use a specific XLA
- Recordset keeps returning EOF and shouldn't be.
- Can I run a message box Macro on Save in Excel?
- accessing word file from an excel file
- Object browser icons?
- How to reference to other Excel application in VBA
- Help with Count, CountIf, Sum Functions
- Copy all Range Names to Personal.xls
- Convert CSV from clipboard into a transposed list (part solution provided)
- Help with calling a function
- Save workbook as a PDF File
- #NAME trying to find VB function?
- Enter formulas in a certain number of rows, based on a cell value
- Breaking links in a macro
- Displaying the progress of calculating cells
- Auto Add Row
- Loosing variables help needed
- pick from list
- Automation Error help needed
- Ifs, Selects & Loops Error Statements
- Worksheet Menu Toolbar
- How do i truncate a series to lie between 0 and 1?
- VBA block warning
- How do U Color shade Locked and FormulaHidden Cells
- vba, step to next line
- Scroll and print
- VBA Setting value error
- waiting Query result
- Automating Import of Date Information
- "how do i use color with if in exel"
- How can I catch a Paste action and default it to PasteSpecial-Values
- password
- How do I open a file from a named cell?
- Automatic recalculation of array functions
- Password Protecting a particular Sub
- HELP!!!! VB Macro in Excel
- HELP!!!! VB Macro in Excel
- Fill a Listbox with mult. Variables in userform
- For Next Issue
- copy problem using excel VBA
- Display only selected fields in a PivotTable with VBA
- Programatically changing MS-Query properties within Excel.
- Adding a tip when the mouse is hovered over a shape in Excel....
- Skip if variable not determined
- removing tabs and newlines
- generating text box value based on equation from other boxes
- Use of Range(Cell1,Cell2) in chart creation
- Setting the active printer
- change pivot field of button type figure to general text
- conversion question
- Alt + F8
- independent macros
- How to automatically create and populate worksheets?
- Split one field into two
- UserForm Listbox doesn't update
- sumproduct in VBA
- Remote Procedure Calls
- run time error(13) type mismatch in Excel Feed
- Blah
- check if the result of a formula is null
- .Parameter property of CommandBarButton
- Finding all the values and storing them
- Excel loops and If blocks
- Formula in macro
- Is there a CopyToRecordset (Oppisite of CopyFromRecordset)
- Cell Row and Column address
- setting page breaks.
- Input Box Asking for Date, and Validating Format
- Web-Based Excel Reporting
- How do you remove leading zeros from a column in an Access databas
- Date last saved/updated
- Canceling Workbook Before_Save event
- Add, edit, delete, save functions in excel using macros
- reference, test and change cell font.
- VBA, database and Charts
- getting rid of unprintable chraracters...?
- listbox and textbox problem
- Print pages
- Update all the work books
- Problem with Monotype Sorts Check Mark
- Exporting data range from Excel to Access
- Variable
- How to count optionbuttons on specific range on worksheet
- Get embeded HTML Button text
- Chartlabeler Question?
- Calendar Input
- HELP I need a function or macro to crop cells
- program
- finding chart series low
- Using VBE to change tab name
- Continuing a loop from within an if statement?
- simple vba queries.. please help..
- Date find and copy function.
- How to get Excel to open text files by the time created not name
- Função de números por extenso
- not releasing excel objects..pl see this simple code.
- Hide Selected Cells
- Conditionally formatting
- timesheet auto populate date?
- Userform Captions
- Date Time of Last Execution
- Excel Still Thinks Workbook Has Macro Code
- autofit
- Hide Columns When Printing
- pdfDist.FileToPDF does nothing
- For Each / Next
- add wks into form
- Getting rid of command bar chevrons that allow "customize" menu (Excel 2003)
- Compile error
- Use Task Scheduler to automatically run Excel workbook
- How do I calculate a several tier IRR waterfall?
- HELP: MsgBox takes 99% CPU usage... why?
- save word doc
- USE
- help me to sort out data by text
- retrieving Text from a textfile in Excel
- Need help on MACRO for copying between worksheets
- 012979666
- Difference between before_close and auto_close
- Closing Excel using VBA
- Importing pictures or graphics
- ContextSwitchDeadlock with Excel VSTO
- Defining a Variable
- Data is pulled from LotusNotes to Excel2003 ,the file hangs.
- PMT Calculation
- function: copy current path or filename to clipboard (XLS)
- Logging data using the same textfile over and over again
- Excel needs function to Convert Rowindex into RowCode (2 -> B)etc
- Run time error 1004: "No list was found.."
- help looping through textboxs on userform
- Renaming a workbook without saving
- -4127 is created by my macro.(Bug?)
- How to Check Empty Rows in Sheet2 when sheet1 buton clicked
- Excel shared file problem
- Like operator
- add text into right-side of menu bar
- Non Refreshing/Recalculating Cell ??
- Job
- Reading Wordpad - Rich Text Format
- pulling data from another sheet
- Opening a file with date extension
- Link page formula error problem
- naming the column
- Inventory
- Combobox Query
- How to create a simple VBA Custom Function
- VBA - Hex To ASCII
- If line ends in assigned value then change item in COMMENT.
- don't save macro results in template
- Using a Macro that switches between workbooks
- Special characters, printing
- Passing value of variant
- Edit Forms
- Expressing If formula in VBA
- web and excel find text string...
- VBA - Error Using Mid To Parse A Data (.dat) File
- Deleteing Rows starting with value (text)
- Macro - select and paste
- Cell background color (interior color) setting not working
- Find Character Position in String
- Fastest way to find item in an array.
- Unable to get the dropdowns property of the worksheet class???
- Help with a simple macro.
- Validation List
- I need to convert a series of DOB's from yyyymmdd to mmddyyyy
- fetch data from excel page
- Passing variables for range series charts, what to do with post macro run; unable to
- insert function, please help
- Help its not working
- Combo box error on form
- How to prevent multi-access for XLAs?
- Setting a Custom Class as a Global variable
- Moved file, changed path, macros don't work
- VB Questionmarks in a For loop
- Counter to delete a row
- Adding items to a right click menu
- Works when stepped-through, but errors when macro ran
- How can I make the copied range from another worksheet independently
- How to pass address(es) as parameters
- Forcing the cursor
- Calandar
- Excel and Finance
- Single statement database/range processing with criteria
- Importing multiple files
- Random Selection
- Find 2 Matches Wors Then Cut Selected Rows
- Loading xml files
- Quickest Way of making an Array
- find max value in multi worksheets
- quick help: get folder name
- formatting decimal places for complex numbers
- Columns in textbox
- SQL query syntax
- Lookup from a very heavy file
- User to choose an item from a list
- Add-In password is requested when closing Excel
- Timestamp for ComboBox
- saving macro gloally
- Custom Functions are static?
- ListBOX1_Click problem
- Reset Excel Defaults
- macro to savecopy as and break links
- Deleting a row
- Return a Value Based on 3 Critera
- macro converts formula using imbeded literals
- passing an object
- date time Formating
- Sum in hidden column
- How to refresh Share workbook in excel someone can see changes
- Date Time Question
- Is Empty
- VLookup error
- Pull Pivot Data
- Newby Needs minor tweak on this VBA Macro code for Excel
- one line!!!
- Hovering over variable no longer shows value
- looping
- Accessing data in pivot tables
- List Filenames from Folder
- Open another excel file in macro
- Combine CSV files into 1 Excel Workbook as sheets
- data flow chart
- Would this require a program in EXCEL? multiple conditional statements
- XLA in startup path
- Delete range on open
- send mail from excel 2000 with multiple attachments
- Error Trapping question....
- limiting rows in a text box?
- double quotes syntax required
- Need a template for setting up a permissions database in Excel
- Message Box
- cannot get GetOpenFilename to work
- applying math operation across range of cells
- Help! with MECE tabulations
- Collecting textbox input within a for loop
- extract data from a cell
- Importing multiple files
- Dynamic Toolbar icon
- Staff Rota Template?
- Convert Workbook (to text)
- Sum vs. Addition
- SendMail to multiple recipients, one variable, and one constant
- ActiveSheet & Apropriate Reference
- Searching 2 columns for dates and text problem
- command button on worksheet
- Converting a report into a Pivot Table format
- Need to change existing formula into values...
- Passing Custom Class Variables through Functions
- Very slow unhidding rows Excel 2000 SP3
- Copying contents of w/s drop down boxes to another sheet and creating a named range?
- Help with macro to give a message box
- Workbooks.Open fails when using a full network path....
- Insert a column with it's own delete button?
- Saving Data
- Hide non-contiguous columns
- Excel FileDialog object and Visual Basic 6.
- using a worksheet range to populate a combo box in excel
- press button via vb and excel
- MSG box if
- sending email from excel using macro
- Time-Tracker form, multiple instance of Excel
- Formatting a date from a textbox
- Subtotal \ Grand Total in VBA
- forgotten variations of loop
- Styles in a cell
- Logging username, date and time
- Sava As and templates
- add colours to caracters
- How do range objects work?
- Named Range
- Multiple workbooks
- Do until code attempt..
- How do I diable Show Tabs under Option Menu
- Open file in VBA
- SpellNumber Function
- Run time error : Excel 2000 and Excel 2003 : different behavior of Macro
- Re: rows of text in merged cell with wrap text
- opening an existing text file useing code
- Comparing using "If" function
- Help, please
- Slight prob with this code
- inadvertently created loop
- How do I use variable dates with a SQL Query
- Matrix averages
- Auto-detect range size
- Voting Response
- Truncating a string in Excel
- inserting rows in between using VBA
- Very Simple Question
- Removing duplicate rows and combining unique data
- userform label double-click goes to click event
- Crosscheck ranges
- Chart
- Creating a Range from two specified Ranges
- Help! finding data and pasting it to another sheet!
- Very slow unhidding rows Excel 2000 SP3
- Excel newWorkbook event not firing
- Playing audio, but not from the start
- % of subtotal needed in pivot table
- Thanks !!!
- Autoatically insert blank row above total when no more rows
- Excel Copy and Paste Issue
- New instance of excel.exe not firing newWorkbook event
- New instance of excel.exe not firing newWorkbook event
- Opening to a certain page...
- Need help: search and delete columns
- positional relevance
- Share macros on a network?
- How to Get Date of Each Cell....
- refersTo property
- Message Box in a macro
- Textboxes - restrict double-click and selection.delete
- Varibles determine macro to run
- How to do Selection.Subtotal in VBScript/ASP ?
- Function ????
- Password in a macro
- VBA to "Label" and "Unlabel" formula
- List all modules in workbook X?
- Unprotecting Sheets
- Getting The Chart Wizard To Appear
- Have this great Macro, but!!
- Excel OptionButtons Value Clearing
- Custom file menu used to redirect to desired sheet
- add-in problems
- Excel VBA window appear unexpectedly.... Really annoying
- Best Online Source 4 MS-Excel & Complex database Handling?
- Late Tracking
- Find & Delete columns to the left stopping at column B
- excel: international formula names in c#
- Find & Delete columns to the left stopping at column B
- Does anyone have an ad in or Macro code to find Phantom Links?
- Removing Cell Labels
- count record in web page...
- question on user-defined formula calculation mode: can it be instantaneous?
- Language independent Pivot settings
- Reference older libraries
- VSTO Excel Crashes in Debug
- Change dialog button assignment
- Form problem
- Shared file issues
- Delete Rows in Worksheet2 that Match Criteria in Worksheet1!A1:A20
- Writing Help for a Formula
- Sort method possible without using select
- Calling Another spreadsheet
- data format 99
- how to properly loop a macro
- Count and Sort list.
- Command Button Macro
- Can you see what's wrong withthis code please..
- Format range of cells for Array formula
- Workbooks.Open 2000 vs 2003
- Creating shapes dynamically and connecting them
- Who's up for a challenge!!
- Sending a range as an image attached to an e-mail
- Adding New Member Variables to Cells and Worksheets
- User Defined Functions
- Work wil rows returned from AutoFilter
- Replace Excel Message w/Custom Message
- Conditional Date Formatting
- activate current sheet
- Removing Links and Formulas
- Worksheet change code to colour in rows in a database
- can i import barcode data directly to excel
- how to copy option button from one worksheet to another
- Resizing a pivot column based on Field Name
- Need a spreadsheet that sorts by month/yr & 2 other sorts w/total
- DisplayWorkbookTabs Macro
- Fix for mouse wheel in VBE
- Create own add-in
- pass workbook on to function?
- Wildcard
- template code in one place
- VBA - Launch VBA Macro From VB
- EXCELL I WANT TO LOOK UP AN ITEM AND FILL IN MORE THAN 1 COLUMB
- Count Number of different numbers
- Selecting a call and using info in auto filter custom select
- Problem with VBA macro running inside VB
- Pasting line to a chart point
- system calls in excel
- Modules in VBAProject (PERSONAL.xls)
- Insert a number a number in column
- Insert a number a number in column
- Check Voucher Template
- Tools | References
- Character Stripping
- lookup two tables
- working with selected cells
- Need Excel 2003 Programming help...
- How do I select printer using VBA?
- Autofilter Question
- Error using ".submit"
- Disabling SaveAs
- copy matrix (diagonal)
- VISUAL BASIC CODE
- Disallow changes once expiry reached
- VBA - Text To Columns in VBA
- Sum Relative Number of Cells in Column
- Using a combo box on multiple pivot tables
- Selecting multiple rows within a CurrentRegion
- Auto fill for dates?
- [XL2000] ObjFolder.Self.Path - 438 error
- Please I Need Help
- Can I get a number in such a format as it should be?
- Find, Copy, Paste to new row
- Maniuplating Worksheet Tabs
- formula!!!!!
- Multiple Excel Search
- Message box if cell is greater than less than 0
- VBAProject remains open after Workbook closes
- Defining Ranges using macros
- OLE Automation and Mutliple Office Releases
- Macro copying cells to a list in another spreadsheet
- Macro for Print Loop within Excel
- Userform help
- Excel API events
- Access -> Excel
- Conditional Formatting - Thick Borders?
- Error Handling - Edit>Go To>Special
- macro for excel, automate task
- Macro to copy workbooks from one location to another.
- Changing Field Name
- Goto a referenced cell
- Calendar Control Changing System Date
- userform listbox cannot get listbox.value to transfer back to main sub
- AutoFit Very, Very Slow
- Need Help Creating a Loop
- Excel crashes when Combo Box loses focus
- Stop column width from changing on pivot table....?
- Search a spreadsheet for words in certain fields
- How to create and name a new workbook based on each unique record
- Find and replace within a column
- Pb with additional VBA reference
- user input decides cell copy range
- loop syntax
- look for sheet name in list and creat hyperlink to cell
- look for sheet name in list and creat hyperlink to cell
- macro High Security Issue
- Workbooks.OpenText problem in XL2000
- filenames and workbooks
- Merging worksheets into one
- insert column macro
- Pasting Between Excel and Word
- Change Formula with Macro
- Printing from Excel using a macro - Phase II
- Auto delete of a sheet
- selecting Variable range
- .xlT File & Spreadsheet Becoming Invisible
- NETWORK (LAN) MACRO QUESTION: W XP Pro, SP-2
- Week starts on Saturday - Working days
- adding checkboxes
- Week starts on Saturday - Working days
- Week starts on Saturday - Working days
- Cell Format Check
- Slight VBA Code Change required
- Closing a workbook exported to the website
- Count 2 (Two) specific words in a cell in a given range
- select a cell following vlookup
- insert formula
- Error 1004 Recordset - Help
- Copy Lotus Data Into Excel
- Reasons why Worksheet_Deactivate fails?
- Macro Help for Substrings
- Autosum a variable column length using VB
- Novice trying to call a web service using Excel 2003
- Peculiar Problem when Doing a Sheet.Copy
- Excel and VBA.NET
- Hardware effect on Chart creation speed
- Determine if a cell is in a range?
- Add total
- Time Tracker
- Time Tracker
- Worksheet_deactivate fails - any ideas?
- Setting left position works in XL 2k and 2002 but..
- Macro to Check only one box
- Empty cells not Empty!
- So, what if it's already open?
- counting actual and displayed values
- Why Application.CutCopyMode giving problem
- Validating a unique reference in a textbox
- Please help. poss VBA
- Help needed on loop
- Use sort in VBA
- extract data from a text file
- CU
- Saving a file to have the filename of the dated it was created
- Type mismatch problem in array - ??
- Clearing data from a so called protected sheet???
- Help with saving from a cell
- ODBC managment with VB Excel
- Code Execution has been interrupted - ??
- Macro - use variable integer as text
- Sum formula in macro returns zero
- copy range from one excel sheet to other fails.
- Excel 2000 file types have been changing.
- VB Combobox field problem in Excel 2000
- date serial
- .xlT File & Spreadsheet Becoming Invisible
- VBA: Opening a .txt chosen by the user
- I am trying to convert an excel worksheet to a pdf.
- Can't delete columns in Excel VBA
- Date since hired displayed in years.months
- Basic Question - How do I return the worksheet number of the active worksheet?
- Find last cell of data
- Can we require "Enable Macros" or else the file can't be opened?
- Increase cell limit from 1004
- Alternative Ways to Spellcheck a Range
- Problem inserting images in VBA forms in Excel on a Mac
- AutoFit Infinite Loop?
- Run a macro by the number typed in a box/button
- Message Box with a Timer
- Extracting Numerous Text files into Excel
- How do I start an inventory system for a small business
- VBA Help on Not Copying Specific Worksheets
- ow can I get the active sheet name to a var in a macro??
- TopLeftCell change to "bottom"LeftCell
- Creating Comment Programatically
- Trouble when trying to call a sub
- Sales Commission
- Automatically calculate in a cell comment
- dialog box
- Keeping track of changes and saves
- Need help - color cells
- Printing Embedded Word Document
- What's the correct format to check the name of a sheet?
- Get Current Year
- Additional Controls not opened
- Show Data Form
- Copying buttons
- assign value to range
- Integrating variables in formulas in VB???
- Excel and SQL
- Toggle Buttons
- Customizing colors
- Is this possible?
- Is this even possible????
- Naming a Range...?
- button to jump to another worksheet
- Database Linked Spreadsheet
- Macro for Pivot Table
- Error 400 - help
- Is it possible to set a conditional lock for a cell in Excell ?
- worksheet change event
- VBA - Loop a Function
- Sample Codes for SQL for Excel VBA
- Setting a Range depending on variables
- Pasting
- How to find intersection points between lines using Excel?
- Macro for adding new items to list
- merging excel books
- setting background
- Program Auto Yes for overwriting files
- RemoveItem - ComboBox
- Searching and Matching Lists
- Sending to groups in outlook
- spaces and codes don't get along
- How to "unnamed" workbook.
- Collect data and sum, w/ connection to another sheet
- clearcontents for some columns of a row
- Indirect Name
- Any vba code to disable only close button in Excel workbook, please?
- Splitting Cell content into separate Rows
- Accessing dll
- Scheduling a Macro to Run
- vlookup in VBA (dynamic range)
- screenupdating = true
- using cells values to determine macro action
- Hide/Show a row based on data entry in another row
- VB doesn't like this Formula?
- Run-Time error '1004: Unable to get the PivotTables property of the worksheet class
- Excel Macro to open file, load & do charts, functional but not usable/not a good prog
- excel references
- Named Range Change Based On AutoFilter
- rewrite in range
- Move a sheet to last sheet of wkbk
- Help, Code won't work and I have no clue
- VBA novice: new to userform & VB editing...
- Change Named Cell ranges based upon value of another cell?
- Any way to save VBA code so it works with older Excel revisions?
- How to save a single worksheet as worksheet name in new folder??
- Forcing VBA to wait until sheet completely calculated
- Set a set as Calendar Control Object
- search for dates set by a formula
- July - UK Excel User Conference
- Auto-Protect multiple Sheets on closing?
- Replacing spaces with zeros
- Opening Built-In Date Form Dialog Box Programmatically
- Change Pivot Field Value
- Choose (open) workbook for actions on user prompt
- PivotTable: how to align row data to the left?
- PivotTable: how to add vertical lines in Data Item area
- Error moving sheets between workbooks
- Count Filled colour in cell in given range
- Workbook_open - Sub problem
- Pasting rows below the last row with data?
- Opening Built-In Custom AutoFilter Dialog Box Programmatically
- name wise Text summary
- Resize columns for all sheets in a workbook
- Count Specific word in Specific range
- VBA - createobject - If
- Opening Built-In Dialog Box Programmatically
- Problems with programatically referening libraries
- Date Format Error
- Bound Combo box in userform
- Can somebody tell me what cause the mistake?
- VBA to display image on a form - image is defined in Range Name
- Executing a Value in a cell
- returning values application.dialogs(...).show
- Darn function in vba
- populate unique entries to txt file
- Skipping blank cells in simple math formula
- How to turn a cell "OFF" or Null it's Contents?
- Deploy "Microsoft DTSPackage Object Library"?!
- Filldown? & Cmb?
- Annoying Problem
- How to display unicode character in Visual Basic script.
- Loading an xml
- routing slip
- Excel error with .NET web application
- Can someone please tell this newb what he's doing wrong?
- Input Box Asking for Multiple Responses
- Access a worksheet level named range with Refers To like "=5".
- AutoFilter based on 2 Fields and 2 Criteria?
- Combo Box List Dropdown
- tab password
- selecting checkbox numbers
- database ODBC custom formula retrieval and other
- Launching Help from F1 on Keyword
- Drop Down?
- Before Print - Case Select?
- Selctionner la derniere ligne et collage special
- Merging a full column into a single
- textbox format
- Ordering a list of numbers?
- proportionally fill a cell
- Macro Toggle On/Off
- keep new menu item with workbook
- Creating a button + Issue w/ digital signing
- Using AutoFilter
- Re: Using AutoFilter
- Run Time Error 1004
- EXECL.EXE command line
- Macro to copy all spreadsheets into 1 spreadsheet
- ?row and ?key -- Worksheet_Change
- Send Email When Cell Value Changes
- how do I merge two worksheets and save as individually
- Adding formulas to cells
- Programmatically verify VBA digital signature and timestamp
- Catching text from a Control.
- multiple objects in single cell
- Auto copy and paste
- Create a form to switch sheets
- Manual Calculate for Excel Workbook
- export to CSV more than 65k rows
- Formatting in Excel
- Force file name change
- Filtering Data In several Tables at the same time.
- Messy Users
- FTP Directory Listing
- Passing Variables through Custom Dialog Boxes
- Macro to delete row based on criteria (first few characters of string)
- ComboBox1_Change - is triggered when file closes
- For Loop Problem
- Spell Check range and move to active cells
- Set Page Number to One After Page Break
- Select Cells In Column that have data
- validating data in acolumn
- Text Length Data Validation, without error message.
- Copy data from one file to another
- Function to display a count of visible cells/rows... doesn't
- Font Color Index / Name Source
- Custom dll troubles
- Re: Trapping Add Shape Event
- creating Excel Application Object in C#?
- Unable to set XValues Property of Series Class
- Userform button - shortcut key?
- Generic Form
- Referencin "Calling" Cell from VBA Function
- Re: My ultimate goal is to create an ID that will always be unique
- sort and column numbers
- finding two cells to sum
- Sub works sometimes and sometimes doesn't
- How do I?
- Opening Windows Explorer...
- Guides "Template" - in Danish "Guiden Skabelon"
- Summing until empty cell
- msgbox background colour
- Summing until empty cell
- get value from same cell on all sheets in a workbook.
- Close an application with sendkeys
- VBA column identifier and looping
- Runtime error 91 help
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.