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: Clearing Pivot Cache
  2. Solved: Worksheet_Change with 2 requirements
  3. How to LinkColumn of a Saved Workbook
  4. Command Bttn import .csv file to new worksheet
  5. Two questions: Long and Dim
  6. Pasting a selection of data
  7. Solved: Solved:
  8. Get current keyboard layout with VBA
  9. Need help in creating complex macro.
  10. Solved: Conditional formatting query
  11. Solved: Change a Picture or Object Color using cell values
  12. Importing From txt File
  13. checking that a user entered decimal number in textbox is only upto 4 decimal places
  14. Creating a Login Form
  15. Application.EnableEvents problem
  16. close Wbk-a and open Wbk-b
  17. Lookup data from many sheet and Skip blank
  18. Solved: Convert Date
  19. Force Macro + Other Applications
  20. Solved: MATCHROW = 0 > HIGLIGHT
  21. add alert to txt if criteria met
  22. [SOLVED] Grid combination logic problem
  23. Macro To Add Grades Into System
  24. How do you make a clickable button without creating a form?
  25. Sync Pivot Tables
  26. Amend Macro Store Info In Different Places
  27. need a save as text macro with delimiter
  28. Solved: match / lookup to code table on different sheet
  29. Filling a range of cells using a VBA function
  30. Solved: Getting data from other sheet with if statement and somprodukt
  31. Solved: *Automatically Unprotect & Protect sheet - Macro command button
  32. Solved: Apply code only to column A
  33. Debugging - Show workbook if code running on memory?
  34. Replace and sort macro
  35. Run a macro on a different wbk
  36. Solved: Automatically import a .bas module
  37. email results
  38. Solved: Collates data from many sheets to Master sheet
  39. Little Regex Problem
  40. Solved: Help: Run-time error '1004': Application-defined or object defined error
  41. Creating a folder with cell contents
  42. If statement logic question
  43. Solved: Loop that works on all sheets in workbook
  44. Moving range to onther sheetbase on cell value
  45. how came wb close by module showing in VBAProject window?
  46. Solved: updating data from another workbook
  47. Listbox selection criteria report
  48. Solved: Displaying - 0 - while using VBA
  49. Automatically move cursor if value exist
  50. Exclude Sat & Sun while calcualting due date
  51. Solved: Resizing Array
  52. Not able to access elements from a webpage
  53. How to compare two sheets
  54. Set Formula and Notify if changed
  55. [SOLVED] VB Code to Copy a table and place it in an email.
  56. Text Import Code crashes at same record
  57. Getting data from different sheet and sort and sum
  58. Solved: If statement based on active worksheet Index Name
  59. Solved: Listbox+rangecopy+concatenate
  60. Copy Prices (with conditions - VBA) from one workbook to another
  61. Solved: Vlookup with an Index & Match formula
  62. Solved: Getting External Data From Web
  63. Help with Solver in VBA (range related)
  64. Reading a text file
  65. Need Help in creating a movie list catalogue
  66. Disable Cut, Copy, Paste Request
  67. Excel 2007 - Can vba display the MenuFloaties mini toolbar?
  68. Solved: Arrange sheet by name in between other sheets
  69. [SOLVED] Topic - Help Debugging Code : Placing a range in the body of an email.
  70. User Form
  71. Search data and return latest status based on date & time
  72. Solved: cancel ESC key
  73. File Size comparison by VBA
  74. Solved: Button to Copy & Move to another sheet ERROR
  75. Putting selected cells data into one cell
  76. Clean up Sort
  77. Automatic Creation of combobox
  78. How can we update the date in a cell when we modify a text cell?
  79. How to get help quickly - and keep getting it.
  80. Solved: New Excel files based on Cell values
  81. Rearrange Excel Sheet to uploadable File for SQL Server
  82. Solved: Merge data as value without formatting
  83. Delete data from Pivot Table
  84. Solved: Conditional Output to Pre-Formatted Worksheet
  85. pull letter above after subtotal
  86. User Defined Function - Mtwo = 2X
  87. Solved: Need to count rows in the copied range, or rows in the clipborad
  88. Small problems with generating a Bubble Chart in VBA
  89. Workbook Open/Before Close events
  90. Solved: Formula for count by day and hour
  91. Solved: Need to limit choices for the save as name.
  92. Solved: Excel2007 .RemoveDuplicates
  93. looping results
  94. Deducting amount of time (hrs) from a date and time stamp (dd:mm:yy hh:mm:ss)
  95. User Defined Function - Payment(mode, price)
  96. Solved: Create a sound
  97. VBA Lookup Errors
  98. Macro Slows with the same data...
  99. Why does my code not work Internet Explorer
  100. Run-time error 1004 trying to select cells
  101. Copy/Paste Macro issue
  102. Solved: Calling a function from a worksheet formula
  103. Solved: How to combined Modul
  104. HELP needed with VBA MMULT
  105. driving hours
  106. Solved: prevent textbox selection without disabling it
  107. Solved: Someone hide the codes?
  108. Solved: Test Large Change
  109. Store data and put them on a new sheet?
  110. Help to modify code
  111. Delete everything on sheet except?
  112. Solved: How do you set up this simple array?
  113. copy worksheet and values
  114. Solved: Radio button is not working - variable not defined
  115. Solved: After filtering row16 down, fill row10 with top visible row. If no results do nothing
  116. Lost Shortcut functionality
  117. Frame visible properties
  118. Columns in ListView
  119. Find Data in a table and enter =now into a certain cell
  120. Solved: Alternate for INDEX/MATCH
  121. Setting ws name
  122. Looping through a bunch of text files
  123. Change Graph data range
  124. Open internet at workbook open
  125. Need help with modifying this array
  126. Easiest way to write greater or less than?
  127. If / Instr command to change variable
  128. Solved: Modify code to close workbook if opened on wrong computer
  129. MsgBox - Displaying two values
  130. Solved: Show date and time in a message box
  131. Search for blank cell based on two conditions
  132. Solved: Need to set textbox to the width between Column 1 and column 24
  133. Protecting Excel Workbook
  134. Solved: passing an array to a class
  135. Save as Macro
  136. Solved: COUNTIF using multiple criteria
  137. Solved: if user keys a specific word in cell
  138. Solved: Dump Call Stack
  139. Solved: Creating a textbox in each cell of the active row range Column 1 to 24
  140. Solved: Selection Change Event only if Row Selected Changes.
  141. Solved: What code lanuages does Excel 2010 understand?
  142. Solved: Permission Denied renaming Textbox if name in the thousand's in 2003 - ok in 2007
  143. vba I/O text
  144. Solved: skip value with error
  145. Solved: Copy and rename sheet in different name
  146. Solved: custom class - multiple values for an attribute
  147. Help in combining multiple spreadsheets
  148. Solved: Select a Sheet in another Workbook
  149. Custom Formatting For Two Numbers in a Column
  150. How to find 2 reference point and grab info where they intersect
  151. Connecting to Oracle Database
  152. VBA for Highlighting
  153. Gmail Macro
  154. Mathematical Calculation "at which point - specific percentage could be achieved"
  155. Need empty recordset for almost complete code
  156. Rearrange columns
  157. XML help needed
  158. Solved: Error Handling Help
  159. Sum text after grouping
  160. Extend the msgbox wider?
  161. Custom sort modification
  162. Solved: do...loop statement
  163. Application.onkey
  164. Copy Two Columns into one column
  165. Solved: Finding and manipulating cell ranges
  166. Solved: select folder bij list
  167. Solved: Chart Macro
  168. Disable print button in worksheet command bar - Excel 2007
  169. Solved: Link button to PayPal
  170. Copy & paste
  171. Solved: set printer to 2 copies automatically
  172. Excel Reverting to all values
  173. Solved: Help with formula to divide number into 4 cells
  174. Solved: Ontime event
  175. Solved: Set all sheets to pagebreak preview.
  176. multiple ranges to if statement
  177. kill wkb & close excel
  178. Monitor cell for change
  179. Module class and form Listed in VBA without folders
  180. Randomly Generate text in cells from a combined range of cells
  181. Solved: Macro Tweak
  182. Solved: VLookup Code Error in form - Runtime Error 1004
  183. Solved: Tweak Macro Not To Eliminate Numbers
  184. Drag & Drop?
  185. Solved: Clear sheet only if File is selected
  186. Solved: SPECIAL NUMBERING
  187. Text String Joiner Macro
  188. Solved: Flashing text
  189. Solved: space bar
  190. Vlookup for multiple instances
  191. Solved: SUMIF not working =:(
  192. Solved: If file is open, can the Thisworkbook open event save a copy and leave it open?
  193. How to Populate Userform Labels from a Range
  194. Solved: VBA to Save PowerPoint
  195. SelectionChange Select Current Row of Range and Lock
  196. How to get rid of these dead macros?
  197. Detect Conditional Compilation Setting via code
  198. click paypal button
  199. odd or even
  200. Unhide column without selecting sheet
  201. Solved: Search for date in range and return cell address
  202. Practice Problems
  203. Solved: When closing Workbook repeated message "Do you want to save?"
  204. print files form dialog
  205. visual Queue in excel
  206. Solved: Screen / Worksheet Refresh
  207. index match help
  208. Solved: IF...ELSE...THEN LOOP HELP Please Help!
  209. Solved: One Script for Multiple Worksheets
  210. Solved: Insert year into cell
  211. Is Late-binding possible in VBA?
  212. Solved: Conditionally moving cell contents
  213. VBA application terminates when Control events are added programaticly
  214. help understanding code
  215. Forex Rates from a Java Applet
  216. Solved: dynamic list
  217. msgBox to naming folder
  218. Link Cell to MS Project % Complete
  219. Pause blinking caption
  220. Updating Inventory
  221. Edit Feature in Userform
  222. Radio button, activate, highlight cells?
  223. Accessing Outlook Contacts / Categories
  224. Make a button transparent?
  225. Solved: Flash Border Line
  226. Solved: Radio button is not working.
  227. Automated Functions
  228. connect Excel to AS/400
  229. moving sheets
  230. How to get out of 'Excel is waiting for another appplication...'
  231. Have sound embedded in VBA file?
  232. Solved: Clearcontents in a row
  233. Solved: Activate Macro When Sheet is Opened?
  234. How to hide a Button
  235. Solved: If Then Statement
  236. Solved: Boolean Working?
  237. Copy/paste a local file into PowerPoint
  238. Solved: Is the coordinate system inside a chart area different than outside.
  239. multiple form
  240. Right-Click on Toolbar button
  241. add a condition
  242. combining vlookup & hlookup
  243. Using an IF statement with multiples
  244. Return Value with color
  245. Solved: A code to write TXT file
  246. an active sheet save as copy
  247. Merge workbook to single workbook
  248. Solved: Error Handler
  249. Dual Monitor Setting in VBA
  250. hiding button when save