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

  1. VBA regex multiline match not working
  2. Populating Combo boxes
  3. Solved: Updating sheet
  4. Solved: Help! Help! Gannt Chart
  5. Solved: Problem With Choose & Match
  6. Mulitple importing of text files
  7. Solved: Code Deletes headers on .ClearContents
  8. help in creating function
  9. Creating a help file.
  10. Print code
  11. Solved: Syntax error in formula...where am I going wrong?
  12. Large size user form
  13. Line graph - ignore zero
  14. Solved: Convert JPEG file to XLS FILE
  15. Solved: Project Explorer window...how to display my module names.
  16. Setting Print Area taking forever
  17. find substring and display message box
  18. Solved: How do I create a PivotTable from data in a worksheet?...
  19. Solved: Combobox in Worksheet
  20. Advanced Calculus VBA Programming
  21. Solved: Select Case not case sensitive
  22. Opening a directory and listing all files within
  23. Running a macro on another spreadsheet with a macro
  24. Solved: How to get the number of days between two dates
  25. Solved: need to copy data from one workbook to another on selected cells
  26. Solved: Export XML from Access using Excel VBA
  27. Solved: VBA To Run Another Macro at An Interval
  28. Paste in correct column based on criteria
  29. Formatting headers & footers in excel
  30. Solved: trapping error messages to hide in vba
  31. Combobox change
  32. Lookup tables
  33. look accross as I copy down
  34. Alter code to only clear data from target sheet
  35. Checking if cell contains a string or a number
  36. Problem referencing other workbooks
  37. Parsing CSV files where data is split over lines
  38. Excel 2002 - data validation and copy/paste
  39. Merging Date and Time from two different cells into one...
  40. Using ListView on Excel VBA UserForm
  41. textbox calculation
  42. action across all open workbooks
  43. Solved: Excel to access cell for cell import
  44. Solved: How do I create a "dialog box"...?
  45. Email message body
  46. Solved: Transferring Data from a Table
  47. Hiding/Unhiding Columns based on Criteria
  48. Solved: Dealing with very large text files
  49. Solved: count the cell hits
  50. interact with htlm
  51. Auto list names
  52. Set Up a Pause Between Calls
  53. Solved: Data from userform to sheet (dynamic)
  54. event procedures
  55. Getting and Extra Worksheet
  56. Solved: How do I 'close' an open workbook?
  57. Loop through, comparing string question
  58. Solved: Automating Hyperlinks
  59. How to match data, then Copy
  60. Deleting rows when date within cell expires
  61. Solved: limit users not to add/enter farmula
  62. Solved: How to pass a CheckBox to a subroutine
  63. Email multiple worksheets - help please?
  64. Solved: Why doesn't this work? Apply macro to every sheet in book
  65. Combine muliple rows into one row based on criteria
  66. Saving 100 workbooks automatically
  67. scanning a column
  68. make the Application active
  69. Solved: Trigger event on change/deactive/leave of a specific cell
  70. automaticaly show Scrollbars
  71. before the last
  72. Compare Two Strings via Len Function
  73. RTF For a Text Box on a Form
  74. Solved: delete a row
  75. Solved: copying data error
  76. Solved: condition
  77. Setup and Write to a temporary storage location.
  78. global variables
  79. excel queryTable
  80. How can I read and write JPG Exif info
  81. User define the number of boxes in a form
  82. conversion of variant
  83. Solved: Copying to the next blank cell
  84. Solved: matching rows/values with rows/values of another spreadsheet
  85. Solved: Excel Freezing When Macro Runs
  86. Stumped Excel/Word-post do..loop results from excel to word
  87. Open workbooks and compare cells
  88. Solved: Tips on a smarter way to perform Insert Line & Paste info?
  89. Using Autofilter Custom feature...
  90. Instructions for Explicit Error Type
  91. Multiple And Condition is Returning Wrong Answer
  92. Delete row on condition
  93. Help Required with inputing data to excel worksheet
  94. Assign Macro to ComboBox??
  95. Solved: Bulk entry of FormulaR1C1 problem
  96. Solved: openfile dialog retain openned name in variable
  97. Finding with userform
  98. Solved: ComboBox error: Invalid property value
  99. How to search on two or more sheets?
  100. Code; Why Will it not work on any other sheet?
  101. Solved: Selection of worksheet
  102. Delete a row with the oldest date when project numbers match
  103. Solved: Delete pages
  104. Excel conditional formatting
  105. Write in a protected closed workbook
  106. Solved: combining lists into a string
  107. keep text formating when transfering text from text box to cell
  108. Solved: VBA write to a protected cell and I have the password
  109. Defining sourcerange
  110. Emailing disjoint cells
  111. Display adjacent cell search results
  112. Solved: Help on Concatenate 2 cells under one drop down????
  113. One named range for the same range on 2 or more noncontiguous worksheets
  114. Solved: Single Command Button on Multipage
  115. Solved: convert worksheet_change to module sub
  116. Conditional formatting formula required for excel
  117. add a shortcut menu to excel
  118. Solved: Fill Formula down & paste values up
  119. Copy data into Selective Range
  120. CommandBox duel command?
  121. changing textbox colour?
  122. Solved: Using excel to send email through lotus notes - variable data and open/close notes
  123. overriding replace dialog box in saveAs method
  124. URGENT!! Detecting Types of Errors as resulted from Cell Formulas
  125. Solved: Left Function
  126. EMAIL command button
  127. How to "tag" worksheet for later identification
  128. Tempermental Code seems protection related
  129. Solved: Change Event?
  130. Validating Cells...
  131. Solved: Change text to hyperlink
  132. Solved: More scanning help
  133. Dynamic OptionButton Validation
  134. Solved: newbie wanting to know how to selct a variable range in VBA
  135. URGENT!!! How to detect whether a value is convertible or not using the Cxxx()
  136. Functions on filtered rows
  137. Solved: Display userform pause code
  138. Solved: Excel crashes when Force Macros VBA is used
  139. run code at specified time each day
  140. Solved: Offset To Add Formula
  141. Solved: Quick Formatting Question - Text Alignment
  142. Solved: Copying from one workbook to another WITHOUT seeing source
  143. Selecting specific sheets to print
  144. Solved: Copy down to blank cells?
  145. Solved: Left Lookup
  146. Applying Title and current date to new file
  147. on click a cell and copy to another cell
  148. Loops and formulas
  149. Compile error: User-defined type not defined
  150. Interrogating jpeg/jpg files
  151. Solved: Number format
  152. Solved: use array to speed up copy and paste
  153. Format Cell in Excel 2000
  154. Solved: newbie question regarding averaging arrays based on dates
  155. Solved: Use of Daverage in VBA
  156. Code to Loop Through Columns & Perform Action
  157. Maximize Excel window
  158. Looping a combobox
  159. Solved: Simple Error Handling Help
  160. Solved: Move row based on text
  161. ListView ItemSelectionChanged
  162. sql server VBA help
  163. Solved: can't open specific Sheet from Closed Workbook, i get eror's! PLEASE HELP!?!
  164. Solved: VBA CODE FOR PASTE VALUES
  165. Progress Bar - extend run time
  166. Solved: Import multiple text files as new worksheets
  167. Visible Timer On Form
  168. Validation form concept
  169. Task complete...note of thanks.
  170. regrouping data
  171. Dealing with Ties when using Vlookup with Rank.
  172. Delete all rows after....
  173. Solved: Sorten Recorded Macro
  174. Tricky IF() use
  175. How to sort numbers in asceding order?
  176. Solved: How to Copy Values from another worksheet to Activeworksheet
  177. Solved: onkey event, toggle?
  178. Solved: Organize inconsistant data from 2 columns to 1 column on different sheet
  179. Solved: Prompt user for a range of cells to copy
  180. Solved: Adding extra vba code
  181. Help: The same text but can not error return by VlookUp
  182. Solved: if sheet not found end sub, if found goto
  183. Copy values from several workbooks to one workbook
  184. Solved: Sending Email Flagged High Priority
  185. call a sub from a combo box
  186. User form hotkeys
  187. Querying Access from Excel using VBA
  188. hide every n-th row
  189. Solved: Image in Comment box problem that Microsoft couldn't help with
  190. Solved: Using XLQ in VBA
  191. Solved: Recording changes in values
  192. Solved: Early Binding ADODB from Excel
  193. optimization question
  194. Solved: Formula with ranges based on variables
  195. Pics not being copied
  196. Converting Excel 97/2000 to Excel XP/2003
  197. Field cannot be updated
  198. Solved: Understanding what used in this file
  199. Adding/copying tables base on Input Data
  200. restricting copy paste so it won't copy formatting
  201. Solved: Barcode Help
  202. sum every n-th row
  203. not a VBA question but please help
  204. Solved: MsgBox not big enough?
  205. Solved: listing errors in data, using Vlookup
  206. Need help with command button
  207. Insert Rows
  208. insert picture in cell
  209. find the range in a sheet
  210. Generate Numbers Based On Month, Year And four Digit Number
  211. Copy/Paste/Delete based on Date
  212. Solved: Box Next To Column A And Above Row 1...
  213. Solved: button problems... some extra wishes...
  214. Solved: Minimize user form
  215. Solved: WEEK in MONTH
  216. Date Format US/UK
  217. copy offset and paste loop
  218. Solved: select or activate fail when code is active?
  219. Cell Incrementation
  220. look down column and paste values across cells
  221. Solved: Run Once Then Delete Code
  222. Solved: For loop for Large Data
  223. Solved: Excel Comments item
  224. Color cells
  225. WebQuery difficulties
  226. Print PDF script: check for pdf printer and give dialogue to choose?
  227. Solved: averaging variable sized ranges
  228. Solved: Transfer data from one sheet to another based on criteria
  229. Searching Words in a String
  230. Find Column Difference
  231. Solved: Font color for string
  232. Returning RecordSet Objects from Functions
  233. Solved: copy a cell value not the formula??
  234. Assign picture to Image Control
  235. Solved: Change Date Format VBA
  236. TREE hYPERLICK UPDATE
  237. Solved: Setting the print area for used rows and columns
  238. Combobox ListFillRange
  239. Dynamic listbox, help! Stressed...
  240. Update table reference while code runs
  241. solver and excell 2007
  242. Authenticating against Active Directory AD usign Kerberso?
  243. code problem
  244. Solved: Excel Security
  245. Solved: Form Navigation Buttons
  246. Solved: Change text to numbers for different sheets and workbooks
  247. Sending emails on behalf of a group - VBA - Lotus Notes
  248. UPDATE HYPERLIck
  249. Dynamic Bespoke Chart
  250. Help protecting pivot tables with exceptions