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

  1. [SOLVED] Create table for each name in specific column
  2. Storing row numbers
  3. Help with coding for labels
  4. [SOLVED] Save Each Worksheet to Individual PDF
  5. Sort using part of cell value
  6. [SOLVED] Multiple users
  7. [SOLVED] Remove permanent comment from cell
  8. Migrated to Office 365 from Office 2016 - MACRO no longer functions
  9. Export From Excel To Access!
  10. [SOLVED] Convert C# to VBA
  11. [SOLVED] VLOOKUP and skip blanks
  12. Sheet Not Fully Active after Selecting or Activating
  13. Email userform
  14. Workbook that forces users to enable Macros and automatically closes after some time
  15. VBA code to make sheet uneditable after I save
  16. insert rows and paste in section from a range
  17. Counter sums quantity of files in said folder but doesnt update unless double clicked
  18. Remove duplicated values from 1d string array vba
  19. count up cell value by one and automatically be protected
  20. Option Button Value
  21. VBA with Vlookup dynamic
  22. [SOLVED] Search workbook for worksheet name, IF yes then run code, IF not display MsgBox
  23. [SOLVED] Subtotal??
  24. Check If URL Returns 404
  25. Copy Cells with Range(Cells R,C). match returning location in numbers
  26. [SOLVED] Help to get one or more filename from folder in excel and make it hyperlink to it
  27. UserForm has Minimize Button. How do I execute it via code.
  28. [SOLVED] How to set formula equal to a series of numbers
  29. [SOLVED] Another Delete Sheets Macro
  30. Multipage Tiff file in Excel VBA Userform
  31. how to check network file through VBA
  32. [SOLVED] Generating results from different sheet by filters
  33. [SOLVED] Dynamically populate multiple ComboBoxes
  34. Help about dynamic value table array in Vlookup
  35. [SOLVED] Comparing two range of cells to find out the number of matches
  36. Export / Save as PDF in specific folder.
  37. VBA Auto Filter
  38. Run-time Error 1004
  39. Generating a Pareto chart based on date
  40. How to combine Selection. PasteSpecial and Selection.insert Shift in one VBA code ?
  41. Win10 + Excel 2016 fail to connect WebDav with ADODB.connection
  42. Copying rows over to new workbooks based on unique column values
  43. VBA SUMIFS Function
  44. [SOLVED] Passing UserForm Text from One Excel Application to Another
  45. Monthly/Yearly Bills workbook
  46. [SOLVED] How to open windows folder using double click on a cell.
  47. [SOLVED] Error on adding validation list
  48. APIs for Hiding UserForm "X" and\or Adding UserForm Minimize (32 & 64 bit)
  49. Using Countif iterating thru rows in a sheet
  50. [SOLVED] Autofilter with variable criteria & field
  51. Why will my loop not move through different worksheets (tabs)
  52. FIFO-GAIN-STOCK PROBLEM
  53. Ctrl Shift Enter on FormulaArray VBA
  54. [SOLVED] Array Filtered without Spaces after 1aRow
  55. [SOLVED] Faster way delete strikethrough
  56. Management weekly report
  57. Unable to use formula in Shapes
  58. [SOLVED] Print Hidden Worksheets from Userform
  59. VBA error 1004
  60. Open Powerpoint within a specified Window in Excel
  61. [SOLVED] complie error: Expected: end of statement
  62. [SOLVED] Trying to copy multiple worksheets into new workbooks
  63. code optimization
  64. Get XLA file
  65. Listbox items as Hyperlinks
  66. No Locals Window
  67. Call code when text is in a Range, NOT every time it appears in the Range.
  68. progress bar
  69. [SOLVED] Message Box Still Appearing When Code Runs Correctly
  70. [SOLVED] VBA plot a Scatter graph data - X and Y axis data taken from sheet row by row
  71. Error 400
  72. [SOLVED] Open CSV UTF-8 files (no acces to editing BOM)
  73. [SOLVED] Windows Folder Creation From Excel & How to Check A Folder Has Not Been Created
  74. vba help
  75. vba to copy and paste each file name
  76. [SOLVED] Copy Column Table x times and add counter
  77. [SOLVED] Range Syntax
  78. Multiselect Multicolumn Listbox allow users to add data?
  79. VBA ListBox List - Want only selected columns to be displayed
  80. [SOLVED] Composing Email using Macro
  81. [SOLVED] Formula Support Issue
  82. Time Conversion into text
  83. Advance filter help
  84. Find value in Excel from Array within Word
  85. [SOLVED] Assigning two macros to one shape to run on different actions
  86. Find duplicate values accross columns per row
  87. Making VBA program more user friendly
  88. [SOLVED] Condensing IF statements
  89. Creating a official form in Excel using VBA!!
  90. Search From a User Form and Display Results in a Worksheet
  91. Macro to move from windows media player to an Excel worksheet
  92. Search for Values that meet a Criteria and Paste Location in a New Sheet
  93. Can multiple Range but not individual cells.
  94. [SOLVED] Permutation Combination using Macro
  95. different footer for every page
  96. [SOLVED] Create a production schedule from a different workbook using cell values.
  97. [SOLVED] Test for Overlapping Project Assignment
  98. insert sumifs with last row based on another sheet
  99. Signature Block on Locked Form - Workaround
  100. [SOLVED] Mismatch Error
  101. Save a part of the sheet with a specific name
  102. Grouping of defined sections
  103. [SOLVED] Copy Module to New Workbook
  104. VBA hour calculation over 24h
  105. the body of the vba generated mail is empty
  106. [SOLVED] calling selected shape help
  107. save selected worksheet as separate pdf file
  108. [SOLVED] Filtering SKU List to Show Items with Multiple Descriptions Only
  109. Kill Excel after user close userform
  110. Update row cells based on listbox cell value
  111. [SOLVED] Need help in ExecuteExcel4Macro VBA
  112. [SOLVED] Transpose Table - Removing Duplicates
  113. Search Replace Offset - substitute
  114. VBA Excel 2013 Prompting users to select a file & retain value.
  115. sieve of eratosthenes vba code explanation
  116. Entering input Data to next available cell in another sheet
  117. vba consolidation of specific sheets data and Pasting in specific Mater sheets
  118. need help writing a code for copy and paste special (values)
  119. Output VBA Code Results to ThisWorkbook
  120. [SOLVED] Need Help with VBA, True Vs False
  121. [SOLVED] How to display all hidden rows and columns
  122. VBA Help in Converting text result of Date into Date Format !!
  123. Sort Userform ListBox
  124. How to sort Listbox with Multiple columns
  125. placing different windows on my screen
  126. NEED HELP! Average Duplicates and Print them separately
  127. Excel Data Tables
  128. VBA: compare values in columns and list the missmatches in a new sheet
  129. [SOLVED] Deleting a row
  130. Application Match error 13
  131. Sharepoint coding
  132. A way to speed up code VBA in for loop with ExecuteExcel4Macro
  133. Adding Formula in VBA ...Need help
  134. Copy paste loop Multiple sheets column wise
  135. [SOLVED] PrintForm opens a 'greyed out' UserForm1
  136. Deactivate "EDIT" after Digital Signature (or add Password)?
  137. [SOLVED] 2 Column messagebox spacing of data
  138. Help with a Formula
  139. [SOLVED] VBA TO Correct Date format
  140. [SOLVED] Modify line of VBA code
  141. [SOLVED] Skip Empty Cells or Ones with a Word in Them and Run function
  142. [SOLVED] How can I print the sorted array back into worksheet?
  143. Drawing two para
  144. Worksheet edit VBA code
  145. VBA: Splitting a big string with no good delimiters
  146. using excel to collect and store data
  147. [SOLVED] Sumifs? can this be done with a ranged criteria?
  148. Loop for excel functions
  149. [SOLVED] Change VBA code to fit 64-bit environment
  150. User Form Help
  151. Authenticating Access to an External Database using VBA
  152. Delete out of date rows
  153. Generate personal schedule from overview
  154. Hide Pivot items based on table
  155. VBA separate uppercase words from lowercase words.
  156. Using VBA to import BDH from Bloomberg
  157. Help: "Method 'SaveAs' of object'_Workbook' failed" - Tried different codes, no luck
  158. Help Needed Regarding Linear Interpolation and Extrapolation
  159. [SOLVED] form question
  160. [SOLVED] Complicated formula, i'm at a loss
  161. [SOLVED] Multiple Offset - Insert into
  162. Declare Global Variable - Private Worksheet
  163. [SOLVED] Array formula - need formula to pick from 2 ranges to use in calculation
  164. Text Box formatting.
  165. Copy Data to Next Empty Rrow
  166. [SOLVED] HELP FIND HIGHEST VALUE USING VBA
  167. vba - help removing selection
  168. [SOLVED] Data grouping?
  169. Variable sheetname in formula
  170. Text Boxes visible not visible on user form
  171. Follow Up Question About the Ribbon
  172. Can I Change Textbox Languege ?
  173. Saving a workbook with macros when they open it.
  174. Vlookup #N/A using VBA
  175. VlookUp giving random values instead of #N/A.
  176. Keyword Identification and Changes
  177. capture few columns from xml file
  178. Matching multiple values from different column
  179. VBA-XML-SEARCH ZIP AND HOUSE NUMBER
  180. Using Wildcards
  181. select a range using 2 address and find if range is empty/has data
  182. Copy Ranges between sheets with Cycles
  183. [SOLVED] Opened/Populated by MS ACCESS, Excel WB can't see cell value on WB OPEN Event
  184. [SOLVED] Print userform to PDF
  185. [SOLVED] VBA: Error when range(variant) condists of only 1 cell
  186. I want to find first 0 in column in vba
  187. Pasting a range into an email, while also adding text to body and keeping signature
  188. [SOLVED] VBA problem: Merge two sheets into one
  189. [SOLVED] How to find out URL from where on the website CSV data is benign downloaded
  190. VBA code for attendance template - In time & Out Time
  191. loop an excel table to update styles
  192. find a date in a range - exact match
  193. Target Specific Array Elements Group
  194. run-time error "4198"
  195. Get table values from HTML IE website custom generated table
  196. [SOLVED] Array Prefix & Suffix Methods
  197. [SOLVED] vba copy active sheet to closed workbook
  198. Creating a dynamic #N/A Filter for EXCEL.
  199. [SOLVED] sum cells above every blank cell
  200. Using VBA in Excel macro to extract data from table and reconstruct table
  201. Formula help please
  202. sumproduct?
  203. Import Outlook-Taks in an Excel-Sheet
  204. [SOLVED] Display values based on matching column data
  205. [SOLVED] VBA macro for data filter and copy
  206. Implementing formulas with variables into VBA
  207. [SOLVED] trouble hiding columns
  208. Copy paste values from another workbook if criteria is met
  209. [SOLVED] Macro for moving the columns
  210. [SOLVED] finding the value and paste in another sheet .
  211. vba help
  212. Pasting an Image Into Cell, Merging Cells, and then Resizing
  213. calculate time difference between cells
  214. [SOLVED] Problem with VBA code in Excel
  215. Comparing to Excel Sheets based on a Key Column Value - Semi Working
  216. VBA script not working what have I missed
  217. [SOLVED] Run-time error 53 when moving files
  218. Pick directory and merge 2 files into 1 workbook
  219. [SOLVED] SUM by colour
  220. Save to PDF
  221. syncing files
  222. Skip a fault 13 with an If code and go on with the macro
  223. Check if Directory Exists
  224. Launch windows powershell using VBA
  225. Multiple Digital Signatures - on different TABS???
  226. [SOLVED] auto filter and send by outlook
  227. VBA: How to prevent chart / picture / button from moving in Excel?
  228. Calculating Compliance
  229. auto filter on adding rows
  230. [SOLVED] Loop Thru Columns
  231. Need help to click on ID using VBA
  232. [SOLVED] Userform: Change Textbox color in loop
  233. Counting Employee hours booked
  234. Move Cells Up after Content is Cleared
  235. Error When Open From Protected View
  236. Macro for data validation with two condition and high-light row
  237. [SOLVED] Code for a changable range in COUNTIF function
  238. Combination of cells to match a specified cell
  239. Move informaiton based on a match
  240. Co-Authoring Issues - Auto-Updating
  241. [SOLVED] Printing Multiple Sheets to PDF (Excel 2013)
  242. [SOLVED] Color Chart Columns by Conditionally Formatted Cell Color
  243. [SOLVED] Copy paste Cell inside Table under certain conditions 2
  244. [SOLVED] When I move the cursor more than one cell become highlighted
  245. create Calendar from table
  246. [SOLVED] calculating time difference
  247. Connect to two barcode scanners
  248. Naming a sheet to the current year
  249. Copying excel ranges to powerpoint
  250. Autofill column B based on dynamic range in column A in multiple sheets except some