View Full Version : Excel Help
	-  Solved: My code start to be slow.
 
	-  Need help to insert column in Pivot
 
	-  Function, compile error.
 
	-  Solved: Need help regarding formatting sting using VBA
 
	-  Solved: Importing data from other Excel spreadsheets
 
	-  Solved: Cant get the value of a control in a multipage
 
	-  HELP to show formula
 
	-  Solved: Running Module from Other Workbook
 
	-  VBA Code to Hide Blanks in Pivot Table
 
	-  Solved: Time Stamp in cells using VBA
 
	-  Copy function
 
	-  VBA HELP
 
	-  VBA lookup and delte
 
	-  Delteing
 
	-  How to insert Japanese character to SAP from Excel?
 
	-  Using VBA to disable Save and Save As
 
	-  Dynamic Range Transpose Loop
 
	-  Solved: Excel 2003 Saveas Issue
 
	-  microsoft ado control & datagrid6
 
	-  VLOOKUP Between workbooks
 
	-  Need help with select case structure
 
	-  Help to a code - Save as - Debug
 
	-  Solved: Date, Month, and Time Stamp using VBA
 
	-  How to sort files before inserting to worksheet
 
	-  Solved: long function from excel to vba
 
	-  How to call\use DLL via vba macro?
 
	-  Solved: Find Text
 
	-  Formatting strings in cells
 
	-  RunTimeerror 2147417848 (80010108) Object invoked disconnected from its clients
 
	-  Refernce formula and formatting
 
	-  Linking macros to hyperlinks in VB
 
	-  Solved: Multiple IF statement (??)
 
	-  Save dialog in ppt
 
	-  Asking about VBA in Excel
 
	-  I need a Worksheet_Change macro moving cell to cell
 
	-  Code to Compare Cell Contents
 
	-  Solved: Is there a way of shortening my ever increasing vba
 
	-  If any column in active worksheet is hidden, then the value of cell A1 is “hide”.
 
	-  Solved: Range.Find returning Nothing
 
	-  Help with a macro
 
	-  Help with multiple criteria functions or VBA code.
 
	-  Remove Last Row Value From Sort
 
	-  Solved: Copy and Paste On Formula Result
 
	-  Solved: Copy a Range then Transpose Paste into every other Cell
 
	-  Export worksheet problem with path
 
	-  for loop returning 2 numbers
 
	-  Solved: Help uderstanding this loop
 
	- [SOLVED:] Hex to Binary conversion, not using HEX2BIN
 
	-  Solved: separate specific symbols in order of priority
 
	-  Solved: Create chart on new sheet using VBA
 
	-  Is querying beyond 255 columns dead?
 
	-  Solved: placing formula in the same cell (D7) of all tabs
 
	-  Re arrange columns from selected rows
 
	-  Auto Start/Stop Macro at specific times
 
	-  Solved: Macro to remove entire if null value encounter in column
 
	-  VBA CODE ADD TO CODE MANDATORY CELL
 
	-  Worksheet_SelectionChange(ByVal Target As Range)
 
	-  Simulate mouse movements
 
	-  dynamic x axis "find last cell" vba code
 
	-  Extract Values of SN tags and save to Excel
 
	-  Solved: .FormulaR1C1 VBA
 
	-  Display tiff image on vba form
 
	-  Double click can edition in ListView
 
	-  CostCenter and Product combinations
 
	- [SLEEPER:] Context Menu on UserForm
 
	-  mail from excel
 
	-  Solved: VBA Code : Help required
 
	-  VBA FORCE CELL NOT WORKING
 
	-  Excel DLL CUDA
 
	-  Link UserForm with worksheet data
 
	-  Solved: Used Range Selective ClearFormat
 
	-  Resize Chart as Picture
 
	- [SLEEPER:] New Workbook for each worksheet
 
	-  Test if variable or object exists
 
	-  reload job nos fron jobs at J status
 
	-  Date Time copy paste not including time
 
	- [SOLVED:] Need help for conversion
 
	-  Extract Web Page Data
 
	-  Solved: Copy data with values & paste in another worksheet
 
	-  Solved: Loop Until Help
 
	-  using excel to fill online form
 
	-  Copy worksheet cells from sub folders to new workbook
 
	-  Excel macro/VBA to sort a column, upload to sharepoint and save as draft on outlook
 
	-  Summarising of info from many w/sheets with a Macro
 
	-  Removing Spaces
 
	-  Solved: Repeat cells N Times
 
	- [SLEEPER:] An MSForms Treeview
 
	-  Solved: VBA to delete a row in another worksheet
 
	-  Solved: Subfolders's names in array
 
	-  Solved: If cell is cleared or blank the conditional formating color is removed
 
	-  Solved: Draw without repeating words until the entire list has been drawn
 
	-  Solved: Help with Find/Delete Entire Row
 
	-  Solved: Incorrect VBA Sort on Workbook Close
 
	-  Problem  Using Kill File
 
	-  How to get records in excel ADO
 
	-  Solved: Add date to Userform
 
	-  Solved: Help with automatically fill in cells by VBA loops
 
	-  Solved: Excel- align rows by column. Works but too slow!
 
	-  Solved: Worksheet Change Function: Created WS?
 
	-  Solved: Return a value from another sheet
 
	-  Solved: Remove Freeze Panes From Inactive Window
 
	- [SOLVED:] Byref argument type mismatch array
 
	-  Excel Automation of IE - help click this button
 
	-  Solved: Double Click Event for Shapes
 
	-  Use a list from Excel to move files on computer
 
	-  Can not get rid of "Do you want to Save changes"
 
	-  Multiple currency format from UserForm
 
	-  VBA - CELL VALUES EXCEED 12 (MONTHS)
 
	-  Solved: Add third column to listbox
 
	-  Solved: sort columns dynamic
 
	-  vba to find and replace exact matches of cell value in a sheet
 
	-  Solved: user name
 
	-  Solved: Type mismatch error on If Not Range...
 
	-  Multiple Criteria Lookup
 
	-  group and hide blank space
 
	-  Special Sort needed - Sorting labels contained in one column
 
	- [SLEEPER:] Disappearing calc field in pivot table
 
	-  Solved: change name tab office
 
	-  Solved: Function that's not working as should
 
	-  Attachment to gmail
 
	-  Solved: cell checking
 
	-  VBA - Macro to create/update documents in Lotus Notes database
 
	-  Export Selected Sheets to New workbook
 
	-  Running Macro Automatically if a cell value is True.
 
	-  Runtime err 1004
 
	-  OFFSET of result from vlookup
 
	-  datestamp on cell CHANGE
 
	-  Excel vba script to insert data into Outlook
 
	-  Multiple conditional values from Excel in VBA listbox
 
	-  Opening a new file of a different format
 
	- [SOLVED:] Excel chart - identify the selected data point through macro.
 
	-  VBA Excel HTML e-mail?
 
	-  pivot vba
 
	-  data send to zohosheet
 
	-  Capture window help
 
	-  Solved: Sort All sheets in a workbook
 
	-  VBA Show All Data
 
	-  CONDITIONAL FORMULA with Percentage
 
	-  execute macro if change to range
 
	-  Text Box, text formatting
 
	-  conditional formatting text conditions
 
	-  Line list box
 
	-  RunTime error 462 - The remote Server machine does not exist.
 
	-  Muti Solver VBA
 
	-  Remove gaps in a combobox list
 
	-  Solved: Use a spreadsheet specifies interval even if another is active
 
	-  Embedded gif in userform
 
	-  Solved: EASY VBA ISSUE TO FINALIZE THE IMPLEMENTATION OF THE MERSEENE TWISTER RNG
 
	-  Merseene Twister VBA app easy issue to solve (with zip file)
 
	-  Compile error: Expected line number or label or statement or end of statement?
 
	- [SOLVED:] Getwindowstext and settext
 
	-  Help with code to copy to another worksheet
 
	-  Consolidate data from different excel files (VBA)
 
	-  Solved: Make folder path and file name with VBA code
 
	-  Solved: Refresh my pivot table
 
	- [SOLVED:] search folder structure and return paths only
 
	-  Solved: Application or object based error
 
	-  Paste special data till last updated row
 
	-  Solved: Smallest 3 numbers in range
 
	-  Class Modules in AddIn .xlam
 
	-  Save As Query
 
	-  VBA Form that uses data from a worksheet
 
	- [SOLVED:] Copy from excel to word unmerged table
 
	-  Solved: Empty Cells Will Not Delete
 
	-  Solved: VBA Pogress Bar
 
	-  code created text box not firing change event
 
	-  ContextMenu example errors
 
	-  repeated user input
 
	-  how to get profit as per fifo method
 
	-  Simple VBA Statement
 
	-  Macro to fill values of row numbers in a 10x20 grid
 
	-  Using HLookup
 
	-  Solved: New procedure at end of code?
 
	-  Solved: Insert header rows
 
	-  Help with Sorting by first name
 
	-  Get HTML Code into String from Newly clicked webpage (i.e. URL doesn't change)
 
	- [SOLVED:] Countif? within a loop
 
	-  PIVOT table - Change sub column label
 
	-  HELP, user-defined type not defined
 
	-  Solved: Getting average of a range within a loop
 
	-  Get last row of a page
 
	-  Unexpected "Subscription out of range" error
 
	-  Creating Summary/ VBA code
 
	-  Solved: Fetching data from excel
 
	-  Passing Array Issues
 
	-  Solved: If statement
 
	-  Solved: worksheet tab options unintentionally disabled
 
	-  Excel 2003 User Defined Function
 
	-  Solved: need help with finding the minimum in a 1D array
 
	-  Solved: Array Formula Question
 
	-  Select an item from a website tree
 
	-  Solved: Macro Equation
 
	-  Solved: Remove certain charachters from a cell
 
	-  adAsyncExecute apparently gets cut off
 
	-  Protecting Cells With A Password In different Work Sheets With Code?
 
	-  Treeview in  2010 64Bit
 
	-  Solved: copy entire row to new sheet along with header
 
	- [SLEEPER:] Run Time Error '76' - Path Not Found
 
	-  Solved: Show All Data From Two Columns Matching Todays Date In A Msgbox
 
	-  Solved: Status Bar Message With Extract Macro
 
	-  Solved: Making a macro compatible among multiple users
 
	-  Solved: Show the working days without holidays
 
	-  Add signature to email
 
	-  Copying and Paste files
 
	-  Solved: Error while printing pdf from excel
 
	-  Solved: Change the place of alphabets to numeric
 
	- [SOLVED:] VBA code for pivot filtering
 
	-  VBA Prevent File From Saving
 
	- [SOLVED:] Working with String in VBA
 
	-  Solved: Popularize Listbox using Textbox
 
	-  Programming for the null case
 
	-  Find the Max Value when a cell contain Text and Number
 
	-  Solved: VBA to remove duplicates as per the date
 
	- [SOLVED:] Matrix Multiplication of Arrays
 
	-  Displaying Search Results
 
	- [SOLVED:] Solved: Change selected cells to common range
 
	-  Solved: Sorting data problem...need to sort at midpoint of data table
 
	-  Read Excel using SQL Statements
 
	-  Generate HTML email with file attached - please help
 
	-  Clearing Auto-Filter with Password Protection on
 
	-  Solved: Macro not working properly
 
	-  Solved: OLEObject Vlookup help
 
	-  Userforms, Listboxes, Virtual space.
 
	-  Add-in file path Excel 2000?
 
	-  Help with crating a tab based on cell value
 
	-  Solved: Setting Pivot Table Filter with VBA
 
	-  Solved: How to use VBA to test if a number is a prime or not?
 
	-  help with Payroll employees
 
	-  Solved: file name via function
 
	-  Saving the return value of oracle function in a string
 
	-  Count unique values based on another column
 
	-  Putting Values of 3 columns into one column using If ElseIf statements
 
	-  VBA to delete multiple rows based on multiple criteria?
 
	-  VBA Or Macro: To format data in a column and delete columns and create new column
 
	-  Compare one column with one cel and input result on a second column
 
	-  Solved: Obtain Pivot Table Cell properties with VBA
 
	-  set color saturation of image with vba
 
	-  Solved: Worksheet change copy to next cell
 
	-  Turn an image into a toggle button
 
	- [SLEEPER:] Z Axis of 3D Graph
 
	-  Solved: Formatting Data Imported From Web
 
	-  Question on Formula
 
	-  Solved: open with filedialog and copy to  my workbook
 
	-  Google Maps, inputting destinations
 
	-  Copy cell range to anther sheet containing;..
 
	-  Help with Copy and paste
 
	-  error in displaying value on a cover page
 
	-  Copy data in a Filter table then email it
 
	-  Copy from Listbox to empty sheet
 
	-  Solved: Conditional formatting, if cell1-cell2>0.2
 
 
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.