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: Showing all offset matches on different sheet using formula?
  2. Summing last two entries or smallest two entries in a list
  3. complicate unhide sheet
  4. Solved: Replace in a sheet and not the entire workbook
  5. Moving 3 decimal places
  6. Simplify SQL string
  7. Solved: use today in formula
  8. Solved: Insert/Delete Row Between Entry
  9. Hide Rows Using Data Validation
  10. 2 Excel Files, 1 Userform
  11. Solved: UserForm scroll bar
  12. Solved: Open text File into a Excel workbook
  13. Solved: Named range quickie
  14. Solved: filtering, maybe?
  15. Solved: Excel out of memory with plenty of memory unused
  16. Print Userform
  17. Copying data from another excel workbook created to another file automatically.
  18. Manipulate data in range
  19. Solved: populating listbox2 with listbox1
  20. Determining name of nested multipage...
  21. Highlighting cells using VBA & Sumif()
  22. Auto close excel after 1hr
  23. Solved: Insert File(s) In to the main xls file
  24. Solved: Display info from Module in msg box
  25. Solved: 52 wks or 53 wks in Year
  26. Solved: Test if last column is longer than first column
  27. Solved: Autofit alternating sizes
  28. Execute SQL Stored Procedure
  29. VISTA: multiple excel apps
  30. copy and paste 2 destinations
  31. Solved: Add Bold to Number Formating
  32. Solved: populating a worksheet
  33. Solved: Call Subroutine to Clear cells on Worksheet_Change
  34. Assigning comments to UDF
  35. Solved: List worksheet names across columns
  36. Count rows based upon multiple criteria
  37. Reassign variable
  38. count if help
  39. Solved: Max and Min dates in right header
  40. Unload frm1 - error (Wrong Number of Arguments)
  41. This Should be an easy copy/paste
  42. ensure that all controls have a value
  43. [SOLVED] Stop WorksheetChange Event
  44. Excel Help - Templates / Forms
  45. Solved: Drop Down List
  46. Solved: deleting form listbox and datagrid
  47. textbox controlSource problem
  48. double V-Lookup
  49. [SOLVED] Delete Rows
  50. Top 5 Help.
  51. save userform and continue later
  52. automatic calculation
  53. Solved: Match
  54. Flexible range graph
  55. API show last active URL
  56. Solved: Return a subtotal in a list
  57. Update Registry key via VBA/excel to chnage default E-mail to Lotus Notes
  58. Retrieving hidden columns
  59. Adding filter criteria
  60. Solved: Generate a computer's hardware code
  61. Display sheet name in a cell
  62. Solved: Macro to compute Lagged Correlations
  63. Solved: Enable additional controls by vba code
  64. Down and Dirty xml->xsd
  65. automatic save a file and close
  66. vbe and excel date settings
  67. Solved: Option button and text box
  68. Solved: Open workbook when excel starts
  69. a userform question
  70. Solved: Apply a Range Name to a second sheet
  71. PERSONAL.VBO
  72. Solved: Problem Moving Code from Module to UserForm
  73. Macro code isn't working
  74. [SOLVED] Dsiplay image based on list box selection
  75. Warning for missing information
  76. Solved: Calculating wage using time format & currency format?
  77. Solved: Import Text File
  78. Help in Tab in user form
  79. Embed ActiveX Control for portability
  80. Solved: Input check
  81. Solved: User defined data type - array of an array!
  82. [SOLVED] Link VBA and HYSYS
  83. Solved: how range is defined for a worksheet?
  84. Solved: Get values from a multi columns listbox
  85. XLM Page Setup
  86. Solved: search for #n/a
  87. Is this ready?
  88. Solved: Create folders on network drive
  89. Solved: Listbox selection
  90. XY Scatter graphs
  91. Chart Problemz
  92. Solved: 1st Form option button to 2nd FORM
  93. Linking?
  94. Solved: Copy & paste a cell and row times defined number
  95. Solved: subtract
  96. Solved: Keep only the newest data?!?
  97. Copy rows from multiple worksheets
  98. Selecting Range based on criteria?
  99. Solved: Selecting Range based on criteria?
  100. Solved: Combo Box help
  101. Solved: Date Formula With Conditional Formatting
  102. Using OWC9 spreadsheet on User Form
  103. Solved: Setting a range from a Worksheet module
  104. HELP!! Attachments to email - excel VBA
  105. Solved: Save one sheet as Read-Only
  106. Solved: Get a Full address of a website using a macro
  107. Solved: Collating and formatting financial data
  108. Excel 2007 -- need help
  109. Form-level key handler
  110. Multiple V-look ups at once
  111. Solved: run if this cell is blank
  112. Tracking payment adjustments
  113. VB date formats - UK / US - HELP!!!!!
  114. Solved: Counting Visible Sheets in a workbook
  115. Solved: use multipage as button
  116. Select all text of a textbox
  117. new to VBA scripting. need help.
  118. V Lookup
  119. Solved: Run-time error '3464' Data type mismatch in criteria expression?
  120. Help with: Hide empty rows, unhide others from johnske
  121. Solved: Advice On Macro For Transfering Data
  122. File I/O Functions
  123. Solved: Ignoring 0 in list
  124. Solved: reducing file size
  125. Solved: Date Format
  126. Solved: Cell Error ####
  127. Solved: Building Dynamic List for Combobox Sort Alphabetically?
  128. Scanning for specific sheet names
  129. Find used cells, skip blanks
  130. Excel VBA Problem :(
  131. how to save worksheets in another excel file?
  132. Solved: rounded down format/display
  133. Conditional Formating
  134. Solved: Pasting from Word into Excel
  135. hide or disable a page
  136. Solved: Excel sync from network copy
  137. Naming a Worksheet Today's date
  138. Alter one macro from within another
  139. Solved: output message in label
  140. clock - display message every half hour
  141. Solved: how to write the codes?
  142. Solved: Install if certain user
  143. Solved: turn off features if not found
  144. Misc problems and questions.
  145. Run macros on different occasions
  146. Concatenate in a cell the content of a column if a certain condition
  147. See the values from a formula
  148. VBA paste from clipboard to email
  149. Solved: Saving Sheet
  150. Solved: Comparing 2 Sheets in a Workbook minor bug
  151. Solved: Sort without a title row
  152. Consolidate to Summary Page
  153. Solved: filling in data, relative to the active cell
  154. Sorting Multiple columns programmatically
  155. Solved: Show Hide Multiple Columns at once
  156. Hide and unhide rows by selecting a letter from a userform ComboBox
  157. Another minor Bug :( passing String variable
  158. Variable Indirection
  159. Waiting message
  160. Enumerate reference GUID's
  161. Solved: Check if sheet is blank
  162. Solved: Referencing A Variable + An Integer To Show Cell Value?
  163. how to delete rows?
  164. set label value equal to file name
  165. Array.Count gives Invalid Qualifier Error
  166. Solved: autofilter event ... ?
  167. Solved: Range Array
  168. Urgent - manual combo input
  169. Add ColumnHead to a ListBox via VBA
  170. Find First Cell, Check if Pivot Table
  171. Help in pictures on user form
  172. AfterUpdate event in Class module
  173. AutoFilter - number of criteria
  174. Solved: Conditional Range without autofilter?
  175. Why my UserForm cannot be initialized?
  176. Solved: Excel to Access
  177. replace an icon
  178. Merge tables on diferent workbooks
  179. Statistics on LogNormal/Monthly Arrays
  180. Praying... and Praying....
  181. Solved: Worksheet_change event with VLookUp
  182. Solved: Formula question
  183. Solved: What's up with thes CheckBoxes and Option Boxes?
  184. Speed Imporvements
  185. Trigger Excel Solver without VBA
  186. Solved: Formula not working the way I need it to
  187. Solved: Display Character Entries in InputBox with "*"
  188. Excel VBA "OnKey" command problem
  189. Block cells
  190. Solved: error
  191. Custom Menu Item not following document
  192. Trigger Excel Solver by User Defined Function
  193. Check availability
  194. % formula
  195. Solved: workout
  196. Changes from vba version 6.3 to version 6.5
  197. Another Related Question/Issue (combining workbooks into Master file)
  198. a udf with many arguments
  199. Problems freezing the header row form scrolling
  200. Solved: Adding Icons to Add-in
  201. Solved: Drag Over Event for Cell Color Format Properties
  202. Solved: Add Input box to this code
  203. Solved: Create an Array from a Filled Range
  204. code failure
  205. Solved: Mark minumums by columns in each segment
  206. Solved: Macro: Cell Formatting is Failing
  207. Solved: colorindex = xlnone ?
  208. Solved: Sort Left to Right
  209. Current Account Program
  210. Solved: Need help implementing code
  211. Solved: Hiding the "X" or close button on user form
  212. Sum text box values
  213. add an item to a vbe toolbar
  214. Print to 1 pages wide sometimes makes it too small
  215. month
  216. Lookup result needed
  217. Solved: ordering complex dates
  218. Sumif & sum only positive or negative number
  219. Solved: Hiding Worksheets
  220. show answer to other cell
  221. how to put the sheets in order?
  222. how to open a sheet instead of another sheet?
  223. code for determining error in s/sheet
  224. Switch to tab if already created
  225. row height set up
  226. updating links to external data source
  227. how to load textbox?
  228. Solved: Run macro after file save
  229. Settle Time for Excel Application
  230. write in cells in correct order
  231. open an image inserted with hiperlink
  232. IF statement inside a vlookup?
  233. Sorting data over multiple sheets into array
  234. Solved: Find blanks - move over and then highlight
  235. Export to Txt File - Amount should be right justified
  236. Macro to delete other macro or Module
  237. Solved: Highlight date if it is two weeks late
  238. Solved: Sheets(Array(1,2,3).Copy based on date?
  239. How can I do this?
  240. Solved: Requisite first posting to view attachments
  241. list box
  242. Excel VBA to server
  243. remove Pivot lookup value
  244. Solved: Create an Array from Filled Range - Part II
  245. Check Lotus Notes if open
  246. Solved: Splash Screen
  247. Autofill dynamic range across sheet
  248. ASCII replacement
  249. Turn on Resources on Install
  250. use code for multiple controls