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 |
- Worksheets do not open Arranged
- Ribbon Macro does not work when stored in Personal file
- Hide, unhide macro
- user form image
- Tom Ogilvy code
- Re: AfterUpdate Code to Subtract Column (L) from (G)
- AfterUpdate Code to Subtract Column (L) from (G)
- track best seller in a shop
- Who Can Develop a new vbPrint?
- RE: Excel 2003 positioning a cell to first non frozen cell
- Excel 2003 positioning a cell to first non frozen cell
- Retaining number format
- RE: Turn Off Auto-Format in Macro
- Turn Off Auto-Format in Macro
- moving columns
- Uprotect sheet in shared document
- updating formulas at inserted rows with locked columns
- Insert new row in specific range from an entry row
- Re: Optionbutton Group test
- Writing Cell info to a new Excel file
- Optionbutton Group test
- Assign Macro to Custome Button Error!
- VB.Net app creates report, then downloading to Excel it takes fore
- Re: help! function not obtaining cell values
- Excel 2007 macro assigned to button
- Syntax for using table and column names
- loop hide cells
- help! function not obtaining cell values
- Excel 2003 macro for turning on AtoZ autofiltering on a protected
- save xlsx files
- Loop a code thru several worksheets
- user form issues
- Help fine tuning delete macro
- Multiciplicity
- Excel 2007 and Mapping Schemas
- Importing Large Text File Problem
- Macro to copy formula and paste into another
- Manipulating data
- Open sheet based on Username
- Save workbook button on Userform
- Comment Box To Multipul Cells
- Defining destination Range
- Find Question
- Find in listing and copy value
- Write text to a table in Word
- Code questions
- Word Document Object on excel Sheet
- Syntax error?
- Using range name in formulas
- RE: File path for Linked Picture
- macros to create symbols
- Listbox value depending on other listbox value
- Extra Workbook Security via 3rd Party Software
- Get rid of apostrophe when pasting text string values
- Automatically compiling many workbooks into one
- Copy formula down
- Get the most recent file from a directory
- Re: Obtain Row No of xlEnd
- Re: Textbox data to cell
- Textbox data to cell
- Obtain Row No of xlEnd
- Function to subtotal by employee and also by month for each employ
- Search for word and copy
- DTPicker Resizing
- Re: lost all modules when opened xlsm in Excel 2003
- Sub Group
- Find a Value then delete cells before and after
- Re: Force Calculation
- Userforms and Dates
- copy values and Countif
- Force Calculation
- Re: Initiating the VBA program
- RE: Initiating the VBA program
- RE: Initiating the VBA program
- Re: Initiating the VBA program
- Initiating the VBA program
- how to send an email when saving
- Re: Combo box selection will not calculate
- create a loop so i don't have to keep retyping?
- Re: trying to create sheets and tab names from first colum of data
- Combo box selection will not calculate
- Forms, marcos, buttons?
- trying to create sheets and tab names from first colum of data
- Re: beforesave
- How do you enlarge a cell
- beforesave
- Can Excel 2007 help with website accessibility?
- Can a macro pause for a data entry before finishing?
- Delete all buttons on sheet
- Unique filenames
- Protection and Auto filter
- Getting file name from the file path error
- userinterfaceonly=True fails with this code!
- Range Selection
- Dynamic DSUM?
- Adding a button to a VB form
- RE: combobox, and chr(10)
- Conditional Line/Arrow
- VBA code syntax to protect/unprotect VBProject asumming if Password is known.
- combobox, and chr(10)
- RE: Manipulating date
- RE: Worksheets in Loop
- RE: Can A Macro Help Me?
- Sum multiple columns; find max
- Remove spaces between items in a dropdown list
- Worksheets in Loop
- Re: To find Average
- Manipulating date
- Can A Macro Help Me?
- Re: To find Average
- RE: To find Average
- To find Average
- EXCEL Issue retriving data from SQL
- Combinations
- Drop-Down List Search Capability
- Reversing the order of a For-Each loop action?
- Worksheet Change event
- Reference to next non-blank cell
- Invoices details
- Make my vba wait?
- Which library does the Format function comes from?
- Re: ReDim arrays in Variant
- Re: ReDim arrays in Variant
- Re: ReDim arrays in Variant
- Searching VBA code to disable excel compatibilty checker
- Test for formula in cell
- Can this be done with HIDE - UNHIDE ?
- Re: HIGHLIGHT CELLS WHICH HAVE NO DEPENDENTS TO 2ND WORKSHEET
- HIGHLIGHT CELLS WHICH HAVE NO DEPENDENTS TO 2ND WORKSHEET
- Strange Replace Failure
- Copy data from on workbook to another...with a catch
- Re: MsgBox sounds
- Re: HPageBreaks and InsertRow Problem
- This procedure used to work before IE8
- RE: Macro In Excel
- Excel automation: how to employ Find function?
- RE: What's the best way to select duplex printing from Excel VBA?
- What's the best way to select duplex printing from Excel VBA?
- Where can I find code for the Excel 2007 functions?
- Extend range from A4 to last column
- Excel export formatting problem for fixed width files
- Print to PDF using Adobe Acrobat 6.0
- is it possible to create VBA or even VB just by entering data into a worksheet?
- How to figure out which right-click context menu is appearing whenclicking shape/picture
- .dropdown
- How to copy worksheet template into multiple worksheets
- Adding hyper links from summary page to tab?
- Mass-change Excel file associations to version 2003?
- Insert Name reference to Active Cell in VBA
- Insert ComboBox into ExcelWorksheet through C#
- Re: Install/register CDO 1.21 on Office2007?
- RE: Install/register CDO 1.21 on Office2007?
- Re: Is it possible to make a custom function behave like a built i
- Re: Get contents of editbox on RibbonX
- Install/register CDO 1.21 on Office2007?
- Apply filter and cell reference
- Open Sharepoint site & Determine the number of files and their nam
- change code name
- Problem with date values
- Private Macro
- Character Analysis
- Tweak some code
- Send e-mail based on condition
- comparing work books
- Pop up Value in VB
- 32-bit or 64-bit?
- TextBox value on an email body with same format
- Re: lost all modules when opened xlsm in Excel 2003
- Re: copy text from a cell to enter in macro
- copy text from a cell to enter in macro
- Re: set range
- Re: Formulas in linking worksheets
- Re: strange vba break
- Re: variable number of For Next loops
- function to colour cells
- Re: due to failed Com Exception failed due to the following error: 800
- COPYING DATA FROM MULTIPLE TABS INTO ONE
- Re: variable number of For Next loops
- Re: save twice command
- Re: Protect Macro
- variable number of For Next loops
- Re: Unhidden rows depending upon the secection of input
- Delete workbook
- Re: How do I get a UDF to return #N/A, as if from =NA()
- RE: Link in e-mail
- Re: ReDim arrays in Variant
- Link in e-mail
- Re: Hide and unhide rows
- Re: How do I get a UDF to return #N/A, as if from =NA()
- Re: Excel macro - search/find function
- Re: Breaking one column into three
- No more fonts can be applied - with a twist
- Formating and Header coloring in VB script for summary sheet
- How can I get the smallest image using copypicture?
- Is there an mso.dll in Office 2003 that is for Office 20077
- Re: Code won't kick off
- Code won't kick off
- Odd formatting issue
- How to create object to follow selected cells in vba
- Re: Data validation list from another worksheet
- Creating an instance of Microsoft Project without it being installed.
- Re: Formula array
- remove/delete/hide/exclude all (Blanks) in a pivot table macro
- Formula array
- Data validation list from another worksheet
- VSTO PowerPoint/Excel Interaction
- Regex Pattern
- Trouble with 255 characters max in a cell
- copying all charts as enhanced metafiles
- ComboBox Drop Down List
- how to insert the picture of employee against his concurrent cell
- Deletion Code - Fix please
- Randomize from set of values
- VBA equivalent to =OFFSET(....
- Calculating and multiplying ratios
- 03 to 07 function update
- Delete sheets
- Reinstate formulas in specific cells
- ComboBox generic reference
- Split cell value and add to array
- COUNTIF calculations & Two-way Lookup
- Three-way Lookup (revised)
- Multiple Column Criteria which deletes all but Highest Value
- Macro to determine values
- adding record to database
- Error does not appear to get directed to the OnError code.
- Data to big for cell
- Open Text Files/Format/Save as .xls for multiple files.
- Macro to set new data validation each time
- Looking for easy way to add data to the first empty row from a for
- vba formula error
- How do I populate listbox1 using the commandbutton8 (Caption Find)
- Data Extract from Multiple Worksheets Macro
- if a cell value changes, update date in another cell.
- Merging Data From Excel
- selecting month column
- Re: Formatting stop when reach blank cell
- Formatting stop when reach blank cell
- How to solve this?
- RE: Format Icon
- Format Icon
- RE: If Macro
- If Macro
- Preserving cell validation on worksheets post data merging
- Reading Excel XML spreadsheet via VBScript using MSXML.DOMDocument
- Copy to Next Blank Row
- GetVstoObject not working
- Is it possible to share a file on the network?
- CellPointer (rectangle around selected cell) invisible
- Possible to do a search/replace in the IDE Code window with VBA?
- Re: Another varible range address question
- Autostart macro-protect file
- INSERT A SYMBOL IN A CELL THAT TAKES ME BACK TO TOP OF PAGE
- Another varible range address question
- Run macro automatically upon opening or closing document
- relative reference pivot table macro
- Budget spreadsheet
- I am looking for a phrase
- Re: macro
- macro
- PowerPoint to Excel
- Create tabs against main list, now I need errors
- Mailing
- Re: connect to access using password
- connect to access using password
- Protext extel-file
- auto assign project
- auto assign project
- Withusing of input box data store in given cell
- balance sheet problem
- Analysis ToolPak Function in VBA is sloooow
- Setting a Filtered Range
- range addressing var issue
- How can I return the format & value of cell with VLOOKUP ?
- Multiple Sendkeys not working... need help to condense code
- balance sheet problem
- VBA to monitor/alert when/if a ActiveCodePane.Window = "General" has focus
- Printing
- Publishing Named Ranges to Web Pages
- RE: Help with subscript error
- Help with subscript error
- How to not execute Worksheet_Change while making changes to it via
- move and modify exiting character in cell
- Data Grid
- conditional copy and paste
- File Open Dialog
- Add column after last column used
- Sort and count or just count?
- VBA code line to ascertain if VBAProject(Test) in the IDE is open
- Setting the Transition Function for two columns
- Opening an Excel workbook with VBA from Access
- Vlookup?
- return UDT element to spreadsheet cell
- Problem with a Userform
- Setting A variable name From Loop
- Simple Macro freezes the whole Excel and PC!
- Hide/unhide personal ribbon tab.
- Opening files on the web
- split data to different Excel files
- Compare value in cell A to value in Cell b and add 1
- Automatically sending Outlook mail
- Run xlsm Macro in the middle of night
- RE: Open files from a file register
- Open files from a file register
- Excel with MS Project
- Macro to Activate a Macro
- Exit 2 Sub
- Programming problem
- Check to see if reference library is enabled
- Re: Cancel InputBox
- Cancel InputBox
- Taking a picture of a userform?
- Tom Ogilvy's Filter Check Function Adaptation Needed...
- If cell equals a text value return a value from corresponding cell
- Dependent Cell - Change Value Problem
- Dependent Cell - Change Value Problem
- Re: coding a find button and a listbox to work together
- Validating a input box entry
- Re: InputBox and UserForm
- coding a find button and a listbox to work together
- Color rows based on a cell value
- Help with code - countdown timer
- Help with code - countdown timer
- InputBox and UserForm
- RE: Writing excel info into MS Word
- Writing excel info into MS Word
- Extract First Letter from each word in a Text String
- Removing a VBA Project from the Project Folder
- Removing a VBA Project from the Project Folder
- Transpose simple question
- Transpose simple question
- Shift Result from Start Time Formula
- Stopping Excel from stripping off leading zeros?
- How do I: vba to create column sorting buttons/hyperlink
- DAY Function issue ...but am baffled....
- DAY Function issue ...but am baffled....
- count multi lines
- count multi lines
- Blank cell w/data validation & automatic fill in?
- Manipulate Text Boxes on Chart
- Code Fails on SAVE
- ListBox Property where 'focus' triggers selection
- ListBox Property where 'focus' triggers selection
- Tracking Driver Hours
- If year = X and Value = A,B,C then show N...
- VBE problem ?
- RE: center aligning commandbutton text
- center aligning commandbutton text
- Autofilter in 1 workbook and paste in 2nd workbook
- Autofilter in 1 workbook and paste in 2nd workbook
- Application error
- Application error
- Same table in to sheets
- Copy Headings based on Cell Value
- Continue formula until reaching a blank cell.
- RE: Cell reference to determine filename
- Cell reference to determine filename
- 0 instead of nothing?
- Helpme with Forumal Array option
- Calendar Userform?
- commandbutton text/assigning sounds
- RE: Help with macro to delete rows
- Help with macro to delete rows
- Get sheets name without file open
- $ sign in Formula with cell referce
- $ sign in Formula with cell referce
- Copy data to new sheets
- UserForm Combobox Change Event
- max number in cell rest in other cell
- worksheet that will only work on one users pc
- worksheet that will only work on one users pc
- Comments for Software Protection Solutions
- Comments for Software Protection Solutions
- Distinguish between Windows Xp and Windows Vista
- Distinguish between Windows Xp and Windows Vista
- Center displayed columns in middle of window
- Inverse FFT
- Copy chart and paste it as a PICTURE back into Excel
- Copy chart and paste it as a PICTURE back into Excel
- Check the two different cells in the same row
- Check the two different cells in the same row
- counif by column2 & column 4 ?
- moving charts - show data?
- RE: Insert Worksheet change procedure
- Insert Worksheet change procedure
- Selected series in chart
- VBA slows with time
- Autofilter
- Creating Dependent lists
- Locking worksheet
- Import Worksheets and "Overright"
- Copy/Paste from Different Worksheet
- Excel 2007 XML error: "The screentip attribute is not declaed"
- remove module via code
- Excel addin
- Excel addin
- Creating Path and FileName
- Creating Path and FileName
- VB editor find/replace: Use pattern matching
- VB editor find/replace: Use pattern matching
- Update #REF! to Active Workbook
- A solution to Excel2007 slowness when running Excel 2003 macros
- Program Speed - Arrays Searching vs. Row Searching
- Adding to a "list sheet names" macro ...
- RGB for column and row headers colors in Excel 2007
- Copy basic format from one cell to another
- Error 400
- combox box
- combox box
- RE: Save As in a Macro
- Protect Workbook
- Userform hanging after show
- RE: Save As in a Macro
- Save As in a Macro
- Excel 2007 Add-in not displayed in Add-in Manager
- Message box with Yes or No option
- RE: IF function and date range
- Loop through worksheets
- Loop through worksheets
- IF function and date range
- Append to a cell
- CLEARING THE CLIPBOARD !!!
- CLEARING THE CLIPBOARD !!!
- Ribbon in Excel 2007
- Ribbon in Excel 2007
- ListObjects.Add Question
- With Specific App
- Scanning in reverse order
- Date Format
- Reading the duration property of an mp3 file in VBA
- RE: Filter show all in VBA
- Filter show all in VBA
- Failed to open document by double click
- Add all fields to pivot using VBA
- Using VBA to swap between a clustered or separated column chart
- Using VBA to swap between a clustered or separated column chart
- Insert Form control on worksheet
- Insert Form control on worksheet
- Hidding ribbon created in Designer
- Hidding ribbon created in Designer
- Update table in access from excel
- How to Write Error Trap
- How to Write Error Trap
- Double click to clear option button
- Environ () Function
- Excel & MS Query caused compile errors
- Change numbering of data
- Change numbering of data
- Selected... or not ??
- Selected... or not ??
- Allow programmation in a userform
- "order by" and removing newer records
- 1 Hour in Excel 2003 vs 8-10 Hours in 2007
- VBA fails with Run-time Error 429 "ActiveX component can't create object"
- VBA fails with Run-time Error 429 "ActiveX component can't create object"
- Need to add values...maybe
- Want to check if cell is blank before running macro
- Requiring Cell Input
- "ByRef argument type mismtach" on string variable *sometimes*
- "ByRef argument type mismtach" on string variable *sometimes*
- Path & File Name
- Path & File Name
- Code locking up until I press the reset button
- Code locking up until I press the reset button
- How do I set this up
- Project / Libary error
- Project / Libary error
- 2 validation macros
- 2 validation macros
- Range object evaluates to Range.value, or Range object
- Range object evaluates to Range.value, or Range object
- Vlookup or Match VBA
- excel form on internet
- excel form on internet
- How does XL "lose" a macro that's right there?
- How does XL "lose" a macro that's right there?
- Anaother time format question
- RE: Selecting a Table Column
- Excel 2007 VBA
- Excel 2007 VBA
- Selecting a Table Column
- Re: Auto Check Mark
- Auto Check Mark
- Activating a command button with a single key stroke
- Hyperactive ToolBox in VBE
- Custom Right Click--VBA?
- Custom Right Click--VBA?
- Insert Tab Character
- Pivot Tables - delete rows from Master List
- VBA Search Workbook Question (Excel 2007)
- VBA Search Workbook Question (Excel 2007)
- Active X Control - Combo Box
- Run Time 1004
- Need help with formula...
- Decimal problem
- Decimal problem
- search form in excel
- search form in excel
- Some expert help needed
- Decline Save
- To remove the promt question message in a Save As method
- Exchange Server 2010 Beta 1
- Open Workbook Macro - with a twist
- Open Workbook Macro - with a twist
- Array/Literal notation
- Array Formula/UDF
- Multipage label caption
- Can I declare an event in Excel 97?
- All possible combinations of data inputted under three headings
- Multiple windows of single file display on windows taskbar
- VBA Range.Formula
- VBA Range.Formula
- About Excel VBA
- Collapsed category title question
- Re: single file, show multiple tabs
- single file, show multiple tabs
- cancel message while sub running
- Excel Macro Settings
- RE: Problem with a macro
- Problem with a macro
- Different ways of generating same range object gives differentresults
- Issues with excel 2000 xsl template
- Using VBA to copy a Chartsheet to Powerpoint
- Sheet navigation, if there isn't hotkey for "go to first sheet"?
- Runtime Error 13 - Type Mis-match
- averaging non-contiguous data using arrays
- Convert UTF-16 Excel file to UTF-8 and back
- Custom Toolbar Loading issue
- Dynamic web query - Can this be done?
- XL 2007: can't change Inactive Excel Add ins to Active (DLL Com Addin as Visible)
- Find text in a word document
- delete rows based on 2 conditions of that row
- Referencing sheet on a web browser
- code trying to run while typing
- dtermine row/column boundaries of selected area
- Clear formula memory?
- Auto copy cell data from source sheet to another wrkbook sheet
- Problems with CSV file input
- Passing an event up the chain.
- Re: Toolbar Gone - STUPID STUPID STUPID!!
- Re: Toolbar Gone - STUPID STUPID STUPID!!
- Entering information
- Toolbar Gone - STUPID STUPID STUPID!!
- Help with Concatenating
- Treeview with context menus
- Multiple criteria...
- Update Excel file
- help with debug errror and saving only one worksheet
- Can we use variables in XL macros?
- Datamatrix ActiveX control
- Scatter chart does not refresh: HELP
- I learned how to rename workbook without saving it
- For Loop
- Comparing against table to return value
- GetOpenFilename with default filename?
- CreateEventProc
- Change when function is called
- control the Visible Property on sections of a UserForm with a macro
- Returning to active sheet
- Text Box Scroll Bars do not appear until you click in the text box
- How to delete commas and spaces when not needed ... S&R way, or macro way?
- Dumb question # 32,345..Moving Around On A Spreadsheet
- Dumb question # 32,345..Moving Around On A Spreadsheet
- Summary table from two worksheets
- Hiding RTD calls
- vba function module returns #NAME?
- Sorting a spreadsheet that is grouped/outlined
- Macro Button to Sort Columns - Troubleshooting ideas?
- Read and write an array
- vba function returns #name?
- Merge Sheets
- Summing two columns
- Deleting Duplicate Rows containing a value matching with a value f
- Macro Code Issue
- linechart through vb script
- Copy from worksheet if cell is blank
- sumifs question
- Error Handling with Worksheetfunction.Match
- Re: Create a Month's Sheets automatically
- Import .odc files into an Excel workbook.
- Create a Month's Sheets automatically
- CDO Email with Gmail
- Copy Worksheet Between Books and Retain Formatting
- Size of arrow in combo box
- .Paste
- .Paste
- .Paste
- Operate on each cell in range.
- Data sort is placing blanks at top
- Problem with advanced filter macro
- Looking to select noncontiguous rows with For loop
- Help - Easy one - ControlSource Property Invalid
- Counter
- Alternate to ActiveWorkbook.Close
- Dynamically Freeze Panes
- Open another WorkBook
- Force Excel to close
- Listbox selected
- Can I do this autoselect with GetOpenFileName or the Dir function?
- Unlocking Aspect Ratio For images
- Three-way Lookup Help Please
- Type of charts from Access
- Solution required
- Converting a grid of data to linear
- Troubleshoot access - excel linked table
- WEBSITE ACCESS AND VBA !!!
- Google query
- Help with Tooltip on clipart
- COUNTIF function help please
- Macro issues - trying to get an array to a column
- Help with VB macro
- Vlookup Help Please
- RefreshTable vs PivotCache.Refresh
- Problem With A Pesky Question during a Macro
- vbOKCancel Problem
- Macro recently quit working
- clear contents re value
- check for links
- check for links
- Renaming the Excel windows taskbar
- 100% quandry
- Finding the biggest number out of 8 variables
- Data Validation - List
- listbox with multiple selections
- deleting sheet
- Delete sheets
- path to macros being changed
- Extract base domain from an URL?
- sumif in vba
- Copy a command button
- Rename Tab
- Download data from web page
- Input Box Location
- Email Using CDO - mixed results
- Window Manipulation
- Driving me Crazy
- .dropdown problem
- Print to PDF code for both Cute PDF and Adobe
- Need to meet criteria
- Efficiency, Workbook objects in User Defined Record
- "Limited Use Question?"
- Add problem
- Preventing Duplicate Records
- RE: Compare cell value with string
- RE: Compare cell value with string
- Re: Compare cell value with string
- RE: Compare cell value with string
- Compare cell value with string
- Form Startup Position
- Autofilter using a value from a list.
- Spell Checking on a protected sheet
- Call a sub in a modeless userform from a code module?
- VB script line graph
- ControlButton Size
- multiple column Listbox - look like table
- Adding and Protecting a Totals Column to a Table
- Dim Array as Byte
- How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code?
- Copy range on multiple sheets into one sheet
- Copy range on multiple sheets into one sheet
- Looping through file names of a csv and then through other csv
- Insert formulas
- RE: Stack Space Problem with On Worksheet Change Event
- RE: Stack Space Problem with On Worksheet Change Event
- OpenOffice macros
- .CurrentPage = "(ALL)"
- Stack Space Problem with On Worksheet Change Event
- Stack Space Problem with On Worksheet Change Event
- Image Stretch While Printing
- Custom Properties for Worksheets and Workbook
- Code debug
- Hide Columns
- Horizontal scroll bar
- Workbook_close
- Auto_open User Name Log
- Is there a command to 'Hide' the Activeworkbook?
- Format Zip Codes Correctly for a Mailmerge
- FRom Pivot table select multiple items under report filter
- module won't quit as expected
- Force users to enter a range of cell in dd/mm/yy hh:mm format
- Re: What application do you use to write VBA on?
- Re: parse Excel
- Re: What application do you use to write VBA on?
- Copy contenst of a cell into a string
- What application do you use to write VBA on?
- Open file from same path
- all permutations
- RE: A way of capturing the new path a file is stored in
- Fully Populate Tree View Control
- How do I calculate the age of a person from their ID no.?
- Find method without "With / Set" in a For...each: error after 1st run
- Address of Excel.Range & Range
- using excel from c++
- Replaced text count
- API code for 'Renaming a Directory'
- Picture on Worksheet Cell
- Cannot find project or library
- FIND method , versus FOR EACH ...
- File check on FTP server
- Import through dialogbox
- Auto_Open Code on Worksheet
- Application.Quit Not Working in Office 2007
- Main Sheet
- Check for duplicate numbers from ones entered and anoter set
- Multiple of a Variable in an If function?
- code to hide/unhide rows
- How do I add iserr or iserror to this
- Wavfile playing trubcated
- Change a web query
- Run-time Error: '438'
- Print Userform - fit to page
- 20007 issue?
- Create list of files with hyperlink from a folder with EXCEL 2007
- Lookup and match color of corresponding cell
- Slow Updatelink off Networked Open files
- Capture
- Activate a Workbook
- CDO to Retrieve E-mail
- new workbook add and save by a modified name based on original fil
- New to excel macros need help with selecting ranges
- Is somekind of Slider Selection possible?
- macro to redirect to another worsheet within the same workbook
- Manipulating Strings in a Macro
- Open Sharepoint Hosted Excel File, in Excel, Using VBA
- Show a value for Listbox1.Selected(i)
- Error in excel com: Microsoft.Office.Interop.Excel Exception from HRESULT: 0x800A03EC
- How do I force user to enter their ID# before filling other data?
- Problems With Page Breaks
- Copy/Paste dynamic ranges
- Copy/Paste dynamic ranges
- Paste
- Automation: Invoking Excel Financial Functions Without InstantiatingExcel?
- Delete All Blank Rows--A plea for help
- Change cell with command button
- Re: Auto code in VBE when pressing F7
- Re: Placing a few spaces between syntax
- Passwords
- Placing a few spaces between syntax
- Read in Data
- Help with inserting automatic comments
- Removing automatic(Default) page break
- Auto code in VBE when pressing F7
- Re: macro to send you to a specified worksheet
- Macro
- macro to send you to a specified worksheet
- Grouping Based on Indent
- Macro to run Command Buttons
- Rearrange Data
- macro for deleting specific columns & rows. Help. Please. No Clue.
- CellPointer (rectangle around selected cell) not visible
- Code Help
- using one macro to edit another
- Add data to 2007 table based on column names?
- Autofill Help Please
- Copy sheet and rename tab
- Looping Help Please
- Visual Studio 2010 (Creating Excel DLL) "warning" no build
- macro to transfer from excel to word
- RE: Visual Basic - Invisible Command
- RE: Delete VB code from a worksheet
- Visual Basic - Invisible Command
- RE: is array redimmed?
- 5 months prior to date macro help please
- Delete VB code from a worksheet
- is array redimmed?
- 2 Autofilters
- FreeFormBuilder Bug?
- Hard code the workbook name in macro
- Macros Being Re-Directed
- Check URL exists in Webquery
- Query 2 excel files with ADO
- Selection after copy sheet failed
- How do i password protect my VB Code from users
- Saving data from a user form
- Worksheet Function
- Invoice
- Button - Assigned Macro
- Retrieving Current Row,Columns & copying Format from Row,Columns a
- "Web" Command Bar always appears on start up
- Moving the cursor around with a macro....
- Comboboxes with multiple values
- Hide value of cell if value same as other cell
- Adjust Zip code to 9 Char fmt.
- Need to run a Macro to ....
- Need to run a macro to ...
- Send an email from Excel using Outlook
- 2 columns w/ text data that i want to do a wildcard comparison
- How to run this macro
- Maintaining selections in UserForm
- Run-time error '424': Object Required
- Conditional Selection.Find
- Cell reference in User Defined Function.
- Running a Batch file from VBA
- variable in application line
- Userform - Label
- Copy if adjacent Cell has data
- Fast AND Accurate
- Compile error in 2003
- setting a variable to the offset of another object declared variab
- Loop to delete shapes
- Re: Sorting Macro Loop
- RE: Sorting Macro Loop
- RE: Sorting Macro Loop
- Website problem
- Return Column Number
- Sorting Macro Loop
- RE: exit form and close sheet
- Copy a mamed range in one worksheet to the first blank cell in a c
- comparing data without unique identifier
- exit form and close sheet
- Highlight Duplicate Rows (In Series)
- name ranges in array
- what VBA command is used to go to the next blank row in Excel?
- PLease Help!
- When this happens, do that, then do the next thing
- query criteria based on a changing list of values
- Spliting Data into Months
- Combine and Convert to Multiple Rows
- If Formula & Vlookup
- AutoShape color
- Re: Coding, Formula, or Conditional Formating?
- Check for duplicate values
- Copy code
- making a worksheet & certain ranges within a variable
- Selecting worksheet and ranges within sheet to run macro on
- Coding, Formula, or Conditional Formating?
- sheet update date
- Keeping XML data in workbook?
- Hide and Unhide
- Hide and Unhide
- Change Print Margins in VBA for Printing an E-mail
- Change Print Margins in VBA for Printing an E-mail
- Extracting specific data from a string
- What is the meaning of this sub
- Problem with UDF
- Application-defined or object-defined error
- Excel OLE Automation: How to access constants ?
- Workbook which having unreadable contents is not getting opened
- environ username vs. application username
- Help with hyperlinks
- Scroll Bars on Worksheet
- Create own properties?
- using the same range name on different worksheets in a workbook
- Cursor and Sheet Protection may09
- Named Ranges vs. Constant Addresses, sheet protection, Guidance.
- Modifying Sub SortMatch
- "Do You Want to Save Changes" message window
- Paste Special values for entire workbook
- Missing Printer Method in VB6
- Add in does not Function in Excel 2007
- referring to a row that contains a single cell
- Problem using DLL written in C++
- Speed up Array Transfer to Dictionary
- Searching a cell for certain contents
- Variables in a Userform
- How do I know that Application.AutoRecover.Enabled = False works?
- How do I print to a printer line by line from VB6?
- list or combo box?
- macro to automatically remove blank rows
- Tough one - image and embedded html document
- How do I print to a printer in VB 6?
- Input box for multiple entries
- ComboBox and multi sheets
- Run Excel with VBA code from Website
- Re: Delete Row if value in row changes
- Delete Row if value in row changes
- Copy all worksheets to another workbook, excl. duplicate sheets already in other workbook
- personal.xls in Excel 2007
- Shell Command
- I want to define the use of Unicode globally in a VBA macro in Ex.
- removing duplicates in a row
- Form Names
- Input box help needed
- disabling macro message
- Locking cells, Excel 2003 SP3
- Execute a macro automatically when checkbox is clicked
- Automatic transfer of row info to another worksheet
- Macro instead of lookup
- Pivot Excel 2007 - Change data source Table head's cells' values ...
- Pivot table - eliminate rows out of the table
- How to check the decimal number of each cells vaue in the column
- Modify all pivot tables in one sheet
- reference with variables
- Check that only ASCII chars are used
- How to check the last digit of each cells vaue in the column
- Is this right?
- Enter smallest amount in row
- Re: Generating new workbooks based on data
- Re: Generating new workbooks based on data
- Generating new workbooks based on data
- 3D averaging / histogram
- Enter the smallest amount in row
- Ignore Case without using Regular Expressions
- Conditional "If Not ... Then" Statement not working properly Help!
- Help with this macro please
- Public Variable Question
- New range overwrites other range in create sheet macro
- New range overwrites other range in create sheet macro
- Assigning macro buttons to macro code in another file
- Error 4605 when trying to copy/paste a table from excel to word.
- Problem with formula
- Defining multiple ranges as one range
- Filtering data hides row
- Code to change PivotTable selections, based on ActiveX CheckBoxes on a worksheet.
- Transfering data
- Unable to Compile a Macro
- XMLSS document to Excel document in .xls format
- Unable to Compile a Macro
- Shell comand
- Problem reading text file
- sheet code window
- test
- Updated sheet content is not copy pasting from sheet1 to sheet2
- Delete VB issue
- Selected listbox item
- Save As Macro
- When
- Get "Large" from List
- Error: "Compile error in hidden module: Main"
- VBA project not viewable
- clipboard excel
- Using function to change a cell color
- Text Formating
- RE: ActiveWorkbook.close problem
- ActiveWorkbook.close problem
- how to open a workbook when application excel is running ?
- Finding TWO things
- UBound array problem
- If Selection is one cell
- data summary & macros
- Using check boxes
- Check if Range EXISTS
- Sub or function not defined
- Lose Cursor After Protecting Sheet
- Get data from closed file... Cont..
- Re: Check cell range for a fragment
- Check cell range for a fragment
- Can a macro do this job?
- Open a Workbook using VB
- Sort
- sOURCE CODE REPOSITORY
- alternative to using the 'chart method' to exporting range as .jpg file
- WinZip 12 page
- arrays
- VB career advice appreciated for self-taught newbie
- RE: Skip Errors
- Skip Errors
- Activate Workbook (Windows) with keywords
- Use Bcc
- using variable in subject when send mail
- Opening a new workbook via a macro
- How to access VBA variable from active worksheet
- Give a sheet a name from data in a cell-saving to a specific folde
- Copying a worksheet with macro buttons on it
- Copying multiple worksheets to another workbook
- How do you get the selection in the VBE Active window
- Can an input box do this
- ListBox question
- insert 3 rows between data
- macros
- a formula to go in a macro
- Looping Question
- Refreshing pivot tables according to scroll menu result
- How can I selectivly delte rows with a macro ?
- Why is this Worksheet Change Event triggered?
- scramble names on work roster
- Command Button misfire
- Looking for a way to Set Range to Entire Column
- XL2003 find and replace broken?
- Change delimiter position based off of Last Name
- Memory Management in VBA
- Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble
- ScrollBar - set MIN/MAX cell value
- Column grouping and hiding being over-ridden when sheet opened
- Subtotal Function response is slow
- send an outlook task to colleagues
- Insert Contents
- Need Calculations Done Event
- Copy sheet to next un-named Workbook
- Runtime Error 13 - Mismatch
- Sample VBA code to open an Visual-Studio-2008-created VBA DLL
- Excel 2007, Custom Right Click Menu Doesn't Work in Table
- Outlook and bcc
- Create User-defined Template
- VLOOKUP in VBA
- To Enable Macro in Excel.
- CNA
- Run-time error: '9'
- Referring to same cells in all worksheets
- outlook task recipient
- Events
- Vlookup based on Combobox in a Userform
- How to implement the progress bar to indicate the Macro start to finish
- How to Upload a Workbook on my website
- How to Upload a Workbook on my website
- Excel XML Time format & arithmetic
- Excel XML Time format & arithmetic
- Excel XML Auto Column Width
- How to hide rows in a range that have a certain value, withoutfiltering
- Open files Error in Excel 2007
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.