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