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