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. Solved: Open and Close File
  2. Solved: Looping with textboxes
  3. Form Button Font Keeps getting smaller
  4. XP Visual Styles to Excel UserForm
  5. Solved: Macro for printing
  6. Macro to save file with active cell value with 3 date options
  7. Method to merge two excel files without links
  8. Solved: Working with CutCopyPaste Mode
  9. Dynamic hyperlink that can survive sorting
  10. Wildcard character for VBA
  11. Solved: email from within excel using outlook
  12. Macro to Group columns on the basis of criteria
  13. Filter Rows with Duplicate values.
  14. Solved: Using InputBox to select Range
  15. Help with a couple lines of code please...
  16. Entering cell comments using VBA
  17. Looping Ranges
  18. Protected Sheet Allows Macro to Execute
  19. Create Pivot table from multiple worksheet
  20. Conditional Drop-Down lists + auto filling
  21. formula/code cleanup
  22. Workbook to track changes in other workbooks
  23. Nested Loops-In What Sequence?
  24. Solved: Find Text Position
  25. Solved: Separated tables in one page
  26. Solved: Run Macro on Specified File and Worksheet
  27. Get MS Word ActiveX Control values from Excel VBA
  28. RefEdit control to clear contents
  29. Resize JPG files to consistent size
  30. Read fr Open File > if not open > open file > and read cells
  31. Solved: Matching 2 customer record sheets
  32. Click Event
  33. Solved: Turning ScreenUpdating On and Off
  34. Solved: How can I have a nested IF-function combined with an OR and AND-fun
  35. Solved: Tracking Comments
  36. ask permission
  37. Need Help for WEB PAGE TextBox
  38. Solved: Is there a shorter way to write my VBA code?
  39. Column counting and Loop
  40. Solved: Performing a Successive Filter
  41. [SOLVED] Automate Chart with filtered values
  42. Count Half of the Visible Rows
  43. VBA If statements Variable help!
  44. Beginner
  45. VBA Code for pivot table from multiple worksheet
  46. Solved: Excel 2003 end(xlup) problem
  47. Automatic Directory File List
  48. Inserting Flash in Office2007
  49. Not sure if possible..brackets issue
  50. Extract Data from Outlook and populate it into Excel
  51. Solved: daylight savings time
  52. Solved: Rename "Microsoft Excel Objects"
  53. Pulling Information from a String
  54. VBA Macro - Automating Web Querie
  55. Solved: Conditional Numbering
  56. Solved: Vba Automate Emailer for Lotus 6.5.3
  57. Subscript out of range for importing files
  58. How to Save File & Overwrite Original??
  59. Oorang: A query about your GUID program
  60. Prevent Worksheet Deletion
  61. Default Messages
  62. Solved: log only once per 5 sec. - only fix code
  63. Solved: Multiple logical tests
  64. Solved: Splitting data from one column into multiple columns in excel
  65. How to Delete Visible Rows in VBA?
  66. Solved: Delete multiple rows & Unhide hidden rows
  67. Solved: Web Query...creating data crawler
  68. Solved: Custom Classes and Collections
  69. Filtering using a listbox across multiple columns
  70. Save file as excel through xl macro from web- in existing code
  71. Need help with delete
  72. Mesage box in VBA
  73. Parse Text
  74. Dynamically allowing/disallowing user sheet insert.
  75. Extract text from multiple text files
  76. Bar chart help any example or sample file ?
  77. Converting manual chart to bar chart?
  78. Solved: Skip blank cells
  79. Solved: Copy text from shapes
  80. VBA: embedded excel chart
  81. Solved: Excel 2010-Run VBA code pressing a sheet button
  82. Solved: how can i add "count" and "Sum" in existing code
  83. Solved: Calculate age from row eleven
  84. Solved: Ribbon management in Excel-2007
  85. Changing default field "All" in pivot table
  86. Sending email without using outlook
  87. Button to interrupt subroutine
  88. Solved: KB entry "Reduce Excel File Size "give run time error 1004
  89. Microsoft Speech Object Library
  90. trigger proc. with a date
  91. copy data
  92. Solved: to extend the coloring
  93. Automatically split a large text file in separate worksheets on import
  94. CALCULATE
  95. Solved: To Auto Populate Value
  96. One message box in a for loop
  97. trouble with .Resize
  98. Print_Area Formula
  99. Record Formula Evaluation Steps
  100. copy filter cells
  101. Conditional formating
  102. Solved: Count according to date
  103. explanation
  104. Random
  105. Solved: Having trouble with "Offset" or the equivilent
  106. To get specific part of filename from a folder
  107. Run process at set time
  108. Mesage box - Conditional formating
  109. Solved: Another Query question
  110. Solved: vb conditional formatting
  111. test of CF
  112. Solved: DropDown Question
  113. Creating a TOC for only visible tabs? Excel VBA
  114. Solved: Count number of files in a folder
  115. Printing solution request
  116. Open csv file using VBA
  117. Solved: Track Changes in Excel Feature
  118. Auto Email
  119. rc
  120. Protect workbook, save and close
  121. Unable to record
  122. Using Macro to Add Code
  123. Filter Pivot table by Month & Year
  124. Solved: Export from Word form to Excel
  125. Solved: Self Destruct file
  126. pdf price lists to excel
  127. copy data from other sheets into another sheet
  128. Solved: loop help please and thank you!
  129. macro to convert all word files to excel from a folder
  130. Solved: Using Range Names with a multiple IF Formula
  131. combine a single sheet in 100 workbooks to another workbook and then summarize
  132. Hide Workbook Title Bar
  133. Naming sheets in "Combine All Workbooks from One Folder Skipping Blank Sheets"
  134. Solved: Auto text-ellipse macro. Is it possible?
  135. Solved: Msg Box code for a RANGE
  136. Find a word
  137. Solved: How to use replace function in VBA?
  138. Solved: How do you convert negative number to positive?
  139. search value in entire wb - only fixing code
  140. use if else loop
  141. Working with vba in two excel workbooks
  142. How do I add the red triangle in the right hand corner in Excel?
  143. VBA Lookup
  144. Displaying a UDF within insertFunction
  145. Performing calculations using VBA
  146. How to loop a date
  147. userform displaying table data
  148. Solved: Using Select Case
  149. VBA macro simple adjust
  150. how to find the value and replace with diff value
  151. Solved: Help with Find function VBA
  152. Change days each time
  153. Sending Multiple Emails via VBA
  154. Solved: filter
  155. Solved: Using one Calendar in multiple userform textboxes
  156. Sort 2 Columns Code Needed
  157. Solved: How to use str?
  158. Copy & paste based on value after stripping characters
  159. Creating a Simple Array
  160. Copy the data of one cell to three Rows in excel sheet
  161. Combine all sheets to Master sheet
  162. Open file with datestamp in filename
  163. Solved: Time Difference between two dates
  164. Solved: Calculate Number of pages
  165. Solved: Dynamic File Path - Code Tweak?!
  166. Looping copy and paste macro
  167. Importing text file -
  168. Macro/VBA find/copy/paste question
  169. Writing data to chart/graph with a variable data range
  170. Cascading ComboBoxes
  171. How to Adjust Column Target
  172. copy range with cell link
  173. search
  174. Mailing PDF from EXCEL
  175. Range.Formula for A1-ref.style notation goes wrong
  176. Solved: Userform ListBox Row selection
  177. Excel Dashboard
  178. Macro to provide count of results
  179. Is it possible to export to html without using save as?
  180. Solved: vba for playing sound effect!
  181. Passing Variable with .OnAction
  182. Copying Values Down or Across
  183. Solved: VBA and HTML help make them talk.
  184. Solved: PivotTable Name issue
  185. Solved: A question about code finding a certain text
  186. Solved: change variable ; from 2000000 to $2,000,000
  187. Reading a text file by column in to an array?
  188. Solved: How do I create an add in that automatically adds a new menu to the toolbar?
  189. Solved: Search for value in columns and display results of the relevant rows
  190. Solved: Hyperlink to PDF file gives error 432
  191. Solved: Alternative to RICI notation in formula
  192. Solved: Copy Paste non-adjacent cells in a range
  193. Solved: Help Identifying Empty Cells
  194. Solved: Escape from Edit Mode
  195. Solved: Compare two sheets semi-manually
  196. Solved: Dir Function - Sequential files
  197. Solved: Removing Noncontiguous DropDown Arrows
  198. gif animated picture on a user form !!!
  199. manage datas from a multilection rows
  200. Display label results in a texbox
  201. Userform Search help!
  202. Auto Import Text file GetOpenFilename no dialog
  203. Solved: copy the formula or address
  204. copy cells from excel table into a pre-formatted table in word
  205. Not sure what to do.
  206. Pulling data according to a cell value
  207. Average of n elements in an array
  208. Formating lines in table/pivot table
  209. VBA code to open an Excel workbook readonly
  210. Solved: Save chart as image plus refresh
  211. Pivot Table Show All
  212. Solved: Copying comments from one workbook to another
  213. Loop but Subscript out of Range
  214. Solved: label caption
  215. Extract Data to Excel from a Website.
  216. Solved: Calling a Function, of Sorts
  217. Using arrays in vba excell
  218. Remove duplication and fill a form
  219. Macro to return picture in a cell?
  220. How to Modify Userform?
  221. Solved: On open excel
  222. Solved: Error on Insert Picture code...
  223. Pick a Workbook and mail its worksheets
  224. Userform Activate not firing in Excel 97
  225. picking range from "A1" to variable
  226. Need help on VBA coding....
  227. Solved: Scroll worksheet when userform is present
  228. Multiselection areas: how to manage?
  229. delete duplicate text
  230. Creating sub-blocks within a large data-block
  231. Is it possible to ask vba to write html code in to an html file?
  232. Changing AutoFilter Range
  233. Excel 2007-UPDATE Links ISSUE with excel 2003 file
  234. Dynamic Formula put in formula with VBA
  235. Save Excel Userform as a Web Page
  236. Solved: If else doesn't work the way I expected
  237. Solved: Date picker 2003
  238. Assigning a cell to a row that has a cell with a similar value
  239. Solved: Formula help
  240. Using Custom Views
  241. Color Banding Rows
  242. Way to get innertext of all childnodes of a node?
  243. Solved: Find,MatchCase PROBLEM
  244. Solved: Alignment on coding page
  245. Solved: Count Business Days Between 2 Dates
  246. Can I run an executable within my VBA?
  247. Solved: load a one dimensional array from non-contiguo
  248. Return Row info based on Column dates
  249. Question on insert Object
  250. Solved: Calling a Function and Resize