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