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

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