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] Wrong result of my macro!
  2. VBA Combobox for vlookup
  3. [SOLVED] loop through files in a folder based on a condition
  4. Replacing Text evenly from 1 sheet to another sheet
  5. Formatting table in worksheet
  6. [SOLVED] Bold First Name in a VBA generated Email
  7. [SOLVED] Convert text in alphanumeric string to lower case
  8. [SOLVED] Returning an element from an array of subclasses
  9. Control Panel using a userfom and hide workbook
  10. How to rename a bunch of files in the same folder using an Excel VBA code?
  11. Import HTML Data into excel
  12. [SOLVED] COUNTIF code then insert copied cells
  13. [SOLVED] listbox1 to listbox2
  14. [SOLVED] Issue with button
  15. [SOLVED] Why are my formulas changing automatically?
  16. [SOLVED] Non Regular Sequential Numbering
  17. [SOLVED] Outcome is not as expected - code might be wrong
  18. VBA To search for a WorksheetSheet and a Column in that sheet.
  19. Excel charts as jpgs to specific powerpoint
  20. help creating a repricing tool with defined parameters
  21. email automation
  22. Mail Merge Excel however instead of Print Need save as
  23. ID matching with Name and sub six hours work time calculation
  24. [SOLVED] Copy row data from one workbook to another based on row header name
  25. vba - copy workbook 300 times once user selects folder
  26. [SOLVED] Line Break Validation
  27. Pull Date by Criteria for Visible cells only
  28. Office Automation: Excel executng Word VBA
  29. Paste column format only through iteration
  30. VBA event to detect an Autofill Scrolling?
  31. [SOLVED] Using concatenate to reference a named range
  32. [VBA] set range find() -> finds wrong value
  33. Iterate 2 dropdown lists and move to all the new tabs to new workbook
  34. Save Active Word Doc with URL File Path
  35. [SOLVED] Split First, Middle and Last Name
  36. Finding the last modified date of an excel sheet
  37. Avoid code repetition by calling the common code from another sub
  38. Dsum and Data Tables
  39. [SOLVED] Looping through a Range of Data
  40. [SOLVED] Loop through all Pivot tables in a worksheet and filter visability VBA
  41. VBA Code problem for Excel 2016 on a mac
  42. [SOLVED] lookup formula to sum percent
  43. VBA Code to attach (multiple) file(s)
  44. Minimize-Maximize-Resizing-Scrolling in a Userform
  45. [SOLVED] how to loop search to show multiple entries in listbox
  46. What am I doing wrong here?
  47. [SOLVED] Range of inputs and graphing of result
  48. VBA Code running in f8 but not f5
  49. [SOLVED] Dim problem
  50. [SOLVED] Remove duplicates (runtime error 5)
  51. [SOLVED] automated data query
  52. [SOLVED] Sum Values Assigned to a Name
  53. Copy data from multiple single-worksheet workbooks into another workbook
  54. [SOLVED] Loop to copy and paste first cell of repeated values
  55. Loop for substitution
  56. Combine Data in Mutiple Columns into Rows
  57. Sheet_change is not worked
  58. Extract single row from multiple workbooks
  59. [SOLVED] Return Multiple Listbox Selection
  60. Need help with Timesheet Workbook I know exactly what I need !
  61. [SOLVED] Create outlook appointementes only on "check" rows
  62. macro to send multiple emails with all attachements from specific folder
  63. my excel vba stop running when i run the userform and not responding
  64. loading a txt file into excel win works fine. Loading txt on a mac doesn't work.
  65. copy and paste a certain number of times
  66. Vlook from Closed workbook taking a lot time
  67. what is wrong with my update button code excel vba
  68. [SOLVED] Validate cells in column A with info from other columns
  69. Improve efficiency of VBA Code
  70. [SOLVED] Getting Run Time Error 5 on String?
  71. Returning the Caption Property for active controls in an email body
  72. search for multiple value using FORMS
  73. VBA_Pivot table capture in array and reapply
  74. [SOLVED] Concatenation with double quotes and comma for the selected list of values
  75. how to get data from an array table with two different values
  76. Need help moving many fields of data from the master sheet to several other sheets
  77. [SOLVED] Error Handling (runtime error 1004)
  78. Filter the entries of Combobox
  79. [SOLVED] Excel 2010 run time error 91': Object variable or with block ...
  80. [SOLVED] Arrangement of values in groups
  81. Performing count and max commands on multiple groups of rows
  82. [SOLVED] Validation Code Problem
  83. It is possible deleting rows in lisboxt datagrid with active sheets displayed vba exc
  84. Outlook vba help - Folder Picker
  85. [SOLVED] VBA-split data into multiple worksheets based on column
  86. it is possible to save individual sheets as a separate file?
  87. How to Merge Cells Specially
  88. [SOLVED] Help to faster this script for moving Duplicates
  89. How to speed up VBA Code
  90. VBA - Set data list
  91. [SOLVED] Split Cells into rows but with two columns
  92. INDEX MATCH in VBA over different data files
  93. VBA to copy a new sheet based on active sheet
  94. [SOLVED] Color cells from previous colored cells in different column
  95. [SOLVED] Showing two expected values together with an IF function
  96. Restoring default Styles in Excel
  97. [SOLVED] MS MapPoint and MS Excel, plot latitude and longitude on a map
  98. Type missmatch error
  99. [SOLVED] Array of Email Addresses
  100. Find empty cell in one spreadsheet and then paste information from another
  101. Array match Only 1 RedimPreserve
  102. Replace text in email body from the excel
  103. VBA for designing your sheet
  104. xlsm file opens and immediately closes
  105. VBA code for conditional cell merging
  106. Run-time error 438: Object doesn't support this property or method (VBA), Office 2010
  107. SUMPRODUCT with additional sums/ adds
  108. [SOLVED] Conditional Statements & Nested If/Then in VBA
  109. [SOLVED] Copy and Paste Problem
  110. VBA Question
  111. [SOLVED] Need help figuring out what went wrong
  112. VBA Code-csv file into excel- from general to text
  113. VBACode to show autofilter criteria just show result as <>, even though filter is set
  114. Insert Vba macro to Sheet 3 using another macro.
  115. How to run external software run multiple files after each other using VBA (in Excel)
  116. macro to extract specific data from text file to excel sheet
  117. Array Question - basic
  118. Detecting Barcode Scanner input vs input by hand
  119. Allocating buyers based on expertise and performance
  120. Edit to "colour to chart" macro - to cycle through workbook
  121. Counting Used Rows In Column - Best Method?
  122. [SOLVED] Formula returning false when it shouldn't
  123. [SOLVED] Help with equation that has several inputs which vary in value.
  124. Excel 2016 Crashes
  125. [SOLVED] Send all files in folder vba
  126. Filtering numbers according to certain ratios
  127. VBA SUM Formula help
  128. [SOLVED] VBA/Excel change value of a cell in multiple worksheets from a range in another workb
  129. VBA Help needed
  130. SaveAs to SharePoint not working in Excel 2013
  131. [SOLVED] VBA Userform using Danish CPR Numbers
  132. [SOLVED] Color Coding Stops After I get to # 65,282
  133. VBA help loop until & IF formula
  134. How to make multiple, non adjacent cells hidden based on cell value code
  135. [SOLVED] Array Output
  136. Excel-How to concatenate data in multiple dynamic number of rows and multiple columns
  137. Public Variable won't pass
  138. Komplex If-Loop
  139. [SOLVED] MoveAfterReturnDirection
  140. [SOLVED] VBA exel programming: how to make a automatically filled up by filling up other cell
  141. Help with IE Button Click - SHDocVw
  142. Save textbox to specific cell based on combobox seletection
  143. [SOLVED] How to do loop in the function?
  144. Dependent between 2 dropdown columns
  145. Paste from Clipbaord
  146. Stock Locator Inventory System-Issue with locator
  147. Listbox not showing Data
  148. [SOLVED] Having trouble with renaming files in subfolders of subfolders
  149. [SOLVED] Select row based on multiple textbox values
  150. Excel Userform DatePicker Default Format to be Blank
  151. Traverse all images in workbook
  152. Forecasting
  153. Distribute Numbers Evenly, With Conditions
  154. VBA - Export as PDF and overwrite existing PDFs
  155. Copy multiple workbooks & multiple sheets into single workbook with multiple sheets
  156. [SOLVED] Adjust/Sync Table columns number Base on a Pivot Table Columns Size
  157. [SOLVED] VBA - Copy with validatation
  158. [SOLVED] Gradual Zoom?
  159. [SOLVED] Copy data block from one workbook to another .. should be easy
  160. Security
  161. [SOLVED] Dependencies and Dates
  162. Merge duplicates with cell color
  163. [SOLVED] Automatically group the cell based on the words that appear in it
  164. click button via vba
  165. Check Values in Array for Matches
  166. [SOLVED] VBA Help please - Find First Row of Data?
  167. [SOLVED] VBA Loop
  168. input box to define formulas contraints
  169. Send Email separating by specific recipient
  170. Need Excel VBA help to loop in folder, execute several tasks and save filesAs
  171. [SOLVED] VBA Code Modifcation To Insert a New Row and Fill out with Data As Per Existing Code
  172. clearing data using range(cells)
  173. [SOLVED] PRINT EMAILS WHERE SUBJECT MATCHES CELLS IN EXCEL
  174. Summary of cash book day wise
  175. Excel VBA - Check excel file names and change if necessary
  176. [SOLVED] Create a new function to find a date or next date on a selected range
  177. [SOLVED] Excel VBA help....please :)
  178. [SOLVED] Variable Not Defined, Excel 2013 & 2007
  179. How to compare different values either by formula or vba
  180. How to return entire output from Array to Excel sheet in one go
  181. Update value in a column from another worksheet depending on the date in a range
  182. VBA Coloring Cells Based on Value
  183. VBA for printing files listed in excel
  184. Perform Sum in vba code
  185. Prining from VBA not coming out in the correct size, please help me
  186. [SOLVED] Copy and paste total row with engineer name and headings to a new worksheet
  187. Refer to a cell in another worksheet (macro)
  188. VBA - open corrupted file - excel 2010
  189. Sharing Interest Dynamically
  190. Aktivate/ deactivate check box
  191. Add a Calculated filed in pivot table to calculate percentage of adjacent column
  192. Auto fill from multiple rows & cells
  193. [SOLVED] Please Help. Rank Formula Macro
  194. [SOLVED] VBA code for sum function for filtered columns
  195. Summing up values in label captions
  196. How to split categorical data in Excel
  197. [SOLVED] Macro to skip rows that have blank cells
  198. Spllit the data customer wise and email id should come in A1 Column.
  199. Using the Custom UI to create a custom ribbon Addin for Excel
  200. formula help
  201. [SOLVED] Timed Message Boxes not handling code in between
  202. [SOLVED] Brining in 2 inputs incrementally & 3 others from lists.
  203. VBA to email each sheet in a workbook
  204. Help with date and time formats
  205. VBA for AUDITING
  206. [SOLVED] Problem with Userform input to Worksheet (Excel 2013)
  207. Prevent Blank Rows When applying filters
  208. [SOLVED] How to DIM script itself?
  209. [SOLVED] Help with solving a maze in VBA Excel
  210. [SOLVED] if not found record after 1st criterial in Advanced Filter - then move to next if
  211. VBA to email each sheet in a workbook
  212. [SOLVED] Copy from Excel to Powerpoint to create a report
  213. [SOLVED] Deleting multiple cells based on value found
  214. VBA to copy / autofill data, where am i going wrong?
  215. Excel 2016 VBA Error 400
  216. [SOLVED] Hidden Object Range Failure in Worksheet Calculate
  217. [SOLVED] overflow error in range.find
  218. counts ships between instances of picked number
  219. Lock ComboBox/ MsgBox as Error
  220. Quick Question (hopefully) - Possible to create a front sheet for analysing data?
  221. proper variable type
  222. [SOLVED] Consolidating data from multiple workbooks with varying ranges
  223. [SOLVED] VBA Dir and HTTP Directories Equivalent
  224. VBA SQL Query from Cell
  225. Same Userform, Different Lines
  226. Multiple Linear Progression, logging and VBA
  227. Excel Clarification
  228. Market- making algorithm
  229. SUMPRODUCT formula does not add up negative numbers.
  230. Conditional Formatting with Multiple Criteria
  231. Excel Userform - how can I send an HTML email using data from the userform with image
  232. VLookup
  233. Transferring Data between sheets to main record sheet.
  234. Data Tabulation
  235. code for sum function
  236. [SOLVED] Sorting by custom aplphabet
  237. File renaming
  238. [SOLVED] IF-ElseIF-Else macro seems to be disconnected
  239. VBA Loop on Overly Coded Macro
  240. Else without If Problem
  241. [SOLVED] TextBox - Named Range Dynamic Search
  242. Programming Scroll Button on Mouse
  243. [SOLVED] Show Random Numbers Looping on a UserForm
  244. VBA to carry out Simpson's Rule for Tabulated (Equispaced) Data
  245. excel vba change cell color based on a number value in a range
  246. [SOLVED] VBA Error run time 1004: Application-defined or object-defined error
  247. Can you help me? I need a VBA code which makes bold a chosen word in a cell
  248. [SOLVED] TMP file not found error when creating multiple workbooks in a loop
  249. VBA Combining Data from Multiple Workbook into One - Need help ASAP
  250. Split cells data in below rows with other data.