View Full Version : Excel Help
- [SOLVED] Turning part of substring into capital for text data
- Generating sheets using several templates
- Macro that Splits columns and creates .txt files with the data
- positioning charts
- Relative selecting to the right (or left)?
- Merge multiple workbooks with multiple worksheets into one
- [SOLVED] Update Cell Based Off TickBox Value
- The specified Dimension is not valid for the current chart type
- [SOLVED] PLEASE HELP ME WITH MONTHVIEW
- Extra lines at the botom of notepad when opening CSV
- Select picture shapes
- skip zeros for chart range
- How to Convert XML text intoe Array
- Macro that updates a workbook using an old workbook
- Extracting a number from text using a vba function
- [SOLVED] SQL Syntax help
- [SOLVED] Unprotect a merged cell
- [SOLVED] Run Crystal Report from Excel VBA
- [SOLVED] Dynamic hyperlinks?
- What method do I use?
- [SOLVED] Change VBA from AutoFill to FillDown
- Compare two sentences and highlight in different color
- [SOLVED] VLookup Formula
- Trying to create Submit button that will attach the form created in Excel via Lotus
- [SOLVED] exporting chart as image on a mac
- How can I see the code used on another form?
- [SOLVED] Filter data to pages based on number format
- [SOLVED] Two macro button but in a double action
- Vlookup from external file
- Please help - pivot drilldown macro
- how to set function( input range )and (array output)!!
- Code That Works on PC but not Mac
- Chart color palette sync issue
- Insert Image to Specific Page using APPWD
- [SOLVED] Macro that copies data and format Worksheet to worksheet
- macro in excel
- IF function
- [SOLVED] initialize all DTPicker same CustomFormat in UserForm
- Kick off macro when a cell is double clicked?
- Adding attachment to the lotus notes via evcel VBA
- [SOLVED] *variable* in .AutoFilter Criteria
- [SOLVED] searching a range alphabetically
- Variable column reference for a formula
- How to make the values in larger font for the cells with datavalidation?
- Refresh ribbon with code
- fixe through the win7 date windows and get information by retrun,!!!
- Workbook.Open Opens a Dialogue Box Instead of the Specified file
- defining a range as a string
- VBA to copy worksheet and insert at the end all worksheets
- How to move column?moving is possible,if so will it affect formulas?
- Protect spesific columns from deleting
- Excel 2010 VBA and Speech Recognition...
- Application-defined or Object-defined error
- IE automation - tricky - how to give the script a file path then click OK ?
- marco in Excel - loop probably
- How to disable Clipboard Section (Cut, Copy, Paste) under Home Tab - Excel 2007
- Need macro to update cell that linked to another program
- dual search criteria over two ranges (ie column)
- Need macro to check data from workbook to another workbook
- Macro which copy cells if other cell have specific value
- [SOLVED] Beginner's attempt at VBA!! Not sure what is going on!!
- Save image from computer to worksheet via userform
- Read Only Files
- Excel and Word
- using pointer in VBA
- onAction refreshing ribbon macro
- inserting a pdf as ole object into word doc from excel
- [SOLVED] Formula to calculate how many circles fit in a larger circle
- External reference help
- length of a minimum of a range defined by a variable
- I Need Help Vba Code Disable Key F12
- #Click in Botton of Web Site whith VBA Excel 2007
- excel vba to sum textbox values inside a userform frame
- Count if - cell color index & cell value (range of value)
- Open file from FTP: "Excel cannot access" error
- Dependent (conditional) combo box without creating UserForm
- [SOLVED] go to worksheet depending on Cell value
- [SOLVED] Change the range to all data range in column
- How can I speedUP my events based procedure?
- Copying data down the column til then "nth" row
- Filtering by InputBox date entries and using Autofilter with 3 criteria
- nested if VBA
- Select Column with VBA and come up 3 rows from bottom
- Open and close multiple workbooks - out of memory
- Right click on the tab: Enable
- [SOLVED] Surveys in Excel!
- VBA codes find multiple data using multiple criteria
- Choosing ranges/cells between sheets!
- Not Saving
- Organizing Data with many categories
- Runtime error 1004 - paste method of worksheet class failed
- [SOLVED] Consolidate two reports based on multiple criteria
- Worksheet sheetchange -out of stack
- [SOLVED] Difference between carriage return and linefeed?
- [SOLVED] Problem wih logical es formula
- [SOLVED] Sorting Simplification Problem
- [SOLVED] Insert row and paste data into (modify code)
- [SOLVED] Alert/Message Box
- Protect Range of columns
- Create a combobox
- vba macro splitting string/text
- How to grab particular data and output data?
- [SOLVED] How to automatically rotate through task
- [SOLVED] Find and copare value afte fill cell
- [VBA] Changing to directory with variable that was read from a text file
- Workbook Not Saving
- [SOLVED] if find less that six numeric value clean the cell
- Search folder -> find excel in folder and copy data
- [SOLVED] Writing formula at the end of selection
- Using R1C1 formula referencing other WB and SH
- [SOLVED] VBA Formual not working
- [SOLVED] Conditional Formating (modify)
- Automate Report
- Buttons often expand to fill the worksheet. Button Bug
- [SOLVED] Copy multiple cells on the same worksheet after a search
- Get data from HTML files
- [SOLVED] vba module not reading the IF Statement
- [SOLVED] deleting old ws (cycling sheets)
- [SOLVED] Interactive userform please help
- [SOLVED] propertrim() and lower() functions, manipulating ranges of cells
- Rename Picture to Value in a Cell & Copy to Worksheet
- [SOLVED] VBA macro help to find index match error
- Analysing a Word Documents headings and write it in an array
- [SOLVED] Adding Page breaks every ninth row
- [SOLVED] Extract data between brackets
- Minor Flaw - Help and understanding required if possible
- One Checkbox to uncheck/disable all others in group
- Select last cell with the data in the column/range of cells - only visible datas
- [SOLVED] Worksheet change help please
- Clean the Cells if cell does not start with (
- Automatic Deleting complete excel sheet in 2 years
- [SOLVED] Change cell color based on text
- Error: You must rely on system font, Adobe 10, windows 7, Office 2010
- Help need to fix code
- Find all values with curly brackets
- VBA syntax error
- Need help seperating files
- [SOLVED] Cells blocked with permission to change II (block full range)
- [SOLVED] VBA code that Unhides sheets that are hidden using sht.Visible = xlSheetVeryHidden
- vlookup on an array
- Excel 2007 Code
- Need Help on a macro...kind of desperate!
- [SOLVED] Copy interior Color to linked Worksheet
- Need Help: Macro that can filter data and plot results on a matrix
- [SOLVED] Extract unique Values by comparing Master list and copy full row to another sheet
- Simple macro - loop to write value from column to another cell, then save as PDF
- creating report
- [SOLVED] Macro to match entries in column A on diff sheets
- [SOLVED] Compare sheets macro
- Find particular text in a sentence in a cell and copy to adjacent cell
- Pick specific portions and make new lines
- word doc with multiple tables to master excel spreadsheet
- Creating Row and Column headers based on a formula and filling area with formulas
- [SOLVED] Increase Target.Value By Percentage
- Move / copy to relevant cell matched with sheet name VBA excel 2010
- [SOLVED] Printing only non-blank rows
- [SOLVED] VBA Query to filter #N/A
- [SOLVED] VBA to populate a multicolumn listBox using Additem
- To Sum all columns to right
- [SOLVED] Unqualified Error
- [SOLVED] How to get Tab-index from user form in ascending order
- [SOLVED] If variable 1 = 'this' then make variable 2 = 'that'
- How to Skip a column for every 2 columns while Paste the values?
- Need VBA coding help for status bar and screenupdating
- (Bit Rusty, Need Help) Copy & Paste for Adjustable Cell Range (Horizontal to Stacked)
- Can some one help on Saving multiple excel files from one excel data file
- text to number
- Late Binding VBIDE
- AppActivate does not work
- [SOLVED] Multiple Criteria Duplicates
- Need Help with Macro
- Excel VBA for ammending outlook Signature template
- Query Connections on a Mac
- Dynamic Named Range used on multiple sheets
- [SOLVED] append several sheets to a 'Results' sheet
- [SOLVED] VBA to lock specific rows when a worksheet opens
- [SOLVED] Date keeps returning time, don't understand why
- Send Keystrokes Without Interrupting The User?? - There has to be a way
- Cannot Insert Image into Mac Excel 2011 UserForm
- mousemove(drag and drop) for spreadsheet on vba userform
- Maximum x-axis value of chart couldn't fit into the image control of userform
- Customer-Data Tally work sheet Update Using VBA
- [SOLVED] Command execution VBA
- Problem solved? HLOOKUP/VLOOKUP question.
- Output Unique Data To An Array VBA
- How to sort invocied by column based on sequence number provided in another sheet
- [SOLVED] Adding Number into the generated Report
- [SOLVED] Insert after
- [SOLVED] How to insert rows in sheet1 based on sequence number.
- [SOLVED] Make macro timer a little bit more fancy
- [SOLVED] Custom function not being able to record correct cell values - RANDOMLY???
- [SOLVED] Copy and paste data and format if values match between sheets
- Modifying codes to add if-else statement
- [SOLVED] Listbox default tem when the list is made up of dates
- Moving Rows Reversing Columns by VBA
- VLOOKUP referencing table name
- Need to calculate sum & division till end of data in sheet1
- [SOLVED] Using DropDown list to navigate through Sheets - Help with Code size reduction
- Fill sheet 2 with details as froma table in sheet 1
- [SOLVED] vba to generate XML file with different values
- [SOLVED] AUTOMATIC ROW NUMBER GENERATOR
- Pivot table format
- [SOLVED] formulaArray resultat over Msgbox
- Changing cell value from another workbook cell value in vba macro
- Sleeper: Run time error 1004 file could not open
- Pivot table priority issue
- Optimize VBA code
- VBA Automatic Data Export from .Docx to Excel
- Code takes action on multiple worksheets
- [SOLVED] CONCATENATE used with IF AND funtion
- VBA code to transfer data to different workbooks
- macro to control visible tabs
- Most efficient way to copy array data (big amount of data) to a txt file
- Pivot Table - Hide Columns + Maintain Grand Total
- Macro/VBA to remove all text before hypens - Active X Combo Box
- VBA Help, need this for school
- Runtime error 1004
- VBA- copy/union certain cells
- Moving Duplicate records from one worksheet to another
- [SOLVED] Reformat Spreadsheet
- Measure height of textbox
- [SOLVED] Macro that sorts a specific column by colors and value.
- Fill Down Data
- Case When error for set values
- Custom button sometimes won't load to ribbon through xml
- [SOLVED] Help using Named Range in VBA tp pupultate a worksheet.
- (*Challenging!*) Protect two range's data validation and change in priority order
- Fetch the data's from excel file and provide the CSV file as a output
- Save a file as csv with date
- Computing Limitations for large VBA code
- Select multiple cells in a range
- [SOLVED] have to delete one to one duplicate entry in muliple columns
- [SOLVED] List all Excel and Word files in a folder containing specific text
- Challenging issue when making alignment of datas into excel using vba
- CREATION MACROS
- With 2 sheets, if value not in one sheet AND column C = specific color, copy & Insert
- [SOLVED] Disable Send by Email
- ScaleAxes with VBA problem
- EXCEL VBA: how to use vba fuction to translate the day format
- select cells through loop
- Need Help with Querying an Excel Table in VBA. ADO?
- Macro to copy data from one workbook to another.
- [SOLVED] Out of memory for below code
- [SOLVED] Wrapper for RtlMoveMemory
- [SOLVED] Subtotals several columns
- Date Filtering with VBA
- Document select, and move
- Hide Rows to variable specific criteria
- When PrintView button is clicked open the invoice in PDF format
- [SOLVED] Insert Picture in Footer
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.