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 174

  1. Recording results of multiple runs using VBA
  2. Paste with offset from a different sheet VBA
  3. Fix Broken Code
  4. [SOLVED:] Find First Cell in Column Containing non-NULL Data
  5. [SOLVED:] Move up cells less than row value
  6. [SOLVED:] Application.Onkey
  7. Combine multiple sheets from multiple workbooks to a single workbook of multiple work
  8. [SOLVED:] VBA to run a Linear Regression Automatically
  9. [SOLVED:] VBA Power Programming 2007 - Disk Examples
  10. [SOLVED:] Copying and Pasting through Ranges of Varying Lengths
  11. [SOLVED:] Export Each Excel Row Text - to PPT
  12. forcing excel sheet to save it as .xlsm
  13. copy/paste values only between 2 tabs
  14. Creating chart by searching input datas in different worksheets
  15. Insert value after matching with existing cell
  16. [SOLVED:] Textbox .ColumnWidths without trial and error?
  17. Pull data from Word to Excel help
  18. [SOLVED:] Identify 7 day separation between product calls
  19. [SOLVED:] listbox items = column headers macro
  20. VBA Code: ascending order of the columns
  21. [SOLVED:] Format all my Command Buttons The Same - Retain Press Color Change Individual Button
  22. how to minimize sum with macros
  23. Delete record from listview and excel sheet at the same time and apply duplicate prev
  24. Need to direct my appointment a non default calendar
  25. Link button to table row for sorting
  26. Compare Dates within Textboxes in Userform
  27. Converting Values from one spreadsheet, and turning it into an XSLT code.
  28. Export excel sheet to .txt, reformat to .dat. But format changes in Linux
  29. VBA to delete rows *partial text*
  30. [SOLVED:] VBA to copy last row of one sheet onto another sheet
  31. Extract web data
  32. PrintToFile Problem
  33. VBA Google Search Scraper/Extract
  34. Vba Outlook license reminder notification
  35. VBA code for distributing items having different weight and time to different slots
  36. Find a particular text in column A and copy the value from next column and transpose
  37. CopyPicture method of Range class failed
  38. WaterFall Chart - Up/Down Bars
  39. [SOLVED:] Need help need VBA to build combinations from values from structured data
  40. Find Search with Msg PopUp
  41. 3-dimensional grid search
  42. Converting xls formula to VBA function
  43. [SOLVED:] VBA to insert Now() when formula result changes
  44. [SOLVED:] Match Funtion Help
  45. [SOLVED:] Find with additional requirement
  46. join multidimensional array vba
  47. Need help implementing UserInterFaceOnly:=True
  48. [SOLVED:] Arranging groups of numbers into a normal distribution
  49. can't run a simple recorded macro
  50. VBA assign random variables to cells
  51. Select and delete entire columns
  52. [SOLVED:] Split a Text File - Rename With the Original Text Heading Found in file
  53. Numbered Text boxes managed by Loop or for?
  54. Extract specific values in text files and paste to Excel
  55. [SOLVED:] Where is the error in this short code??
  56. SumIf in vba returns 0 value in userform
  57. [SOLVED:] copy from one sheet to another sheet based on column names
  58. [SOLVED:] What I'm doing wrong???
  59. Script to Change Chart Titles
  60. [VBA]:How to use VBA to merge 2 sheets into one with the same ID
  61. Speed Up Get Data Code
  62. [SOLVED:] Copy rows and paste them to new sheet
  63. [SOLVED:] Naming a Range (VBA)
  64. [SOLVED:] VBA to pull values from cells off of second sheet
  65. Remove blank cells to left if condition
  66. Countif Synthax
  67. VBA "Object doesn't support this method" HELP!!
  68. cut entire row and paste many times as quantity - Tables
  69. [SOLVED:] Help w/combining excel actions
  70. Looping Through Worksheets
  71. Using Index match in VBA returns wrong value
  72. Open Multiple Files in a Folder, List file name, and calculate Average of Column
  73. Autofill a resize range
  74. Replacing "/" with nothing -VBA
  75. [SOLVED:] Excel VBA to print 3 copies of sheet if it finds something in cell A2.
  76. Offset selection by 3 columns?
  77. [SOLVED:] Ribbon Issue
  78. [SOLVED:] Run-time error '13': type mismatch VBA code
  79. excel vba range property non contiguous ranges
  80. [SOLVED:] Using VBA code to change value of a checkbox in a cell
  81. [SOLVED:] Ranking like values the same, but not omitting the next rank number?
  82. Extracting minimum and maximum points above and below moving average
  83. [SOLVED:] Naming a column B range based on Col A value
  84. [SOLVED:] Change listview items font color based on criteria
  85. [SOLVED:] VBA to transpose rows to column based on values in col A
  86. Links and Macros Automatically Enabled
  87. Excel VBA code to get data from a cell.
  88. Excel Vba Code To Create New Worksheets When Range Is Updated
  89. Compare the value with different name.
  90. copy paste macro needs sum function
  91. [SOLVED:] Import Excel Named Ranges into Word with VBA
  92. VBA Code: excel is hanging at some point
  93. VBA Interacting With A Child Window
  94. [SOLVED:] VBA to populate row of cells with userform listbox data (code runs by column only)
  95. "object expected" suddenly popping up
  96. Find last column , enter formula to last column skip 3 lines and repeat
  97. cannot add date
  98. [SOLVED:] Need help with fixing code - Match FName + LName and highlightcells
  99. HELP!!! Importing CSV file into excel based on cell value
  100. vlookup on temp file
  101. [SOLVED:] Sumif using offset in vba
  102. [SOLVED:] Increase cell value by 1 when workbook opens
  103. Check for empty cell in a range of #N/A cells
  104. [SOLVED:] VBA to Paste top rows to bottom 4 rows as values
  105. VBA Excel Google Search Scraper/Extract
  106. Optomize Code for a Sort and Remove Duplicates Macro
  107. [SOLVED:] adding comments to ListColumn tables in Excel with Access VBA
  108. [SOLVED:] Select Case
  109. [SOLVED:] Need Help with revision of current VBA macro! please!
  110. Can't get right code to amend records in listview
  111. Using ADO with Excel
  112. If cell in column B(tab1), copy tab2 and paste value from column B(tab1) into new tab
  113. If a cell is filled up, copy data to the right of cell instead
  114. Email Attachment via Outlook
  115. [SOLVED:] Make formula equal to cell contents of last cell in a column
  116. Save specific Outlook attachment to folder
  117. Define cells and cut them
  118. Interest claculator that allows payments and advances
  119. Split Excel sheets to multiple Workbooks based on Criteria in Cell A1
  120. Loking for a macr to delete first six lines of txt documents
  121. [SOLVED:] Take values from different area of a column with a variable range lenght
  122. Auto-populate a master list from info in other sheets without adding spaces
  123. VBA assistance
  124. VBA to login and post in FACEBOOK
  125. Using And / Or with Conditional Formatting
  126. VBA Assistance - Highlighting and Deleting based on another cell value.
  127. [SOLVED:] Merge Excel files with different yet similar data headers
  128. Change list values using VBA
  129. Slow dynamic shart update xl2016
  130. [SOLVED:] "For each ... next" loop not working
  131. [SOLVED:] Row Compare - Data not cell
  132. A way to filter based on strikethrough formatting?
  133. Form 2.0 Frame
  134. Saving & closing
  135. [SOLVED:] VBA to place combinations from cell to muliple cells essentially un merge them please
  136. [SOLVED:] need VBA to arrange the data from left to right smallest to largest, please!
  137. [SOLVED:] Need VBA TO LIST VALUES THAT CORRESPOND VALUES IN GHIJK
  138. [SOLVED:] Help edit data in listview via two Dtpickers
  139. Exporting worksheet from a closed workbook in a shared drive to another workbook
  140. Ribbon Interface Menu builder
  141. Help in VBA problems with Macro
  142. Expand the Range For Each Cell in Range
  143. Excel VBA to compare two lists
  144. Calculate the percentage of those who answered YES
  145. synthax of Cells.offset.value
  146. [SOLVED:] Renaming a sheet after a cell value that's too long
  147. [SOLVED:] Select and sort rows based on multiple criteria
  148. Calendar by BlueCactus not works
  149. Need this to in VBA please the formula used is limited. Thank you
  150. Autohighlight
  151. Elseif with values of formulas
  152. Search for Job ID and update fields in row below
  153. Specified table rows copy from Sheet to another sheet
  154. [SOLVED:] Data sort a dynamic range of conditionally formatted cells?
  155. Alternating MsgBox
  156. Sleeper: How to divide time series in to shorter time series in vba
  157. [SOLVED:] Data sort a dynamic range?
  158. [SOLVED:] ADO - Issue in Excel
  159. aggregate Data and create new dashboard
  160. [SOLVED:] Anyone fluent with .Names.Add using values rather than addresses? (advanced)
  161. [SLEEPER:] Update a list rather than just add to
  162. [SOLVED:] Remove extra commas from end of content
  163. Loop through Pivot Table Filter field from a List and create pdf
  164. Trouble executing VBA on remote connection
  165. Linking equation with a code.
  166. [SOLVED:] Moving data labels to variable location on bar chart
  167. [SOLVED:] Need VBA out- put to different location on worksheet.
  168. CommandButton - Save in multiple locations
  169. VBA - Connecting to Database using System DSN
  170. I have a formula that needs to be turned into a VBA, please!
  171. [SOLVED:] How DO I remove the FALSE return from this formula to leave an empty cell.
  172. Hyperlink Error handling challenges.
  173. [SLEEPER:] Dialog box, select rows>5, delete in multiple worksheets
  174. Highlight 2 Cells Based on a text value(false)
  175. [SOLVED:] How to ignore hidden columns
  176. [SOLVED:] Adding to Collections
  177. [SOLVED:] Show UserForm ONLY once workbook is fully open & displayed
  178. Need Help with Excel Project
  179. Compress Mutilple Files
  180. Need VBA code revised to ignore the Column A data, please!
  181. [SOLVED:] Multiply two columns and sum a column in Listview
  182. [SOLVED:] Input 2 files and create 3rd file
  183. [SOLVED:] Find first row with two commas and delete
  184. VBA - finding date in another worksheet
  185. Change the major units in X axes in chart(vba)
  186. How to hide cells based on values
  187. Excel VBA ~ Google drive doc
  188. [SOLVED:] Reference formula help
  189. Print/pdf excel sheet and include a specific word document vba
  190. [SOLVED:] ELSE without IF Error - multiple line breaks including AND and THEN
  191. [SOLVED:] Range Copy/Paste Loop for Multiple Sheets to Multiple Sheets
  192. Remove pictures/shapes of PowerPoint with VBA
  193. newbie needing VBA help
  194. [SOLVED:] creating label
  195. [SOLVED:] VBA Code Range Issue
  196. [SOLVED:] How to use VBA Slicer to connect two PivotTable
  197. VBA, where ever the data is found in column BCDEF, macro can still accomplish results
  198. Book2 Macros interfere with Book1 Copy Book2 Sheet
  199. [SOLVED:] Conditional Formatting Help
  200. worksheet Names 255 or less byte truncation - bug?
  201. [SOLVED:] Problem with chart
  202. VBA using INDEX MATCH
  203. [SOLVED:] Pivot Table Data
  204. One Cell with different Time and Strings
  205. [SLEEPER:] Cut away days to have only hours : 45841.12 -> 0.12
  206. 2 Macros Please Help getting so lost... to delete columns and email files
  207. 90 days past due chart
  208. Subscript out of range: Do While Cells(s2, 2) And Cells(s2 + 1, 2) <> "end"
  209. [SOLVED:] Toggle Shape Fill & Text Colors
  210. Object as Picture and Data Rearrange
  211. [SLEEPER:] A Simple Pyramid Totals
  212. HTML scraping/parsing
  213. [SOLVED:] Conditional formatting without using A1-notation in the rule
  214. VBA - conditional error with code involving LBound(SheetNameArray) To UBound(SheetNam
  215. VBA Code to control Data Connectin from CSV File
  216. download via Microsoft.XMLHTTP fails
  217. Prompt message box for importing access table data
  218. If XLSM in XLSTART, Then Excel doesn't open with blank WB
  219. Search for Excel workbook and open
  220. Copy data from userform to sheet using option button
  221. List text files in folder based on partial file name - repeats first file found
  222. Simulating returns
  223. [SOLVED:] Inserting Files From Multiple Columns - Concatentate Result File
  224. Combine excel workbooks from multiple folder into one workbook
  225. How to STOP Excels spell checker from checking text boxes
  226. [SOLVED:] VBA to delete rows where first 4 words of text in column A are duplicated
  227. [SOLVED:] Re-lock a Column after its been unlocked upon cell exit
  228. Write Data to Embedded Excel Worksheet in Word
  229. VBA - Finding and copy row with first value >&< certain threshold
  230. Dynamic arrays And Financial Functions
  231. [SOLVED:] Hide Unnecessary Decimal Markers
  232. Date selection help please
  233. Change font on a sheet based on a value in a different sheet.
  234. [SOLVED:] VLOOKUP TO GET RESULT AS FORMULA
  235. Search by Multiple Criteria and Two Listboxes
  236. VBA Importing text files from user specified folder
  237. VBA Code Not Working In China?
  238. [SOLVED:] Dynamic Column In Code
  239. Webservice into Excel
  240. Formatting with hidden columns
  241. Sleeper: Sum and Export to PDF
  242. [SOLVED:] In need of help with a code
  243. VBA code for re-organizing address lines
  244. Table of Contents: Hyperlinking to Folders Using a Combination of Cells
  245. Want to search for value in column across multiple sheets and copy rows with value.
  246. [SOLVED:] Add certain amount of rows to last rows per chapter
  247. Speed run time of code
  248. Move rows that meet criteria of sheet from multiple workbooks to other workbook (VBA)
  249. Identifying Duplicate E-mail Addresses with Different First and Last Names
  250. [SOLVED:] VBA Help - Code to create a copy of a macro enabled workbook