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

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