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

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