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. How to find and use the maximum value in VBA
  2. read Tag property without opening file
  3. Strings and Variables
  4. [SOLVED] Test Pivot Table
  5. VBA Pivot Table creation looks different than manual creation
  6. [SOLVED] Function working within Sub but not in spreadsheet
  7. [SOLVED] List box looses Blue 'highlight' when changing forecolor
  8. Generate Shapes, Align, Group, Cut and Paste
  9. Macro to find and replace based on different text within one cell
  10. Web query Looping from table selection
  11. [SOLVED] UserForm that Stays Visible on Screen When Scrolling
  12. Compare data from two workbooks
  13. [SOLVED] How to check if value starts with text
  14. [SOLVED] ListBox_Click event fires without clicking
  15. excel help
  16. Macro to copy values from one sheet to another based on specific conditions
  17. Reference specific text strings despite being repeated elsewhere?
  18. [SOLVED] Macro to delete all rows between two different text stings in column A
  19. Problem with copying the text format.
  20. How to execute a VBA program and halting another VBA code till the old program ends
  21. [SOLVED] Very omplicated calculation of hours worked (PLEASE HELP)
  22. Redim Preserve Change LBOUND
  23. How to insert a formula in a dynamic range using VBA
  24. [SOLVED] VBA - Change code to work on whole workbook
  25. [SOLVED] Difficulty using KeyPress Command
  26. need a vba code HELLLLLPPPPPP
  27. How to generate Sum formula in excel
  28. Populating a Cell with a Table
  29. [SOLVED] Type Mismatch Error Confusion
  30. Checkbox make values to textbox
  31. save and close an excel sheet when I press the Windows + L buttons
  32. Problem between macro event and SpinButton
  33. Unable to get pivottable property of class
  34. Saving Screenshots in excel
  35. Select number of rows based cell value
  36. VBA VLOOKUP
  37. macro prompt?
  38. [SOLVED] Run-time error '445' - Object doesn't support this activity
  39. VBA Macro Help - Extract from Multiple Closed Workbooks
  40. Import particular data from book1 to book2
  41. Help with text file row count - only want the last 13 rows
  42. [SOLVED] Sum Up Cells Value When Specific Value Match
  43. Userform with changeable headers/ listboxes to opt for creating reports from Excel DB
  44. Selective listing of files in a folder
  45. copy filtered data into different worksheet
  46. [SOLVED] Load data from TXT to Excel sheet (numbers with decimal get like text)
  47. Macro Help - Pasting
  48. vba code To Save Copy As Cell.Value
  49. [SOLVED] Find average of all values between two index match values in table
  50. Need help with my code as it doesnt seem to be appearing
  51. Avoid duplication in copying
  52. Combobox from external database, not working
  53. invalid or unqualified reference
  54. Color Code Data According by Categories
  55. Using a barcode scanner with Excel
  56. filter multiple columns simultaneously using Vbscript
  57. [SOLVED] Accessing Excel Tab data from Button
  58. A variable SUM formula in excel
  59. Excel 2013 Macros Click-Activated Shapes
  60. Writing to a cell in a loop
  61. Help with the meaning of this code
  62. Macro to remove marker line and border
  63. How to find and use the maximum value in VBA code
  64. [SOLVED] Can I use an excel sheet to calculate in a vba program?
  65. Convert Table to Calendar (Wincalendar functionality)
  66. Creating a form to filter data?
  67. VBA EXCEL : HELP ON FIND/REPLACE
  68. Checking Excel background image with VBA
  69. NEW TO VBA...Need Help..driving me nuts
  70. Excel formula help
  71. course analysis from bitcoins with VBA
  72. Advice needed to speed this code.
  73. I need to count the amount of weeks a piece of text has appeared since last change
  74. Hyperlink to specific sheets in workbook based on drop down selection
  75. Macro to pull outlook info based on excel values
  76. Join Error
  77. [SOLVED] How to export variable from textbox into a cell after clicking on a button?
  78. VBA excel help
  79. merge worksheets
  80. How can I refresh a webpage in VBA before downloading it?
  81. Need to copy from all sheets from all workbooks
  82. VBA code to copy / paste values only + auto change cell value
  83. Runtime 1004 error
  84. Save As Help
  85. [SOLVED] How to extract date range into multiple rows?
  86. Why is the default value of UserInterfaceOnly False?
  87. Macro To Add DSN
  88. Procedure Too Large
  89. [SOLVED] vba or formula to find number of duplicates in a range
  90. Why is the sub or Function not defined for the following code
  91. [SOLVED] Help Needed! Macro to pull if cell does not equal criteria
  92. VBA matching, data manipulation across different worksheets
  93. [SOLVED] Filter and copy to WorkSheet help
  94. New VBA Code
  95. [SOLVED] Applying a multiplication by macro on a column
  96. [SOLVED] Problem using keyPress command
  97. Populate vlookup formula 1Million item
  98. Auto updating of worksheets in an Excel Workbook
  99. Last entry in a Column
  100. Percentage covered by values using VBA
  101. [SOLVED] Pivot Table Grand Total
  102. VBA Current region minus header and last column
  103. [SOLVED] Creating Sheets from Cell Value IF Only!
  104. [SOLVED] vba to loop through multiple worksheets and paste specific data based on a date
  105. A day longer than 24 hours
  106. [SOLVED] Can this Conditional Formatting Code be simplified
  107. Creating indivisual diaries from master rota
  108. Hyperlink from a cell in another sheet. Not quite working for me.
  109. [SOLVED] Macro for copy/paste values for only that row where the change is made
  110. VBA macro to hide rows based on cell value
  111. VBA to Find & Fill a cell based on row & column headers?
  112. IE WEBSITE FILE UPLOAD
  113. VBC Excel to find latest creation date zip within folder, then open CSV file embedded
  114. Auto Data Display by Scanning. Please help
  115. [SOLVED] Using Userform with Date Picker to Select Data Range in Excel
  116. Lable the last know person to entra data to a cell from a list of names, populate dat
  117. [SOLVED] Easy If-Than code for comparison of multiple values doesn't return correct value
  118. Textfile loop to find/replace characters
  119. Save as Types
  120. Pivot find and replace
  121. [SOLVED] Types inside a Type
  122. Spreadsheet Consolidation based on specific path
  123. [SOLVED] Help needed with VBA to auto insert pic into comment
  124. Remove string in text files
  125. [SOLVED] Clear multi - select Listbox
  126. [SOLVED] match delete vba
  127. VBA - Auto Select Sheet, Save & Close after 1 hour
  128. [SOLVED] Vba find and replace with loop
  129. [SOLVED] Excel Loop WITH Function
  130. [SOLVED] Preserve exact formula, monthly analysis for full year
  131. VBA to Search both Email subject and/or Email Body in Outlook
  132. Intermittent errors after running macro varying number of times
  133. Macro wont work with a cell which is updateing by formular
  134. vba help
  135. VBA wont run unless through the editor
  136. [SOLVED] Error when using variable when connecting to SQL from Excel
  137. hide rows based on highlighted cell in column
  138. Copy and Paste based on cell value
  139. ODBC connection if not on users PC
  140. Is it possible at all?
  141. Using Range.Find to search another Open Workbook
  142. [SOLVED] What is wrong with my VBA code?
  143. Several If statements inside For Loop
  144. Embedded HTML Image Issues
  145. Combining parts of 3 workbooks
  146. [SOLVED] If range contans "0", mark as incomplete
  147. Values lookup in two different tables
  148. [SOLVED] Empty Row Deletion
  149. VBA to Add 3 Aligned Footers with Custom Formatting and Text
  150. Order Assignment Problem
  151. Directing SendKeys to the Correct Application
  152. Help -needed call named range based on cell value
  153. What Do You Think About This?
  154. [SOLVED] Excel Book Recommendations
  155. [SOLVED] Clear activex listbox selection
  156. [SOLVED] Goal Seek without Cell Reference
  157. Compares different rectangular areas and highlights equal values
  158. VBA
  159. [SOLVED] pulling data from a csv file based on specific dates
  160. VBA Cloudera Hadoop connection
  161. Merging PDFs and Allowing for Filling of Adobe Fields
  162. Help Understanding Code
  163. Different references for same formula (more complicated than it sounds)
  164. Put Excel image to PowerPoint in specific location?
  165. SUM of Values by Region and District
  166. Copy Multiple sheet as SaveAs
  167. MATCH VALUE FROM TAB2 and UPDATE TAB1-CONDITIONAL
  168. VBA: adjusting pivot table per macro
  169. VBA to collect data from Pivot
  170. [SOLVED] How to connect to a RECORDSET
  171. [SOLVED] Loop through URLs, save source
  172. Help with #Value! errors
  173. [SOLVED] How do I have a cell value displayed on my user form?
  174. [SOLVED] Apply different format to each column of selection
  175. Counting rows in clipboard
  176. [SOLVED] Loop through combinations and add only Even & Odd numbers together within each.
  177. Adjust placement of copy paste to suit last row of previous paste
  178. Count texts in two colums and if no match write data
  179. Count number of mondays
  180. (VBA) error adding Title and Subtitle to PowerPoint Slide
  181. Excel 2013 VBA Import Dynamic Range from other Workbook
  182. Setting a range object & applying table style
  183. [SOLVED] How to replace a path in the code by a variable?
  184. Excel Userform Listbox VBA Help
  185. Enabling Content in access db with Excel VBA
  186. [SOLVED] Excel 2013>VBA>Function>Sum Visible Columns
  187. VBA code to prompt user to select file folder but still keep the file name...
  188. excel 2016 splitting datasets creating new separate sheets
  189. [SOLVED] Generate 5/50 lottery combination with selected odd sum or by even sum!!
  190. Macro for copy & paste data from worksheets if path of file changes
  191. [SOLVED] Assigning values from a table
  192. Display Data from Sheet
  193. [SOLVED] VBA Loop - If Cell is not empty then....
  194. HELP!!! Fastest code in consolidating columns with different headers
  195. Conditional Formatting not pasting correctly with macro
  196. [SOLVED] Excel 2013>VBA>Function>Average Visible Cells Horizontally
  197. Using Vlookup to set ranges for Loop, not sure how to integrate it.
  198. [SOLVED] Do While Method to append data
  199. Generate 3 sets combinations, which 3 sets sum match: to request target sum
  200. [SOLVED] Copy complete folder to another folder
  201. [SOLVED] Trying to name ranges over a number of columns
  202. [SOLVED] Excel 2013>VBA>PageSetup>User Defined Formula>Interference
  203. [SOLVED] Trying to get a range of cells to show up in my Combo Box
  204. Run-time Error '1004' - Method 'Open' of object 'Workbooks' failed
  205. [SOLVED] Using wildcards to filter list - help
  206. [SOLVED] Saving filename exists
  207. VLOOKUP formula with subtotals
  208. [SOLVED] Excel Margins
  209. Lotus Notes - VBA
  210. [SOLVED] File copy wont copy to the right folder.
  211. VBA to trigger input box when criteria in data found
  212. Help with Data in Column A and Shift...
  213. [SOLVED] Move files & folders from one location to another from excel
  214. [SOLVED] Check if activecell is in a column with date in the header in any table
  215. [SOLVED] Copy data from excel and paste it in to a word template at different places
  216. [SOLVED] Schedule code to run at a set time and then at intervals thereafter
  217. Skip first sheet in For Each loop?
  218. VBA -- Call Function Not Running Macros Properly
  219. Help With Recursive Formula
  220. VBA Find and Replace from Excel Range
  221. 90% there - Maybe paste as picture instead to esure cond format?
  222. [SOLVED] Create list of files in a folder and link to them in Excel
  223. Microsoft Dynamics AX
  224. ComboBox lag
  225. [SOLVED] Currentregion and autofilter Help
  226. HELP!!! Need a VBA code to get a table from a site
  227. [SOLVED] Date Problem showing as 42463 ?
  228. [SOLVED] Require total in column B of positive & negative values
  229. Excel Search Function
  230. [SOLVED] VBA loop to do multiple cut, transpose pastes within a loop, then repeat.
  231. [SOLVED] Dynamically Copy and Paste
  232. month end variance analysis
  233. Filter A Range And Chart It
  234. [SOLVED] VBA Array Function - Return Array from Range without Blanks
  235. [SOLVED] VBA - Filename Checker?
  236. [SOLVED] Need some very basic help
  237. Search and copy macro with search criteria
  238. Need macro that creates new rows and copies matching info from sheet 1 to Sheet 2
  239. [SOLVED] Need to change code in bottom line
  240. [SOLVED] Excel/Word/Access
  241. [SOLVED] VBA filter
  242. [SOLVED] Aligning two tables
  243. [SOLVED] Insert row & total other columns
  244. if unique of column A b c then count ifs
  245. Help with excel and word. Sounds easy, but its not.
  246. Runtime error 13 : Excel vba pivot - please help
  247. Formula getting a cell's data from another worksheet.
  248. [SOLVED] VBA Code Required
  249. Using VBA to Copy Multiple Workbook Filenames into their Workbooks
  250. [SOLVED] Displaying numbers in fractions, not decimal (when concatenating)