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. 430 Error when Macro Run
  2. Solved: Operate with data from txt file
  3. Solved: Macro to Re-arrange Data
  4. Create Search Form
  5. VBA Array Filter
  6. Computing average over columns with VBA
  7. Solved: Inconsistent updating of spreadsheet formula when changing file name
  8. Solved: VBA -- IF Statement
  9. Solved: Detecting when a different sheet is made active without using Worksheet_Activate
  10. VBA Vlookup
  11. Empty vs Zero
  12. Solved: VBA function procedure homework help
  13. Solved: VBA average and standard deviation homework help
  14. Populate a useform textbox with text from Control Box form
  15. Data editing/moving/arrange.
  16. Number Format Short_Cut
  17. Extract Text from Word Document and Put in TextBox
  18. Solved: Combobox: Enter, Tab and Backspace Keys Not Triggering Keypress Events
  19. VBA to Concatenate Variable Range
  20. Solved: copij formula in protected sheet
  21. Specify paper tray
  22. Excel VBA Get Internet Explorer Data
  23. Solved: Cancel a Loop if .Find Parameters Do Not Exist
  24. Solved: Workbook_SheetChange and If Not Intersect error
  25. Buggy Pivot Tables?
  26. Tooltip on Labels
  27. Help Referencing Other Spreadsheets
  28. Solved: Using a loop with Select Case
  29. Solved: (How to) Transpose one long list of numbers in CSV file to a number of rows
  30. Solved: Strange behaviour of =cell("filename",A1) formula
  31. PDFCreator automation in VBA Excel
  32. Two Quick Questions: Using Count Method + Using Offset Property
  33. Solved: Macro to change text to date in a set range of cells.
  34. Solved: Clear Specific InteriorColor Index
  35. How to pass combobox/textbox selected member into sql string in main module
  36. Fastest Way to Build a List
  37. Solved: Save File routine
  38. [SOLVED:] Help with additem from textfile
  39. Simple Copy/Paste code
  40. Create new line for each slash in field
  41. Solved: Counting with SumProduct
  42. UDF and Select Case
  43. [Help] Exporting data and filling columns
  44. Highlighting Min Median Max and Percentile90
  45. get value from local html file
  46. [SOLVED:] Cell Value vs Text
  47. connected combobox
  48. Solved: Excel file that lists the file names in the folder
  49. Attach Hyperlinked Documents to email
  50. Market Survey Monte Carlo
  51. Using VLookup in Excel
  52. Using excel to get email dates from Lotus Notes
  53. Sum particular cells
  54. Solved: Counting Models
  55. [SOLVED:] Disable Double Click
  56. VBA to format windows directory listing?
  57. Solved: clean lines if more than 10 lines in column
  58. Userform code module too big, how to reduce size
  59. Find and replace within VBA modules
  60. VBA Search Multiple Sheets help
  61. Solved: Help to shortened code as its too complex for maintenance.
  62. Lookup code in Userform errors out
  63. VBA Save As Prompt Help
  64. Controlling MS Word from Excel VBA
  65. Solved: Array Countif that will ignore Formula Blanks
  66. [SOLVED:] Another Option Instead of Using Multiple SumIfs?
  67. Solved: TextToColumns question
  68. Different footer for each page of a sheet
  69. [SOLVED:] Get PDF page size
  70. VBA File Sucurity Code
  71. Solved: Sort all files in a folder and open the latest one
  72. VBA: Enable Editing
  73. Example Excel Database?
  74. TextBox Challenge
  75. Solved: moving texts separated by a dash (-) for the bottom row
  76. Trawl directory, format that data into a new list
  77. Add Loop and timer
  78. Solved: VBA What If Analysis (Data Tables)
  79. Difficulties with a userform
  80. Error 1004 copy of object failed
  81. Find string within a string and highlight
  82. Solved: automatic change of tab names
  83. excel vba
  84. VBA code for inserting blank row in between the data points
  85. Runtime error 5 - manipulating strings & Ascii
  86. Solved: Error 1004 when trying to sort data
  87. Solved: Excel Database Search Engine
  88. Dots to comma in userform
  89. gmail send mail with noreply
  90. Help - Custom right-click menu in Excel 2013 64 bit
  91. Grouping data
  92. Solved: file list with last accessed date ....
  93. Tidying up - loop from excel to word
  94. [SOLVED:] Adding the exact IDs
  95. Dynamic chart ??? VBA
  96. Linking cells, sorting by values in column
  97. Automatically combine multiple sheets
  98. Solved: show, either conditional formatting, icon sets, or change font colour of userform Lbl
  99. Autofill or something else to multiply a formula
  100. 50 REWARD for urgent help
  101. Solved: Change word file generation depending on a selection
  102. macro to filter on each unique record and print range
  103. VBA SUM OF COLORED CELLS?? PLEASE HELP
  104. search for date in column
  105. VBA copy cells from one book to another
  106. Odd error -
  107. Network days in a calculator
  108. Solved: User defined function not appearing
  109. Datedif (FULL MONTH)
  110. How can we find to what correspond some values in a function?
  111. keystroke event
  112. Concatenate Excel Files
  113. Solved: Userform entry
  114. Solved: Prevent useform from pulling data from other open workbooks.
  115. Solved: Inserting rows after highlighting a cell
  116. Solved: Error Handling strange behaviour, it only works the first time
  117. Solved: auto quick info feature is not working
  118. Find text string in multiple workbooks
  119. Protecting excell file...
  120. Textbox Validation
  121. Solved: Run-time error '13' on an If stmt
  122. Finding a string within a string multiple times
  123. Userform Repaint
  124. Solved: Calculating Future Costs
  125. Trying to determine if certain fields are unhidden.
  126. Content in Outlook email from range
  127. Networkdays macro automization help
  128. Consolidating Multiple Protected files into one
  129. Use a spinbutton to change items in listbox and update sheet that populates listbox
  130. Solved: Exporting VBA array to existing Access DB
  131. I can't get the correct Rows to delete
  132. Solved: Combine Multiple Workbooks Into A Summary Sheet
  133. Solved: Userform to start with another worksheet
  134. Addition to code
  135. how to create word document based on data in excel
  136. two-variable data tables
  137. Solved: Help Running SQL USP in Excel
  138. The online database؟؟؟
  139. Solved: sort specific columns
  140. Data from one wks to others
  141. ClearContents (Differnt columns)
  142. Reading from a Website
  143. Solved: UserForm For Item Additions
  144. KeyCode = 9 Combobox Disappears
  145. Peekmessage and Excel 2010?
  146. VBA Q
  147. [SOLVED:] Post to view attachments?
  148. Find and Findnext Problems
  149. Userform - picking name from sheet
  150. Display value in a cell if between 2 other values
  151. Passing array from one function into another function
  152. Solved: VBA Offset help
  153. Solved: Sum particular cells
  154. Solved: How to get data from UserForm2 into UserForm1?
  155. Solved: Trying to add two numbers together, but instead they are stuck next to each other??
  156. Copy & paste in next available cell
  157. "Subscript out of range" failure. Working with two workbooks. ShellExecute
  158. Data Validation - How to update cells when a name is selected from a Data Validation
  159. mvlookup unique values
  160. Solved: onchange event fired by deletion of row or adding row
  161. Solved: Sum a column based on multiple criteria in different columns
  162. Solved: Access Combobox Entries found in a Userform from Another Userform
  163. strange with excel 2010
  164. Error Messages
  165. taylor/maclaurin series
  166. Cells.find in loop error -> return to the beginning of loop
  167. macro not working for if function
  168. Solved: Track Changes On Row Delete
  169. Solved: show pdf from userform pdf reader based on "file.pdf" from cell reference
  170. Copy Columns Based off VLookUp Result
  171. VBA assistance to separate out strings btw semi colons in cells and copy each indi
  172. change in VBA
  173. Solved: Print page by user input
  174. Solved: If Vlookup, Formula is case sensitive???
  175. Sleeper: Build business days calendar
  176. Combo box display
  177. Solved: Limiting Toolbar Form Controls Checkboxes
  178. Question on Array
  179. Need help to improve code
  180. Run time error 445 "object doesn't support this action"
  181. sound file duration
  182. show/play powerpoint in userform WeBbrowser?
  183. Please help me edit code
  184. Solved: Conditional Format Only On Filtered Records
  185. Download excel from website that uses ASP
  186. Solved: Copy the data
  187. send email notification from excel to multiple recipients
  188. send email notification from excel to multiple recipients
  189. column chart seriescollection transparency
  190. Sort in Excel with Multiple rows and column
  191. Pop Up Message On Conditional Format Criteria
  192. Running Stopwatch Assigned to Buttons
  193. Accessing data in getelementbyid() model
  194. Solved: Help for loop function
  195. Solved: Help Using VBA arrays.
  196. VBA assistance to modify code
  197. Need help for edit code
  198. Run code under specific criteria
  199. Problem with trying to create a data entry screen template
  200. Need to pick up the row and column of a cell?
  201. Solved: Please assist in copying row found during Do Loop to new sheet.
  202. Solved: Compare and delete duplicated data
  203. Events to go to certain parts of code after a value is entered
  204. Dim "refrenance to cell text" as integer
  205. Solved: Manipulation on Array elements
  206. Solved: Copy Selected Data to New Worksheet
  207. Solved: Add commas on each line into cells
  208. How do you read all cells in a row?
  209. Solved: find the data on 2 sheet delete the row of second sheet
  210. What reference do I add to access .net objects from Excel VBA
  211. Continuous Looping, help!
  212. Hyperlink - Listview
  213. auto show a window
  214. Solved: Loading a listBox
  215. Solved: Using VBA to Sum changing groups of Rows
  216. Solved: Merge column by select them
  217. I need help edit code auto sort
  218. duplicate records extraction with percentage requirement
  219. VBA Country code from Cell Range
  220. Embedded Chart Events - Selection Object Erratic
  221. Solved: Only show maximum value of repeated data
  222. Predefined "Save as"
  223. Solved: Progress bar almost working
  224. Thematic Map India
  225. Count number of cells in worksheet_change
  226. How to assign values to the strings came from combo boxes on the basis of text..?
  227. hide #value!
  228. Rolling calculation
  229. Advanced Filter From Varying Criteria Range
  230. India Map
  231. Separate rows depending on specific criteria
  232. Solved: Getting the path to a folder from just the folder name
  233. Solved: Percent of Row Group in Pivot Table?
  234. Conditional IF Based on Cell Value
  235. Automatic consolidate report from selected excel files
  236. run macro from closed workbook automatically for every 24 hours
  237. Solved: Passing data from userform to sheet/cell
  238. Solved: Pop Up Message On Cell Value
  239. I Need help edit code copy and past
  240. [SLEEPER:] How to add fancy controls to userform
  241. Solved: Formula to Add to date Change
  242. Userform_Activate
  243. Run VB application via VBA
  244. Solved: SUMPRODUCT - Multiple Cells (Looking for VBA Method)
  245. Question about drawing table list box
  246. Adding a new row will break my little VBA script
  247. Need some help with date
  248. Conundrum
  249. Solved: UF countif in range
  250. Dynamic selection of columns in Excel