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

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