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