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