PDA

View Full Version : Excel Help



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

  1. Runtime Error 5: Invalid procedure call or argument
  2. problem unprotect vbproject
  3. Error 461
  4. Solved: textbox disappears
  5. XL2000 Add-In Question:
  6. Compare VBA Code in Modules
  7. Solved: Quick Concatenate Question (formatting)
  8. vlookup closest value
  9. Solved: Closing Excel by clicking the Red X
  10. Solved: set row color based on value of a cell
  11. Solved: TextBox Character limit
  12. Solved: VBA to count characters in cell - getting error
  13. Solved: Date and time
  14. Solved: Combobox linked to calender
  15. use excel database to populate 2 different word doc
  16. Solved: modify code to run on several sheets in a workbook
  17. How to get to the single dictionary entry without knowing its key ro value?
  18. Progress bar Running on top
  19. Solved: total by company
  20. Solved: Insert comment
  21. Excel form to database help
  22. Chart Help::Stacked Column
  23. What Causes “Personal.xls” to be Opened?
  24. Stringlists or String arrays
  25. can't call subs automatically
  26. Data Validation issues
  27. Rename controls in VBE
  28. Solved: Delete emty rows.
  29. Solved: Join Sheets Cells By Common Field
  30. Using Variables in VBA formulas
  31. Solved: Remove a shapes
  32. Solved: Range Error during loop
  33. Search value as the part of the Sheetname
  34. Solved: Select variable range of rows and then delete ??
  35. How to Add a File to References List with VBA
  36. Loading malformed xml into MSXML2.DOMDocument
  37. Different sound file question - simple ??
  38. Solved: Select copy & paste
  39. delete blank rows
  40. Solved: Changing Values Between Text Boxes
  41. Saving a Worksheet
  42. Applying Format To ALL sheets in Workbook
  43. Solved: How to sum a range of cell values based on common data field
  44. Solved: How do I sort a dynamic named range?
  45. Solved: Unhide and activate sheet based on system date
  46. Problem with error type mismatch
  47. Solved: Delete Text to Left of First Number
  48. Merge cells based on a cell value
  49. Make VBA Code Shorter
  50. Solved: download files from internet thruugh VBA
  51. Linking to formula rather than paste special
  52. Event for Ctrl-G
  53. Help in Vlookup function error
  54. What Message Is Being Written?
  55. make textboxes visible at runtime?
  56. alerts out of a spreadsheet based on dates
  57. Solved: Distribution Graphs
  58. Solved: How To make Macro Interactive
  59. How to know value of margin of the last row on page
  60. Date formula required
  61. I just want the Date, not the time (CDate(Now))
  62. Userform triggers Excel Crash
  63. Need help about listbox column count property
  64. Special Calendar to fill textboxes
  65. Solved: Conditional Format VBA not using Range Name Value
  66. DSO and File Properties
  67. Solved: Inserting an undetermined number of rows?
  68. How to tell user to get updated copy?
  69. UDF for Three Parameter hlookup
  70. Solved: Count Formula Based Currency Criteria
  71. Solved: Copy the table in Word document to NEW Excel file
  72. How to open a secured directory
  73. Same code - one set works but other does not...
  74. Solved: run access macro from excel
  75. Multiple Excel ranges to multiple Word tables.
  76. Solved: Flashing commandbutton?
  77. Copying Data from different workbooks
  78. print preview , value of ending line on page
  79. Solved: Countif with a Range Name as the Criteria
  80. Super Quick ComboBox Question
  81. Solved: Modify Hyperlink Code
  82. Need VBA help with populating missing data??
  83. Solved: move to textbox in other sheet if is "TAB" pressed
  84. Sports league VBA program
  85. Listbox items getting transferred in reverse order
  86. Password to open file via macro?
  87. Message box to appear once commandbutton is pressed?
  88. Copying from a PDF file
  89. textbox validation help please :-)
  90. Solved: Code randomly stops without CancelKey Disabled
  91. Mega Sort
  92. checkbox to populate 2 textboxes?
  93. How to make a text box mandatory?
  94. Excel 2003 File Size
  95. start search from beginning with static variable
  96. Importing part of textfile
  97. Solved: Printout Problems
  98. Sorting CurrentRegion?
  99. EXCEL TO WORD BOOKMARK
  100. Solved: Set X-Axis Value to match row numbers
  101. Worksheet change - single click>value entered
  102. is it possible to do screen tips without hyperlinks
  103. Solved: Highlight only certain words in cells
  104. Using data in a worksheet and vba to complete a form on a website.
  105. Late-binding --pls sort out the confusion
  106. calculating monthly returns in table from historical data
  107. Autohyperlink to and replace file names in worksheet
  108. Set TextOrProperty attribute change the name of company
  109. ListBox Item queries
  110. Selecting a sheet within a workbook by using a macro
  111. Solved: Excel insists on changing the format of cells
  112. Solved: VBA to delete text between < >
  113. Count all unique entries in a column (mission impossible?!)
  114. Solved: From Excel, create table of selected rows in Word
  115. Delete Custom Document Properties?
  116. Reading pdf file into excel 2007.
  117. copying information from another tab
  118. Solved: add slash in string
  119. Combination from binary bit to Hexdecimal
  120. parsing in vbscript
  121. Solved: Batch Renaming all files in a folder
  122. Solved: UDF for mann-whitney statistical test?
  123. Solved: Filter Workbook when protection is on
  124. Solved: counting number of observations under condition
  125. calculate % of each items total in a year in Pivot Table
  126. Solved: Small macro, simpler way of writing it?
  127. Insert Template Macro
  128. Solved: Deleting multiple values within range of rows
  129. Check for visible rows after filter
  130. Solved: Multidimensional Array Sort
  131. Need to nest .Find routines in VBA
  132. Finding mode of array in VBA
  133. Fusing chart and shapes before copying
  134. Solved: Delete row (numbered) all other rows (numbers) change in sequence
  135. Solved: Arrows in Excel Document
  136. Solved: strange Unload Me behaviour
  137. transferring selections from one list box to another
  138. Insert A row in workbook A automatically if a row is inserted in WOrkbook B
  139. Remove the file extention from the file list
  140. Solved: to accept changes
  141. Solved: copying dynamic range from Sheet1 to Sheet2
  142. Solved: .bas vba export question
  143. Searching a record or row.
  144. Update the value from B file to A file
  145. Solved: Command Buttons to SAVE, SAVE and EXIT and to EXIT without SAVING
  146. Solved: Passing variables between suns and functions
  147. Pasting charts in the same document - avoiding new instance creation
  148. Array help, deleting columns.
  149. Combining vba for forcing macros and expiry
  150. Solved: Extract Data From Text File
  151. Return a value from an activex
  152. Solved: Find string in the cell and then output value
  153. Solved: Argument Not Optional Error
  154. Not Highlighting Errors
  155. Solved: Deleting rows from selected cells.
  156. force users enable macros and auto save&close if idle
  157. Custom menu top left
  158. Delete WB-Open sub as WB is saved
  159. Need a String Function
  160. Save As Issues (excel 2003 and excel 2007)
  161. zodiac userform to display zodiac sign picture based on users birthdate
  162. Solved: Initializing Entire Array at Once:: Syntax Error
  163. Delete VBA Project
  164. Trouble With Assigning Value to Cell
  165. Carriage Return not working
  166. Imbedding Image File Instead of Referencing?
  167. Solved: Copy module from present file to PERSONAL.XLS
  168. Excel multi criteria search
  169. optionbuttons and vba
  170. Solved: Extracting 5 or 6 digit numbers from a cell
  171. removing items from collections
  172. Compare Workbook to 2nd workbook (Newbie)
  173. Solved: Using Bold with .Cells Object?
  174. Really Quick Precision Question
  175. enter commas
  176. Problem with Cancel Button in Input Box
  177. problem with activecell is blank or zero
  178. Solved: Force users to enable macros in a workbook code by Ken Puls.
  179. Unhide a Hidden Workbook
  180. multiple search and filter
  181. Call tracker - VBA coding help
  182. Solved: Combo Box inside pop-up Message Box ?
  183. Case Select Statement
  184. Filling an array with a for..each construct
  185. Solved: VBA code for a button with user supplied titles
  186. entirecolumn.hidden with autofilter result
  187. Closed: sendkeys
  188. Solved: vba to make formulas work
  189. Cant read txt file with Unicode symbols and store it to cell
  190. Formula Referencing other cells
  191. Excel Macro that creates an Auto Macro
  192. Exclude a single xl file from macro
  193. Return cell address in messagebox
  194. Combine 2 similar worksheets (live document)
  195. Solved: excel to word for Labels
  196. Match function for 2 columns
  197. Insert Rows
  198. Save different filename based on multiple selection
  199. Need a solver
  200. Make other cells invisible or locked programmatically
  201. Solved: Simple question for CheckBox in sheet
  202. Solved: shapes in a worksheet
  203. Solved: excels AND function
  204. Solved: excel's IF function
  205. Cnverting Excel if into UDF.
  206. VBA Performance Query
  207. Compare Columns
  208. Excel CSV Read issue
  209. Accessing Excel Spreadsheet via Sharepoint
  210. Look For and delete
  211. Copy/Past cell contents into a PDF Field
  212. [SOLVED] TAT Calculate in office hours
  213. Button w/drop down list
  214. IF, Solver and Clearing Cells based on the IF
  215. Linking excel with folders and show the content
  216. Excel values to Website, web data extractn back to Xls. PLEASE Help!!!
  217. Solved: Using comments to track changes
  218. working on range
  219. Hyperlink to Chart or Range by Double-click Named range
  220. Regarding getting values for Multi Column LISTBOX
  221. Solved: Create Multiple Sheets and Save As CSV (COMMA DILIMITED) FORMAT
  222. Solved: deleting duplicate rows
  223. Solved: Finding Specific Days In a Year
  224. Need Code to Check if .CSV file has finished writing
  225. Solved: How to rename text file to date and time format
  226. Solved: Selecting a hyperlink using Data Validation
  227. Link userform check boxes with corresponding text boxes
  228. Solved: Hide row with a 1 on selection change
  229. Hide comments programmatetically
  230. How can i speed this up?
  231. Solved: Converting Minutes Into Hours
  232. Copying Worksheet to another book with new name
  233. A little (?) VBA help
  234. Solved: Delete a CSV Workbook from Another Workbook?
  235. Solved: Validation In Cell
  236. Protect a column ins workbook with macros
  237. consolidating the difference in counts on hourly basis
  238. count subfolders
  239. Solved: Finding the rows of a Selection
  240. Sampling after Auto-filtering
  241. Solved: Find does not do an exact match
  242. Solved: reversed sequences in code
  243. Solved: Return Sheet Index of Last Sheet
  244. find next and loop combined
  245. Solved: variables carrying over from userform to Module
  246. Blank or null string in drop-down
  247. Solved: Get state of checkboxes
  248. Solved: userform textbox format for currency
  249. Solved: Formula property compile error
  250. Excel Creating an Email Error