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