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. [SOLVED:] Selecting ONLY filtered cells NOT all the active cells in a column
  2. [SOLVED:] Excel Macro Run-time error '1004': Selected method of Range class failed
  3. Hello, how to distribute content to a cell by various cells automatically.
  4. [SOLVED:] Find a string and clear cell's contents to the right
  5. error parsing text files in directory using excel 2010 vba
  6. Filter all sheets by filtering one sheet
  7. Quartiles with N/A
  8. Filter
  9. [SOLVED:] Lock (freeze?!) objects
  10. Private VBA Apply to all New Worksheets
  11. Consolidating Multiple Sheets into One File
  12. [SOLVED:] Filter on today's date
  13. [SOLVED:] Workbook.Open Event not working correctly
  14. Splitting Sheets
  15. Macro for counting frequencies
  16. VBA String Range Detection
  17. [SOLVED:] Merging multiple worksheets into one
  18. Simple computation to record the difference between consecutive cells over a range
  19. [SLEEPER:] Need help creating VBA code for interpolation (kinda)
  20. [SOLVED:] Improve Multiple loop code
  21. VBA: Compare 2 cells from different workbook and publish the text right or wrong
  22. [SOLVED:] How can I use a current worksheet rather than creating a new one?
  23. Delete rows based on a condition
  24. copy-paste from one Excel file to the other VBA
  25. Conditional macro in Excel based on two or more conditions
  26. Prevent duplicates for 2 sheets + msgBox
  27. [SOLVED:] conditionally sum values based on the TOTAL of multiple columns being greater than 0
  28. fill in sequence number
  29. Get data from a PDF...VBA
  30. [SOLVED:] Text Box not Displaying
  31. VBA Expert Wanted! >> Populate Table by Cycling Through Sheets
  32. [SLEEPER:] Retaining the Macro code for disabling Save option in Excel
  33. [SOLVED:] IF / OR Statement
  34. [SOLVED:] Delete table last row
  35. [SOLVED:] Transponse help
  36. [SOLVED:] Formula - Sumif,sumifs, aggregate
  37. User Defined Function Call Error
  38. [SOLVED:] Returning the Desktop Path
  39. Vlookup/Index match, Vba code for two sheets in a Workbook
  40. Pasting Rows from one Table to another
  41. Cell Split or add Rows Excel VBA Leave Plan
  42. [SOLVED:] Creating a new row problem
  43. Use Find Method to Clear Groups of Cells in Column When First Cell Marked "DELETE"
  44. VBA problem can anybody help
  45. Macro to Convert text to Number to last cell in the range
  46. Excel userform to search find and return data
  47. VBA Shift One Row Down.
  48. Help....for Changing Vba Code in a Pivot for Filtering a Criteria.
  49. Assigning a cell value to a variable - between different workbooks
  50. Excel file which listed new for any update information
  51. Macro to Copy data from Input sheet to Output sheet based out few criteria
  52. AutoFilter and Copy - Paste
  53. [SOLVED:] Listview in userform to show data entred by textboxes and comboboxes
  54. Run-time error "91":
  55. Exit from Sub which is called from another Sub
  56. [SOLVED:] Seletion problem in listbox (Userform)
  57. TextBox Has Numericals, Value is String of Hexadecimals
  58. place grid in parsed xlsx
  59. How can I copy and image file from Access Table to Excel?
  60. Reset Sub Workbook_BeforeClose
  61. add date to the column during update in worksheet
  62. Urgent: Help Needed With INDIRECT Formula
  63. [SOLVED:] Create Outlook 2013 Calendar items without duplicates
  64. [Solved] Referring to a String within Quotations
  65. [SOLVED:] Excel MultiLine Textbox to Access Database - MultiLine lost in the Access Database
  66. Code for multiplying 2 values based on search
  67. Help with worksheet_change
  68. date issue for excel file
  69. Pivot Table expand/collapse buttons
  70. [SOLVED:] Help with Loop
  71. Importing Data from Closed Workbook
  72. [SOLVED:] SUM IFS (Vba)
  73. ISNA alternative
  74. Data Comparison between master workbook and another workbook
  75. Creating list of Unique values in offset cells
  76. Cycling through filters
  77. Pivot error
  78. [SOLVED:] Array declaration question - "myArray()" versus "myArray"
  79. CMD.exe window keeps "taking over" when looping
  80. Copy email id & contact numbers from multiple resume which is in word file
  81. Formating date delimiters in real time
  82. XML Source data format change, Macro's no longer working
  83. [SOLVED:] vb to copy and paste based on criteria
  84. VBA formula
  85. Copy Charts from Excel to power point 2007 and save as.
  86. Looping a macro until the formula within the macro results in an acceptable output
  87. Multiple Command Buttons & results in a new sheet.
  88. Open a file from browse window and perform VLOOKUP
  89. [SOLVED:] AdvancedFilter displaying Unique values.
  90. google poly line encoding in excelR
  91. [SOLVED:] Unable to locate named range in code
  92. [SLEEPER:] How to avoid Circular reference in a Range
  93. [SOLVED:] Transformation of data with macro
  94. [SOLVED:] save one large file as separate text files
  95. [SLEEPER:] Syntax for unique values
  96. [SOLVED:] Filter Data Using Macro
  97. [SOLVED:] Modification to copy VBA code
  98. [SOLVED:] VBA: Importing data from one worksheet to another returns "TRUE"
  99. [SOLVED:] Aligning a chart textbox with a variable datapoint
  100. [SOLVED:] write data consecutively if certain cell is not empty
  101. [SOLVED:] Application.FileSearch Help
  102. Help: How to Find and Replace VBA Code with VBA Code?
  103. VBA to copy down information into blank row
  104. How to Allocate ER Credit with VBA
  105. What if analysis in Median (formula help required)
  106. Loop for copying values from excel file to fill sentences in Word
  107. [SOLVED:] SUMIF with Left criteria VBA
  108. 2003 sorting code not working in 2010
  109. [SOLVED:] Max Row Index for an Array
  110. [SOLVED:] Excel 2010 How to Create a Custom Toolbar and Distribute to 50+ Users
  111. Using VBA to send emails via outlook using excel cells
  112. Establishing comm link with Eicon Aviva from Excel VBA
  113. [SOLVED:] Use Cell Value to go offset to another cell
  114. [SOLVED:] Auto-remove duplicates from dynamic list
  115. [SOLVED:] Find and Open an email in Outlook
  116. [SOLVED:] Odd error when comparing times with "dateadd"
  117. Code to sum columns in lastrow +1
  118. how to get the directory (file save) when the macro is run the first time in the day
  119. I need help with this VBA exam example
  120. Macro to Transpose data
  121. Can you help fix this macro?
  122. [SOLVED:] VBA Edit to Search Range
  123. [SOLVED:] Nested Loop in VBA
  124. [SOLVED:] Employee schedules, 15 minutes interval table [working/slow; need alternative ideas]
  125. Excel Recursive function through XML file
  126. [SOLVED:] Pivot Table VBA
  127. Prompt/Store value based on a selection/entry
  128. Create different text files from parts of a range
  129. Using vba to automate a Microsoft Word document with data imported from a Excel sheet
  130. Copy-Paste rows from multiple worksheets into a new workbook based on unique id
  131. Defining Dynamic Named Ranges with VBA
  132. Macro to combine columns without formulas
  133. nervous! How To Import Data From SQL Query To VBA Coding?
  134. Return Last April using VBA
  135. search in another excel file with VBA
  136. [SOLVED:] TRYING TO UNDERSTAND HOW EXCEL VBA MACROS AND USER FORMS ARE LINKED TO EXCEL FILES
  137. Conditional wrap line - VBA Excel
  138. Linear programming using solver in Excel 2000
  139. VBA code for entering a formula not as expected
  140. VBA Multi Select ListBox Issues
  141. Revising a code that inserts a new option column upon execution of an option button
  142. VBA: Text from Excel to Word with formatting
  143. Userform calls other userform, then populate worksheet
  144. Linking Content of Wkbk1 to Wkbk2, Extract filtered information into table in wkbk2
  145. Help with VBA code Transfer excel range to Word bookmark
  146. how to open protected view excel file using VBA macro
  147. PDF Data to Excel Adobe XI
  148. Develop a macro to solve below problem
  149. How do I copy Internet Most Visited Places shortcuts to an Excel sheet ?
  150. [SOLVED:] How to set the SubTotal TotalList using a variant instead of an array
  151. [SOLVED:] Advise on "Best" or "Better" practices
  152. [SOLVED:] Pulling specific lines from a text file into Excel
  153. Pull data from webpage
  154. VBA Help - Excel Range (text) to Word Bookmark
  155. [SOLVED:] via code to use to 6, 8, 12 sheets
  156. Help vba code for a formula in two cells
  157. [SOLVED:] Vlookup using Vba code across two tabs
  158. [SLEEPER:] Create Summary
  159. Create new sheet
  160. How to Pass an array of implement(ed) object(s) to a sub/function?
  161. Help with a code for a picker
  162. Split certain cells to multiple sheets IF value
  163. [SOLVED:] macro to take values from range to slicers
  164. Vba to insert text in range of cells
  165. If dropdown only contains one option, automatically show that option - How????
  166. Return the value below the cell that contains a specific string
  167. I Need an Array Formula?
  168. Data from Excel to Word 07 Bookmark
  169. [SOLVED:] import txt or csv delimited parts into different excel sheets
  170. Sleeper: Look up records in Access from Excel and copy data to cell
  171. Date Validations using VBA code
  172. Loop within a loop vba
  173. Determine if all files in a folder were created today
  174. excel says it cant find the file I just DoubleClicked
  175. [SOLVED:] User Form .SetFocus Help
  176. Build new Nested Loop in VBA
  177. [SOLVED:] How to add a label to one selected data point in an xy scatter chart
  178. Sort on multiple dynamic columns using excel VBA
  179. [SOLVED:] Open Latest Outlook email by Received Date
  180. create a worksheet based on description
  181. VBA Form inserting dates in the wrong format
  182. [SOLVED:] VBA Set Variable equal to macro function
  183. [SOLVED:] Max value in array and return adjacent column (similar to offset/match in excel)
  184. [SOLVED:] SaveAs xlText (tab delimited text): delete empty line at the end
  185. [SOLVED:] VBA Sheet Protection Failing
  186. Copy and Enter Current Record Displayed in Userform a # of Times to WS
  187. Excel Duplicates
  188. Moving sheets to a new workbook
  189. VBA CODE- Match 2 cells and display the result
  190. Error When Testing Collection for Key Exists
  191. [SOLVED:] FSO filtering on the fly
  192. [SOLVED:] Change Numbers to Words
  193. VBA Importing a sheet from a closed excel workbook
  194. Multi-step workbook/sheet automation with VBA, macros, INDEX MATCH combination
  195. [SOLVED:] Add Dates to Printed Header
  196. Concatenate in VBA
  197. Excel 2013 - VB Script to save and e-mail form
  198. [SOLVED:] [VBA] Pasting data in Word looping for no apparent reason
  199. [SOLVED:] PivotTable field name is not valid when changing source data
  200. VBA Code - Lookup column1 in Column2
  201. How to Shell to other Application with excel vba
  202. [SOLVED:] Question with FSO filtering - snb
  203. VBA Calling/Application.run with dynamic inputs + error handling
  204. HELP with Formula to calculate Interest Rate
  205. Running a PDF file from Excel
  206. PROBLEM WITH SCROLL BOX INSIDE A FORM
  207. [SOLVED:] Custom Function Needed for Evaluating Performance
  208. Saving Row as Text file - Concatenate & Line Breaks Not Working
  209. [SOLVED:] How can I remove duplicates from a dynamic range?
  210. Small Script Edit - Pasting value in front of data set
  211. [SOLVED:] Cannot unlink word header
  212. Delete row based upon Date
  213. Running macros while logged off
  214. [SOLVED:] Copy value of cell if date matches the date of another sheet
  215. Problem to create an indexed array - M(1 to 1, 1 to 4){i}
  216. [SOLVED:] VBA Code: If not in column A then Replace
  217. [SOLVED:] Dynamically Color Coded excel rows
  218. Turning Auto Calcs into Run by Button
  219. [SLEEPER:] Merge and Append 95 Workbooks into One Workbook
  220. [SOLVED:] Move data from one sheet to another and export
  221. [SOLVED:] VBA Code to Insert a Row
  222. Copy sheets from file to another but Not Copying those that already exist in 2nd file
  223. Move cell values and buttons up from application caller
  224. [SOLVED:] Clear contents before replacing text
  225. Search through a number of files for keywords and return associated data. help!
  226. Userform With Multiple Independent Combobox (delete row when not match)
  227. VBA Excel data to Powerpoint
  228. [SOLVED:] index match function & IF to exclude few values
  229. Color issue confusing me
  230. Help putting border around a range
  231. [SOLVED:] Add a sort filter to existing code
  232. Compare 2 multi-arrays and isolate duplicate into 3rd array
  233. Help with code to determine whether two strings are in a cell
  234. VBA Code - If Code #1234 found in ColumnA then result code 5678 return in ColumnC
  235. VBA Code: Use keyboard keys in VBA coding
  236. [SOLVED:] VBA/VBE Weird behavior when deleting a code line in a sub using a different sub
  237. How to Go to Next Row on a UserForm
  238. [SOLVED:] Finding the Sum of Numbers between words in the entire workbook.
  239. Shape Conditional Formatting & Permanent Logged In User, Date & Time Stamp
  240. [SOLVED:] Get latitude and longitude from Bing using VBA
  241. Help with macro for filter
  242. [SOLVED:] Import worksheet based on filename and date
  243. Pulling Data from Web - page still loading
  244. [SOLVED:] Search left from specific column eg. "y"
  245. convert text with (.) to number with (,)
  246. Removing blank lines from report calculated by macro
  247. [SOLVED:] macro to hyperlink excel cells to pdfs
  248. [SOLVED:] Cell Returns no value even though the cell does contain a value
  249. [SOLVED:] VBA/ Checkbox to add/remove fields in pivot
  250. How to close the all excel workbooks once i open a one excel workbook