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 |
- module and vba?
- Add-in name capitalization?
- Disabling Auto_Open in distributed worksheet
- assign dataset to matching dataset
- Macro to concatenate multiple rows in a column, without selecting each group manually
- Lookup Value in Range/Array and Return Column Header Value
- msgBox
- Count & List Combinations
- Follow hyperlink but don't update links....is it possible ?
- Lotus Notes Task
- Formatting multi-line text
- Find and Paste Program
- Referring to cells
- Variably Hiding Cells
- macro which works in excel 2000 does not work in excel 2002
- making charts with vb 6.3
- Runtime error 91
- Extracting specific data from one column to another column
- comboBox properties
- After adding a new sheet, wanting to compare cell values
- Advance filter question
- Use String from another module
- Clean Exit from InputBox
- looping when checking isdate
- How to create chart using VB 6.0
- A fast way to fill cells in Excel
- variables
- Last Selected Cell
- Popup box to enter VLOOKUP value
- Re:Final days - London Excel Conference Registration giveaway
- How to path to user's desktop
- Place a User Form on Start Up
- IsDate
- Internet Navigation
- formatting input boxes
- Incorporating VB6 RichText control into Excel VBA
- Close user form when button is pressed
- Open 'n' Hide
- Re: Change colour of cell depending on content
- Re: Change colour of cell depending on content
- Read from text field
- Checking data in each cells of an array
- Change colour of cell depending on content
- show info when workbook opens
- Force macro on save
- How to check for Internet connection
- How to open .xlt containing PivotTable?
- need help using send keys
- Link to external file
- export file to excel
- define unique Advancefiltered range
- Hi All,
- Selfcert and Network
- Index number for CommandBar right-click on sheet tab?
- Using Controls on a Worksheet
- Split a string
- creation of name range without selection of cells
- Splitting a workbook
- Excel, reference a cell for parameter in SQL to import data
- Finding a value and going to that cell?
- Help! Security when using a VBA macro to access an Excel File
- Copy worksheet, rename, merged cell problem??
- How do I get a Function to return Null?
- Make Excel allow numeric fields as text
- need a formula to work out how much ......
- data import question
- Change from Column Selection to Cell Selection
- Can I Select an "Import" Template Based on a Doc's Filename?
- Simple worksheet selection question???
- Custom View Macros
- On Change Event
- Border question
- Disapearing formulas
- Additional Controls disabled
- Re: Shapes
- roster - printing out who is on
- Newbie Run Time Error
- on error
- VBA created in excel2003 doesn't work in 2000
- Multiple Cells
- Word wrap issue
- Using the ActiveCell function on 2 different worksheets
- Problems with Transposing. HELP!
- Max length for a menu command name
- Paste link With Worksheet that has password
- Combining R1C1 and absolute reference in SUMPRODUCT in VBA
- quit on error
- Multi Listboxes with data dependent upon user choices
- good gotos and bad gotos
- Empty cell instead of 0
- Event: Workbook_Change or Worksheet_Change
- What's the secret on scroll bars in textbox
- Setting an array range of cells???
- Tough - show a hierarchy
- Merge Cells in VBA
- Page Breaks Macro
- Trouble opening PC version of Workbook on MAC
- SELECTIVE DELETE
- Change Cell Background color Automatically
- Create a workbook with only 1 sheet
- Macro concatenate formula
- Baseball Combinations
- VBA - Multiple Array-Enter Command
- Sending email with selection of data from spreadsheet
- How to create a button to switch to a custom view
- How do I identify a range based on cell value?
- Re: matching values
- How to create a view option (or hide/unhide preselected cells) (Repost from Misc)
- How to read filesystem shortcut attributes
- How to cause a #num! error
- Prorated Average
- Ændre dato (tal) 20060615 til dato
- invoice template?
- Jump to "Defined name" range!
- Commas appear when typing
- Specify which sheet to paste to
- RE: Specify which sheet to paste to
- FORMULA FOR EXPERT, PLS MAKE THIS WORK
- Mulitple Entries in InputBox
- REPOST: VBA Acessing Member Variable in C# Com AddIn
- RE: FORMULA FOR EXPERT, PLS MAKE THIS WORK
- RE: Specify which sheet to paste to
- sort multiple columns of data but not change the data location... Possible?
- errors in emailing Excel
- Help with VBA export of cells to PowerPoint
- ChDir statement
- Hourly Macro Help
- Help!
- Margins in form items
- How do I get data validation message to appear using a macro?
- Retrieving Data from Multiple WorkBooks
- Query PVCS
- Run-time error 1004: Too many different cell formats
- Transform text in date format
- Buttons
- Query Refresh without filename prompt
- Subroutine calls between workbooks and object references
- Connecting button to macro
- Pause Code Execution
- Canceling a read file function
- how to set the value of a cell from another cell
- Excel macros for interprocess communication
- automating a process in pivot tables
- Excel Worksheet Delete "Data may exist"
- Adding two cells together
- How do I colour ill a cell in excel with a formula?
- Returning a value from a form
- VBA/SQL Question
- More Selecting and Deleting
- User form/Modul
- Managing Filtered Items
- Userlogin for excel speadsheet
- VBA Acessing Member Variable in C# Com AddIn
- Color Problems
- List of macro shortcut keys
- Using sheet name of workbooks
- 3rd stupid question from newbie - autoloading userform
- cell not changing
- pasting info from workbook to sheet in another workbook
- Format Page set up for all tabs in workbook
- Macro for Trimming
- Cell Deleting and Shifting
- VLOOKUP Formula from one cell to 2nd cell
- Naming worksheets in loop
- hide and unhide rows
- Display button
- Sheets reference change variable
- Checking if Validation exists in the cell
- pasting form 1 sheet to another
- Checking format on input
- Sum in vba only works for multiple values not for single values??
- Loops and Events
- Merged cells
- code for print dialogue
- how to see only youre userforms??
- code to unprotect sheet with password
- Import a CodeModule then call its method in Workbook_Open()
- Main first
- VNC and Excel
- Find + remove blanks if cell contains only numbers
- Pre-Open VBA
- SaveAs
- how to bypass password??
- Get data from Excel-cell and check format
- Rolling credits list
- Clear contents
- Insert blank cell and labelling if difference in comparsion
- Search for blanks
- Search and replace blanks
- Charts
- Delete Pivot table
- executing database
- How to link a form to a sheet in excel
- Conditional deletion of rows
- Replace Function using Wildcards
- Opening a file via VBA
- filling userform listbox
- Excel Menu Bar
- List of Different Cells
- Re: excel question
- Re: matching values
- ?????.Auto_Open ???
- Re: Clean up and Fix Two Macros
- Re: matching values
- Extracting data from 1 file to multiple files
- excel merging?
- Save Status Bar Disappers after running macro
- Changing cell colour depending on content??
- Text Box in Chart
- how do i use vba to zip folders?
- Application.FileDialog(msoFileDialogOpen) and error 75
- Print even & odd pages with different margins
- Dynamic Name Labels
- Worksheet Navigation Help
- Excel VBA Macro stops running when another program is activated
- Disable Link Alert
- Leftover Workbooks Named "Object" When Opening Excel In IE
- SQL? Index? Excel?
- use mouseclick to dynamically change chart series? Chart_beforeDoubleClick?
- DateTime picker control
- Please Help :)
- Another stupid newbie question.
- Formula appears as =RC[-3]+RC[-1] Whats this?
- Document security question
- Basic Compile Problem
- 20 Procedures one Command button
- If cell contains text, leave as is
- Find macro with wildcard as part of code
- If Statement
- run a macro when cell value changes
- Controlling switching to other sheets
- Execute macro many times??
- Working with Workbook array
- How to find the Dimensions of a Variant Range
- Copy Entire Row
- Hidden Text Boxes In Spreadsheets
- Display of Comments on Excel file saved as .mht
- spinbutton In Form
- Strange Request
- Add 1 to a number each time you print
- Having a floating row or hiding unused rows?
- Hide Printing Dialog
- SUMIF with Mulitple Conditions
- xlDown stops at next empty cell, not at last row of data
- Find/REplace from table questions...
- delete images in an excel sheet
- Rename with more than 31 chars an Excel sheet
- Display Value in 'Currency Format'
- Input Box and Message box Help
- Find and Replace within workbook - from Visual basic
- Running macro on open of workbook?
- need to seperate one cell's formula by delimiters
- Change Text Color When?
- Help: Excel Macro window run button disabled for all code in 1 module?
- Excel, OLEDB and uppercase problem.
- Printing all from drop down box
- Using Checkboxes to enable/disable vb
- Help function
- SUMPRODUCT USING <>
- slow processing with .find
- Formatting Text by when last modified
- Searching for a Partial Filename
- Copy contents of textBox to Cell in Excel
- Duplicated form at runtime
- search function without error if not found
- for..next statement problem
- substitute chatracters within a cell
- formula or VBA - would like to autofill cells based on start date and # of months
- Saving an Excel file & overwrite (C++)
- Newbie-question: recorded macro does not work - why?
- SUMIF
- Exclude first charachter
- Auto delete rows within a specified range
- Placing Data in a Range
- Save Single Worksheet
- Corporate Error Reporting with DW.exe
- How to disable all Excel Events and then re-activate them?
- macros in network restriction
- Looping
- MSFlexGrid to display Excel data on VBA form
- Hide and unhide rows for multiple areas
- Special Cell Selection
- create macro - delete all rows with zero in column L
- Creating a graph with existing data...clear data after save
- Cell address
- no builtin chart options for me..(Excel 2000)!!
- macros using find/replace
- is there a way to connect excel to a pop3 server?
- Difficult macros
- hide and unhide rows
- Import a external data
- Pivot Chart Problem
- advanced filter and format
- Userform Combo box list
- pop up box, searching worksheets and running macros help please
- Creating cub file using VBA
- find values and identifying cell-adress
- Passing values
- Data program
- Extracting Data - Open vs Closed
- import and export from SQL SERVER to Excel
- student's t table
- Importing libraries explicitly in macro code
- Dynamically change accumulation links when adding worksheets
- Destinct records macro
- VBA - If / And Statements
- Excel filter does not working anymore
- removing commas in csv
- autosave on changing worksheet
- Copy part of worksheet in VBA
- xlb as Addin ?
- Filtered Array for Listbox
- Save one sheet as .csv with macro
- Goto a named range using the contents of the active cell
- Accessing a 'column' in a VB array
- Using SocketWrench
- Undeclared variables allowed in a Module defined with Option Expli
- Macro and automatic update
- List box deselect
- Dynamic Headers via VBA - Probably Simple Answer?????
- macro to search for & select ranges to sum
- Data Validation
- Password on VBA causing problem
- Detecting Double Entries
- embed?
- double freeze pane
- Extract Date (04/05/06) into Text (040506)
- I would like to get a time stamp that does NOT update upon recalc
- Floating Command button
- how to format a label to 2 decimal places
- How to open a spreadsheet and make changes to it from code?
- Paste Special
- COM add-in doesn't work
- Pull mutil values from one LOOKUP formula
- REPOST: Calling Excel Automation Add-In in VBA
- Now I want the opposite
- Using COUNT value as variable
- How to perisist object in Excel
- Background color change
- Using Excel to generate an Outlook Calendar Event
- Protect formula without protecting the worksheet
- multiplication
- Date and Time
- macro to show list of worksheets in a workbook
- Hide row if date "A" is later than date "B"
- Deleting blank cells in a column
- Initiate Macro On Save
- Convert numbers to text
- Calling Excel Automation Add-In in VBA
- REPOST: Automating series generation for scatter plots
- Multiple Criteria
- Retreiving list of table & field names from Access into Excel using VBA
- Multiple Prompts
- Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist
- list all the find values
- keep track of previous excel range value after dragdropped...
- Calling Excel Automation Add-In in VBA
- Adding sheets and copying data problem
- Locking Cells from list
- cell with highest value g5 would be upto 80=1,81:160=1.5,
- vba encryption
- Referencing cell in Named Range in Function VS Formula
- unhide rows when cell is clicked
- Suppress workbook display
- Specific Cell Selecting
- Using Macro to copy latest data from one Workbook to another
- Conditional Formula
- Dynamic Headers via VBA - Probably Simple Answer?????
- Checkboxes
- Change Application Security Settings
- Inserting A row & page break
- In VBA, possible ot subtotal without selecting?
- Conditional Formula
- User defined functions without using VBA.
- AutoFill a formula down a column
- Copy Unknown Number of Sheets
- Auto "Save As" Cell value when data entered in cell
- Save WB from reference found in cell D1 to specific folder
- Selecting a Pattern of Rows
- Is there a way to setup Worksheet Tab Descriptions based on cell i
- Passing arguments to userforms
- Iteration Calculations between sheets
- When will bug 919127 be fixed???????
- lookup
- Multiple Links from drop down box
- E-Mail as Hyperlink
- PageBreak in VBA???
- VBA Loop Formatting Text Question
- Macro Question
- cell.replace strange behaviour
- Subscript out of range error - save copy error
- Subscript out of range error - save copy error
- Workbook_BeforeClose
- calling a userform
- Get FileSummaryInfo for files saved on Intranet
- select range between two empty cells?
- Why do add-ins reference specific path
- importing text from bookmark in Word to excel
- Excel Automatino/COM Add-In Question
- Resizing Pivot table column
- Deleting automatic page breaks in excel 2003
- How can I use VB code to execute macro when double-clicking cell?
- Excel Sheet.Copy Method (Excel 2003 SP2 )
- Delete a Column Based on User Entry
- still saving a record to excel even if i press the NO button
- 2 questions about developing.
- Save macro Truncating text
- Can anybody help me please?
- Can anybody help me please?
- Reading Row headers into a listbox
- Filter problems
- Filter problems
- Filter problems
- Timer
- Put 1D array into column
- Seclect Column or Range according to Cell's Contents
- VBA automatically change text format into general format?
- Query parameters
- London Excel Conference Registration giveaway
- EXCEPTIONALLY SLOW LOOP ....help!!!
- Putting the document number custom property in workbook
- Cannot Shift Objects off Sheet....?
- search worksheet
- Speeding up Array
- Read/Write from/to a closed workbook
- Query - Data Layout
- Message Box Help
- How to pass variable between closed workbook
- How to pass variable between different variable
- Average a range within an array
- Delete Unwanted Rows (Help with Range)
- Pagebreak and Zoom problem
- "" does not return blanck
- Problem in linking
- Using Range & Cell
- modeless
- do while loop
- Filter is not working anymore.
- Paste Values
- How do i parse a text string with a date?
- Name Manager: new version released
- creating form on worksheet
- Lock Cells with Specify Range If Cells contains value
- Summarise Worksheet Data
- making cells change relative to each other, cant figure out
- Summarising Worksheet Data
- Run Macro after update
- Refer to sheet2 - even when named
- Change delimiter in import function from comma to tab
- PIVOT TABLE DATE GROUPING
- Macro to add count forumla with dynamic range
- How to program keystrokes other than CTRL+something?
- How can I search in this forum?
- pasting into a list using a macro
- Delete selected sheet
- Custom button :Copy data to new workbook
- copy and paste from one sheet to another with VBA
- Runtime Error 9
- No sure why this isn't working
- vba select from Active Directory (LDAP)
- using variables to reference sheets
- Too many gotoos?
- Find out if a Value is Contained in a cell
- Problem deleting rows by index
- Need Help w/ Search or Find Macro
- Date from a cell........
- huge problem!!!
- Trapping error from Empty Dynamic Named Range
- I need more help with Absolute Reference
- Cell Colors Dependant on Date
- MSAccess 2000 Newbie Question...
- macro I shared isn't available in any other workbooks?
- Macro to replace error values
- data capture from screen
- sort grouped cells
- PageSetup.set_PrintQuality .NET method
- VBA - Strange behavior
- VBA Error Handler
- Formulas not working once macro is used
- Formulas not working once macro is used
- Stupid question from newbie re: data from multicolumn combobox
- selective protection
- WorkBook Activate event not working
- Macro to find columns to hide
- Gathering Data
- Case Statement - help required
- Set a range for all worksheets in workbook??
- Web service to Pivot table
- VLOOKUP in VBA
- Word crashed after repeated XL macro use
- Variable Range/chart
- Update Values Dialog
- "Too many diggerent formats"
- Duplicate prevention from Listbox selections to worksheet
- For Each Array Question
- excel help
- Save Userform as bitmap
- add row to the end of a list and data change
- modifying formula reference
- V Lookup Problem
- FAO Mat P:son
- Which sheet gets calculated first for iterations?
- comparing rows
- Macro to copy Column 1 of all sheets to a seperate sheet.
- Opening Multiple Sessions of Excel
- HELP! Conditional Formatting
- Date in VBA
- Sorting information
- Page# Return off lookup
- Opening the Autofilter dialog box
- Automate cell selection
- Re: Date Picker - "Linked Cell" Property
- Date Picker - "Linked Cell" Property
- Newbie question
- If cell is empty then run macro otherwise skip this macro
- Time range to workdays in relevant months
- Cell addressing
- Copy and Paste select data to another workbook.
- use of PROPER function in Macros
- Problem with macro for importing data to template
- Macro Opening or Looking for Another Workbook
- Reg : GUI
- formula for finding Friday
- Add value to cell...
- Is there an "OnOpen" event for Excel
- Macro for Row Processing
- Update Sheet1
- Creating User Friendly Templates
- Formatting Excel charts created with VBA
- Error 1004: Application Defined or object defined error
- Print multiple reports from list validation
- VB & autotext
- I need a QueryTable.Refresh solution
- Making Excel 2003 as the Default over Excel 2007
- In SelectionChange Make Last Rwo Dynamic
- Collect used areas of multiple spreadsheets into one...
- Modifying .txt file using Excel VBA
- RTD formula
- what went wrong?!
- Delete Rows
- Re: Sell Program - Screwed by Managers !!!
- Countif result in message box
- How to diasble save and save as menu but allow a save button
- Option Button Grouped
- Remove Chart Label with Percentage 0.
- Hide whole row when cel C3 is 0 (zero)
- Select.Range
- Read data
- Web Query
- MACRO HELP
- Number stored as text. How do I keep the number format?
- Locate and Format Row Macro
- Last week for regular registration - London Excel User Conference - July 19-21
- How Do I Modify Pearson's Code to Add "Treat Consecutive Delimiters As One"?
- Scheduling Worksheet
- fill blank cell with cell above: special case
- Programmer to hire
- Looping to update another sheet
- Command Button on worksheet
- how to select a shape
- Macro for sorting within groups
- Having problems with quotation marks
- text in ***
- Need Help Importing Text File Using Two or More Spaces as the Delimiter
- Help with Object Design
- excel close + save by button press. how?
- ActiveWindow VBA problem
- Running two arguments within same code
- Sort out data on seperate sheet
- printing special numbers!
- Last Column to first Column
- Need emplyee time card app, daily in/out, excel vba based.
- Fill FAX template in Word from Excel VBA
- Self-Contained "Database" file?
- Program to resave a collection of .xls files into tab separated .txt files
- Alignment of Graphs
- Error in code
- .xls values, like .pdf
- selecting a column
- Questions: Copy ranges, autofilter macro, subtotals, & naming shee
- Translating numbers into number with color pattern
- Read value from combobox (cleaned off duplications)
- variant to long?
- Add new sheets with code
- rng, varinant to long and offset questions?
- Delete all rows not today
- Trouble with this code
- Find last row through a macro
- user-level access to pivot table
- Upper-case all text in Excel 2003 spreadsheet
- Copying worksheet to new file by macro
- Creating an image file
- Workbook open event
- Problem with file finding macro
- Case Satement
- VBA programming certification
- How can I select a range of cells for header?
- Changing cell color if date is...
- Determining What FormatCondition Has Been Chosen
- Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row
- Embeded Wav
- Map/List of folders, subfolders & files
- "Force" user to save file with specific name
- CommandText
- Suming a column to another worksheet
- Bringing up sort command
- listbox to cells??
- Force user to save file with specified filename
- I need help with a (apparently) very simple VBA script
- Clear cells in Column D if not = Auto
- Determining if data is sorted in descending order
- Send email based on date value
- Orderly Validation Against Separate Ranges
- Help Template & Database
- Setting Timers in Exce.
- Shortcut Key
- Populate First Empty Cell In each Row with Text
- Excel crashes everytime I send focus from control to worksheet
- Excel sheet analyzer/generator
- Macro to Paste Items to All but Several Workshets
- Code deleting all rows in error
- Format prompt in VB InputBox
- Extracting data from some files in folder
- Simple iteration problem
- DATE & MONTH minus ?
- Need help with grouped counts
- Identify an add-in file that is not installed
- How Do I "Toolbar List"
- code dropping zeros in number strand
- How Do I "Toolbar List"
- move to new column after ,
- Syntax error in code
- CopyFromRecordset will fail if the recordset array data such as hierarchical recordsets ???
- Problem with Date Conversion Code
- extract data from pivot via vba (Getpivot is not convenient)
- Copy and paste data from one sheet to another in a single workbook
- Disable all "Refresh Data on File open"
- Add-ins passwords
- Delete entire rows where there is a blank in column A
- VLOOKUP with multiple criteria
- SUMPRODUCT - small correction required
- VBA replaced ?
- Filling out usernames in IE
- Help with Creating Email
- What in the world is it doing??
- Public function in Personal.xls
- MACRO HELP PLEASE
- Macro help please........
- Speed VBA Excel 2003 vs 2007
- Change color of text segment in msgbox
- How to save a file
- Sell Program - Screwed by Managers !!!
- Excel 2007 Beta
- getting info from multiple workbooks simultaneously
- findings text in columns
- First of the year
- Loops
- making text in Title Case automatically
- Simple question
- Factorial macro or formula.
- How to Show Existing IE Instance if Already Exists, Else Open One
- Password protect a workbook created and emailed by a macro?
- Match columns
- next empty row
- Find and Replace Values in Range
- userform cancel button
- Adding a hyperlink to a shape
- Macro to paste in the active cell the contents of a cell from another file??
- Save a Workbook as "Read Only"
- Please help with auto Date and Time with VBA
- adCmdText
- multi tab workbook
- Auto-Format Excel Spreadsheet?
- VBA/Excel Add-ins
- Easy questions about Auto Save
- Code For Date Accepts Text
- Creating an MSForm based on a table
- Textbox in userform doing weird things
- General Quesiton
- is a variant an object
- Extract data from many workbooks VBA
- Concatenating problems
- repost: Dynamic chart help
- saving website html as string
- What function(s) should i use?
- Macro Question
- socket in excel vba
- Hyperlink to Word Template
- Combining files and their respective VBA macros
- Excel IF function help
- More efficient copy/paste??
- Determine if folder exists
- What am I missing here?
- Help needed with Pivot table macro to remove data
- Won't accept textbox3
- FileSystemObject.copyfile
- Automatically update links in Excel 2003 after inserting rows in .
- Problem with Formula n VB Macro
- Accumulative total
- Return ADO recordset to worksheet
- help me¡¡¡¡
- COUNTIF criteria in VBA
- Quite simple macro, but I can't seem to fix it...
- Macro to copy specific cells from one workbook to another
- How to update an external excel sheet
- Application.Volatile
- Program to accummulate data on ledger sheet
- Macro to Move Excel Button
- Updating Data through Webservices using Excel
- Is this macro even possible?
- macro CopyData Help
- Question about a custom defined function
- Create an Excel splash screen without the caption bar
- how to remove a space after a string?
- Line number in error handler
- How to count number of pages in a named range
- Calling a button event from a .NEt application
- how to execute a macro assigned to a checkbox in vba
- Excel keeps reformatting floating point values to dates (e.g. March 17)
- Macro to Paste
- Retriving name of cobntrolelement
- Final days for regular registration - London Excel User Conference - July 19-21
- colouring the entire row to a color .
- Excell sheet help needed
- incorrect addition
- Data validation dependent of value of option button
- Fire events for all comboboxes in my sheet
- Find new value and replace with old one
- Formatting / centring Text in a Msg Box
- find and delete
- Context menu
- Log file...
- displaying the user form data
- undo delete
- Help with PasteSpecial
- RePost - Creating WBooks
- Dynamic chart to track progress by date
- displaying contents of a user defined directory
- Validation list to a Range?
- Custom Menu Bar
- C# RTD Server
- XML Files
- RE: xlCellTypeVisible - not working?
- RE: xlCellTypeVisible - not working?
- Locking cells with a checkbox using a macro.
- Double-Click on cell
- Passing formula value to variable, hide rows
- Excel crashes on simple procedure
- Create Named Range in VBA
- Wildcard search for string within a string?
- Referring to a worsheet in another workbook
- Application.Calculation = xlCalculationManual fails
- macro for copying a range to a column of cells
- Macro delimiting text if column has value
- Re: xlCellTypeVisible - not working?
- Input Box Size
- Complex SUMIF statement
- Macro that deletes certain rows only
- I hope not a dumb question.....
- Retrieve all Outlook calendar appoinments for a day
- Active Workbook
- Copy Formula Instead of Value
- Passing File Name To Macro
- Workbooks.Opentext - oldskool '97
- Selecting a sub range?
- Hello I am trying to write an If/Then statement. Here is the data.
- using row autofit but with minimum height
- Copy text from Excel to Word
- variant to integer format?
- Using Pivot Table to analyze multiple variables in satisfaction survey
- Count displayed rows
- Form Question
- Copy formula to a column of cells
- Compile error screwing with me
- after save event/procedure
- how will i create a formula that will copy the content
- 2 Questions 1 about Macro, 1 about VLookup
- Indirect reference to run macro in another workbook?
- Macro If And
- Conditional Copy Macro Help Needed
- Page x of y
- Check For Add-in
- MailEnvelope
- 2007 Bug? ChartTitle.Characters.Text not working
- Newbie Question on Setting Cell Value in Sheet2
- Set Cell Value
- Disable drag and drop and cut and paste
- extrapolate range coordinates
- Auto Hide Task Bar
- remove autofilter from some columns
- Convert EXCEL to TEXT FIle
- Round Robin Tournament Generator
- where do I find docs on excel automation programming?
- Download from FTP
- Newbie Questions 02
- Creating WBooks
- HELP... AUTOSUM........Add(msoControlButton, 226)
- 'extra' file in VBE project- can't delete it? XL2003
- Detecting key presses
- Pivot Table heading case sensitivity
- Last Used Row
- Embed a Userform into an Excel document
- CommandButton Question
- DTPicker to be dropped down on initialisation
- string parsing w/wildcard problem
- is it possible to automatically change the color of the bar chart as soon as it reach
- Select a sheet by name in a macro
- Delete row problem, could some help me on that?
- Two links changed on my site
- SendMail Error Trapping
- Array from row in worksheet
- transpose data from horizontal to vertical in a specific column
- Counter variable in For Loop
- SUMPRODUCT
- Macro If and...
- Excel PivotFields/Items
- Getting a hook on Toolbar Events
- vba check for disabled macros
- Finding duplicate values b/w two columes
- Path/File access error
- Selecting Blank Cells
- copy rows based on specific field value
- External Reference - Filename Change
- Change background color
- Set Path for GetSaveAsFilename
- Copy and Paste Visible Cells
- Solver error
- Arranging VBA windows
- New to Programming
- Newbie add-in questions
- A macro that shows updates - PLEASE HELP!
- runtime error -429
- Inserting new worksheet
- Date Format in Userform
- Run procedure when value changes
- Count number of cells that are highlighted
- compare cell formats
- CSng adds erroneous digits to the value
- Why is this a Type Mismatch error?
- Calling a private macro
- Newbie question
- inserting formula
- Can you count a certain color cell?
- To delete certain data in excel. eg contains #DIV/0?
- Autofilter dropdowns
- getting size or setting it?
- How to read the Amount and MinusValues of ErrorBars in a series
- Printing pages from different sheets in a set order
- how to create macro that will display the sub_subfolder
- Dynamic Range
- Could not sort the first row ??
- VBA vs VB.net
- custom button to copy a few cells and paste on somwhere else
- Flashing Curser
- Make a loop to Find a value then move a row of cells
- Change the Formatting of All Instances of a word in a worksheet in Excel
- Selecting values from a list to add up to a specific quantity
- Auto message box
- Ignoring Certain Characters In a Cell Using VBA
- moving cells to another column based on number of characters
- Sort out data with VBA
- Changing Value of Cells
- Is Excel is now going out of it's way to mess me around?
- Create summary WB
- Tricky data type error
- Validation Drop Down Box
- integrating row number in a formula
- Need a Matrix diagram - Please help
- copy and paste (visual basic)
- Read zip file on disc
- linking workbooks - expert advice needed!
- Determining Whether File Exists
- Confused about assigning DIM and such
- Dynamically refreshing Pivot Table Range.
- is it possible that the data values shown on the data labels be in a duifferent range
- Modify database
- speed of processing
- Array usage
- error handling
- calculate all possible combination from 10 variables
- Help!!!!!! - Find Function not working from C#
- End of Spreadsheet
- Pulling my hair out
- Inserting Values in a Multidimensional Array from Two Different Controls
- Macro to Create Sheet & Duplicate Sheet
- Converting a formula to its value
- Importing/deleting .bas files (a lot)? Repost
- how do i enable user logins
- Workbook Open not triggering
- The Ultimate Problem
- Form placement on spreadsheet
- Open excel at a set time
- Linking Tab Names to a single cell with a worksheet
- What is The ORng value after this code is run?
- Dim
- Range.Value2 is failing for lenghty strings
- Dynamic multidimensional arrays
- RE: Dynamic multidimensional arrays
- code failure
- Assign cell value to variable
- Find
- -2147221080 800401a8 Automation error
- RE: Dynamic multidimensional arrays
- Microsoft.Office.Tools reference
- RE: Find
- RE: Find
- two lists of numbers
- problem to access sheet from add-in
- work with invisible sheet
- Font of ListBox
- Logical operator inconsistency
- open workbooks to extract info into one
- Populating Cells using VBA
- RE: Running the second part of a macro only on Thursdays?
- Add Formula SumIf Relative Range D = A*
- save and replace
- Re: Have 2 Macros run in a specific order...Can This Be Done
- Duplicate all Macros?
- Have 2 Macros run in a specific order...Can This Be Done
- Variable Filename calls
- Disappearing Callouts
- Running the second part of a macro only on Thursdays?
- Runtimem Error 9 Subscript Out of Range
- Path/File access error (Error 75)
- Parsing a string
- Table Update
- Before Print - one worksheet only
- Refreshing Imports
- Changing font color in email
- Selecting many Checkboxes to align & size
- Data Entry and Display problem
- VB Macro to Automate a Search/Replace
- for next loops>> basic information
- Updating a cell that uses a .NET add-in function
- Won't Add Multicolumn Data
- Macro to insert lines
- Resize Print Area/Pages Macro
- RTD value changes not triggering worksheet change event
- Changing subject line in email
- Does library reference stay with the code?
- pull down menu in validation cell
- Seach & Replace Macro
- Chart Name
- Listbox Column Count and Width Dont work. Seems Easy
- E-mailing in Excel
- Excel VBA
- Hide rows with macro
- Save column J only using copy/paste & temporary copy
- Through a command button hiding rows
- Search Spreadsheet - Results in either listbox or new spreadsheet
- Why doesn't working? Application-defined or object-defined error
- Opening an Access Database and running procedure Via Excel VBA
- Exporting data to another spreadsheet
- Update E-Mail Data Base
- Using solver while disabling auto calculation
- Renamed ranges - PART 2
- Excel 2003 Performance/Status Bar Quest
- Challenging?
- macros
- Trouver la ligne et colonne sur laquelle se trouve un checkbox
- printing selected sheets
- Getting Word to work with Excel
- Getting Word to work with Excel
- Insert Diagram
- Macro to open search box?
- Excel 2003 vs 2000 VBA Compatibilty
- Excel workbooks , internet links
- Hide all Sheets
- option buttons
- Relative addressing with INDIRECT function
- Print 2 pages per sheet
- RTD feeds into excel not trigering a worksheet change macro
- Can this be done?
- Command Buttons on Excel Worksheet - font size decreases on click
- Excel "price-stop" formula
- Calling a sub method
- cell copying?
- how to log all excel files opened on my pc?
- emailing info
- Progress Bar Control
- Re: Shouldnt this work?
- Re: Shouldnt this work?
- sum format
- Ref. problem after sheet import
- submiting from form to sheet
- path xml mapping
- Excel - Polish version - SUBTOTAL
- Function runs more than once
- disable range selection
- Including an inputbox within a macro
- Match and find entry
- Insert Formatted Row at specific point within Dynamic Range
- Using DTPicker to change date in a cell when user selects cell?
- How do retrieve data from anotyher excel file...Pls Help..Urgent!!
- Pie chart slices too thin
- List of Folders
- MFC - CopyFromRecordset - Copy data to Excel
- Populating Lists in forms
- copy several cells if one cell is set
- Lookup or Index or Match, not sure.
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.