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

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