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