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

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