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. VBA Code for Searching\Renaming files in a folder
  2. Automatically increment single cell from 15 to 150
  3. stop incrementing
  4. VBA code help to sum values in conditionally formated cells
  5. [SOLVED] How to count no of shapes in a group?
  6. Any suggestion for VB self-learning resources?
  7. VBA Macro for taylor Series of Sine (x)
  8. Listing rows associated to a value in Col A, by selecting related value in Col B
  9. VBA - Draw line to next high value
  10. Select PivotItems from to...
  11. [SOLVED] Split Cells that have Alt+Enter Text Into Multiple rows and fill rows accrodingly.
  12. VBA Coding help - Multi-page User Form, vlookup, and INTERCEPT
  13. Email macro works 1 time on excel sheet and stops
  14. Clock not working properly
  15. email macro stops on Debug Run-time error '91'
  16. Customer accounts balance(debt,credit) vba
  17. Pivot Table: pct by rows
  18. [SOLVED] Need Help with this macro, please! need to return unque values from within range
  19. [SOLVED] hh:mm:ss conditional formatting
  20. How do I populate a listbox in Excel Userform with data from the non active sheet
  21. update date automatically hen saved
  22. Link last Checkbox in Column to Cell below
  23. Variable in Loop
  24. Run time error help
  25. [SOLVED] Send Data to Alternate Userform
  26. Saving Autocorrect entries into different languages using VBA
  27. Do tables work with well macros.
  28. Help in VBA to transfer data into multiple files in a folder
  29. [SOLVED] Modifications to macro that copies cells that contain the name of a worksheet
  30. [SOLVED] Speed up VBA code
  31. Programatically Add Reference
  32. Mass Find and Replace VBA - Need Help
  33. [SOLVED] Show Area of Freeform Shape
  34. Email macro
  35. [Novice] VBA Looping Macro
  36. Find and Replace
  37. Using Excel VBA to Scrape Web Table Data
  38. How to get the name of USB port name
  39. Problem in converting charts in workbooks to pictureP
  40. objFolder.GetDetailsOf not working
  41. Filter ShapeCount for Grouped Shape
  42. Count if vs a trade with 'todays date formula' help
  43. [SOLVED] Loop values from data validation list vba
  44. Creating and displaying 16 frames on a userform each frame two labels.
  45. Selecting the row with the highest value
  46. Userform vlookup, copy row data, display each found in sequential order in same form
  47. Running Code in Visual Basic Window Versus in Excel
  48. Double Type error 13
  49. [SOLVED] Newbie help on row count as range
  50. Formulas with Minus
  51. Using Input Box Variable
  52. Visual Basic run-time error 1004 work around
  53. transfer data
  54. RANDBETWEEN not stopping
  55. [SOLVED] Need help constructing a vba code to show frequency of given values within delim data
  56. VBA insert formula based on another cell selection
  57. [SOLVED] resize word pictures
  58. Run time Error 1004 - Unable to get the Picture Class..(Inserting URL images)
  59. Text Comparison between a column and a table is not working.
  60. Send or data transfer multiple conditions
  61. [SOLVED] Inserting Picture
  62. Copying table to another sheet on worksheet change
  63. Deleting text after a specific character
  64. [SOLVED] Bulk Export Worksheet Code
  65. [SOLVED] Filtering data on multiple conditions
  66. Get the reference from other sheet & go next row automatical
  67. Problems with Sum Function
  68. Pivot Table VBA
  69. [SOLVED] Build parent/child hierarchy
  70. Import data and remember file path
  71. [SOLVED] Sort using the active cell value
  72. Macro to format 2 cells adjacent to each other
  73. Formula visible cells
  74. VBA to help copy and paste few columns from pivot table 2 another table within sheet
  75. Generate a series of column data with a condition
  76. Using Calculated Field to Return the Difference Between Two Columns
  77. Acceleration of working Script. Ideas?
  78. Delete duplicate rows based on 2 conditions using VBA Macro (Beginner)
  79. counting non numeric with pivot tables
  80. [SOLVED] Vlookup or indirect,Help
  81. VBA code for Data Entry
  82. Clear and restore conditional formatting of different cells before printing
  83. [SOLVED] VBA to add series to graph only if data in column.
  84. Pivot table Error
  85. [SOLVED] Macro not working while sending email
  86. How to make excel vba crash proof?
  87. Pivot 1004 run error why?
  88. Macro to Edit Links ?
  89. [SOLVED] time degrees to decimal degrees
  90. Track updated data in table
  91. Activex Controls Combo Box unique values
  92. [SOLVED] Problem with .Find in Loop.
  93. Triggering a VBA Sub with DDE/RTD
  94. [SOLVED] Copy and paste loop help
  95. [SOLVED] Helping a student automate a couple of sheets
  96. VBA not working
  97. A-Z processing of folders
  98. [SOLVED] Delete cell data if value is high
  99. parsing txt log to excel table
  100. Add sequential # to userform once saved
  101. Search in multiple workbooks to identify duplicate values
  102. Creating a database using a VBA code with user from
  103. Index into specificied collection is out of bounds error
  104. Remove cell data for numbers over an average amount
  105. [SOLVED] add random picture to Image in Userform
  106. VBA to copy files ( list ) from location ( different locations ) to another folder
  107. [SOLVED] Searching for date in array
  108. [SOLVED] Checkboxes
  109. Loop through specific range of dates do something and then do it again for new date r
  110. [SOLVED] Creating a history
  111. Excel crashing after running macro to work with autocad and after deleting column
  112. [SOLVED] Loop through the record and summarized
  113. Combo Box selection = 2 values set
  114. Copy and Insert Rows based on value in column R
  115. VBA to save as not saving values.
  116. [SOLVED] Help With Macro to Attach Multiple Items To Outlook
  117. [SOLVED] random unique images
  118. email sending
  119. Create ppt from Excel using macros
  120. Designating Master file to excel
  121. [SOLVED] Using VBA SUMIF with multiple conditions
  122. VBA Excel - Macro simple - help needed
  123. Whats wrong with my code, copy paste does not change Array formula
  124. Easy Excel Formula Problem
  125. multiple times same control wit same function after click
  126. [SOLVED] Wanting to change the range in a Macro
  127. Freeze one cell after data is entered
  128. Copy and paste not working for macro
  129. Please help _table update
  130. Send data from excel with API (XMLHTTP in VBA)
  131. Macro(s) for importing txt-file
  132. Macro flickering
  133. [SOLVED] Using autofilter to loop and count visible cells
  134. [SOLVED] How to save as txt file name depend on current date and time
  135. Caculate Distance between 2 points on x y scatter plot chart
  136. Remove Duplicates and Replace Content Cell
  137. transfer data from excel to word
  138. Use KB shortcut keys to return a value from a range
  139. [SOLVED] Using Countif formula in vb
  140. VBA -> Lotus Email Attachments, How to better Optimize my Code?
  141. Problem with MkDir
  142. Separating data with VBA
  143. Get the shape's RGB value
  144. delete text from word
  145. Extracting resume data from word to excel
  146. VBA to centre range of images in cells
  147. how to search the next value in excel
  148. calculating time display when the macro is running (the time is a lot while calcule)
  149. Encrypt Decrypt Excel cells/ colums
  150. [SOLVED] Rename Files By Adding Last Modified Date
  151. [SOLVED] Importing file with date that changes daily
  152. [SOLVED] IF statments with weekday
  153. Opening and Saving spreadsheet
  154. [SOLVED] Adding more drop down list with my macro?
  155. [SOLVED] Highlighting every other row containing data
  156. [SOLVED] How to write last row update record in excel into txt file ?
  157. Duplicate value removal across sheets and rows and columns IN A FILE
  158. [SOLVED] Seperate unique accounts and manipulate data
  159. [SOLVED] Help with formula please
  160. [SOLVED] Help with a difficult sort
  161. RT Error 424 - Object Required, when UNIONing 2 ranges in order to sync 2 columns
  162. Need help with VBA Error
  163. "The Master" ,The one Book that rules them "ALL."
  164. .Click in IE only works every few attempts
  165. Delete duplicate rows
  166. [SOLVED] Copy and paste data from a source file to destination file.
  167. Comparing 2 Workbooks AND Their Worksheets
  168. Partial String Search cross sheet reference
  169. Combine all text files from multiple folders into one worksheet
  170. Open and Link Spreadsheet Using VBA
  171. Interactive maps
  172. Userform Help
  173. Excel 2007 3d animation engine - Tutorials
  174. [SOLVED] join an merge cells in column A but at same time the same rows in columns B and C
  175. [SOLVED] Multiply two matrices
  176. VBA Delete for Shapes Range Very Slow
  177. [SOLVED] Disbale Shift Key on workbook Open
  178. Run-Time Error '1004': Method 'HasRoutingSlip' of object '_Workbook' failed
  179. read contents of pdf
  180. Copy single row from multiple workbooks to one main sheet
  181. [SOLVED] Move an excel file to another folder
  182. Macro to copy selected cells in a row and paste into new sheet at specified locations
  183. how to display Unicode Hindi characters into combobox from mysql database
  184. How to transfer userform data to two diffirent sheets in diffirent cells?
  185. Copy the entire row if the value in column R is greater than 1 and insert above
  186. Plot a AREA in a X,Y scatter plot
  187. [SOLVED] Multiple URL's to Get External Data
  188. [SOLVED] Trigger event when pressing F12
  189. Make custom formula with VBA's
  190. Pattern Style
  191. VBA code to find fraudulent activity in data
  192. Vlookup or Index/Match code to find the value
  193. Use Bookmark To Fill in Word Document From Excel Data
  194. Dim - Compile Error: Syntax Error
  195. [SOLVED] VBA Vlookup Reflect Data to TextBox1
  196. [SOLVED] Reformat data in specific way
  197. [SOLVED] Change "Selection.CurrentRegion.Select" so macro captures cols A-Q, non-contiguous
  198. VBA help
  199. [SOLVED] My first excel VBA project
  200. [SOLVED] Search for files with ending ".csv" in a folder and work on it
  201. save and Merge PDFs From Excel
  202. Macro which auto runs when every excel workbook is opened
  203. [SOLVED] Expand rows automatically based on grouped rows
  204. Comparing 6 coloumn and highlighting the difference
  205. autonumber a string within a cell
  206. Reformat string
  207. How to Merge/ Combine , three worksheets ?
  208. VBA IF STATEMENT HELP
  209. [SOLVED] automatic E-mail using Arrays in VBA
  210. Emailing Named Ranges Using VBA
  211. [SOLVED] compare workbooks version number
  212. [SOLVED] Data lost when sending file as attachment
  213. Macro for Splitting Information Contained Within a Column
  214. Allow copy and paste only
  215. How can I do this differently and faster
  216. Highlight some of the cells in a row
  217. [SOLVED] Reset data validation drop-down list via VBA linked button
  218. VBA to save .xml file from selected Columns
  219. Combo Box Data Validation Macro not working
  220. How to extract zip files by looping through folders
  221. Reformatting Images in Merged Cells
  222. Take a text string (user input) field and resolve/parse to use defined abbrevations
  223. Automatically determines what shift is working based on time
  224. [SOLVED] picture not load after time sometimes
  225. compare value from notepad with value in excel
  226. How to unzip files?
  227. [SOLVED] VBA to assign & then access a workbook a variable
  228. Need to correct a VLOOKUP/ INDIRECT combo formula
  229. [SOLVED] Move Up or Down A Rows Using VBA
  230. Data validation query
  231. Tracking Changes to a worksheet using VBA
  232. Make report summary using VBA arrays
  233. Looking For A Programmer
  234. Header info on excel list
  235. [SOLVED] Help with code
  236. Save Sheet As New Work Book
  237. [SOLVED] Help with formula
  238. [SOLVED] change row format to show 0 as first symbol
  239. Input Box and Msg box Help
  240. Opening A Working Book and Using Copy & Paste
  241. Excel Send Rows of Data to Different Email Addresses Based upon Cell Values
  242. Formula Index, Match and Partial Match four columns
  243. VBA macro - select multiple cells, perform a historian query based on a date, repeat!
  244. how to make general range
  245. [SOLVED] getting the error "91 object variable or with block variable not set"
  246. [SOLVED] Rookie Question: Three Columns - Total, Sub-Total, Calculate Percentage...?
  247. stop errors on a user form
  248. Web Automation (Excel+VBA) - Help checking element in table
  249. Find the first cell in a column by criteria and replace with combobox value
  250. VBA Loop problem