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. XL2000 Add-In Question:
  2. Compare VBA Code in Modules
  3. Solved: Quick Concatenate Question (formatting)
  4. vlookup closest value
  5. Solved: Closing Excel by clicking the Red X
  6. Solved: set row color based on value of a cell
  7. Solved: TextBox Character limit
  8. Solved: VBA to count characters in cell - getting error
  9. Solved: Date and time
  10. Solved: Combobox linked to calender
  11. use excel database to populate 2 different word doc
  12. Solved: modify code to run on several sheets in a workbook
  13. How to get to the single dictionary entry without knowing its key ro value?
  14. Progress bar Running on top
  15. Solved: total by company
  16. Solved: Insert comment
  17. Excel form to database help
  18. Chart Help::Stacked Column
  19. [SOLVED:] What Causes “Personal.xls” to be Opened?
  20. Stringlists or String arrays
  21. can't call subs automatically
  22. Data Validation issues
  23. Rename controls in VBE
  24. Solved: Delete emty rows.
  25. Solved: Join Sheets Cells By Common Field
  26. Using Variables in VBA formulas
  27. Solved: Remove a shapes
  28. Solved: Range Error during loop
  29. Search value as the part of the Sheetname
  30. Solved: Select variable range of rows and then delete ??
  31. How to Add a File to References List with VBA
  32. Loading malformed xml into MSXML2.DOMDocument
  33. Different sound file question - simple ??
  34. Solved: Select copy & paste
  35. delete blank rows
  36. Solved: Changing Values Between Text Boxes
  37. Saving a Worksheet
  38. Applying Format To ALL sheets in Workbook
  39. Solved: How to sum a range of cell values based on common data field
  40. Solved: How do I sort a dynamic named range?
  41. Solved: Unhide and activate sheet based on system date
  42. Problem with error type mismatch
  43. Solved: Delete Text to Left of First Number
  44. Merge cells based on a cell value
  45. Make VBA Code Shorter
  46. Solved: download files from internet thruugh VBA
  47. Linking to formula rather than paste special
  48. Event for Ctrl-G
  49. Help in Vlookup function error
  50. What Message Is Being Written?
  51. make textboxes visible at runtime?
  52. alerts out of a spreadsheet based on dates
  53. Solved: Distribution Graphs
  54. Solved: How To make Macro Interactive
  55. How to know value of margin of the last row on page
  56. Date formula required
  57. I just want the Date, not the time (CDate(Now))
  58. Userform triggers Excel Crash
  59. Need help about listbox column count property
  60. Special Calendar to fill textboxes
  61. Solved: Conditional Format VBA not using Range Name Value
  62. DSO and File Properties
  63. Solved: Inserting an undetermined number of rows?
  64. How to tell user to get updated copy?
  65. UDF for Three Parameter hlookup
  66. Solved: Count Formula Based Currency Criteria
  67. Solved: Copy the table in Word document to NEW Excel file
  68. How to open a secured directory
  69. Same code - one set works but other does not...
  70. Solved: run access macro from excel
  71. Multiple Excel ranges to multiple Word tables.
  72. Solved: Flashing commandbutton?
  73. Copying Data from different workbooks
  74. print preview , value of ending line on page
  75. Solved: Countif with a Range Name as the Criteria
  76. Super Quick ComboBox Question
  77. Solved: Modify Hyperlink Code
  78. Need VBA help with populating missing data??
  79. Solved: move to textbox in other sheet if is "TAB" pressed
  80. Sports league VBA program
  81. Listbox items getting transferred in reverse order
  82. Password to open file via macro?
  83. Message box to appear once commandbutton is pressed?
  84. Copying from a PDF file
  85. textbox validation help please :-)
  86. Solved: Code randomly stops without CancelKey Disabled
  87. Mega Sort
  88. checkbox to populate 2 textboxes?
  89. How to make a text box mandatory?
  90. Excel 2003 File Size
  91. start search from beginning with static variable
  92. Importing part of textfile
  93. Solved: Printout Problems
  94. Sorting CurrentRegion?
  95. EXCEL TO WORD BOOKMARK
  96. Solved: Set X-Axis Value to match row numbers
  97. Worksheet change - single click>value entered
  98. is it possible to do screen tips without hyperlinks
  99. Solved: Highlight only certain words in cells
  100. Using data in a worksheet and vba to complete a form on a website.
  101. Late-binding --pls sort out the confusion
  102. calculating monthly returns in table from historical data
  103. Autohyperlink to and replace file names in worksheet
  104. Set TextOrProperty attribute change the name of company
  105. ListBox Item queries
  106. Selecting a sheet within a workbook by using a macro
  107. Solved: Excel insists on changing the format of cells
  108. Solved: VBA to delete text between < >
  109. Count all unique entries in a column (mission impossible?!)
  110. [SOLVED:] From Excel, create table of selected rows in Word
  111. Delete Custom Document Properties?
  112. Reading pdf file into excel 2007.
  113. copying information from another tab
  114. Solved: add slash in string
  115. Combination from binary bit to Hexdecimal
  116. parsing in vbscript
  117. Solved: Batch Renaming all files in a folder
  118. Solved: UDF for mann-whitney statistical test?
  119. Solved: Filter Workbook when protection is on
  120. Solved: counting number of observations under condition
  121. calculate % of each items total in a year in Pivot Table
  122. Solved: Small macro, simpler way of writing it?
  123. [SOLVED:] Insert Template Macro
  124. Solved: Deleting multiple values within range of rows
  125. [SLEEPER:] Check for visible rows after filter
  126. Solved: Multidimensional Array Sort
  127. Need to nest .Find routines in VBA
  128. Finding mode of array in VBA
  129. Fusing chart and shapes before copying
  130. Solved: Delete row (numbered) all other rows (numbers) change in sequence
  131. Solved: Arrows in Excel Document
  132. Solved: strange Unload Me behaviour
  133. transferring selections from one list box to another
  134. Insert A row in workbook A automatically if a row is inserted in WOrkbook B
  135. Remove the file extention from the file list
  136. Solved: to accept changes
  137. Solved: copying dynamic range from Sheet1 to Sheet2
  138. Solved: .bas vba export question
  139. Searching a record or row.
  140. Update the value from B file to A file
  141. Solved: Command Buttons to SAVE, SAVE and EXIT and to EXIT without SAVING
  142. Solved: Passing variables between suns and functions
  143. Pasting charts in the same document - avoiding new instance creation
  144. Array help, deleting columns.
  145. Combining vba for forcing macros and expiry
  146. [SOLVED:] Extract Data From Text File
  147. Return a value from an activex
  148. Solved: Find string in the cell and then output value
  149. Solved: Argument Not Optional Error
  150. Not Highlighting Errors
  151. Solved: Deleting rows from selected cells.
  152. force users enable macros and auto save&close if idle
  153. Custom menu top left
  154. Delete WB-Open sub as WB is saved
  155. Need a String Function
  156. Save As Issues (excel 2003 and excel 2007)
  157. zodiac userform to display zodiac sign picture based on users birthdate
  158. Solved: Initializing Entire Array at Once:: Syntax Error
  159. [SOLVED:] Delete VBA Project
  160. Trouble With Assigning Value to Cell
  161. Carriage Return not working
  162. Imbedding Image File Instead of Referencing?
  163. Solved: Copy module from present file to PERSONAL.XLS
  164. Excel multi criteria search
  165. optionbuttons and vba
  166. Solved: Extracting 5 or 6 digit numbers from a cell
  167. removing items from collections
  168. Compare Workbook to 2nd workbook (Newbie)
  169. Solved: Using Bold with .Cells Object?
  170. Really Quick Precision Question
  171. enter commas
  172. Problem with Cancel Button in Input Box
  173. problem with activecell is blank or zero
  174. Solved: Force users to enable macros in a workbook code by Ken Puls.
  175. Unhide a Hidden Workbook
  176. multiple search and filter
  177. Call tracker - VBA coding help
  178. Solved: Combo Box inside pop-up Message Box ?
  179. Case Select Statement
  180. [SLEEPER:] Filling an array with a for..each construct
  181. Solved: VBA code for a button with user supplied titles
  182. entirecolumn.hidden with autofilter result
  183. Closed: sendkeys
  184. Solved: vba to make formulas work
  185. Cant read txt file with Unicode symbols and store it to cell
  186. Formula Referencing other cells
  187. Excel Macro that creates an Auto Macro
  188. Exclude a single xl file from macro
  189. Return cell address in messagebox
  190. Combine 2 similar worksheets (live document)
  191. Solved: excel to word for Labels
  192. Match function for 2 columns
  193. Insert Rows
  194. Save different filename based on multiple selection
  195. Need a solver
  196. Make other cells invisible or locked programmatically
  197. Solved: Simple question for CheckBox in sheet
  198. Solved: shapes in a worksheet
  199. Solved: excels AND function
  200. Solved: excel's IF function
  201. Cnverting Excel if into UDF.
  202. VBA Performance Query
  203. Compare Columns
  204. Excel CSV Read issue
  205. Accessing Excel Spreadsheet via Sharepoint
  206. Look For and delete
  207. Copy/Past cell contents into a PDF Field
  208. [SOLVED:] TAT Calculate in office hours
  209. Button w/drop down list
  210. IF, Solver and Clearing Cells based on the IF
  211. [SLEEPER:] Linking excel with folders and show the content
  212. Excel values to Website, web data extractn back to Xls. PLEASE Help!!!
  213. Solved: Using comments to track changes
  214. working on range
  215. Hyperlink to Chart or Range by Double-click Named range
  216. Regarding getting values for Multi Column LISTBOX
  217. Solved: Create Multiple Sheets and Save As CSV (COMMA DILIMITED) FORMAT
  218. Solved: deleting duplicate rows
  219. Solved: Finding Specific Days In a Year
  220. Need Code to Check if .CSV file has finished writing
  221. Solved: How to rename text file to date and time format
  222. Solved: Selecting a hyperlink using Data Validation
  223. Link userform check boxes with corresponding text boxes
  224. Solved: Hide row with a 1 on selection change
  225. Hide comments programmatetically
  226. How can i speed this up?
  227. Solved: Converting Minutes Into Hours
  228. Copying Worksheet to another book with new name
  229. A little (?) VBA help
  230. Solved: Delete a CSV Workbook from Another Workbook?
  231. [SOLVED:] Validation In Cell
  232. Protect a column ins workbook with macros
  233. consolidating the difference in counts on hourly basis
  234. count subfolders
  235. Solved: Finding the rows of a Selection
  236. Sampling after Auto-filtering
  237. Solved: Find does not do an exact match
  238. Solved: reversed sequences in code
  239. Solved: Return Sheet Index of Last Sheet
  240. find next and loop combined
  241. Solved: variables carrying over from userform to Module
  242. Blank or null string in drop-down
  243. Solved: Get state of checkboxes
  244. Solved: userform textbox format for currency
  245. Solved: Formula property compile error
  246. Excel Creating an Email Error
  247. Open to specific location of worksheet
  248. Solved: Need help "Run-Time error 91"
  249. Solved: Lookup Intersection and copy column data into another sheet
  250. Populate combo box from selection of different combo box