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

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