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