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 174

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