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