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

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