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

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