View Full Version : Excel Help
- Show graph in userform but via sharepoint
- [SOLVED:] Lookup formula not returning the correct result
- [SOLVED:] Userform is not displaying anything when i change a "box" to visible or not visible
- [SOLVED:] Worksheet SelectionChange Error - Target.Address - if statement
- Script not working after moving data to SharePoint
- [SOLVED:] Help: Capture file location on the first opening of a workbook/workbook open event
- Column getting truncated
- Open and Close Workbooks | best Practices
- Excel file always opens in read-only mode when opening from sharepoint
- [SOLVED:] How to create a values only copy of WB while keeping formatting and filters in tact?
- Excel VBA folder-search-tool
- Application Visible with more than 1 workbook
- [SOLVED:] mismatch when sum values in multiple textboxes
- [SOLVED:] Cumulative based of criteria
- Opened Workbooks are still opened after executing Macro (Workbook.Close doesn't work)
- HELP!! can't figure out details for a file-combining macro
- Not Getting Sum Result From All Sheets
- expenses compared to the budget
- Market data and charts
- copy with loop double variable
- [SOLVED:] Date Help
- Macro for inserting rows if value
- [SOLVED:] Multi-sheet procedure
- [SOLVED:] How to Change the Value of a Cell based on the values of two other cells
- [SOLVED:] Zero Out Column if another column has a certain qualifier
- [SOLVED:] Create Summary
- How to prevent duplicate value
- Shell Command results in Runtime Error 5 - but path appears to exist
- [SOLVED:] Countif in VBA Module
- New to VBA: Compile Error Syntax Error
- Add the value taken from the user to my range for ActiveX ComboBox
- Loop Through Data Validation List and Copy Values Given By Each Item
- [SOLVED:] Re-Arrange Columns after Import
- [SOLVED:] Is it possible to store range objects in an variant array?
- [SOLVED:] clear dependant drop down boxes
- [SOLVED:] VBA code to pull in data from SQL table
- copy information with vba
- [SOLVED:] Deleting Worksheet Stops Script
- Pull SQL Data into Excel by Date Range
- Setting tab order, adding ability to stop/start code and refine functionality
- Macro Or Command To Change Photo In Excel - Urgent Weekend Help Needed
- Data validation and manipulating input
- [SOLVED:] Check if within multiple ranges check problem
- [SOLVED:] Compile Error Private WithEvents oCbarEvents As CommandBars and Private Sub Worksheet
- strAddress = .ActiveCell.Address Run-time error 438 when switching sheets
- [SOLVED:] Delete Rows if Cost Code Bucket is Zero
- SUMIFS on multiple rows and columns, based on a mapping
- File Selection- if user cancels- End Sub Then call macro1
- How to split a big text file (with more than 500000 lines) in to smaller files
- [SOLVED:] Conditional Format:Need to compare 2 cells with any other 2 cells for the same number
- wrap broken lines in one line in a given text or log file
- Copy text from text file between keyword in rows.
- [SOLVED:] insert auto serial number in user form
- [SOLVED:] storing processed data
- [SOLVED:] Textbox within a Frame in UDF unable to take focus. Why not?
- [SOLVED:] looping through functions
- Helper columns to solve problem
- search and copy the line
- Help to remove duplicate strings from table
- VBA script updating values other sheet
- [SOLVED:] Formula with OR condition does not return expected result
- How to close all the hyperlinked files automatically?
- Array loop values
- Make a declared variable equal to values from multiple cells
- [SOLVED:] HOW TO CONCATENATE: IF(condition;result string;result string) result string?
- Sleeper: Find a Partial Match from Location Sheet
- [SOLVED:] 3 questions regarding VBA Excel
- [SOLVED:] Expanding the range
- [SOLVED:] need Code to select value from dropdown list using numeric values
- [SOLVED:] MkDir and "Path Not Found" Run-time error 76
- Criteria based lookup
- Instant change between one textbox to another.
- Insert Multiple Image and name image in Userform
- Copy and paste styles of diagram
- [SOLVED:] VBA Excel - reduction of lines
- Copy and paste specific ranges
- [SOLVED:] create Summary report from information on the DATA Tab.
- Checkboxes and filters
- [SOLVED:] Copy Data from one workbook to another - based on tab name
- [SOLVED:] VBA Userform macro help for range dates
- [SOLVED:] Search for name and letter matches and split equally
- Search for a match files using value from selected cell in Folder or Subfolders
- Return latest result for work schedule
- [SOLVED:] Every time you open the UseForm, it generates a new code
- Image embed
- [SOLVED:] AutoComplete doesn't recognize Cell A1, it starts getting information from the second
- check if serial number is repeated
- Can someone recommand an obfuscator for xlsm?
- Doppelte Einträge zusammenfassen
- [SOLVED:] How to range table "t" from ActiveSheet "Charts"?
- [SLEEPER:] How to convert number of color to RGB?
- [SOLVED:] how to force users to enable macros
- [SOLVED:] IF Countif and Textjoin - Help required
- [SOLVED:] Help for viable registration solution and code improvement
- [SOLVED:] How to pull information from different columns of data from the same row?
- Help needed- Analysis of splitting of orders
- Need vba to code to split data depends upon col I:I and col J:J
- VBA Help on drop down list
- HLEP!! I need help modifying this code.
- insert selected row from listbox to excel table
- Worksheet Change Referencing Cell in Another Sheet
- Automatically delete rows after time period using time stamp (have partial code)
- Excel counts a blank as zero. Why not leave it as a blank?
- [SOLVED:] Cross section by matching column and row headings
- Filter values from a table and display them in different textboxes
- Price List Comparator
- Filter By Multiple Criteria then match results to different workbook & paste new data
- A search code with three possible results
- [SOLVED:] How to save multiple selected information from a LISTBOX?
- Making code more concise - VBA scrape information
- [SOLVED:] Pivot table
- VBA Code for pasting today's date into a text box
- [SLEEPER:] VBA Email TO Cell that contains IF formula
- Vlookup to ListObject "Table copy, paste"
- [SOLVED:] Saving is not creating a new record line, but saving over it
- VBA Help to change Form of Smart Art Nodes
- Finding Shape types WITHOUT selecting the shape ?
- How do I get one cell color to change based on another cell color that changes?
- Why do macros work once and then stop? Example is included
- [SOLVED:] Putting Values with Leading Zeros Into CSV file
- Copy data from user selected source file to current open workbook
- Using the TEXT function and Concatenate function in one formula
- How to Solve using CurrentRegion if cells in Table is Protected
- Copying values from one column in a sheet to another column in another sheet once.
- VBA - function Vlookup
- Can I add cell info into a comment box via a formula?
- VBA - Range of object _ Global failed
- Help : Error on saving workbook to dektop synced with OneDrive
- Lookup to add Products from one table to another VBA
- code to setup crop dimension
- Does anyone else have this error 1004?
- Picture shows in userform with search
- [SOLVED:] Fastest way to transform data
- [SOLVED:] show multiple separate information
- Retrieve formulas and autocomplete
- [SLEEPER:] Loop between two tables to sum their matches
- VBA - Problem in .range
- Log Scale graph in excel
- [SOLVED:] Formula to FIND specific TEXT within a worksheet
- how to create a portfolio Optimimizer using VBA
- [SOLVED:] Move data around in workbook
- Item number with current month
- Linear interpolation with lookup of two values
- Using VBA Set for workbook and worksheet
- VBA Code for Highlighting Cells based on If then Rules
- Create a Userform with a Textbox and link it to a Cell or Table
- VBA Code for PDF of Vibile Sheets in array
- Method 'SaveAs' of object'_Workbook failed
- [SOLVED:] Keycode 13 only for textbox input on userform
- [SOLVED:] Conditional Formatting borders around cells with formulas
- [SOLVED:] Making a function based on Find having IF
- Simple code that refreshes link to another excel file with Password
- [SOLVED:] Sort range from one empty row to the next empty row Custom
- [SOLVED:] Repeat Search Function
- [SOLVED:] Formula to format the cell? (so text gets enough space)
- Reference a cell.
- Macro not working for fetching data from Active Directory
- After user clicks 'Notify', do this
- Unrecognized text on different computer
- [SLEEPER:] Compare the selected item of a listbox with a table
- errors on Macro code for consolidation
- How can we use VBA/Macros Excel for solving this interesting simulation question?
- [SOLVED:] Help with simplifying my background substraction (data analysis)
- Transferring data workbook to workbook
- Sleeper: VBA using Loop
- Sorting two way pivot table with VBA?
- Sleeper: Linear interpolation in Excel
- Sorting and cutting part of the sort into a new tab
- [SOLVED:] Msg error: "Exception from HRESULT:0x800401A8" when refreshing reports automatically
- [SOLVED:] Extract a number from text in cell using VBA
- [SOLVED:] IF Else statement not executing properly
- [SOLVED:] Pin Folder to Windows Explorers Quick Access in VBA
- VBA code
- [SOLVED:] Code only doing it for cell not entire column
- [SOLVED:] Can a Header
- Precedents arrows state
- Haven't encountered this before, what does it mean?
- Dynamic update for each userform textbox through looping
- How to make a macro work in selected worksheets and how to fix a macro error from CF
- Help duplicating from one cell onto multiple rows
- Modeless Form Closing
- [SOLVED:] Problem in concatenate
- Macro called from Menu no longer responding
- Break record row into multiple rows
- [SOLVED:] Can't loop a macro
- Insert Row & copy and paste formulas in new row
- [SOLVED:] Lookup values from a range with partial non-ordered keyword strings
- Creating a VBA to find and delete duplicate values within Excel workbook
- Reformat found data and count equal 'strings'
- Insertion range depends on meeting conditions
- [SOLVED:] How to add row in second Sheet using ActiveCell in first sheet?
- [SOLVED:] Impossible to insert
- Editable listview items
- VBA - Prompt To Save Excel File In Variable Location
- help with the debug
- Help to fine tune the codes | transform data, delete blank rows and then autofill
- Removing leading letters in a text using VBA
- Add some cell values as notes
- [SOLVED:] How to assign a worksheet change codes to a button to refresh the values
- Range Address Variables
- VBA Macro Sort Range
- Fiter, Copy and Paste unique values in the next available row of another workbook
- Replacing hyperlinks with find and Replace
- Copy the last 3 columns
- [SOLVED:] VBA code to search on folder and sub folder for file named in worksheet
- How to cycle through control sheet in workbook
- [SOLVED:] Combinng Ranges into One
- Macro That Inserts a New Row and Defines Formulas to Cells
- Move To Top Of The Sheet
- Crossposting VBA Question - Overlapping Text Boxes with all Shapes
- Adding label for msoDropdown control type
- [SOLVED:] Copy the Last Row Within a Range and Paste to Last Row in Another Sheet
- Cannot get Application Caller to work
- excel help
- Function behaving differently
- Hide/unhide columns
- Noob question about Do-Until Loops
- DO NOT Copy Data Under Table/ Copy Data from Table to Table
- macro to add or subtract date and time from yyyymmdd_hhmmss format
- Need help with sending multiple .bcc from range in excel
- [SOLVED:] VBA doesn't compares correctly via greater than string comparison
- [SOLVED:] Multiple Individual Exclusive Checkboxes with data validation Macro (code here)
- [SOLVED:] autofocus on userform after print out
- VBA - Flat Text Import Changes
- Filter for suffix [x] when a comparing file has _x suffix
- [SOLVED:] Help with Code to splitting values into 2 columns
- [SOLVED:] Small VBA Macro: introduce cell text into a CountIF formular and get output
- [SOLVED:] Shape Colors Updated per Cell Value (150 cells and shapes)
- Using a class module for several userforms, identify which userform is active
- [SOLVED:] vba code if lastrow is full, it errors out
- vba print 2 ranges in one page
- Transfer data from one work to another
- [SOLVED:] Scale display vba code
- [SOLVED:] Delete rows with previous dates
- [SOLVED:] Copy Multiple Range on Multiple Sheets.
- [SOLVED:] Code searches entire workbook-Need only specific coulmn + keep formatting after Paste
- [SOLVED:] Change active page of Vision object in Excel
- VBA Form Source List
- How to calculate a route / find waypoints between start and destination
- Transfer specific columns from sheet to another
- [SOLVED:] Refresh custom formulars that checks background color and output as 1 or 0 (File here
- Convert ASCII code back to text with StrConv + vbUnicode (VBA)
- Quick VBA Question - Adding Another Condition - Use ElseIf?
- Need Help converting columns to YML format
- [SOLVED:] Help needed to count duplicates but derived by a column of values
- [SLEEPER:] A macro to show and hide specific rows in specific worksheets
- Finding duplicates in 6 columns by excel VBA
- [SOLVED:] Vlookup in Different Workbook - Sheet Looping
- Delete Button on UserForm won't Cooperate (Run-time error ‘1004’, Range Class Failed)
- Can Not Seem to Get If and ElesIf Statement to Work Correctly
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.