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 |
- Where do I find help for Visual Basic for Applications Extensibili
- VB Macro for Excel
- Help
- import txt file macro
- Ranges of Named Fields
- BUG: Font Size / Control Size Changes
- Global macro for resizing and reformatting Excel charts
- import data from works 3.0 on windows 3.1
- Determining whether a named textbox on a chart exists
- Replace Update Links prompt
- Referencing a cell when using VLOOKUP
- Logic and Loop Code
- Change to UPERCASE
- Check cells for 'Auto Save As' file naming
- how do I automatically advance data to next cell when overwritten
- Help with creating hyperlink via VBA
- Create a new folder
- Change to Worksheet Change Event
- Help on Echange rare
- Need a Macro plz !
- What's wrong with this code?
- Writing a line in to a file
- Open multiple text files and paste contents to single cell
- drag and drop a formula
- Need Help with Set Object = Collection(index)
- Cells.Replace in VBA
- How do I make my Excel 2003 document work in Excel 2000?
- How do I select the last entry in a sheet, to use in a formula?
- Another way to remove formula
- Last item in listbox not getting displayed.- - Excel VBA appln.
- Programmatically inserting hyperlinks
- Create Discout Table
- Open dialog box and disabling
- run-time error 1004
- Check if date is valid
- Runtime error 91 when connecting to SQL Server 2000
- selecting range and copying to new worksheet
- How to disable files type combo box in Open Dialog box
- exact copy/paste
- Help with a Macro....
- existing file excel2000 macro
- How do I calculate an offset between two ranges?
- Best way to write an app using Excel sheets that doesnt look like excel
- turning off automatic calculation when loading VBA add-in
- Need help with arrays (I think)
- Returning value in VB editor
- searching in several columns
- Listbox selection follows hyperlink
- Remove Selected Entries from Excel List
- lookup formatted cell
- Text to speech
- HELP: survey data collection & analysis
- Name the ActiveCell
- format as %
- Activate Previous worksheet after adding a new worksheet
- appending records
- Idiot can't insert page breaks.
- Rollup worksheets into a master worksheet - automatically?
- how to average a cell value across worksheets?
- Finding and Formatting the 5 highest values in a range?
- Macro/Loop If Statement Help -delete the row with the specific te
- Deployment and config files
- VB code donation required please!
- two unaswered questions, Could you answer me one or the two of the
- problems maximizing windows in VBA
- Compile List of Rows With an Empty Cell
- UPPER / LOWER function VBA
- Obtaining column/row numbers of cells in user defined function
- FormatConditions appears to kill copypaste
- SaveAs macro in Excel
- Copying Selective columns
- VBA Excel Model Diagrams
- Macro Won't Open up Userform
- Toolbars and menus
- Automatically remove a Combo Box
- Double Countif
- update cell in automatic mode....
- Compile List of Rows With an Empty Cell
- Worksheet Change Event
- tracking database change
- Need directory path without filename
- How do I get A ComboBox to execute
- skip hidden sheets
- Finding the last modified directory and file
- Recording Macro, toggle absolute/relative reference, button disapp
- Activeprinter
- Lock Checkbox value
- Concat and summarize 6 columns to 2 columns
- Open files within specific file structure
- VBA code to change registry value of existing DSN
- Macro Sum Formula For a Variable Rang
- Tools...References shows "MISSING:" in front of 2 references
- internet connection via excel macro
- Listbox Slider control
- Stops at certain row with Error 91
- Runtime Error 1004???
- Columns resize event
- Compare a selected Range with a Named range and select cells that do not exist
- Finding the number of rows on a worksheet
- how to add database values to a specific cell
- Bug with SelLength? (Excel 2000)
- Problems sending file link in email
- combination
- Porting Modules
- how to - Insert predifined text in each cell of a column
- How do you insert lines to make an accounting journal page
- "Always trust macros from this publisher" is greyed out in Excel
- Re: Help
- Adding only working days
- Help
- Creating a master list
- Command Button on Pivot Chart
- Export or save my digital signature?
- Re: Ron de Bruin (ADO help)
- Loop
- How to offset certain cells after dragging down a formula
- Using Older versions of ms excel with 2003
- Assign Cell Content As File Name
- Excel should rewrite macros when adding rows or columns
- Macro to select cells within a range in which the cell color is none
- Supress dialog box when MS query returns more than 65536 rec's
- RE: Error when loading a programme from a tool bar
- where do i place the code ?
- Application.WorksheetFunction problem
- exact number of characters in textbox
- RE: Copying table from webpage to worksheet
- insert data ODBC
- changing rows for columns
- Macro for Excel to add up items and delete extra lines?
- changing cell values from within UDF
- Is it possible to unprotect a workbook without opening it?
- Opening Word Files in excel sheets
- Open CSV file, format data and write output to a text file.
- How to re-set focus to the text box after deleting invalid data?
- RE: I want to add a checkbox at the end to return data to a separate s
- Reading excel data into another aplication
- action on lostfocus in a cell
- Capabilities of a User-Defined Function
- Merge / Collate Workbooks into 1 Workbook
- word å’ŒExcle 图æ*‡æ—*法显示
- NEW VBA in NEW Excel ??
- Re: Inputting month and year only
- Message on screen
- Closing Excel Application
- Deleting a record from Access data base using programming from excel
- Re: Inputting month and year only
- linking format
- Database question
- How to duplicate Worksheets
- Re: Changing directory names
- Re: Changing directory names
- Doing a macro in every worksheet except 2
- Re: ATT: Ron de Bruin (ADO help)
- code for organizing array
- Solver
- Re: Excel not adding proplerly... - sample.xls (1/1)
- Re: Excel not adding proplerly... - sample.xls (1/1)
- Excel not adding proplerly... - sample.xls (0/1)
- find all instances of text in string
- Determining File Size
- error 2015 performing vlookup
- final answer to run macro at certain time
- With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project.
- Need help with loop
- on click change cells color and increase a number..
- Consolidate data in an 2-dimension array in VBA
- All Subdirectories
- Clipboard Clear API error
- Database
- Re: Clipboard Clear API function Error
- Newbie: Help with workbooks
- User defined functions
- Object variable or withblock variable not set
- Weird Cell Behaviour
- Object Defined error
- Doesn't recognize worksheet
- Error trapping
- Userform locks up Excel
- Exporting Access Queries to sepcific ranges in an Excel workbook
- Send a query and receive data through a Comm Port
- Format Series in Pivot Chart
- Exporting Access Queries to sepcific ranges in an Excel workbook
- email several attachments (change to ron's macro?)
- HELP !!!
- Workbook to Web
- using a multi-select listbox to pull data
- Thanks Tom
- Adding a control to a User Form
- Macro only working on 1 row
- Unable to set FormulaArray property of the Range class
- duplicate data, if command in VBA
- How do I handle #Value in VBA?
- DDE Commands
- Delete 2 rows skip 1 delete 2 more
- Format Data Series in Pivot Chart
- Code compatibility issue
- how shell open AcroReader w/command line filename?
- How to round down to nearest 5 minutes, time calc?
- VBA to control the Mouse
- How can I use the worksheet function FIND in VBA or is there a FIN
- Autorun.inf
- Problem with Code --- Please help
- Automating Solver in loop
- File or function not found error
- Can't get OptionButton choice result from form?!!
- Adding a column with reference to another
- Usinf cells for filename
- GroupName for OptionButton
- Which runs first, Workbook_Open() or external query refresh?
- Macro to Update Charts
- which event/method should be used to handle sheet refresh in VBA
- Help declaring array limit with variable?
- RE: which event/method should be used to handle sheet refresh in VBA
- Automatic filtering keystroke
- Copy Paste Special Values
- Moving objects
- Changing the size of Comment Shapes
- Help wih complex formula or macro or solution
- Text wildcards
- using cell info in an equation... Very frusterated
- Null to Zero from External Data
- Number rounding within a formula
- Custom graphical cell contents
- Sheet Reference in vlookup
- macro abouut solver
- Late Binding
- Calling a Sub with a Command_Click
- selecting a cell based on lookup with VBA
- private macro and shortcut key
- Trigger macro when nr of sheets changes
- Workbook_BeforeClose doesn't work!!!
- Graph Ranges
- Find Column heading and then Delete entire column
- Copying a variable range
- VBA Code to copy values &formats to the next worksheet
- Make textbox1.value default
- Function Used?
- Locking components BUT Still allowing to change settings via VBA
- Populating a database with a template
- Find last word in cell
- Too many different format cell
- sending e-mail it is ok from VBA not from Excel it-self
- UserForm - Storing user's choices
- Sheet Listing
- Progressbar
- VBA help to replace if formula
- VBA Help to replace If formula
- Which sheet will be printed?
- digital certificate
- array question
- application.dialogs(xlDialogPrint) - arguments
- copying data from text file to excel sheet
- Display of arabic-type fonts in Excel VBA forms
- copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro
- Delete words in cell if that word is in red
- How do I Clear ALL unprotected data entry fields in a protected sh
- VBA copy from single to merged cell.
- RETURN TO C
- Copy and paste values for particular column
- Before print
- VBA code to edit a formula in excel?
- First-time Use Code
- password protection popup
- Excel 2003 protect not working in Excel 97
- Move to a set cell if
- Data Validation with additional input
- Changing the active workbook
- copy line nased 2 button on userform...
- Assessing whether any checkboxes are checked within frame
- Validation, how to see "today" date on top of the drop down list?
- Test for for sheets existance
- Followhyperlink using specific web browser
- Userform Textbox multiline Vs format in worksheet
- Help on cleaning / speeding up code
- Disable Option in Como Box
- Need offset range for loop
- Microsoft Query using Excel
- Using a variable in a formula
- Pivot Table - display filtered data
- import text file
- Hyperlink Code only works when file saved on desktop
- Autofilter method of range class failed
- Menu item deletion
- Last row in spreadseet
- excel2000
- accounting software template in excel 2000?
- get HelpContextID's or Tags of all userforms
- word automation
- Error Handling to mitigate "Run Time Erorr 13 Type Mismatch"
- One sheet e-mail
- Dynamically name MultiPage Pages
- ado command timeout property
- MouseDown()-MouseUp()
- Please help!
- Template
- Automatic Border along Pagebreak
- macro in excel 2000 vs excel 2002
- Adding Sheets to a combo Box
- ranking cells in excel
- Why can't you use brackets, braces like parenthesis in Excel?
- help extending formula to range
- How to set the value of a cell using its row and column numbers?
- Parse out answers from a column
- Range of averages
- Code problem
- Re: Subtotal - copy to other worksheet
- Data sorting with a twist
- Reading a text file line by line
- how to retrieve properties of a file in VBA
- Export UNIQUE rows to access with ADO
- Subtotal - copy to other worksheet
- Anything New with the Too Many Cell Formats Issue?
- transfering data
- Worksheet Sizing
- Excel won't quit from VB.NET
- Loop problem
- Repeated Multiple Find
- Numbering
- Display of Record Set
- The formula to determine if with 3 separate if conditions.
- Accounts payable projection and tracking
- comparsions of columns and deletion
- Manual sequence to add a combobox/dropdown/listbox to toolbar
- Move cell info from one worksheet to another buy click a checkmark
- Delete excel file after copy
- Delta
- Getting text data from textbox
- disable events does not work
- Macro to view 'Print' dialog box
- Before Print and UnDo
- VBE PROTECTION
- Programmers available
- date problem
- Trouble calling Add-In Macros
- ActiveWindow.VisibleRange.Width - Is this the correct code
- Re: find question
- find question
- Change cell value when right-clicked/double-clicked
- Print VBA code in Editor format colors
- Good chalenge on header/footer
- Return of position on page in excel
- ActiveX control error -
- URGENT !! Drawing Programme in excel
- Screen updating
- user form error 9
- Check if cell value is found in a seperate range of values
- TEXT() function problem in Excel 2002
- Array formula returning #N/A when inserting new rows.
- Next w/o For?
- Mathematical Time Conversion Formula
- Help with complex formula or macro or solution
- Fill-in Range from UserForm
- Code execution interrupted on PrintPreview close
- Controlling Monarch through VBA
- Linking Multiple Workbooks
- Access Question
- Color text macro
- How to fill an internet field using VBA
- Add-Ins ???
- Text color in listbox
- Can I make an alert box with with a yes/no question?
- Color Text Macro
- Macro to synch three pivottables based on same data
- Paste event
- Array contents in module page?
- VB to protect cells not working in Excel 2003?
- How to fill an internet field using VBA
- Creating and Destroying Excel Objects from VB
- Interfacing EXCEL wir an RS232 serial device
- If Cells.Find finds something
- Vlookup
- how to protect VBA source codes
- Merge consecutive cells using conditional formatting.
- How to get value of CheckBox in VBA?
- Change zoom to fit different resolutions
- Mutli-dimensional Array to Single-Dimension Array
- Hiding Rows
- Sort collection string keys
- List in cell
- Forms, Range Control
- if statments using text
- Disable Form Events From Being Triggered
- Add Current workbook as an attachment
- user defined function receiving a range as parameter
- Counting Digits in a string
- using vba to copy user-defined chart type
- Using picture files
- Resizing Picture
- copy line with 2 condition....
- using input from user to select wk1 to wk52
- Adding shapes to xy scatter charts
- Copy line based a click into userform...
- First New Post
- less than 0.5 but more than -0.5
- VB code in Excel
- filling userform textboxes
- Locale problem
- External table/range reference trouble
- Flashing message in cell (alternate font and background colors)
- VBA and SQL
- Excel/Access ODBC
- Use Macro to copy part of text in cell
- Connecting To a Excel Database
- Using VBA to access files in a list in EXCEL
- Alarm, Play wav file
- select cells in red only
- vb exe crashing
- Choosing multiple Criteria to populate a textbox.
- run vba code dynamically of another add-in workbook
- MsgBox Position
- Find the nearest point to 1000 rows where "amounts" balance and apply special formatting to that row
- .offset() function
- Variant
- Is Nothing
- Deleting a chart using VBA
- Disabling Security Messages (Macros)
- Change Process Priority
- AppActivate
- Combo Box Sorting Update Problem
- OLE Error
- How can I call Fourier Analysis from a Visual Basic macro?
- Why does this not work
- copy column
- Timecalculations : How ?
- How to show messge box text in Excell work sheet
- Selecting part text in a textbox
- Scroll name in about-form for credit
- Ok IM REALLY LOST.. PLEASE HELP
- If Not equal to statements
- Date returning value or day of week
- Two columns whit same value
- hide columns
- Check box
- Lock to copy/ modification data
- How can I make For-Next loop with date?
- Worksheet
- Hlookup Problem
- getting extra excel instance when controlling from access VBA
- Run Macro & Rename Sheet upon creating copy from blank.
- Convert Excel 4 Macros
- RE: How can I make For-Next loop with date?
- How to make a function change other cells in worksheet
- Is there a Template for Church Business and Reports?
- Copy method failed
- Urgent help on floating segmented bar chart
- RE: Urgent help on floating segmented bar chart
- Disabling and re-enabling the AutoFilter from VBA
- Late Binding or Late Anything
- source location and error message 400
- Code looping until machine freezes!!?
- Help with word object
- Dynamic Hyperlink
- Help with Vlookup
- Need to Add References
- how to close active ie browser using a macro
- SKIPPING A COLUMN
- GetOpenFilename - Error
- User defined type not defined
- copyFromRecordset - vs - getRows
- Check for previous entry
- find values and combine in one cell
- find values and combine in one cell
- possibly array formula for depletion
- AddIn functions in code?
- Cell formatting
- Selecting a row relative to the position of a button
- Filter copy incl more than it should
- Populate Combo Box with Text file
- List all worksheets (and Document Names)
- Media Player versus Windows Media Player
- Macro Required - to process data
- UDF Raising an error
- Autofill
- Find latest date for each row
- DropDownBox?
- dropdown.fontsize ??
- Transfer rows with varying criteria
- Project: Assignment letter
- long list into printable view
- Transferring rows with variable criteria
- load local htm help file with HelpContextID
- Path name in title bar-READ ONLY prob
- Checking accuracy
- Input box Type:= 8 not working
- Selecting a range using a column number reference
- Cells.Find for text w/ line break
- No active cell
- Removing items from listbox
- Problems changing Embedded Chart Name
- Re: VBA Question: User Form and input masks
- VBA Question: User Form and input masks
- Email body with a script and a table
- Interesting performance "black hole"
- Error message
- simultaneous pairings
- Why it is not pasting it to the correct place?
- Copy to PDF
- export range as picture
- Rogue Admins
- spin button code
- Forms and scrolling
- Sum (IF
- Auto fill
- How to detect if a workbook is hidden through VBA
- Need help with odd behavior of worksheet rows
- Code with query goes from greyhound to turtle speed
- A new excel challenge
- Dynamic Find and Replace String Within Functions Based on Column Values
- protect and unprotect
- protect and unprotect
- Move Part of Cell String
- Imported file Date formats unrecognisable/unconvertable
- How do I program telnet using exel through dos?
- Security discussion - how to effectively distribute an Excel file
- VSTO Date Evaluation
- OPen excel workbook...
- Copy Down Formulae
- problems w solution 4 enable AutoFilter for a protected worksheet
- How can I copy data from one workbook to my own workbook?
- printing the project
- How can I copy data from one workbook to my own workbook?
- too many combos
- i need help
- Problem with AppActivate.
- to update or not to update
- Allow user input, but not format changes
- How to see columns from which values were not returned by HLOOKUP functions?
- Count Numerous Matches Only Once
- Variable Acting Like a Constant?
- CubeFields
- Address Property
- Determine if an excel file is already open
- Download from SAP too big
- Passing an index to a second workbook
- Data sorting a crosstab table
- Filtering and coping w/combobox
- Chart Objects Error
- Find a value in a column
- Selecting multiple criteria HELP!!! :(
- Excel 2003, paste special menu
- opening a .csv file via VB
- Row Reference
- Golf League Help
- Entering subtotals quickly in several columns
- Same value in cel
- Text alignment within a listbox
- Copying sheets form other workbooks
- Sort Data Automatically
- How do i can countinuously update time?
- Smart Application.Path
- emailing in Lotus Notes
- Compile error: Can't find project or library
- Excel strange (erroneous?) decimal behaviour
- closing excel
- Search Google from Textbox
- how to check if folder exists
- Find part of string & delete row
- Changing the text color of a complete row ...
- Macro when Inserting Line
- Sending Mail from VBA
- How to replace a function with its resulting reference in a formula?
- Activex control button problem
- Select a varying range of text and paste into a cell
- what is mean by ^ in formual
- Insert calculation with VBA is slow
- Paste Method failed (Activesheet.Paste)
- comparing data in two similar format reports
- Dos Directory
- Personal.xls
- How to Clean up exported Userform.frx?
- userform problem
- How to replace a function with its result or resulting reference in a formula?
- showing / hiding gridlines through VB code
- filter using VBA
- VB-macro - Copy from another workook
- Chart problem.
- Quick question - quick answer about assigning shortcut keys
- Loop through cells meeting conditions
- CustomDocumentProperties problem...
- MatchEntry for combobox added during runtime
- Activate and Display a Workbook in Internet Explrorer
- Printing Help
- How can I copy the data of sheet 1 to sheet 2 with modify?
- Copy Cell to Same Cell on Multiple Sheets
- Saving file using data from worksheet
- Highlighting entire row
- VBA ".Find"
- Convert code rows to columns
- repost: Need Help With Steaming Data Macro
- Excel opens All files in Default file location
- customize calendar (some dates in red color) in excel
- Importing csv data into worksheet from the web
- How do I Sum variables
- .Net Excel Add-in missing Images in ListView
- Paste method fails in VBA
- Relative Ranges in excel macro
- One custom menu copies
- Linking access records in to excel
- Disable "Select Multiple Items" in Pivot Table
- Display contents of (Multiple Items) from Pivot Table
- reset the data range...
- Exported Date Format is Changed by Ecxcel
- Excel VBA to click 'submit' on form
- how do I add paramters / criteria in the excel query?
- Userform/Module
- Select Case help
- ColorIndex and Caps Change too slow
- Macros with the VBE
- Add the specified number of work days to the a date.
- convert to a number
- Writing data to SQL server
- Last Row of Selection
- change font color whenever click a page of multipage control
- Copy filterto workbook
- Custom Number Format
- Maintain focus on one worksheet while collecting data in others
- Application.Calculation gives run time error
- Stumped on Array
- before mail
- Form Close Button
- Pivot Table - 3 columns turn-around-times
- How to find the rows existing in one column but not the other?
- OLEOBJECTS IN WORKSHEET ARE WACKED
- Identifying Objects (again)
- File name in Vlookup
- Get the list from Autofilter after filter some criteria
- Conditional formatting two rows at a time
- cannot shift objects off sheet
- IF THEN-HIDDEN ROWS
- Finding cell address for minimum number
- How to define tab key settings?
- VBA does not recognize Excel worksheet function "indirect"
- One macro to rule them all
- Re: What is wrong with this code?
- Moving cells to another sheet
- Refencing a Microsoft WORD Library in EXCEL VBA
- HELP with this code!
- Verify the format of the content of a textbox included in a frame
- Removing Cells from an Excel Range
- How to clear items on a form?
- What is wrong with this code?
- Selected Cells Menu
- Create floating button based on button click in menu
- Want macro to select current cell
- Using Wildcard on Workbooks.Open
- Validation Question
- Color Rows
- Help on Vlookup for Undetermined Range
- Returning Columns to a List Box for a Holiday LookUp Table
- Follow on to: Determine if a workbook is already open
- what is stdole reference in excel vba library
- Formatting text in Commments to cells
- Advanced Formatting [2]
- VBA
- Adding Excel charts to PowerPoint presentation in Office 2003
- Copy tab delimited string to worksheet row - VB6 application
- Excel and Vba questions
- Open an existing workbook and reference it
- error in XValues
- Use VBA to format paint cell(s)
- using VB to filter
- Formulas in Pathnames
- Restricting Characters in a cell.
- Is this wrong?
- How can I upload a file to my webfolder?
- Halt all code while macro runs
- Can't close e-mail
- Userform from a Userform Problem
- Read Binary
- Variable table array name in VLOOKUP
- New Job
- working with large text files
- Excel: I can't see the worksheet tabs on my screen anymore. HELP!
- How to display data in Combobox with no dups
- Accidentally Protecting Sheets
- Retrieving range string from named range
- "ByVal Cancel As MSForms.ReturnBoolean"
- Attaching sheet to e-mail
- Validation inputmessage multilines
- How to transpose an excel worksheet having more than 10000 rows into a text file, may by tab delimit
- Too narrow columns
- Save workbook with 10 different names
- Change "Properties" of files
- Problem Pasting entire row.
- How's this verification done?
- Advanced Formatting
- How to force Excel to NOT update hyperlink paths?
- Add double quotes to each field
- Worksheet reference vs Worksheet("").Activate
- Consuming a web service in Excel 2003 that requires a certificate
- Creating a back up copy.
- Refering to Public Variables in Functions
- Find & Delete Duplicates across two Excel Worksheets
- Fill an individual report with values from a team report?
- How do I copy a worksheet form a workbook in my workbook
- Run Time Error 13 Type Mismatch
- Select Case, Less and Greater than?
- Excel VBA: Browse For Folder - Cancel Button
- Preventing automatic upgrade of references to ADO
- Cancel RefEdit
- VBA to Merge Cells
- LIKE in Excel VBA?
- How to activate add-ins for particular files??
- Force a Message Box to close unanswered
- copy userform input to cells
- #NA error using vlookup in vba
- Sorting Data.... Help!!!!
- Locate cell name using variable and looping
- -1^2+1 vs 1-1^2
- event with commandbar button right-click?
- From excel to word
- Trouble with web services in excel 2003
- Rank items in VBA Array?
- how to write a macro for solver function
- copy paste special values
- Chart on a Userform
- Dropdown Sub Menu
- dialog box to pick path & file
- Easy solution need for find problem
- time stamp a cell that doesn,t change when time stamping another
- type "cheese" in a1. Click cheese and get picture?
- data entered on multiple sheets also added to summary sheet
- Automated data entry
- New Sheets for hyperlinked files
- time sheet help
- Macro sheet by sheet error
- Distributing Macro's and Personal.Dot files
- Retrieving data from work sheet to USER FORM
- Form creates new workbook and pulls data
- IF THEN FORMULA
- Can this be condensed
- applying a macro for a specific field to a range of fields
- Data input macro
- Data Field in Pivot Table
- Identifying Objects
- workbook open query
- UDF for opening most recent file added
- Prevent User from Going Past a Certain Cell
- I want to make one loop
- How to hide a textbox
- VBA Beginner: Help with Checkboxes on created User Form
- Userform searching and update
- filter a combobox
- Determine if a workbook is already open
- Search & Extract various strings from many files to one excel file
- List Box Multiselect Form
- please help
- please help
- Re: Set as read only based on user name.
- Select last worksheet in workbook
- Searching multiple columns
- Set as read only based on user name.
- Add data to different worksheets in same workbook
- Data Entry Form (similar to default Excel Data>Form)
- Arranging data
- List box: Populate with Range Names
- Using Excel VBA to close IE
- How do I count cells in spreadsheet that are not empty?
- Pathname reference
- MaxLength Property issues
- Clearing Ranges from Multiple workbooks.
- vb code help with date format
- Re: SAP BEX
- Run an External .exe
- Re: SAP BEX
- VBA in Excel - Public variables & VB 6.0 vs version 6.3 in Office
- VB executable
- Group date into Year and Quarters
- why am I getting a 3010 error?
- using a range in a custom function
- Get File Size (Number of Bytes) of Active Workbook
- access closed workbook
- Can't Trigger Event Procedure from a Checkbox created on the Fly.
- Link Checkboxes and Grey out the Check
- IF ... and... HELP ... :)
- check if worksheet is empty
- Concatenate to a text file
- InStr GRRRRRRRR!!!!!!!!
- How do I create a range with all values in a sheet?
- Assign Macro 2 a Button....confusion
- Long running macro and screen update
- Creating a varying UserForm using cells from a hidden worksheet
- Wrong number of arguments - Help
- Private Sub Workbook Open() - question
- VBA Coding - any ideas why this UDFs not working?
- Re: How to write an average formula from VBA- SHOULD BE SIMPLE!
- Re: Help with VBA Mail Merge
- Conditional symbols
- How to check if Software is loaded on a users C: drive
- nested if loop with logical OR/AND
- search for string within a string
- Large documents and Java
- Re: building a reporting sheet which reports by date and shows values of another sheet
- highlighting duplicates
- Re: How to write an average formula from VBA- SHOULD BE SIMPLE!
- Re: How to write an average formula from VBA- SHOULD BE SIMPLE!
- Re: Pass Excel User License to Variable
- Re: Pass Excel User License to Variable
- Advanced filter in VBA - criteria in non-adjacent ranges
- Sorting multiple columns as one
- RE: Copy row if....
- Re: Copy row if....
- Re: How to store current row into variable
- manipulate string
- Working with Rich Text Format
- Write variables from a loop, once only
- After VLOOKUP!
- Advanced filter: criteria in non-adjacent ranges?
- newbie help - code need correcting
- Find first empty row
- RowsToColumn
- Using XLA to load VBA program
- Dynamic calculations according to user input
- Sum
- Linking to external workbook
- subtotal question
- Linked sheet design theory
- to click on a cell and go to named local HTML file
- Capturing Steaming Data Macro problem?
- Countif declaration problem with ""word""
- VBA, Excel Date Problem
- Need Help with Macro Code
- Simple Question
- Watch to Trap Protected Sheet (Repost)
- Run Time Error 1004
- Excel Templates
- [VBA] Creating sheets based on criteria
- Looping through a group of checkboxes
- pastespecial question
- send email with email addresses in a range of cells
- Pasting Values of range to another range
- Just the numbers please...........
- save as from combo box list
- Accessing Microsoft Access Tables
- Do not know to how reference another sheet in my formual - embarrasingly simple I hope
- COMBOBOX
- Microsoft Discussions Page Layout
- Disabling Menus
- Dim
- resize question
- hiding a workbook
- How do I "conditionally" change font size based on text length?
- Find Duplicates and Append
- Send button in Excel
- transposing and creating new rows
- Macro with Drive-change?
- Supress screen update while writiing to another sheet
- Macro to Change Font Color
- Opens directory
- Optimization question: how to bypass copy and paste
- Sheet1.Activate vs Sheet1.Select
- automating a procedure
- Error 1004: Calculate Method of Range Class Failed
- Random Sequence with no Duplication
- formula
- Sizing of copied columns
- Data > Table
- TreeView
- Add Sheets
- Macro
- Error Handling issues
- wrong reference after dragging down a formula
- General Loop question
- VSTO Cell Alignment Enumeration
- Question regarding "INDIRECT" and Charts
- Range select
- Extracting column number of max value
- ? activate a commandbutton in code ?
- Repeating macro procedure on several worksheets
- Continuous Range
- Loop through Combinations and Keep a Count
- today() bug
- VB code needed as this is way beyond a novice like me!
- Run several macros in a row
- Help with Object variable error
- Deployment of Microsoft Office Xp Primary Interop Assembly
- Which control caused the macro to run?
- making a formula over varying ranges
- Control Face ID's
- Automating to generate the next Invoice No.
- Editable combo. Elaborate code example wanted.
- HyperLink
- Naive question on Range naming but please answer
- Re: Save workbook, in .zip
- Save workbook, in .zip
- Strange conditional copying of spread sheet??
- Paste Special
- code skips blanks in data
- Im literally a beginner, please help!
- drag formula down with other reference
- Help with code
- copying combobox
- i = input box - help
- Autofill dynamic no. of rows and columns
- VB Code help
- Playing sound in VBA
- public function
- Adding Labels to XY Plot
- Very Strange Error when using Format()
- Read out VBA code from a damaget excel.xls workbook.
- Copying data to another sheet and sorting it automatically
- Multiple selectboxes on one row in a listbox???
- Combobox_change does not repond?
- Error opening recordset where table is empty (but has field names) - How do I avoid?
- Saving Excel workbook in SQL server using c#
- problematic problem
- Saving Excel workbook in SQL server using c#
- Avoiding macro run for terminating by user
- Saving Excel workbook in SQL server using c#
- Can I get all fields for all tables in a FoxPro DB into excel (one table per sheet) automatically?
- copy all named ranges in a sheet to seperate sheets
- using cell data to name a range
- Compare multiple listbox contents
- Excel instances remain opened
- VB Complie error - can You Help
- variable interest rate calculation
- Autofill with changing data
- Error while Checking for Regular Expressions Library in VBA
- change curdir to a folder on a network
- Maintaing a Data List
- Conditional Formatting or a Formula I think?
- Embedded queries...
- Re: PasteFace issue
- Navigation Command Bar
- FOR EACH statement
- Display Last Figure
- Command Button
- mouseover-event
- Copying individual files (workbooks) into worksheets
- Message Box Colour / Color
- Printing a Sheet without opening workbook
- FollowHyperlink automatically
- IE Window Name
- IsNumber question
- Conditional format question
- Reading the Clipboard Source Information
- display and change listbox data
- comparing rows and deletion
- Visible Instances of an Application
- web page title into range "B1"
- Conditional Formating a range
- Code Doesn't Wait!
- Docking the Watch Window
- Range question
- Data Validation List
- VBA Printing
- Combination Formula
- Can Excel act as Access?
- Bypass entry of data from Lookup Table
- Create a list of unallocated payments
- deaking with nulls, I think...
- Macro to go quickly to a sheet
- How to copy the hyperlink of a list of cells in another column
- Unlock VBA Project
- Userform access on multiple excel files??
- Find last used cell in row with blanks inbetween
- Copy/paste error help
- Newbie: Can't delete to left with WScript
- DOS....there must be a better way
- Selection
- Range problem
- VB code help please
- formula help please
- Keep getting runtime error 1004
- Microsoft Excel 11.0 object libary
- Extract cells
- Worksheet tab popup menu not working
- Delete rows with numeric values, leave rows with text
- copy question
- renaming sheets dinamically
- Formula help
- Workbook_BeforeSave Head ache
- Macro help please
- Excel macro to open files within a folder
- Printing pdf
- Compare cells and grab if matched
- Unexpected SaveAs prompt for workbooks with pivot tables
- Trouble with Calling a workbook
- Why does memory usage expand so much?
- Problem with references/variables
- Open A Word Document from Excel
- does excel know in which cell a button is located?
- VBA and line graph
- comma as concatenation operator ?
- macro to add in a column by manipulation of other columns
- de-link *dates* in chart from data
- Select Case for Active Worksheet syntax.
- filter of column problem
- Excel VBA Help
- Row Number of Max Value
- Capture ENTER
- Macro to append En Spaces
- double click and move over
- clear the values, but not the formulas in a range
- Index Match #N/A error, please help
- how do I refer to a multi-sheet named range
- RE: I hope this Excel question belongs here...
- Runtime Error
- Userform.Lable Variables
- Storing Sheets Names for loop
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.