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

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