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

  1. Solved: output subtotals only to new sheet
  2. Calculate Group Totals
  3. Solved: Save Worksheet selection to PDF
  4. DTPicker giving time not date.
  5. Trying to store a refedit range into a cell
  6. Solved: VBA Run-time-error '424'
  7. Solved: Does Excel 2010 Home version come with flexgrid?
  8. Transfer the TextBox.Value from one Form to another
  9. Solved: formulas help.
  10. Limited Blinking text
  11. Transfer data to another worksheet only if "Column A" has any value entered
  12. Cleanup and fix vba code help
  13. Solved: Data Duplication Problem
  14. Solved: VBA formula relating 2 worksheets
  15. UserForm help
  16. Solved: questionnaire
  17. ListBox1 & ListBox2 & ListBox3 one criteria for Filter
  18. Solved: Conditional column delete based on multiple criteria
  19. Array Help
  20. Solved: Select Case problem
  21. Cumulative addition - Vb
  22. Solved: Date display
  23. display differnt cell protection message
  24. Move row if text is in column matches string
  25. Solved: Checking the value of mulitple checkboxes
  26. Cells blocked with permission to change
  27. Solved: Compare column with multiple sheets
  28. copy from excel to ppt office 2007
  29. Bin2Hex Method between Worksheets
  30. Random Choice From Array
  31. VBA: How do I use a Variable Name in a formula
  32. Solved: error
  33. Solved: Delete records for the current month
  34. Pivot Table - Pivot Fields Orientation.Position giving me an error
  35. Update the VBA code in a XLA file
  36. Sort with Multiple columns using VBA
  37. Unique Values
  38. Remove the default Excel menubar
  39. VBA code to look for files and put result in an array
  40. Copy ranges
  41. OleObject file Access in an Excel file
  42. Change Event Handling for a cell and for a combo box in Excel 2010
  43. Why won't this simple code work anymore?
  44. Solved: Deleting source data used for drop down list?
  45. Macro to retrieve the value based on the column value in another
  46. Solved: Determine the Quarter for a Date based on a condition
  47. Stock qoutes date deviating.
  48. How to capture user last key press using VBA in Excel?
  49. Create custom submenu using commandbar
  50. Parsing excel value into SAP BW Analyzer 7.x
  51. Zip a file via VB?
  52. Create Text Files for each cell value
  53. Solved: Reference Visible Cells within a Range
  54. variable range giving runtime error 1004
  55. Solved: Auto Filter by month of activecell, and subtotal result in a msgbox
  56. How can I search with Listview and Array ??
  57. Copy mode is giving error
  58. Macro to Import Text files in Folder into Excel
  59. Solved: Excel 2007 If today is Monday show the previous Friday's date
  60. Solved: Read HUGE text file and copy to excel
  61. remove <100&10
  62. Solved: How to specify range using contents of cells?
  63. Solved: Sum every other visible cell via VBA
  64. macro don't work normally
  65. Save as to 2003 .xls
  66. Consolidating excel files with different rows and columns?
  67. delete rows in the sheets
  68. Dynamic range calculations on other worksheets
  69. Need Guidance for learning VBA and macros
  70. Solved: Need VBA Code to search one WS from another WS
  71. Copying cells from 2 row/Pasting into new column
  72. Solved: Cycling through Workbooks
  73. message to delete value in cell
  74. Solved: Formatting Output As Double Digits
  75. How to find out which Form Control button on worksheet has been clicked?
  76. Solved: Protecting code
  77. Solved: Optimize programming
  78. Excel heatmaps
  79. * excape doesn't work in macro
  80. Need micros coding for applying values.
  81. Code hangs if not find the any data in Master sheet
  82. Send Email (Lotus Notes) Creating Temp File Problem
  83. Email lotus notes send sheet
  84. Import data as value to a master sheet
  85. Same concept hide and full screen
  86. hide 0 values in pivot table
  87. Show selected months in Pivot table
  88. Solved: Used range code
  89. Extracting Specific Text from Email!!
  90. Solved: batch macro to delete rows
  91. Need help on excel graph for the given scenario
  92. Highlight the columns being used to AutoFilter a range
  93. Count the Cells
  94. conditional column range
  95. VBA Error Handling Help
  96. creating a Copy/paste macro from one sheet to another assigning buttons
  97. IsFileOpen Error "53" in 2003
  98. Password TextBox in UserForm
  99. Solved: division with zero
  100. Error Handling in VBA
  101. Automatically choose which file to open?
  102. Can you intercept a keystroke during a long loop
  103. vba cell format strikthrough and red
  104. Solved: vba : Syntax modification help required
  105. Organizing People Using VBA / Excel?
  106. Solved: Sync Loading Bar with actual Process
  107. can this be simplified with a loop?
  108. code Transpose whole workbook
  109. VBA: create separate sheets based on cell value
  110. renaming all files in folder & subfolder with name & date
  111. Solved: vlookup skip blank or 0 cells and find match
  112. Copy Paste sheet Range to another worksheet
  113. VBA form events
  114. Solved: Automate Several Sheets
  115. Solved: Rename worksheets based cell value
  116. Solved: Passwords part 1
  117. Passwords part 2
  118. Solved: msgbox display
  119. Solved: Array Query
  120. Check date is between 2 dates
  121. Adding a ScrollBar to a dynamic UserForm
  122. Posting value to Cells from VBA, where Cell are protected?
  123. Solved: Take User form data to new worksheet
  124. Excel VBA code to Correct Day ?
  125. VBA events part 2
  126. Putting values on cell based on cell colors
  127. dropdown menu
  128. Selection criteria
  129. Solved: code to work for 12 TextBoxes of a form
  130. find end of the...
  131. Importing and formatting text files
  132. How to exclude hidden rows/columns while executing a VB code
  133. Strange behavior for my VBA code (HELP)
  134. Group cells
  135. Array Help2
  136. calendar??
  137. Formting and Adapting
  138. data validation
  139. Solved: vlookup problem
  140. Copy into new workbook based on cell info and other questions
  141. search a specift text and concatenate with another row
  142. Is it possible to migrate data using visual basic in excel with other systems?
  143. csv import
  144. merging worksheet with forced repetition
  145. Pivot Table Help
  146. CountIf and only different values
  147. Look up for a value in a worksheet and store it in a variable
  148. Loop Thru Textboxes - Help....
  149. Calling a Stored Proc from VBA
  150. Solved: help on tranposing data from column
  151. Solved: Take Userform data to new worksheet
  152. Solved: if file is open or if file exist
  153. Solved: paste to match destination formatting
  154. Solved: inputbox not keying value
  155. UI and Cell Event Routines?
  156. Attached sheet as Email Body
  157. VBA to change content at the click of button
  158. click a link in a webpage
  159. Excel-VBA
  160. VBA Code to copy only the Pivot Data from a Pivot Table with out Grand Totals
  161. Solved: create worksheets from column values
  162. Solved: Search, Edit and Re-insert
  163. Can I use MD5 encryption in my Excel VBA Project?
  164. Runtime error
  165. VBA: Msg Error if Duplicate
  166. Solved: Listbox, should be simple!
  167. Solved: Tab sheet Name In the Sell
  168. Pivot table filtering according to current year
  169. Click Listbox how to show more picture ?
  170. how to get unmatched records from database tables ?
  171. [Q] Save Sheet Box prompted
  172. Prob with vba code in 2007 and giving error after i installed 2010
  173. Worksheets problem
  174. Excell-PPT shape handling problem
  175. Solved: copy reference without link from copyed file
  176. Append text from adjacent cell to an existing cell for all rows in worksheet
  177. Check Range
  178. Pasting excel tables one after another in word file using VBA
  179. Solved: Extract words
  180. Solved: Use cell value in formula as Dynamic Range
  181. How to make an Excel Macro globally available?
  182. How to access the literal content of a cell, regardless datatype
  183. Urgent Help - Macros to Insert Rows in 2 Sheets simultaneously
  184. Solved: date format question
  185. UserForm text box info passing to cells
  186. Hyperlink and copy sheet based on specific criteria
  187. Find Contents of cell
  188. Solved: Insert New Range Name
  189. Deleting text from right side of an individual cell
  190. CODE FOR JOB
  191. Error Handling Stuck in a Loop
  192. how to make an "isletter" class in vba?
  193. Excel to Auto cad block attributes
  194. Solved: check number of words
  195. REAL VALUED ROOT OF A POLYNOMIAL_newton raphson algorithmn_VBA
  196. Sorting a Listbox Data in VBA
  197. Solved: Delete sheets
  198. Last cell in range
  199. Solved: Does this make sense?
  200. Link Excel cell text to autocad text by VBA
  201. Solved: Phantom Pictures/Images
  202. append text file
  203. Return Value from Dialog
  204. index match example
  205. Mark cell as complete
  206. Move data from world to excel
  207. Multiple Row Totals Based On Pivot Table
  208. highlight activecell in combo box
  209. Summary
  210. Worksheet_Change and RTD Link
  211. Solved: unable to get the transpose property
  212. Solved: Hyperlink to folder
  213. running some macros automatically
  214. Hyperlink to folder
  215. Delete all hyperlinks and the associated sheets
  216. password protection difference
  217. Automating IE to get data from a website
  218. Solved: sumproduct question
  219. Solved: Exclude Sheet names from list
  220. error code, run time error '424
  221. Solved: Painting cells meeting conditions VBA
  222. Solved: VB to keep all border
  223. Solved: Instructions Following a Called Script
  224. Solved: sumproduct question 2
  225. Solved: Dynamic Drop Down List Freezing
  226. Solved: Creation of Pivot Tables has errors ):
  227. Solved: Populate Combo box with shortened list
  228. Delete the last row that was filled
  229. Variable question
  230. Delete blank row after words and print in pdf
  231. Solved: Simpliest Way to Reconcile Checkbook
  232. Solved: Reference a Range in a different Worksheet
  233. Solved: IsNull Function Not Functioning
  234. Solved: Need to extract a few items from 250 XML Files in a Tree View, to a Spread Sheet
  235. Initialize Multiple Textboxes
  236. Add new items to list
  237. Userform Dynamic TextBoxes/Labels/Checkboxes and SQL Insert
  238. Help Me!!!
  239. Solved: Text to Columns or something similar
  240. Regular Expression Replace
  241. Top 20
  242. "Freeze" some rows with highlighting
  243. Solved: Syntax Rectification Required
  244. Solved: VBA code for removing blank cells in a list
  245. Need help with VBA code for hiding across multiple ranges
  246. Multiple Sheet Consolidator into one MasterSheet
  247. Solved: Action code 2 only in cells
  248. lookup or match
  249. filter, select and mail search results
  250. Restrict two macro run at same time