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. Finding Alpha Numeric in string and delete row
  2. VBA/ Call Function and sum from different sheets
  3. VBA Code to deploy plots
  4. Dynamic form question
  5. Extracting ContentControl Data from a Word Doc into an Excel Sheet for analyzing
  6. Verifying emails have been sent
  7. [SOLVED:] PivotTable Error
  8. Related to Thread: Colour Entire Row Base on the Value of Two Other Cells in Excel
  9. [SOLVED:] Exclude Dir dot & dotdot from listbox
  10. [SLEEPER:] RecordSet in Excel VBA
  11. Closing workbook without close button
  12. [SOLVED:] Recording data from outlook to an open spreadsheet
  13. Formula Last Cell value in row but placed in the same column
  14. [SOLVED:] VBA Function - Portfolio Volatility using Co-variance Matrix
  15. [SOLVED:] Show Message Box for Limited Time Period before continuing with remainder of code
  16. [SOLVED:] Name Manager question
  17. VBA code required to delete Right click menu over SHAPES
  18. form question
  19. Simple VBA macro - move cells, pull data from adjacent cell
  20. [SOLVED:] Convert-Calculate and Convert Again
  21. Consolidating Multiple With Statements to Run Faster
  22. Copy Hyperlink from Image to Text
  23. [SOLVED:] VBA Userform Issue
  24. Tagging Type based on Criteria in the file
  25. [SOLVED:] Is there a way to add music by vba code?
  26. Sending Text to an existing Batch Script to be used as variables (Encoding)
  27. Run-time error '438': Object doesn't support this property or method.
  28. VBA auto copy-paste from Excel to Word works but no source formatting!
  29. Help With Applying Numeral Limitations in VBA Forms
  30. [SOLVED:] Userform Appearence
  31. [SOLVED:] Help With Option Buttons in VBA UserForm
  32. The query did not run, or the database table could not be opened
  33. Help with "dim as"
  34. Compile Error Regarding If Statement
  35. Using Option button in userform
  36. [SOLVED:] vba array into combobox userform
  37. [Help]Export ListBox contents to new workbook via CommandButton!
  38. VBA to collate information from 3 workbooks into one Ranked Table using filter
  39. Need assistance in the code
  40. Add new project number to user form
  41. Need to generate ID when pulling files from shared folder
  42. [SOLVED:] Passing variables from userform to normal module based on command button clicked
  43. [SOLVED:] find "w" instance in column and count within range then change the next "Daily" val.
  44. Remove bits from a byte
  45. Loop thru sheet and send emails
  46. [SOLVED:] input msg error when "Cancel" button is clicked --
  47. VBA Files "clashing"
  48. Email through excel from lotus notes 9
  49. [SOLVED:] Specific formulas not working in Loop_all_files_in_folder macro
  50. [SOLVED:] Macro copy & paste into new sheet if condition is met?
  51. VBA, Looping directory with calculation Error.
  52. Enabling Macro to Active When Multiple Cells In Column Change
  53. Copy Cell Color to Another Cell & Changing Graph Color to Match Cell Color
  54. For Each digit in a multi-digit number
  55. Loop help
  56. [SOLVED:] Issue with Basic If statement code to change data in a column
  57. Help With a Sub
  58. Extracting data from a table
  59. Macro / VBA help for a complete newbie, please? Auto-delete data/helper cell
  60. Extract data from between two dates..
  61. Autofilter with more than two criteria
  62. variable email title in outlook while sending in vba
  63. Loop through every auto filter drop down, copy result cell and paste to another sheet
  64. [SOLVED:] Help with Worksheet_Change
  65. [SOLVED:] Custom Object Self-referential Events
  66. Sleeper: VBA Best practice
  67. How to fast read/write Excel VBA array contents to and from text file!
  68. How to fast read/write Excel VBA array contents to and from text file!
  69. [SOLVED:] Changing the Value of the ComboBox
  70. [SOLVED:] Combine data in two column if sum of column is same
  71. Split on cell into various rows with VBA
  72. [SOLVED:] Copy pivot table and paste it in to next available column in same sheet
  73. Code to be used for all the ranges in the column
  74. [SOLVED:] Run-time Error 1004
  75. Loop thru excel workbook and send sheets not working
  76. [SOLVED:] Non-Contiguous columns in multiple workbooks into New Workbook - Efficiency?
  77. Import large text file. Please help me to fix this code.
  78. Making key binds to vba userform buttons
  79. Trying to return value deep within the Locals window
  80. How to add an Pop-up message
  81. VBA Extract Matching Data from Worksheet Named Range
  82. Add row if text is not identical to above cell
  83. [SOLVED:] ASSISTANCE NEEDED PLEASE. If..Then.. ElseIf statement that loops.
  84. [SLEEPER:] Merging multiple excel file into one
  85. [SOLVED:] Modify code to look for certain sheetnames
  86. Sleeper: Code not deleting shape
  87. runtime error 13
  88. VBA using IF to populate msgbox
  89. Copy & Paste to new sheet if cell contains data?
  90. Find the duplicate and create a pivot using VBA
  91. Help with worksheet loop
  92. Find the Max of s Subset within a Subset
  93. Code to select current open workbooks under ComboBox n Userform
  94. [SOLVED:] Copy Rows and Paste Values
  95. Input Box to Sort by row
  96. VBA second half repeats twice
  97. [SOLVED:] How to trim a string from both sides?
  98. VBA code problem with random numbers generations
  99. [SOLVED:] Range Selection Then apply formula with third column over
  100. Use VBA to output file automatically
  101. VBA Transpose every 4th row, loop until empty column
  102. Highlight Row Based on Cell Value
  103. Decode vertical text file to horizontal text file
  104. [SLEEPER:] Running macros on files on SharePoint Server
  105. Interaction on Child IE Window
  106. Sum problem help for a novice
  107. Excel cell value as string won't store
  108. VBA to block black filled cells as sheet updated
  109. Match and statements in sheets
  110. [SOLVED:] Delete Scooby (Shape)
  111. Vba Code for data set passed with each press of a button.
  112. VBA code to run other macros
  113. [SOLVED:] Worksheet change event help
  114. [SOLVED:] Macro from this pseudo code?
  115. Sleeper: VBA Saving a Word Document with a reference to an Excel Cell
  116. [SOLVED:] Change macro to produce PDF's instead of workbooks
  117. Loop through code, move across a columns
  118. VBA: Detect whether Office 365 subscription or purchased Office version
  119. code does run too slaow and too long
  120. Reading data from one spreadsheet into another using VBA
  121. [SOLVED:] Worksheet Activation and Change issues
  122. [SOLVED:] Calculated field in Pivot help
  123. Creating a Folder in Sharepoint, if it does not already exist from an excel userform
  124. Identifying Object that initiated VBA sub-routine
  125. Need help in aligning data in different rows
  126. [SOLVED:] Change a worksheet's code name to Sheet1
  127. [SOLVED:] Attempting to extract 3 column listbox values after adding new row
  128. Count checked fieldform and content control boxes from word using excel
  129. VBA color index
  130. [SOLVED:] Advanced filter help
  131. Find cells containing A two letter string by itself
  132. [SOLVED:] rearranging the rows and columns
  133. [SOLVED:] Calculate time spent in each job role.
  134. [SOLVED:] Sum a range across multiple Worksheets
  135. Reconciliation Macro Help
  136. Match values from different columns
  137. [SOLVED:] Next without For Compile Error
  138. Extract files as a object into excel from folder path
  139. Help with ComboBox In userform
  140. Solved
  141. [SLEEPER:] Code to Force Macros Not working WHEN extended
  142. Textbox number of digits allowed
  143. Linking a textbox to a worksheet sub
  144. Applying If statement to string
  145. sumif criteria based on cell color
  146. [SOLVED:] How to Speed up Code without Excel falling down - EXCL 2013
  147. Protecting a Sheet But Allowing Certain Features
  148. Mscomm32 (using Netcomm) reading issue with USB to serial comport
  149. Internet Explorer VBA Automation - Help with one issue needed
  150. VBA to import excel data in word document
  151. Ned help with vba error
  152. [SOLVED:] Hiding Rows from a Function
  153. Sum Alphanumeric (Multiple selection)
  154. Excel to return looked up values from drop down list?
  155. [SLEEPER:] Excel Macro to make Bloomberg refresh Data?
  156. [SOLVED:] Text outcome coming out reversed
  157. Auto Picture Insert in Excel 2007
  158. [SOLVED:] my old code is strange today
  159. [SOLVED:] Formula Help
  160. Use of Indirect or other method to pass data between sheets
  161. User Form help
  162. User Form textbox mismatch
  163. [SOLVED:] Some incorrect results from a formula
  164. DELETE COLUMS
  165. [SLEEPER:] VBA code to fill in a combo-box of an IE site linked from another IE site
  166. [SOLVED:] Highlight Cell Based on Number of Times its Value changes
  167. Making an Auxiliary Table For Grade Distibution
  168. Excel Formula for the below conditions
  169. Updates on Vlookup/VBA regarding scan components
  170. [SOLVED:] Check string length
  171. [SOLVED:] auto filter blanks
  172. [SLEEPER:] VBA code to delete row that meets certain condition
  173. [SOLVED:] trying to build an array from a userform listbox
  174. Extract and Recombine Multivalue Path Parts Using RegEx UDF
  175. Making a Histogram (Grade Distribution)
  176. [SOLVED:] Changing tab colors based on a list of tabs and cell value
  177. [SOLVED:] Checking a Range for a Value, If another cell has a specific value
  178. Multiple criteria comparing
  179. VBA code to generate letters in one cell
  180. macro does not run
  181. [SOLVED:] Change Long Date to Short
  182. Two-Way Editable Links Over Different Worksheet
  183. [SOLVED:] VBA to add form data to multiple sheets.
  184. Date Formatting Issue
  185. Macro for adding and verifiyng country code phone number(prefix)
  186. Rotating Tasks
  187. Macro for Depulicating Multiple Columns in Excel
  188. Making an auxiliary table with adding new data
  189. Making a Table
  190. Search Column for Word in an Array, If Found Paste Replacement in Adjacent Empty Cell
  191. Comparing Data From Two Sheets and Find Non-Matching Values
  192. [SOLVED:] Selecting worksheet that is called by macro range
  193. [SOLVED:] Changing Tab color to "No Color"
  194. Need help to correct code
  195. [SOLVED:] Userform - textbox value format as a time
  196. xml add column range B:C5000
  197. [SOLVED:] Extract pivot table data list table
  198. Excel database - Userform doesn't work out
  199. [SOLVED:] Out of Stack Space
  200. Sleeper: VBA code for random numbers generation and sorting problem
  201. VBA Code to Search and Select Sheet through Input BOX
  202. [SOLVED:] need help in cells count According to color
  203. [SOLVED:] Shading Every Other Row
  204. Share files from VBA
  205. Making an Auxiliary Table For Counting Colored Cells
  206. Excel2000 Sendkeys VBA
  207. Excel VBA code reads wrong innerHTML code
  208. help with porject
  209. [SOLVED:] Code works every other time
  210. UserForm to Sort Worksheet
  211. Need Help ASAP Issue with Subs
  212. repeating the copying of cells from one worksheet to another
  213. Run time error 462 the remote server machine does not exist or is unavailable
  214. [SOLVED:] error after change const to intger
  215. Protect List Validation
  216. VBA, Email sending out from Excel question, please help :)
  217. VBA code to copy and paste a sheet from a workbook containing a particular name.
  218. Email Watcher Help For .display
  219. Go to cell based on value of another cell
  220. [SOLVED:] Vlookup VBA by select range from another workbook
  221. Need either VBA or formulas to count and then sum up range value in a column
  222. DISABLE PASTE INTO ANTOHER WORKBOOK
  223. NEW TO VBA NEED HELP PLEASE!!
  224. Insertinf formulas using VBA
  225. [SOLVED:] Drag a formula down to the end of a list
  226. [SOLVED:] Code for a Calendar W/Notes
  227. Loop for spefic condition not working
  228. [SOLVED:] Copy data from one worksheet to another based on date
  229. [SOLVED:] create a summary
  230. [SOLVED:] Copy content of one excel to another if matching the sheet name
  231. VBA code to copy and paste a sheet from a workbook containing a particular name.
  232. Copy data in corresponding cells
  233. [SOLVED:] Loop search multi column listbox
  234. Copy Range to Another sheet if Cell Match
  235. Inputbox to filter pivot table field
  236. Angle between two coordinates
  237. [SOLVED:] TextBox VLookUp not diplay message if EAN is wrong
  238. [SOLVED:] Copy rows based on criteria
  239. Fixed formatting of combobox?
  240. [SOLVED:] Need help modifying a VBA code to add an exception
  241. [SOLVED:] CTRL + Shift + Down in a Macro?!!?
  242. Combine and sort 2 columns
  243. VBA: wait for object to finish not working properly
  244. [SOLVED:] Filter more than 2 values
  245. [SOLVED:] Copy the contents of a worksheet which includes merge cells and make multiple copies
  246. [SLEEPER:] Update Access Table (INSERT INTO)
  247. [SOLVED:] Clear Sheet Row Containing Combobox Selection without Affecting Formulas in Row
  248. Moving Range, Find & Change Value
  249. Derive bearing & direction from a declared decimal degree position
  250. VBA Code to add to the below that will do a vlookup on certain columns that are merge