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