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

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