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: Using Union to combine two ranges
  2. Basic VBA - Active X control to also link to cell value
  3. Updating Internet Web page from excel
  4. Random numbers from a range to specific sum of randam values!
  5. Solved: Average Cells Based on Numbers in Array
  6. Probelm Filtering Pivot Table
  7. Copying Filtered Items to an Array
  8. MESSAGE: License information for this component not found
  9. Exporting a sheet with macros included
  10. Overlapping of Text VBA Problem
  11. Solved: splitting text at Hyphen
  12. My macro crashes on a different computer!
  13. Solved: Read the URL in column G then paste the company name from website in column H
  14. Using variables to reference a range
  15. Copy a range to another workbook
  16. Disable or Hide new workpage tab
  17. Solved: Quick Simple Help with Selection Code
  18. Solved: Simple Selection Code Question. The readable version.
  19. Sleeper: Save 2 Sheet's - criteria in a particular cell
  20. Solved: Chart Macro: Automatically Selecting Labels Range
  21. [SOLVED:] Convert date to string yyyymmdd
  22. [SOLVED:] Group pivot items
  23. Solved: Is it possible for a function to affect another cell?
  24. VBA issue trying to match sets of data
  25. Error ,want help
  26. forum searching question
  27. Macro that generates a report of cells' values source
  28. multiple criteria for sumifs VBA code
  29. Auto Numbering
  30. creating multiple workbooks and worksheets quicklyA
  31. Solved: Add entry into one sheet into a list in another by triggering worksheet change event
  32. Sort columns in VBA
  33. how to loop in vba
  34. Solved: please rectify auto row insert
  35. VBA ignore weekends and holidays.
  36. cells that some rows have in common
  37. Solved: Select Tabs using a string
  38. Alternative for vlookup.Need help on my code
  39. Solved: Author Name in Excel
  40. [SOLVED:] Fault in Code, Do I Error code it or write code to account for it?
  41. VBA to identify unique values
  42. sumproduct in vba
  43. File Browser Return Full Internet Path
  44. Excel Data Matching Word Tables & Looping
  45. Filter out Rows with multiple duplications of data
  46. Open multiple workbooks by loop through cells
  47. i need to kill 2 processes
  48. Solved: Remove Duplicates
  49. extract sring from last space
  50. Planing Formula
  51. Sound Generation Software
  52. VBA to change filters in pivot one after other
  53. Solved: Hiding Sheet Via Userform
  54. Charting Month Year at together
  55. Call function from .XLSB to .XLAM
  56. Solved: How to unlink a TextBox linked to a cell in a worksheet
  57. Solved: Copying Cell data and formats across two spreadsheets
  58. find last cell with cell reference
  59. Rename external ped files with names given in excel
  60. Sleeper: Loop & Match to copy multiple row of data
  61. Returning a date with a function
  62. Solved: Excel file splitter
  63. PDF to Excel Import
  64. Selection box on Vlookup error
  65. VBA code to click website button to access node
  66. Solved: How to Write Formulas in VBA?
  67. Solved: Exiting loop once condition is met
  68. Solved: Copy Rows to another Sheet in another Workbook
  69. automatically send email if cell background colour changes
  70. Solved: Printing code
  71. Solved: userform to populate the list box with values
  72. send login details to web form using Microsoft.XMLHTTP
  73. Solved: Conditional Sorting
  74. Show progress on extraction of data from DB
  75. ActiveX Control _Click doesn't work in second window
  76. I Need Help Edit Code Auto Save Every 5 Minutes
  77. Solved: Autofill Series with a minimum and maximum
  78. Solved: Useform autopopulate list box on opening the userform
  79. Find and replace data in a text document
  80. unhide\resize enmasse
  81. Split into 2 rows IF - VBA
  82. Code Fix to Delete Duplicates
  83. Solved: Use input box in a formula
  84. Trying to write a vba variant to an excel range which consists of a singular row and
  85. ActiveX Textbox Help
  86. VBA - Split time range in 10 seconds increments
  87. VBA to import sheets from a workbook in a folder
  88. Lock ectire row by an value via VBA
  89. Solved: VBA that synchronize sheets to another sheet
  90. Search and Update Records in External Excel File
  91. VBA: get specific folder from the path
  92. Solved: Create Text files for each subject and Date
  93. Populate Variable Array from Range - VBA
  94. ComboBox's linked loop Crash HELP!!!
  95. input button
  96. VBA Format vs Range.NumberFormat
  97. aggregate & concatenate
  98. Solved: Worksheet_Change to concatenate values
  99. Read pdf content from excel
  100. I need help edit code clean cell and past
  101. Data manipulation
  102. Create Subfiles from a master file using key to split workbooks to seperate files
  103. Count of cells using VBA
  104. Validation
  105. Exclude a word
  106. access database tables in Excel
  107. Solved: Add autofilter to data on a worksheet that is not the active sheet
  108. Conditional Formatting and VB
  109. Find the largest value in a column, then copy and paste to a different workbook
  110. After send email, write column already sent
  111. Sorting columns containing checkboxes by values in header row
  112. Insert Row in new workbook
  113. Help to copy and paste based on cell values
  114. Help to execute a word macro within a excel macro
  115. Solved: Last 10 Rows of a Range from a Closed Workbook
  116. need to concentrate on VBA itself
  117. Sleeper: Copy values using auto filter more criteria with macro
  118. Solved: Filter Guide on "X" criterion on the "Y" result tab "Z" and "V"
  119. Solved: vba to insert formula using variable
  120. Vlookup issue - How to change the source file without affecting vlook
  121. Get current web page title and output to cell
  122. Userform help
  123. copy value and insert new row then paste
  124. VBA: Compile Error: "Invalid qualifier"
  125. unable to set the currentpage property of pivot in vba
  126. Timer counter
  127. Solved: Arrary Function, Not updating Correctly on Different Sheets
  128. Solved: Lock unprotected cells, if a cell is changed - VBA
  129. Solved: Excel forces text into date format
  130. Allow end users to delete multiple rows within a range only - VBA
  131. Excel form that attaches file
  132. Solved: VBA Program to Compare 4 Columns in Excel (Required)
  133. Create "draggable" series name for chart created in VBA
  134. Solved: Excel Workbook Not saving
  135. Creating an excel Save As button in a workbook.
  136. Show Equation of Referenced Cell
  137. Built my excel app but it's super slow
  138. Solved: How to fast write Excel VBA array contents to a text file!
  139. Search and Replace Macro for .txt files modification
  140. Solved: Using find and copy, but only want it to search in 1st column
  141. Exporting specific data to seperate files
  142. General Excel Question
  143. Downloading URL to SaveAs in Directory
  144. Change Font and Size in Excel Footer
  145. Creating a form on an excel worksheet and posting it to a data sheet in the same wkbk
  146. [SOLVED:] Multiple selection in Data validation list
  147. Error Handling inconsistent?
  148. If a cell is NA then lock sheet - VBA
  149. Find Page numbers on one sheet (footer) and paste on cells in a different sheet
  150. Solved: Finding % usage of a word - w/filtering
  151. Solved: Create files and change properties
  152. VBA error 1004- Glitch or Coding Error?!
  153. Compare Column
  154. naming charts
  155. only local SQL databases?
  156. Vba Code Automatically Sort Large To Small
  157. Global Address Link
  158. Solved: Creating and Sorting a Dynamic Range
  159. extract data from pdf to excel
  160. searching data if id of column matches
  161. [SOLVED:] Copy info of a name range
  162. Include Filename in the Modified Macro
  163. Solved: data from Word form to excel sheet
  164. Send email based on a date
  165. Solved: Question Box on Flowchart
  166. inserting multiple drop down menus
  167. Solved: Code to search for a Value in a Range
  168. Translate index-match function to vba code
  169. Pivot Table and Formula
  170. help please ASAP type mismatch error
  171. Copy from notepad and paste in Excel cells
  172. Bulk Email address verification through macro?
  173. VBA to consolidate multiple excel files into one
  174. How show msgbox in created Word Document
  175. Could you tell me what is Excel VBA?
  176. To count values in a changeble range
  177. auto saving a file using a number value from a cell in the spreadsheet
  178. Sleeper: Capture old value of cell before change!
  179. Problem with declaring variables
  180. Enable grouping and Ungrouping in Protected Sheet - VBA
  181. Date Separater
  182. Enable users to click"+" to group/ungroup in a protected sheet - VBA
  183. Staying on Current Sheet
  184. Macros to Import Keyword file
  185. Validating repeated values, then bring the result to another cell
  186. How to move a cells value to a diffrent sheet with a check box
  187. Solved: Need VBA code to split quantities based on availability in another table
  188. VBA to autofilter on current date
  189. Merge “Paste Values only” VBA code with “force macros” VBA code and place the code in
  190. Solved: vba auto row insert and revert back
  191. Auto-insert comment, auto insert date and time
  192. First Factor Formula
  193. Pop-up Error Message
  194. Naming Array
  195. [SOLVED:] Object Required For Parameter
  196. Solved: Another Dynamic Range Question
  197. Combining "Force users to enable macros in a workbook" and "Disable Cut, Copy, Paste"
  198. Solved: Problem with Proper Case
  199. VBA script to move files from one folder to 3 and populate list of files
  200. Solved: VBA help
  201. Find all black cells in a range
  202. Pictures - Grouping and Flip
  203. Close IE using Caption Name
  204. Refresh Data Connections in VBA then Message Box
  205. Solved: Make a Summary Sheet
  206. Linking Combo boxes
  207. Multiple goal sheek code error
  208. Detecting Multiple Active Sheets
  209. Solved: Sum a column B where column A is the same in two different sheets
  210. WHATS IT TAKE TO GET A ANSWER
  211. HELP!
  212. Solved: Dir function skipping the first file
  213. Solved: match 2 columns and display 3rd column value
  214. Axis Rounding (decimals, tens, hundreds, etc.)
  215. How to count number of red color in a row
  216. Solved: Use Index, Match, and Max VBA
  217. Loop through files in a directory and delete if not currently in use
  218. How to find exact substring within a cell
  219. Solved: Help Importing multiple XML files - VBA
  220. Conditional Paste
  221. How to write a vba code
  222. Load text files to ONE sheet
  223. SUM variable range LOOP
  224. Loop to combine data in 2 columns and insert string every 145 combinations
  225. Function to Return an Array
  226. Problem with IE automation - getElementsByTagName
  227. Finding data in a range
  228. Solved: Send Data to different workbook
  229. Solved: Removing a item from a listbox
  230. Solved: Storing Values/Data beyond a subroutine
  231. Solved: Pull data from other sheets
  232. Solved: Lock Cells (Excel 2010)
  233. [SLEEPER:] Pulling custom footer from another sheet, to only appear on *final* page
  234. Help - Automate Pivot Filter Changes
  235. Solved: Continue Macro after Error Handler
  236. Solved: Delete a six-row block which occurs every n rows
  237. Two doubts on some (i think) simple codes
  238. Cashflow Present Value Calculation
  239. VBA - PIVOT RELATIONSHIPS
  240. [SOLVED:] Check for presence of VBA Procedure in all modules
  241. Who has a file open on SharePoint
  242. animated chart
  243. Working with text for a report
  244. Code for not add the data in Sheet2 if all cells in range in Sheet1 are not filled
  245. Solved: Sum unique values in a range
  246. VBA export of cells with variable range
  247. Save Excel to PDF one page wide
  248. Code to automatically add new email address to a table
  249. Histograms in excel 2013
  250. book