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 |
- Re: Delete VBA code in worksheet through a macro
- Re: Delete VBA code in worksheet through a macro
- Prevent User from Deleting Drawn Object
- Macro to copy text to a specific cell reference
- Insert Rows in Protected Worksheet
- Problems populating an array
- Creating Custom Menus
- boo boo
- Disable menu items with VBA
- observation on .filldown method
- Complex numbers in VBA (Excel(
- formulas - multiple reference sheets
- Re: Nested If Then
- Re: listbox
- MSCAL.OCX
- Re: Nested If Then
- Re: writting a macro for the sum function so I can use it as a keyboard shortcut
- Internet Explorer Automation with Excel VBA
- Cannot insert object when I update version
- MSCAL.OCX
- Re: Nested If Then
- Formatting Cells
- Re: Function to extract and return the first and last cell from addres
- Non-consecutive numbers in Macro
- Actual row of a filtered row
- Commandbar frustration.
- change datestamp from yyyy-mm-dd to yymmdd
- How to find a column
- control of dialog macro dialog box. on open
- Re: Replace() Range Function
- sendmail error
- Row Referencing
- Novice VBA question...
- Excel 2000 versus Excel 2002 question
- Why am I getting the Copyright Sign instead of the Letter C"
- Re: Open webpage
- Re: use of Macro in If statement
- Re: usgin a macro within an IF statement
- Password Protect Worksheet Viewing
- send macros with file
- Trouble getting the OFFSET fo work
- Programing Outlook using Excel
- Sort filtered rows in VBA
- sendmail message
- exel macro to eliminate duplicate record
- Re: Associating Cell with Background Image
- Distribute Excel Addin
- Changing Row Referencing
- macro code doesnt work in command button
- Auto-Hiding rows based on cell in seperate worksheet
- Exporting pictures object from Excel
- Problem with 'For' loop execution [VBA,Excel XP]
- Re: Totalling across sheets
- Re: writting a macro for the sum function so I can use it as a keyboard shortcut
- writting a macro for the sum function so I can use it as a keyboard shortcut
- Totalling across sheets
- Find Non-consecutive numbers in list
- How to create text file from selected excel data
- Crack a VBA password?
- Cell formatting changes on export
- Automate this code
- Cycle thru worksheets in a workbook
- Unhiding a sheet
- VBA complex numbers
- help with command bar positioning
- runtime error 1004
- Do Until VB Macro
- button control on Forms toolbar
- User Info
- Evaluating Week No.
- Re: Prevent multiple cell select
- How2 Delete "Not exist" charts/sheets?
- Re: Copy range content as picture - truncation problem
- Cell Reading Problem
- Removing a reference
- DLL
- sheet orderings
- MS Query - Parameter Bug
- Re: Alternative to updating 300,000 links in Excel 2000?
- Hide Formulas
- loop through columns
- Moving Directories
- re Alternative to updating 300,000 links in Excel 2000?
- Import data into seperate sheets
- Automatically Confirm Deleting Charts
- Re: Data loading more than once into excel columns
- Data loading more than once into excel columns
- Check image availability on userform
- Saving Userform as Gif
- Help on Disabling Save & Print Options
- Excel VBA - Timer
- Excel VBA - Timer
- Macro
- Make all empty cells in columns = 0
- updating spreadsheet
- Entering Date via SQL Query
- Screenupdating is always true
- Automatically paste cells that return a value, otherwise maintain existing formula.
- Thanks
- Excell Macro help
- Determine page which row will print on
- compiler error in calling Exell functions
- Selection of non-empty cells
- cell conditional formatting
- give me a hand,About printpreview
- Re: command bar question
- Different text format on a listbox entry
- Excel VBA - determine location of a keyword
- Re: Auto Open macro not performing as expected
- Re: Check Box weird problem
- Re: Thanks.
- values from other workbooks.
- Macro to send HTML email...
- Help: Iterative Operations for Election 2004 Project
- Macro Debug
- converting VBA scripts to stand-alone exe files
- Number format in CSV file
- parameter queries in macros
- a for selected sheets print named page macro
- Re: msinet.ocx
- Font Changes on Embedded/Linked objects in Word
- Conditional Format ?
- sendkeys method - question
- file name reuse
- Outlook Question
- Report All Column Widths In Active Worksheet - Corrected
- Selectively Unprotect an object
- Delete rows based on comparison criteria
- Assistant Balloons hanging on
- Re: Many Rows to One Row based off of first column
- dividing report by region
- Help with automatically running procedures when an Excel file is accessed via web
- Userform Comboboxes - need a quick how to..
- Open Multiple Workbooks or Worksheets
- create my own "table"
- Alternative to links for updating worksheet?
- Re: Current time Current date.
- Creating Borders with a formula
- Re: VBA Challenge - Flag Missing Info
- activeX
- Returning The Column Number ?
- totalling across pages
- HELP: need to find number and sum another colmn
- Can I use a VBA function I write myself in a formula?
- Referencing password protected Workbook
- send mail with MAPI problem
- Re: Real time countdowns
- Getting a String Path from a browser...
- Excel VBA - How do I make a bar chart
- Re: VBA Challenge - Flag Missing Info
- Pop-up calculator?
- printing ranges ina macro
- Shrinking Listboxes
- Help with copying 46000+ Rows from Excel to Word
- Setting Range Command
- How Do I Run A Macro When Excel Is Resized?
- Convert two times to "Hours Worked"
- Anchor points in Excel, for web use
- Filtering records
- Showing and hiding columns
- Running a macro when a cell value changes
- can't get code to Run
- Report All Column Widths In Active Worksheet - an example
- Split Workbook part 2
- Re: Macro in VBA: Setting a variable print range HELP NEEDED!!
- Re: Put Info from Clipboard to Textbox on form
- Re: Many rows to One row
- Re: Put Info from Clipboard to Textbox on form
- Dynamically changing filename referenced by day
- Macro help needed...
- Copy Filtered Rows
- Changing Pivot Range Programatically - header row issue
- current row of user-defined function?
- tree view
- Re: Active application
- Using VBA to intercept PDF's Save file dialog box
- launch any file type from excel macro
- Hey Frank,info needed
- Removing preceeding spaces
- Conflicting Code?
- Count/Frequency in Pivot Table
- Re: Array Length.
- Re: Array Length.
- DECIMAL PLACES DISPLAYED
- xlLineStyle
- Re: Count/Frequency in Pivot Table
- Re: SpecialCells(xlCellTypeLastCell)
- Enter the same value for a group cells.
- dynamic userforms
- Save Over
- Protect a group of cells
- Re: Is Range Between two Ranges
- Re: SUMPRODUCT using data from multiple worksheets
- SUMPRODUCT using data from multiple worksheets
- Don,Rollin,Tom, and all others...Cud u help me in this (Urgently needed)
- Re: VBA - Printing a frame
- Making Tabs
- Re: msinet.ocx
- Re: Disabling Excel Prompting when it detects a circular reference
- compile error: out of memory
- Re: Check Box weird problem
- Re: Making Tabs
- Command Translator
- Multiple .dbf File Import Help
- Re: Thanks
- Lock userform position
- Sorting the contents of a cell
- gegevens zoeken
- Re: Last Row
- Repetitive task macro
- How certify my xls file
- which command?
- header of portrait page in left margin
- Sorting data using merged cells as keys
- Prolem with recalculation
- Excel XP 2003 changes from Excel 2000
- e-mail range from excel
- Hyperlink
- editing listbox
- Visible Button If.....
- highlight row
- Re: hide rows with any dates
- How to enter data in row in popoulated column
- Re: highlight row
- Re: Disabling Excel Prompting when it detects a circular reference
- pivot table series problems
- List and Sheet Create Macro
- Outlook Signature after Attachment
- Product Catalog
- Product Catalog
- Find & Replace w/ Name Changes
- Re: Creating Formulas That Accept Multiple Ranges
- I only want to grab specific cells
- How to Mute/Enable Windows Sounds whilst running VBA code
- Deleting Columns
- Floating Total row
- Newbie Question - Moving text from one cell to another
- is there such function
- lookup on 2 valus
- Access table exported to Excel does not preserve blank cells
- Getting Excel to not try to coerce numbers to Date
- Run Time Error 1004 Unable to set hidden property
- Find & Replace w/ name change
- Re: Code doesn't go past first IF statement
- Re: run time error 13 type mismatch
- Re: Document properties
- Looking up information
- Re: Document properties
- Copy and paste in VBA
- Split workbook
- getting a range of cells from calculation
- Re: "Loading..." Splash Screen in Excel
- Module to set Page Breaks based on criteria through code
- Conditional Formatting - more than 3?
- Calculating number of items
- Excel 97 error
- Re: "Loading..." Splash Screen in Excel
- Re: "Loading..." Splash Screen in Excel
- onkey help
- Defaulty directory
- calendar
- Using " | " Character
- Clipboard Question
- Displaying Cell Data on a Form
- Accessing Active X command button properties
- Using quotation marks
- worksheet_change event when multiple cells changed (pasted)
- Determine the class of an object
- Urgent Help needed !
- Copy Sheet w/out Formula's, JUST values
- User defined functions - parameter descriptions
- vlookup
- Opening a file
- Macro Help - Suppress warning box
- unlock workbooksin hundred of excel files
- tree view control
- A chart that allows for new data to be entered
- ListBox and arrays
- Exel VBA- userform startup problem
- Re: run time error 13 type mismatch
- Down Arrow
- Font settings in Excel
- Cell Search Function
- vlookup again
- Thanks again,but another query
- AutoFilter & Hidden Rows
- Problem with "On error resume next" with "custom VLookup"
- range that spans two worksheets
- Automatically Run Macro
- Problem with references to OCX control
- onclick event for cell
- Excel Formula Paste
- Excel VBA Problem- Using Find Function
- Combo box copy and paste
- One button - Excel to word?
- Excel function macros
- Can someone help me with this code
- Consolidating cells
- Get filename only
- Empty but persistent toolbar
- Assistant.NewBalloon test
- Excel automation in MFC
- Textbox Properties questions
- Pivot table printing
- Copying hidden rows
- VB password protection??
- eXCEL vbA : Copy n' Paste data and counting
- Problems with vb.veryhidden
- Shared Workbook
- Re: Talking to a Perl script
- Programmatic Access to Visual Basic Project is not Trusted
- CreateObject Question
- Fill sequence down cells
- label with continually updated time
- Re: Save and Close Excel using OnTime
- Reset System Time
- Save data in template from a form. Please Help!
- Out of Memory Message
- Combo Box Data
- SaveFileAs
- Open a connection to dbf file
- Undo row insert from macro
- Select a random value from a column of values
- Solver Record Macro Function
- Pivot Table 2003 refresh Client Saftey Options
- Faster alternative to Dir() ?
- Message--MEMORY COULD NOT BE READ
- V Look Up
- Re: Quick Question on Hyperlinks
- Re: Need help with identifying values and changing formats.
- Do Loops
- SQL Update
- Search Comment Text
- generating a rank order on two variables
- Pivot Table
- Locking a sheet...
- Editting Formulas Using a Macro
- If...Elseif...End If
- MS Query
- formatting function?
- Urgent Macro help needed !
- MS Query Using Vairable From A Cell
- unticking a tick box within a macro
- Share Macro
- Re: combine text and number with preceeding zeroes
- Set Print Area with a macro
- Winzip - Shell Execute
- Help With Forms
- How to permanently delete a custom toolbar
- Protection problem macro
- Copy And Paste From Excel To Word
- Error Message
- Help Needed...
- Help with save as coed
- format variable to 3 decimal
- trying to get column values to line up...
- Combobox
- Cell ForeColor
- importing data
- Redefining Styles
- Inserting blank columns
- countdown
- copy Transpose range data
- C0dŁ !!!!
- Excel 97 error
- E-mail from excel
- Sheet settings
- Move data from on sheet to another based on month
- help with summarizing
- calling macro in excel from VB program
- Delete Entire Row If Column C is Blank
- textbox value validation
- Format function 2000 > 2002
- Network address not Local Address
- Hide a row based on values
- Userform
- Sub to change formulas in a col
- Closest-to function
- How to check if a worksheet exists in worksheet collection
- CopyFromRecordset for Oracle ?
- VBA for the case when web request returns nothing.
- Da xla a xls
- Page totals
- Socket Programming in Excel
- sure but...
- Time function in Excel
- Problem with ADO connection fm VB6 to Excel
- Check file open status
- Getting a macro to perform a function on a certain day every week.
- Problem with Ado connection fm vb6 to xls
- VBA UserForm Question.......Help!
- (de)activating a device
- protecting macro VBA
- Listbox 3
- Saving attributes
- Autofilter a range in a different instance of excel
- Pics
- Program Excel 2000 With Vb.Net
- Creating vectors of numbers
- add an inventory item to a word doc if there is a Y in column C
- Exporting data to new instance of excel - created but not visible?
- Problem after removing digital signature
- Planning system
- Macro with protected cells.
- Macro Help...
- How to load these XLS files
- [Excel][DLL] Writing a DLL custom function for Excel with Delphi
- How to clear all item from a combo box?
- EXCEL-ACCESS DEVELOPER AVAILABE
- Function to convert string
- send to mail recipient
- Cosa ritarda l'avvio di excel (anche di un'ora)?
- Re: Optimization Problem
- cosa blocca avvio excel
- Is Indexing Possible in VBA/Excel?
- A hard DO loop for me
- Pivot table calculation
- Macro to open SaveAs... and change filename to cell value
- Macro to Print All Files in a Folder
- adding reference "can't find project or library"
- Maximize & Minimize where are you ?
- VBA editor hangs when changing font
- excel web query distribution
- returning values from a User Form
- Crreating an Object
- Using Arrays to select Shapes
- taking average of each set of all possible combinations
- User-defined data type; Error: Only User-defined types...
- Help
- Displaying Excel chart in C# application
- How to cycle all possible permutations
- Excel VBA - Add Sheet Change Event at Run Time
- Send values to "calculator" and answer back
- Replacing Tab with commas
- General question: how many controls allowed?
- Copying Rows on Text Colour?
- User form list box refering to another worrkbook
- Re: filtered recodset to pivot table (or not)
- Maximize & Minimize buttons where are they?
- Disable PDF in Excel
- Toggle calculation
- 'go to' macros
- Not recognizing a Const
- Macro problem. Need a vague not absolute reference
- locking use of the file.
- using ADO on an excel spreadsheet
- Excel macros help me ! very very urgent
- Toolbar Buttons (macros) fail after filename change
- ThisWorkbook module question
- Height + Width of a Range
- indirect copy protection of Excel files
- Is it possible to do that using excel formulas ?
- Private forms and sheets
- Re: Running out of memory - changing links and updating Access from xl
- API for TaskBar options
- Button
- Re: Scheduling Worksheet
- Checklist
- Problem with finding dates in Excel Macro
- 'LastRow' Function not working
- unprotect worksheet
- Re: VBA error 1004
- rendering in browser
- Dir() function to return either List of files or folders
- Urgent Macro Help Needed
- Re: VLOOKUP
- Issues with solver
- Userform blinking label
- RE: Set Focus Problem with Multipage Control
- RE: Set Focus Problem with Multipage Control
- Re: Calling procedures in .xla projects
- RE: Macro to lock in 14 views on a worksheet
- Error message:"Compile error modul 1"
- Method SaveAs with no overwrite YesNoCancel dialog
- formula
- A Marco Delete Question
- VLookup pulling data from wrong cell
- Password Macro
- Set Focus Problem for textbox control on multipage control
- file retrieval
- VB macro code for SQL Query
- Named Range
- EXCEL multiple criteria in countif function
- Macro to match output from 2 columns...
- Date question
- Something Very Strange, possibly a Flaw?
- Cell selection in non-active sheet
- Excel on the web
- Protect charts AND allow to copy them?
- One button to open and re-select
- Open sheet once 1st time xl is open
- use vb to delete marked rows
- Different Solvers.xla in Office 2000
- Re: Can't find links button to place it on toolbar
- formatting function?!
- Adding and subtrating from rates.
- vlookup function
- Urgent problem saving a file read only
- xl97/xl2k events in pivottables
- Excel user-defined Function: definition/help of arguments
- Removing rows featuring certain words
- How hide cells when print out?
- Error 1004 HELP
- Finding cell that a user click?
- autosave add-in settings
- Excel sheet......help.
- Excel sheet ...... help.
- Convert from seconds to mm:ss within a cell
- onClick action from cell selection
- Displaying a picture
- Problem with IE menus after installing excel macros
- Protecting different ranges with different passwords
- How to add a PivotItem ?
- MS Access Database Connection problem in Excel XP 2002
- Reference multiple Instances of Excel
- *.gif images
- workbook to be protected
- Pivot Table
- Fastest way for comparing columns?
- Workbook Properties
- Reset userform
- How to Close the entire Excel File
- Opening a file using VBA
- Help Required By Relative Newcomer
- attributes for MsgBox & InputBox objects in VB ?
- Eenie meenie minee......
- Change CommandButton Caption
- How to copy a range to a closed workbook
- Communicating down RS232
- Auto insertion of date and time
- combobox missing between excel 2000 and xp
- switched date format opening dbf file
- GetOpenFileName with network
- digitise graphical information
- chr(32) vs chr(160) ??
- Excel equivalent to Word Variable
- RE: Help with forecasting future values based on a current value?
- External Data Source Questions
- Excel XP
- Help: Election 2004 Project -- iterative operations
- matching numbers with images?
- Finish one section of code before continuing
- Program no longer work on Excel 2003
- Re: VBA error 1004
- Re: checkbox hell
- Re: checkbox hell
- Calling workbooks with apostrophes in name?
- Excel VBA - Search record with multiple criteria
- Avoid to reopen a working Workbook
- Re: Trying to add a Pie Chart
- decimal places in currency
- Custom function does not work from an addin
- numbering items in a column based on a condition
- Adding text to first empy cell in column A
- simple macro
- Simple macro help
- Re: Automatically applying a macro to many workbooks
- lost Courier New font in the VBE but it's in my machine
- Re: VBAProject Scope
- Re: VBAProject scope
- Re: VBAProject Scope
- Format Vlookup column with Text
- VBAProject scope
- Conditional move rows to another sheet
- Protecting buttons with VB code rather than protecting sheets/books?
- Re: Write Command Output
- Re: Write Command Output
- Excel VBA Macro
- Autofilter
- Memory per Sheet
- If open, go to, else open
- Re: User Defined Type
- Chart Name
- Re: Displaying Web Page
- Re: Displaying Web Page
- Re: Inserting a filename into a cell
- Autocomplete in VBA turned off
- How to call out object's text w/o selecting
- What Key
- suming across sheets
- Trying to save a worksheet
- conditional formatting
- Re: Visual Studio Tools for Excel problem
- Application Level Events Question
- Repost with code - Runtime error '1004'
- Reformatting a cell using VBA
- Run-time error '1004'
- Comparing a range with text
- Emails data from each row in a sheet
- Pivot Table
- Animation
- Selecting ranges to copying and Paste
- How do you automatically update criteria in MS Query
- Alternate Worksheet printing
- IsEmpty and bookmark help with excel 97 and word 97
- UserForm
- Re: Range("F83").FormulaArray
- setting a command button to be a hyperlink
- Rounding up decimals
- Do you want to replace existing file?
- Copy/Paste From Excel To Word Macro
- Combo Box
- Conditional Formatting on Time
- What workbook is calling the function
- Public Const on a Drive
- Protect file on a shared Network drive
- Transfer value to cell
- how to delete rows that show no value but contain formulas
- Excel VBA not counting colored cells
- Problem with Excel using a .Net rich text box
- Message with RoutingSlip
- Create New Worksheets in VB
- Input data from one worksheet to another
- Formats many sheets
- Using macros to cut & paste rows to a new worksheet
- Copy error with Autofilter
- Force minimum text box entry
- Visual Studio - Office 2003
- How to overide spell check blocking in protected sheet
- Keeping track of Global variables
- Totals
- Dates in TextBoxes
- Locking range for view of Excel Sheet on button click
- Opening Notepad from Code
- Hide Rows and Columns
- Excel
- opening file with worksheetfunction
- Help Delete Rows based on the macro in this message
- message box pop up for a given value in a cell
- Why is my Workbook Open procedure not working
- how to extract the row number of a cell with certain value
- Rename file
- Application.Inputbox acting strangely
- Paste to Multiple Selections
- Deleting a Menu Bar
- For Each - Range Cell
- COM Addin in C#
- How to make a spreadsheet as popup?
- CAE macro for green screen updates with Excel data
- Large file size problem...
- Tabs in Excel Spreadsheet
- Re: filtered recodset to pivot table (or not)
- Re: Data Interpolation
- Expand Range
- detect empty cell
- Placing a Form with multi-tables into Excel
- ExcelApplication
- Update Dates
- Excel 2002 Macro to Execute SQL Statement
- Excel Marcos
- Using Sheet names in formulas
- Finding Folders
- Re: Running MS Queries
- VBA Project Password
- Tool tip for controls
- How To....
- All Caps
- FieldInfo
- Re: Why I got this 1004 runtime error
- Using Columns().Row() To create a range
- Copy method of chart class failed
- (Urgent) If col D= value, avg col G
- Escape On Error methods in Subs
- Create subfolders in a folder
- convert excel worksheet to binary array
- Checking if a worksheet already exists...
- Auto unique numbering
- start a macro everytime excel opens
- Re: Trigger Event - Frank Stone
- Macro works in 2003, not in '97
- Macro within Macro
- Can't get FindNext after deleting row?
- Search/Find in any worksheet
- Deleting workbook
- VBA - Status Window?
- Runtime Error 424
- Re: Checking entire row for duplicates
- ColumnWidth
- Using SELECT...CASE with comparison operators?
- Excel 2003 Additional Workbooks After Excel Crash
- Re: setting chart axes
- Open Unique excel.exe
- Re: Checking entire row for duplicates
- Display a range fullscreen
- Re: Inserting Formula
- Trigger Event
- [UserForm]: *.gif
- Tutorials?
- Getting data from several worsheet/books
- Key Identifier for Sheets?
- Initializing a Form with multiple forms embedded
- Whats wrong?
- Updating of one file and prograte to others files
- Calling to a specific cell
- Re: adding Activex control through code works BUT... Cannot access ob
- Open then Close
- Comparing Two Cells in Excel
- when would you use "new workbook"
- Re: Deleting workbook
- ListBox.ColumnHeads Property
- Macro crashes excell from remote location
- password protect
- Excel VBA - How do I programmatically change source code in another file?
- Renaming Files: Take 2
- comparing values in excel with vb6
- Error
- Re: Createobject (repost)
- Re: Jim Rech's Browse for Folder
- Calculations in a pivot table data set
- Traversing two named rages of unequal length
- Project Name vs. Workbook Name
- Outlining works in XP not in 2000
- save as...
- Renaming VB Form Causes Macro Corruption
- Protecting an Excel Sheet name from being changed
- Difference b/w 2 worksheet
- Cell contents in Excel??
- Array formula with =sum
- Iterative Macro
- VBA Auto Cell Formatting Uppercase
- Copy image of UserForm to a clipboard
- VBA
- creating Databases and tables
- Percentage code
- Combobox Value
- Improvement to sub: Detect data extent and convert to values
- creat and transfer data sheet1 to sheet2
- Can not open excel workbooks from the file manager
- Importing cell info from closed workbooks into new spreadsheet
- right click menu reset?
- setting chart axes
- Using macro to add data in specific cell within a table
- FAO : Bob Flannagan
- Lookup / Vlookup ??
- Calculations in a pivot table data set
- Calculations in a pivot table data set
- using one macro to set a variable in another
- Save .txt file as .xls format - HOW??
- block scrolling
- check if worksheet is protected using code
- excel vba.........
- Returning Dates - Lead Times
- Returning Dates - Lead Times
- VBA to copy
- Macro to sort Worksheets
- Newbie Question: Returning the value from a cell on another sheet
- Filesearch with disregard of Case
- Starting with command
- Ask for help of Excel
- Super Easy Question -- "
- ActiveX Property Pages are not visible
- Property Pages from my ActiveX are not visible
- Increment array for debits and credits
- Coluring cells in a Range
- VBA - Drop down; list range
- Option Button Macro (Forms Toolbar)
- Moving Cursor once set number of characters are entered.
- Trying DROP TABLE in SQL from Excel
- Hyperlink
- Shrink Formula
- Pasting formulas without copying file ref.
- Color constants in VBA
- Help Me!!. can not set the string with len more than 255 character to the value cell
- Retain, restore selection?
- Question on Custom Sum Function
- loop
- 16 digit Credit Card #
- new to excel help me
- Re: Pivot Tables: counting columns and matching
- Range question in VB
- Find & Replace Macro from external spreadsheet/db?
- How to verify a cell is in a named range
- Error in code opening Outlook
- Deleting new control button on auto_close??
- counting device
- Loop expression to calculate return
- Naming a range versus formula in Excel
- Running a Command Button from a different sheet
- calculations in large data set and in pivot table
- Calling a sub with a variable...
- Swtiching the focus of Textboxes
- Workbook Open
- Database Query
- Re: minimum scale error code
- Rename Files
- Populating a cell with numbers without numbers being formula-based??
- Please help with vba code question
- Hiding the sheets my macro works with...
- Open pdf without converting
- Re: I want a msgbox when the contents of cell change
- How do I set a default path when using Application.GetOpenFilename
- Copy data from an external application into Excel
- Column question
- Internet printing problem using hyperlink from worksheet
- Wild Ideas
- How to check for password in an excel file.
- Why this 1004 Error message?
- Null?
- Data Validation
- Text Files
- Merging part of one field with another field
- Re: where is my record button?
- How do I add a Password?
- Modifying text files with VBA?
- converting architectural units
- Re: Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor???
- Totals
- Re: Click event unhiding sheet
- How do I set a default path when using Application.GetOpenFilename
- Office/Excel 2003 - Stop toolbars automatically opening
- Stacked Column VBA
- Numbers
- Re: Creating a custom toolbar in VBA
- Searching with Macros
- Excel VBA from Excel 97 to Excel 2000 errors
- Re: Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor???
- Testing for content in Range
- Dynamic range
- run time error 13
- Count Pages
- Netsend or another type command
- To: Bob Phillips
- Bold certain text in textbox
- Inserting a line....
- Excel Macro - Save Function Problem
- Sending multiple emails using SendMail
- =sum formula using arrays
- VBE Custom menuitem not calling OnAction macro
- Control Toolbox
- Formula to name tabs in excel worksheet
- Re: rounding a formula in a cell, then replace the formula
- Global vars
- Re: rounding a formula in a cell, then replace the formula
- Creating Buttons and assigning code
- Re: Selecting a Range inside a range
- labels, comboboxes, etc
- Non-contiguous selection
- DragAndDrop_event doesn't exist - any substitute?
- Looping through to stop on pie charts
- Compare Current Date
- Yes No dropdown box
- Delete duplicate cells
- Connection to notes
- Avoid user to access first two rows in a sheet
- Relative path
- Altering Textbox Colour
- Can anybody help please? Urgent
- Active Workbook Properties - comments
- Forms and sheetranges
- To: Dave Peterson
- Hosting XLS files within IE 6
- Re: Delete Duplicate Records
- Copy From Recordset
- Reference to a variable in windows(???).Activate
- Creating a worksheet with values based on a control cell
- How to make Excel feel switching application?
- change all instances of Queensland to QLD
- Variable Value
- Events and values and Ranges
- Re: Where do macros go?
- Error 1004 - Out of Memory
- Error 1004 - Out of Memory
- Auto refresh and DDE update is not work when running macro
- Is worksheet protected?
- Excel Vba - Comparing 2 ranges of data and displaying result in another worksheet
- Header & Footer
- Re: Comparing rows of data in two worksheets
- Format of textbox on userform and correct result
- Using solver in macros - Help
- A simple question -- Evaluate()
- Re: Importing a text file using ftp
- Look for numbers in a cell
- Unable to add user-defined data types to a collection
- Data transfer macro
- Range and Cells
- Re: ? about the VBA code
- Re: "AND" statments in Excell 2000
- FileServer with GetOpenFilename
- Auto_Open and Workbook_Open
- Re: "AND" statments in Excell 2000
- Excel2000: How to copy data validation using VBA
- Re: OnAction menu item property coding
- Help Me! Exporting Excel 97 to Excel 2000/2002
- Calling macros from a VB app
- Exporting Excel 97 to Excel 2000/2002
- Re: PSW for Macro & Codes
- Spaces in sheet names
- keeping buttons from moving
- Hard Return in large textbox
- formulas in code error
- Re: page setup via code
- How do I Insert a row that includes copied formulas
- Color Code Duplicates
- Can I automatically populate my dropdown with all available macros
- Browse for folder
- Can I automatically populate my dropdown with all available macros
- Reading the contents of an inserted picture
- Paris Hilton has an Excel question
- Copying Macro to Several Workbooks Fast
- Remove all Listbox items
- selecting a row by header row in VBA
- Clear a textbox
- dates
- Newbie Post - Clear All Button
- Re: How To: Page Fields
- Automation COM Addin with Excel
- bizarre "invalid procedure call" error
- Index or Match?
- Re: Digital Signature issue in Excel files
- How to access Excel-Sheets from outside Excel ?
- Excel97 (w/ VBA) Template won't open in Excel2003
- Dropdown box of macros
- Function unable to return Collection object
- Re: Activating Worksheets and Importing Data from them
- Find
- True/False Checkboxes
- Applicaition Default File Path
- Embedding of graphs/charts in forms possible?
- Print to .csv file
- Help with creating Excel Macro
- How do I find out my row number
- Macro won't execute when "For Each 'range' in 'range'" is added
- Probelme with coding...
- sql querries
- Changing range name in loop
- Searching for specific text
- Controlling java applet
- Deleting entire rows based on certain criteria
- Compile Error
- Returning From VBA Event Code Called From Excel 4.0 Macro
- Re: Run-time Error '1004' Unable to get the findnext property...
- Re: OPEN WORKBOOK WHEN EXCEL OPENS
- Opening File Browser
- Error Checking Option
- Certificate Problem need solution
- Automatically print in Excel
- Excel 2003 / IE 6 bug closing workbook
- excel to powerpoint via macro
- VBA ?
- Need help with creating a special copy and paste macro
- Display set range
- Doing it's own thing - Jim R - Check here
- disable mulitple select on pivot page field
- Override error code 214154 - max embedding
- sql querries
- Building COM Add-in in XL2003
- Docking windows in the IDE
- Re: Disable Format Painter?
- Date/Time Picker Event Won't Fire
- Printer Dialog Box
- Save= False Question
- Zip workbook
- Excel Crashes When Copying Multiple Sheets in VBA
- Counting a range of cells based on 2 dates?
- Sum depending on cell background color
- Links from Word no longer updating
- Searching within excel
- Apllication.OnTime
- #NUM!
- Change and update contents of a dropdown combo ....
- Integration between VB and Excel
- Searching a column
- Find & replace with VBA
- Protecting VBA Project
- what is wrong with creating pivottable ?
- Deleting rows based on multiple criteria
- Excel200: Strange behaviour for Name when referred from VBA
- How to define a Range with variant?
- Protect/Unprotect function options
- UNDO in EXCEL97 macro
- Sheets Name into array for form dropdown
- Row Height for merged cells
- Macro to create worksheets base on name
- Dates
- creating a routine to help memorize
- Repost: ListBox Headings - customized! Class Module (warning: long post)"
- Analysis Services accelerator for Excel deployment
- Extra rows in csv file
- Multiple ComboBox Lists
- importing data from multiple excel spreadsheets
- From Excel to VBA and back?
- InputBox: Display Cell Content not Cell Ref ?
- Followhyperlink - How do I disable IE launch?
- An advanced email question.
- ADO & CopyFromRecordset performance
- Error handling
- save into file while user is entering values in cell
- Updating Access Database from Excel need help
- FORMATTING CELL CONTENT !
- Auto_Open and Workbook_Open in Addins
- Automatic Updating
- Macro link issue when saving as new filename.
- How do I solve this (Part II)
- Word Control in Excel
- Inserting Picture from Camera
- Capture Custom View in a Variable
- Attaching Custom Menus
- SaveAs works on one PC, not another. "Save" not really an option. What to do?
- Listbox 2
- #N/A
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.