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

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