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. In work materials vs delivery date
  2. [Help] VBA for scheduling
  3. golf 4somes
  4. Test to determine workload
  5. Else without IF error !!!
  6. Data lookup formulas
  7. Moving data between sheets based on headers
  8. Numbers update as per Pivot table
  9. Show column headings and corresponding values/text based on dropdown selection
  10. Barcode Asterisks Around Date Formula
  11. vba - vlookup on data stored in array
  12. [SOLVED] Run time error -2147417848 (80010108) Method "_range" of object "_worksheet" failed.
  13. Export specific sheet from a file to a specific sheet in many closed files
  14. Code for Slicer
  15. How to change code for sheet to work whole book
  16. VBA - Outlook to Excel
  17. Need help : fill listbox with search result
  18. VBA variable url webquery
  19. Force User to Enter Date but in UK format
  20. Excel VBA game help
  21. excel help
  22. Copy Data from one sheet to another IF cells are specific text colour
  23. VBA msgbox help
  24. Eliminating Pop-up when using RemoveDuplicates
  25. Turning Multiple Optionbuttons subs into one sub
  26. Aligning Columns and rows
  27. data transfer through loop
  28. Copying charts from all Excel worksheets onto Powerpoint slides
  29. Different Phone Number Formats from list of numbers
  30. Change Check Box character to text
  31. [SOLVED] Search using two ranges
  32. Help with time diffrences
  33. Search for Specific Text within a Cell
  34. [SOLVED] YTD SUM
  35. [SOLVED] VBA to Copy / Paste into New Workbook With Different Layout by Column & Row Headings
  36. [SOLVED] Filter between two dates on multiple ranges
  37. Auto update Form Text box with form editor name
  38. [SOLVED] Changing code from copy entire row to copy specific cells
  39. Checking for MULTIPLE duplicates on save_click
  40. Run-time error "438"
  41. [SOLVED] Switching worksheets unexpectedly after exiting UserForm
  42. Make Cell Blink 3 times
  43. [SOLVED] Extracting intersecting values from two or more ranges
  44. [SOLVED] Need help parsing subtext in cell
  45. [SOLVED] Find zero
  46. [SOLVED] Find specific words in a worksheet and change the font color of those words
  47. Distance between 2 locations 2D array
  48. [SOLVED] How to fix Compile error: Else without if
  49. [SOLVED] Help with renaming files (Name "xxxxxxx" As "yyyyyyyy" wont work)
  50. Compile error argument not optional
  51. Macro listing files in folder, used to list all now only first
  52. Run-time error; Invalid procedure or arguement
  53. Help Looping through array
  54. VBA Newbie question
  55. Two dropdown lists
  56. Function to list file names in a folder
  57. Help removing encryption from an excel template using VBA
  58. [SOLVED] Deciphering VBA Code
  59. Extract value from HTM file
  60. [SOLVED] Hide and Unhide Columns based on Cell Value
  61. Compare list of values to rows in another sheet, copy row on first match
  62. Copy Paste VBA code Required with some additional requirements Button
  63. Sum adjacent columns based on criteria
  64. Salary Structure Calculations
  65. How to run macro only selected rows
  66. VBA to read text file and import specific data from it to excel columns
  67. X-Y Scatter plot using VBA
  68. Yes/No Optionbuttons
  69. Excel VBA: resizing a pasted image in word using excel VBA
  70. VBA format Word
  71. [SOLVED] Microsoft Object Library Reference Missing - Outlook to Excel
  72. Mirroring of sheets to a single summary sheet
  73. 2 selection critria in a WorkSheet form
  74. [SOLVED] How to keep Inserting Rows Command from moving other cells in a sheet
  75. Select data through 2 slider bars
  76. urldownloadtofile-is-downloading-files-to-inetcache
  77. Senders Email Address: Outlook 2013 to Excel 2013 Not Working
  78. Download and open Excel file
  79. VBA: website scraping in general and specific problem
  80. [SOLVED] Changing Multiple ranges to Dynamic ones
  81. [SOLVED] Can you Format as fraction in VBA -- Format(123.456, "# ??/16")
  82. Message when you try to open the file
  83. [SOLVED] VBA Coding Help
  84. [SOLVED] Value & Formula - Export Sheet from xlsx to CSV
  85. [SOLVED] Select range till last empty row
  86. Add double quotes to cells that contain spaces
  87. VBA Table of Contents
  88. [SOLVED] Select data down to next empty cell in column
  89. [SOLVED] Need help w/formula to show just some amounts
  90. Copy from RDP (remote desktop) to local desktop
  91. [SOLVED] VBA- how can i have a userform behaviours just like controltiptext?
  92. VBA help solving assignment
  93. Compare cells
  94. Split to Files - adjustment
  95. Upon exit excel woorkbook save charts as picture
  96. [SOLVED] Arrays using MMULT Function
  97. Vba view active ie window and mouse over text and pull to text box
  98. VBA for Setting Min and Max Axis for Scatter Plot Graph
  99. [SOLVED] ForEach Loop Trouble
  100. Import Multiple txt files
  101. [SOLVED] Dashboard prepration
  102. Slicer vba code
  103. compare dynamic arrays and copy data from another array into a cell in WS
  104. Splitting data into other worksheets based on data in ROW
  105. Macro - Mail every worksheet using A1 as address
  106. [SOLVED] Limiting Window Size to the used Column range
  107. Excel Macro pulling data from Word 2013 form - formatting question
  108. [SOLVED] Retain excel cell format when copying to word bookmark
  109. Catching fatal VBA errors
  110. Copy partial rows with criteria to new workbook identified sheet
  111. [SOLVED] UDF to count colored cell pairs fails with #VALUE!
  112. VBA - inserting picture on from clipboard to userform image
  113. Transferring Excel data into Word
  114. macro save as
  115. VBA Code->copying sheet from mutiple sheets excel into single excel with diff sheets
  116. How can I find next small value(look up value) in a range?
  117. VBA Cells update vica-versa using VBA code - Level 100 Can somebody solve this?
  118. [SOLVED] VBA - uppercase of the first letter in each word, while the rest remains intact
  119. TextToColumns FieldInfo ignored
  120. [SOLVED] Adding batches of serial numbers
  121. Ribbon Control not displayed at file open
  122. I like to find next small value..
  123. [SOLVED] Vba Code for sorting date
  124. Parsen/Scripting web-pages with Excel-VBA - no refresh data
  125. Every possible combination
  126. Print Charts to pdf
  127. [SOLVED] Ribbon customization issures
  128. Smart View - Connect to a Shared Database
  129. [SOLVED] Match Overlap Date Range and multiple criterias
  130. [SOLVED] Take absolute value of all array elements - Please Help!
  131. [SOLVED] Set value to variable in vba to use different sub
  132. comparing elements of 2 arrays
  133. CommandButton button in Excel 2016 does not work
  134. [SOLVED] Removing end elements of an array (they are all 0)
  135. [SOLVED] Find row index where max value is located
  136. Huge working excel document
  137. [SOLVED] Help with vlookup in VBA
  138. [SOLVED] Auto copy range data and paste on last empty row
  139. [SOLVED] Force opening a file as a .XML
  140. Automatic Hyperlink documents in excel workbook using a command button
  141. [SOLVED] Code that opens a file and uses data from that file to replace data in another
  142. function with paramarray help
  143. Deleting rows which consists cell value PM and CM and remain cell value intact.
  144. Results changing from a drop down selection - understanding VBA code
  145. VBA in Excel to search for PDF's and report if exist yes/No
  146. Hiding Quick Access Toolbar (QAT)
  147. Userform on Mac
  148. [SOLVED] Setting the width of an inserted word document
  149. [SOLVED] Excel MACRO that make variable sheets with conditional information
  150. Finding out leaves and exits
  151. I want to make change in data model in manage data model of powerpivot by vba code
  152. Run-time error 438: Object doesn't support this property or method
  153. SSL connection to external source
  154. [SOLVED] HTML href cutting off URL at first space
  155. How to avoid hardcoding a filepath
  156. Attemping to loop data/extract/compare
  157. [SOLVED] Array Indexing - Please help, at a loss for words...
  158. [SOLVED] Generate Text Files
  159. Looping Macro
  160. [SOLVED] Range(Cells()) and the 1004 Error
  161. Text stretched in inserted word object
  162. Addins and CustomUI, OnAction to only run Subs in book?
  163. Storing Previous Cell Value in Historic List
  164. [SOLVED] Chart Title and Axis Title positioning
  165. [SOLVED] CDO Email, specific cells in the body
  166. [SOLVED] Overflow Error in Array Assignment
  167. code for the filerting and copy n pasting in another sheet
  168. Copy paste with VBA
  169. Change Direction
  170. [SOLVED] Random Select Rows and Copy to Next Sheet based on user input value
  171. Add a row below an activebutton, keeping the format without resizing the button
  172. Merge two pdf files with partly same name in 2 different flders
  173. [SOLVED] Delete Rows in Table
  174. [SOLVED] Open Window in 64 Bit Excel VBA 7 using Windows API
  175. [SOLVED] Code is dropped when sheet is copied and emailed
  176. Code for Vlook up
  177. Sum for a certain criteria
  178. [SOLVED] Forms, Formulas and Dropdowns. Difficult
  179. cant figure out compile error: do without loop
  180. Connect via ODBC to Access FE on remote server from Excel
  181. Copy from worksheet to worksheet in different workbooks with IF condition
  182. Custome Date Picker! Duplicate value
  183. [SOLVED] VBA - Moving files
  184. errore
  185. [SOLVED] Hiding Rows
  186. [SOLVED] How to disable "traditional" Save and Save As functionality
  187. Save file to folder with variable
  188. [SOLVED] Error 1004 with method "Columns" - only when opening the file
  189. Ways to optimize VBA loop
  190. DTPicker - select date, then continue automatically
  191. [SOLVED] Compare and replace- Long Sentences
  192. Import CSV files in a Loop
  193. Run-time Error 438
  194. [SOLVED] Creating consistent charts and layouts
  195. [SOLVED] have cell take value of another cell when a thir cell's value is changed
  196. Consolidate datas from workbooks to masterfile
  197. [SOLVED] VBA Copy Clear Paste
  198. return only values from one column which have different values in another column
  199. [SOLVED] Set Focus To A Particular Cells with OptionButton
  200. VBA - How to select range of cells based on value of 2 cells in each row
  201. Delete columns based on current month
  202. [SOLVED] How to turn off "activate when cell changed" while other macros change cells?
  203. Switching from one tab to another VBA
  204. [SOLVED] Multicolum list box displays incorrect format
  205. [SOLVED] problems with copying the values of one cell to another
  206. Removing Conditional Formatting When Printing to PDF
  207. Help needed to edit CSV files
  208. [SOLVED] UDF returning multiple values
  209. Copy range in worksheet into new workbook - input box
  210. [SOLVED] Transpose multiple rows, varied length, to a single column?
  211. Removing all non-numbers from the last portion of string
  212. "You've entered too many arguments for this function"
  213. VBA Transpose Paste Loop (looping recorded Macro)
  214. Excel Crashes
  215. Struggling wth VBA, trying to specify paste destination
  216. macros to search for string in cell from text files under folder & return no of count
  217. [SOLVED] Error 438
  218. Macro to stack lists until empty
  219. [SOLVED] Excel VLOOKUP to Google Sheets
  220. [SOLVED] Transpose Column - But Exclude Rows - Found in Array List
  221. Adjusting my working Excel -> Outlook Calendar Code to work with an exchange calendar
  222. [SOLVED] Weird forloop behavior with worksheets
  223. Trying to create an interactive UserForm
  224. [SOLVED] Trying to Shorten/Simplify some Code to Make it Easier to Apply To Other Workbooks
  225. [SOLVED] VBA - Help Needed - Macro SpeedUp
  226. VBA to Download documents using URLs, create a folder and save it in
  227. [SOLVED] Getting The Cells to focus!!! Using FOR LOOP to find and select only the last row)
  228. multiple columns in a list box
  229. Month report in excel doc
  230. Code that will compare two files and merge the data
  231. [SOLVED] RibbonX customization issues (XML)
  232. [SOLVED] Looping trough varibales names - is that possible
  233. Programmatically Add Procedure to Sheet Module
  234. Index/Match over multiple tabs
  235. Populate and Sort a ComboBox with visible unique values from an Excel table
  236. PowerQuery refresh / Pivot Table refresh
  237. MkDir Runtime Error 76
  238. Control Box Data Validation won't change font size
  239. Control Box Data Validation won't change font size
  240. [SOLVED] Need help with eisting event code to in regards to recording row of active color cell
  241. Automatic calculation problem
  242. Randomly selecting 50 cells from a range & filling with color
  243. scheduled macros execute a few times VBA?
  244. how to click href using vba
  245. VBA syntax question for Dynamic Web Query
  246. Copying Excel Tracker into Access - Endless Issues with INSERT INTO statement
  247. Merge data from multiple spreadsheets into one master sheet.
  248. Merge data from multiple spreadsheets into one master sheet.
  249. [SOLVED] Different results when execute code by "F5" or "F8" (step by step).
  250. cannot get Listbox column count property