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

  1. Solved: Noob question
  2. Solved: Increment offset
  3. Solved: Creating a name range in one column
  4. Update Links in multiple workbooks
  5. Solved: create a named range with a changing area
  6. Solved: want to remove #div/0 error by vbnull string
  7. Solved: Counting Cells Where Formula Does Not Return ""
  8. Column number conversion: hex to dec and dec to hex
  9. Solved: Print 2 pdf VBA error
  10. Solved: Autofilter using date
  11. linking ranges into dropdown and option boxes
  12. Solved: Search for first open cell in Row
  13. Solved: Different Passwords for all Users to view W/sheets 1 master password
  14. VBA for copying and pasting and insertion of rows
  15. Error Generation during copypaste macro run
  16. Solved: check file for xls and xlsx extensions
  17. Solved: Downloading Excel File from Website
  18. Solved: index/match with more than one match
  19. Solved: Creating a drop down list with source from another sheet
  20. Solved: Delete workbook on date....
  21. Solved: Alphanumeric Sort
  22. Solved: Using is empty on a range
  23. Solved: VBA Userforms and Cell based formulas not getting on together!
  24. Solved: Adding and Naming a Worksheet using VBA
  25. Moving Data from one table to another based on value input
  26. Solved: Highlighting Option Buttons
  27. Data And control operations from a closed workbooks being applied on report
  28. Solved: Cut Paste data into different sheet
  29. [SOLVED] check lengh of the values and move to next sheet
  30. Solved: loop not looping properly
  31. Solved: Active Cell Help
  32. Solved: How to bring back Recording / Stop Recording floating tool bar
  33. Please help to tweak my VBA codes
  34. Solved: Formula For Less Than / Greater Than
  35. insert array formula into range based on option button selection
  36. Solved: Text Import - cell format issue
  37. Solved: Run time error 1004
  38. Solved: VBA Hyperlink Problem
  39. Solved: Insert Image from file
  40. Solved: VBA Sort
  41. Solved: multiply statusbar
  42. Solved: Deleting Worksheets without OKing "Warning Message"
  43. Solved: Check if Sheet Name Already Exists
  44. Solved: Dynamic Controls
  45. Solved: Drop down lists tutorial
  46. Solved: help with copy and paste
  47. copying data from a closed workbook
  48. Solved: Create A Short Cut Key in Menu
  49. Solved: Autofilling a formula within row parameters
  50. Solved: Subtracting Named Ranges from combo box selection
  51. Solved: Interesting Auto-Number Problem VBA
  52. Solved: rearranging Code, separating OffsetResize
  53. Solved: Index Match Formula - Odd Behaviour
  54. Email code problem, stopped working
  55. ScrollBar value * call Macro
  56. Combobox vs protected sheets
  57. Solved: Vlookup in VBA - problems
  58. Solved: YesNo Box - Options Query
  59. Solved: Covert number to absolute value
  60. Solved: VBA issue with named ranges across workbooks
  61. Solved: Long vs Double data type
  62. Read Only view of a worksheet
  63. Solved: Copy content of upper cells
  64. Solved: Create folder & export sheet, not working
  65. Solved: TextBox Deleter Mystery
  66. Solved: Changing code (connecting range to dropdown selection)
  67. Solved: Named cell reference
  68. copy rows to worksheet two and PDF to print
  69. Solved: Problem with textfile save
  70. Solved: Exporting select data to a .cvs
  71. Solved: Run-Time Error "13" - Type Mismatch
  72. Combine 2 Codes
  73. Solved: Using vlookup with changing end array column
  74. Solved: Deleting rows as if by magic!!
  75. Excel chart alert (32000 pts)
  76. Copying range value without cellformula
  77. Data changed when imported
  78. Creating Timestamps
  79. Annoying privacy warning
  80. Solved: Automatically Save As when file opens
  81. Solved: Want to apply code to all sheets but wont work
  82. Solved: if cell="yes" then colour row yellow? how could do this?
  83. Sum If Same Row in data table contains criteria
  84. Get txt files from a folder to master file in different sheets
  85. Solved: Employee Rota: Worksheet_SelectionChange not working
  86. CHART Formula Change VBA
  87. How to make an input form?
  88. Updating series for all charts on Worksheet
  89. Running a Function or macro of child file from a Master file
  90. Cascading Lists via VBA
  91. Solved: Select numerous cells from active cell
  92. Invoice
  93. Solved: Date format incorrect from Text File
  94. Solved: Search Macro and Merged Cells
  95. Userform in Defult text box
  96. Solved: write log of changes in workbook
  97. Solved: how to wrap pages in multipage control
  98. Thank You VBA Express.
  99. Scrollbar
  100. How to extract data from Oracle Database into Excel Spreadsheet via VBA code
  101. Solved: Simple delete entire row
  102. Separating prices by month
  103. Deleting All Shapes Deletes Data Validation Forms
  104. Naming ranges of cells using cell content
  105. Solved: Print Preview
  106. Finding average of a range with macro
  107. Solved: Loop and Compare cell value & value returned from ado query
  108. filter based on active cell
  109. Listbox items from an array
  110. Solved: EXCEL communicating with hyperterminal
  111. Comparing data against table of values to output new data.
  112. Get help for telling me how to code VBA to pass argument from Userform to worksheet
  113. VBA Strongly Typed Arguments
  114. How to line up input boxes on forms?
  115. How to deal with quotes within a string
  116. Column Formatting Works in one instance, but not another
  117. Preparation of excel spreadsheet data for google motion charts api (VBA?)
  118. How do I disable inserting of rows?
  119. VBA Code to Automate Grouping
  120. Returning Arrays From Functions
  121. Source Control Of Spreadsheets
  122. Solved: Copy/Import based on Column Header Name
  123. Error message for missing data in userform
  124. Pass date as parameter
  125. Solved: Split Control
  126. Getting user to log changes before workbook is closed.
  127. Solved: vlookup not cooperating with other code
  128. Pivot Table Macro to lock manual filter/remove blank rows from datasheet
  129. Running a function of another file
  130. The opposite of TRIM
  131. Professional Looking UI Forms
  132. Icon Librarys
  133. Bot
  134. Option Button first IF not working.....
  135. How to open Other file types
  136. Referenzen permanent verfügbar machen
  137. Solved: vlookup problems, even formatted as numbers
  138. How To Use Vertical Spacing - Make Equal
  139. Solved: macro to make linegraphs
  140. Solved: Prevent duplicate data entry?
  141. My Macro stinks
  142. Closed: My Macro keeps crashing!
  143. Select/De-select items in list box
  144. Tracking Deadlines with Excel and Groupwise
  145. Solved: Calendar Control
  146. Error when passing data from Excel into Access (Office '97)
  147. Using Template To Produce Reports Where Number Of DataItems Changes - Advanced.
  148. Excel 2007 Pivot chart - showing filters on pivot area
  149. Copy from a cell and insert in another on a new line with a date
  150. Finding String2 in String1
  151. Trapping UserForm Events In A Seperate Class
  152. Solved: Pattern match to find worksheet name
  153. Maximum users of an Excel File?
  154. Solved: clicking on option button
  155. Selected Cell Color / Personal.xlsb
  156. How do I check if a word file is open from code?
  157. Functions
  158. problem comparing cells based on a condition
  159. Update specific data in one sheet with NEW data from another?
  160. move items in column up/down by criteria
  161. Solved: Get cell reference from one cell
  162. Solved: Copy range from multiple excel files in one file
  163. Solved: Insert a formula if a different cell is not blank
  164. Unable to copy, paste; Right click disabled
  165. Excel 2007 and if statements
  166. Solved: Sync ListViews items
  167. Copy to first filtered row problem
  168. Solved: Find a sheet name
  169. Self Destruct VBA Code
  170. Match value in two columns & delete non-matching rows
  171. Solved: Check list of folder files
  172. Decent Grids
  173. Disabling ActiveXControls Prompt
  174. Paste Combo Boxes so Cell Link is always in same row
  175. Solved: Macro to add value to cell based on previous available cell valu
  176. Solved: Sheet Calculate Event Not Working
  177. VBA Statements work in debug, but not otherwise.
  178. Using Progress Bars
  179. Delete Copied Data
  180. Looping through a range code
  181. Incorporating lastrow variables into sumproduct formula
  182. Solved: UserForm KeyDown Button Forces cursor to jump to next textbox
  183. Solved: Excel Update Links Problem
  184. Solved: Code to find a given string in a worksheet
  185. Database Connectivity Using Singleton Pattern
  186. Making a cell noneditable based on dropdown value in another cell
  187. autofilling formulae across columns
  188. Hiding sepecific column on based of condition
  189. Solved: Remove blank series from a chart using VBA ?
  190. Generate a message to Save and Not Open when downloading a file
  191. Solved: Need Help Trying to Unlock Certain Cells
  192. Do Loop Help
  193. Forward stepwise regression using VBA
  194. Working on Code efficiency...
  195. Capture Printer from Printer Dialog
  196. RibbonX code
  197. Solved: Error 1004 in Transpose macro
  198. Wrapping UserForm Modules.
  199. Solved: Hide Unhide Worksheets based on Name
  200. Help With Formula
  201. Public Variables don't work
  202. Unable to copy excel spreadsheet to another spreadsheet
  203. Solved: Data Validation , multiple selection same cell
  204. Solved: find, copy and paste
  205. VLOOKUP or HLOOKUP
  206. Solved: Changing Arrangement of Text in a cell
  207. Solved: Moving Rows with repeated value to different Tab
  208. Remove zero chart labels
  209. Solved: import data from another workbook
  210. Solved: Hyperlink - full address from displayed text
  211. Copy and Paste Range in the body email
  212. Solved: Dynamic code based on cell values
  213. VBA for Pivot Tables Help (Dates)
  214. Is it possible to create VBA or even VB just by entering data into a worksheet?
  215. File Lister
  216. Combine 2 or more Cells into 1 Cell VBA
  217. Userform input value to macro
  218. Workbook OPEN Event Code - Update Links
  219. Solved: How to chk on duplicated cell values & show msg box
  220. Varying the cell range around a sum formulae
  221. Passing a UDT member/element
  222. Can Excel 2007 help with website accessibility?
  223. Solved: Macro to Add Link to Each Worksheet?
  224. Solved: Prevent Sql injection in User Form
  225. Solved: Centralized Log Manager
  226. Solved: Limit length of input text box..
  227. Add subject, body, and attachments to emails thru excell/groupwise
  228. Solved: Detect if workbook is Read Only
  229. Shifting data in cell from a work book to another based on some condition.
  230. Special macro for range goal seek
  231. First & Last name comparisons
  232. Solved: wb close and form close
  233. Refresh pivots on close AND on data being entered
  234. Process works in debug
  235. Solved: UserForm change width- Left Border?
  236. I need help with a click proceedure attached to a dynamic label
  237. Print specific pages of PDF in Excel using VBA
  238. VBA Code Help
  239. Solved: useform help filling list from DB VBA
  240. Stop Excel from Updating Formula to external Workbook when copying the formula
  241. Extracting highest value correlations and series names from Correlation Matrix
  242. Solved: SUMIF "criteria"
  243. Solved: Calculate cell
  244. Solved: Formula Problems
  245. Solved: Inserting data from Excel into Access
  246. Sub string help
  247. Using an Excel Spreadsheet as a DataSource using DAO
  248. Excel VBA to print the entire Workbook single sided
  249. Problem toggling details
  250. Solved: Move excel files to a difference folder if sheet name is not "Payment Request"