Excel Help [Archive] - Page 142

Lock active cell based on value in above cell (9 replies)
[SOLVED:] Sort list Box (2 replies)
check if Access file is open and who the userID is (2 replies)
Copying from one sheet to another (1 replies)
Structure of the array that is returned by ClipboardFormats (5 replies)
Solved: Extended 'ControlTiptext' for combobox items (4 replies)
Method 'Range' of Object_ Worksheet' failed (10 replies)
Forumla Problem (3 replies)
Solved: End For Next routine on error (4 replies)
Different ways of copying (8 replies)
Listbox Multi column error (7 replies)
Solved: Export data to .txt file (3 replies)
Lock record creation in Excel (1 replies)
hiding/unhiding a page on a userform (3 replies)
Solved: Setting up a global dictionary (5 replies)
Solved: Layout of Monthly Data needs to change (2 replies)
Opening workbooks via shortcuts (2 replies)
get letter of the active column (5 replies)
Solved: Building add-in errors (6 replies)
Solved: Rolling average (6 replies)
Solved: sum visible rows only (6 replies)
Updating graph automatically once the data changes (1 replies)
What object is missin here (error 424) (9 replies)
Difference between Sheet and Worksheet (2 replies)
Solved: if value less then 5 show warning in worksheet change (5 replies)
[SLEEPER:] Alternating row colors while sorting??? (3 replies)
[SOLVED:] How to Force a Formula to Calculate (2 replies)
Setting up a UserForm (12 replies)
find last cell with formula (5 replies)
Solved: Reorganizing Data (8 replies)
Solved: addTextBox: how to find points from top/left of a specific cell? (2 replies)
Solved: Schedule a macro (8 replies)
Solved: Find last row, Array Worksheets via Function (14 replies)
VBE opens by itself (6 replies)
Solved: How to add image to chart series point (1 replies)
Solved: Code for buttons (17 replies)
Solved: update inventory when receiving and shipping (37 replies)
Solved: Inserting Blank Row (3 replies)
Solved: Multiselect listbox (7 replies)
Solved: Replace Method using variables to find/replace (6 replies)
object question (2 replies)
Solved: Setting Array for Two Sheets- Almost there (8 replies)
Solved: one source two targets, pick with dv (2 replies)
Compare and Print with VBA (2 replies)
Declaring a variable and assigning a value to it at once (6 replies)
Consolidating multipule workbooks (4 replies)
Solved: any way to clear textboxes on a userform? (4 replies)
How to clear a userform after completion (4 replies)
populating lists (3 replies)
Public variable doesn't reset (5 replies)
Collect Data via the Web: redux (20 replies)
Solved: import multiple text files from listbox (6 replies)
To a.Copy/b.Paste or to b.Value=a.Value (6 replies)
Solved: Populate listbox (2 replies)
Why can't i select things on non-active sheet? (8 replies)
Solved: How to move a comment? (5 replies)
Solved: If Instr line of code assistance needed (15 replies)
inputbox variable validation (3 replies)
repeating/looping through code (18 replies)
Why does this Crash (10 replies)
Solved: multi summation of columns (2 replies)
Solved: Sorting on each sheet balks (14 replies)
Copy data from excel to another application (1 replies)
copy paste (7 replies)
Help: Excel object size unit (4 replies)
Controls on sheet OTF (3 replies)
Solved: Highlight Text in TexBox on UserForm Open (2 replies)
Number of work hours between two dates (1 replies)
Solved: ? Better way to code (9 replies)
Setting the limits in y-dimension for a graph (2 replies)
Solved: DATA VALIDATION (2 replies)
Editable Worksheet_Change result (4 replies)
Collect Data via The Web (37 replies)
[SOLVED:] adding new items to a dropdown (9 replies)
Help Adding a constant text to a numeric cell (3 replies)
Random Numbers via HTTP (6 replies)
Solved: For Each Loop Through Sheet Collection Getting Wrong Results (6 replies)
Help: Worksheet_change event disable "undo"? (4 replies)
Solved: Sorting a Range, Header info? (2 replies)
dropdown on a form (2 replies)
formatting a label (3 replies)
Creating a graph from a selection (3 replies)
Solved: Non-Contiguous Reference Clear Contents (4 replies)
Solved: Formula or vba required for most frequent text in an array. (6 replies)
Centering Text in a Message Box (9 replies)
Solved: Replace tilde character fails (9 replies)
Presenting two datas in a graph (3 replies)
Solved: Multidimensional Array (8 replies)
Solved: DISPLAY "0" INSTEAD of #NUM! (7 replies)
Solved: Clear white space off each column of each sheet of a workbook (4 replies)
Weird runtime errors (1 replies)
Code for a find sort and copy. (1 replies)
Solved: How to add an Accelerator to a Caption? (2 replies)
Solved: Putting String Array to cells directly (5 replies)
MultiPage manipulation (6 replies)
Named Range issue using file online (0 replies)
Solved: Adding Sheets By Day Order (5 replies)
Creating a Pivot Table using VBA (7 replies)
VBA to grab data from other .XLS file (4 replies)
How to show Form abobe selected cell? (1 replies)
Solved: How do I force recalulation of custom function on Workbook_Open? (19 replies)
Solved: How to tell if no value is selected in a listbox (10 replies)
Save a copy solution (11 replies)
users access (2 replies)
Solved: DisplayFullScreen Question (6 replies)
adding image to vba loaded userform sourced in sheet (5 replies)
freeze pan (1 replies)
Solved: Range object Id property (10 replies)
Solved: Passing &amp; Returning array to/from Property Get and Let (4 replies)
Solved: For Each Loop through Worksheets Collection (3 replies)
Solved: referencing different cells for calculations (7 replies)
pivot tables and (15 replies)
Calling UserForms: FormName.Show or Dim Object/Set New? (6 replies)
Values and formats of only visible sheets and ranges copied to a new book (1 replies)
Test if Current Dir is Read Only (12 replies)
Excel and Notepad: how avoid additional inverted commas after copy and paste? (1 replies)
Forms, textboxes & labels (3 replies)
Solved: Simple Floating Toolbar - enhancement (2 replies)
Help with deleteing row conataining #VALUE! (1 replies)
Solved: Pivot Table Formatting (3 replies)
Listbox Count (2 replies)
Store Value of Last Row even after the procedure ends and Excel Closes? (14 replies)
Getting to know what element of ComboBox has been selected (13 replies)
Creating the user GUi forms the right way (3 replies)
Solved: Understanding VBA minutes (3 replies)
How to position a chart? (2 replies)
Check if workbook exists (10 replies)
Scrollbars for a Frame? (1 replies)
[SLEEPER:] The "BEST" formula function in Excel: (3 replies)
Linking Problem (0 replies)
stop clock help needed!!! (7 replies)
code to tell excel which folders to look into. (4 replies)
import worksheets from changing workbooks name (2 replies)
SECURING VBA CODE (29 replies)
insert pagebreak if chart is not fully displayed (4 replies)
Help: HOw many color is there in Excel (5 replies)
problem with paste to active workbook (1 replies)
Leave out blank items in combobox (5 replies)
Find Range & Fill Down (9 replies)
how to get: Index function keep value? (1 replies)
Self filling combo boxes (1 replies)
Cell contents become ### (5 replies)
Stop User from Entering Formulas (4 replies)
Solved: Expiration Date (3 replies)
Import Txt and Parse (9 replies)
Solved: Value Added Tax conversion problem (2 replies)
To Compare 2 Sets Of Data And Change The Values Accordingly (5 replies)
Sharing: What VBAx Is All About- Give It Up & Smile (3 replies)
Macro help.. (11 replies)
Can't get a result of formula (6 replies)
Solved: Hyperlink on menu button (14 replies)
Return named range with vba (2 replies)
Solved: Procedure Too large to complete message. (21 replies)
Option choices - how do I export results? (1 replies)
Solved: VBA Combo Box Coding (3 replies)
Solved: VBE column references (4 replies)
excel formaula (1 replies)
Paste Special Bitmap Excel VBA to Word (11 replies)
Solved: Formula - Runtime 1004 Error (6 replies)
Backgrounf formatting in Text Control (10 replies)
Forcing .xls to open in 2007 (1 replies)
Solved: Copy/paste from all worksheets, except sheet1 (5 replies)
Coloring of the tab of a worksheet (4 replies)
Forms/windows or whatever it's called (10 replies)
search data from other worksheet (1 replies)
Challenging macro (6 replies)
[SOLVED:] Excel data organization nightmare (13 replies)
Highlight cells on combobox selection (3 replies)
Excel Hyperlink (1 replies)
Sumif with multiple criteria?s from another worksheet (7 replies)
Adaptive Database/Table (1 replies)
Solved: Change Cell Colors By CF (4 replies)
How to find the Last Used Row on Each Sheet (2 replies)
UnprotectGreenCells (3 replies)
Help: How to make list value change with the source (5 replies)
Excel procedure to run Access Query using ADO (2 replies)
Problem with .PasteSpecial (xlPasteValues) (6 replies)
Solved: any way to delete & refresh contents in a dropdownbox? (25 replies)
Formula - (4 replies)
List box from columns? (9 replies)
Problem with Code (Inserting New Row) (16 replies)
Solved: Two input variables at vlookup (13 replies)
Solved: input data to post in worksheet (8 replies)
[SOLVED:] Speeding up the processes (2 replies)
Invalid forward reference error (6 replies)
Solved: Delete duplicated, tally to make report (2 replies)
hide textbox (3 replies)
countif forumla (3 replies)
EXCEL COMPATIBILITY DRAMA (10 replies)
Placement of a method (2 replies)
Automation Help (3 replies)
Do While question (2 replies)
Solved: copy, cut, paste: on a hidden sheet, possible? (21 replies)
Unload userforms (2 replies)
Solved: Help with case statement (5 replies)
Solved: VBE and continue (2 replies)
crashing on closing (8 replies)
Solved: Select Case Construct Help (0 replies)
Solved: naming a dynamic array with 7 columns, fluctuating rows (3 replies)
Solved: Check if user has selected more than one cell (3 replies)
Solved: find last row and add border to bottom &gt; Resize selection? (3 replies)
Copying data from one sheet to another (12 replies)
Drop down lists problem (2 replies)
Solved: Pivot Table Creation: Error 438 (2 replies)
Select issue (9 replies)
Solved: Display Animation While Random Numbers procedure (10 replies)
Copy data fields macro (2 replies)
Solved: UserForm Show Input error Message before proceeding (7 replies)
Solved: Entering only values that are different to a list box (4 replies)
VBA Objects (getting a combobox) (2 replies)
Automatic open, save, close problem. (3 replies)
Sleeper: Macro to unsort data back to its original format - exact copy (3 replies)
Changing/retaining format of cells (8 replies)
Running FTP commands from Excel Macro (2 replies)
Solved: Clearing a multi column listbox (2 replies)
array (14 replies)
Solved: Join 2 formulas to work as 1 (17 replies)
Solved: Loop: IF Condition is getting skipped (17 replies)
How to print 1st page of several excell workbooks (2 replies)
UserForm has Color but when print must only print in Black (4 replies)
running slow (2 replies)
what type of sheet (15 replies)
Investigating the selection (5 replies)
[SOLVED:] What happened to this sheet (4 replies)
Auto adjust (0 replies)
Magnify /Zoom sellectecd cell (4 replies)
Solved: Find last filled row IN PARAGRAPH (13 replies)
ActiveCell not working the way i'd expect (2 replies)
Naming a selected range (1 replies)
Highlighting changed cells (11 replies)
Automatic Opening, Saving Closing a Workbook... (0 replies)
Delete data starting from specific row (4 replies)
get min and max from array... (3 replies)
Solved: Inserting Day of the week on a userform TextBox (14 replies)
Solved: Your Opinion, Please (4 replies)
Formula to find last significant value in string (3 replies)
Relate 2 Tables in Excel Database (3 replies)
Pivot Table with ADO (2 replies)
Pivot Table Calculated Field (2 replies)
Formatting issues (15 replies)
Solved: auto copy and sort on change 2 columns (6 replies)
Solved: How to maintain control as nested subs exit? (10 replies)
Sending Info from Excel to Word (1 replies)
Solved: Write a Small Procedure for me please? (7 replies)
Copy and paste based on two criteria (3 replies)
Solved: Generating numbers in excel (4 replies)
finding merged cells (8 replies)
Solved: Macros wont run even with security set to low (1 replies)
formatting macro in VBA (7 replies)
Solved: Run-Time Error 5 Invalid proc. call or argument (3 replies)