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. Passing multiple arrays between sub
  2. Solved: Get The Replaced Cell's Address
  3. Solved: Search Formula limits exceeded
  4. Code to Undo & Re-Do
  5. [SOLVED:] Solved: How to Use VBTAB
  6. Installer for Macro
  7. Getting chm help file to open from menu
  8. Formula for counting used rows - Anomalie?
  9. Solved: Transfer Data to Another Workbook
  10. How to RAR a folder via VBA?
  11. Number format
  12. [SLEEPER:] Set a variable equal to the sub name
  13. save a file to a defined destination
  14. Solved: Feed Word with changing data from excel
  15. Solved: merging worksheets matched on 'key' in column
  16. Printing each sheet to pdf with a unique pdf password
  17. Spreadsheet to Form Help
  18. Solved: Windowstate = xlnormal then Center Position?
  19. Solved: Calling a Subroutine
  20. Saving data from several objects to 1 cell
  21. [SOLVED:] Indian number format
  22. Solved: Number Stored as Text
  23. If statement
  24. Word.application????
  25. Loop Help to find Intersection Cell Address
  26. Excel GUI : Activate a button from macro
  27. Findout Max value
  28. Solved: Macro help
  29. FYI - Adjust zoom, orientation, and papersize automatically
  30. Looping/Code Consolidation
  31. Delete Add-in with code
  32. Sleeper: Do a v-lookup on a closed workbook
  33. Counting
  34. How to give a button a fill color?
  35. date in vba when paste defaults to american
  36. Solved: What is wrong with this thing??
  37. Dynamically Created Toolbar with Custom Icons are Blurry
  38. Copy Variable Range
  39. Code to add a menu, macros to it and remove when book closes
  40. Extracting Data from a PLC
  41. initialize active X control
  42. Solved: can we have Greek letters in label caption?
  43. Solved: CheckBoxes
  44. Can these functions work with arrays?
  45. Solved: Listbox populated by Userform selections
  46. Solved: Enable & Disable Macro
  47. Solved: Substitute Workbook Source Name?
  48. Solved: Add If Statment to w/ Array to Loop
  49. Add to Pivot Cache based on Criteria?
  50. If statement and Qualifying help-- please
  51. Save Excel File to Fileserver via Macro
  52. Solved: Multiplying cells
  53. Extract data from closed workbook using VBA with data range unknown at start!
  54. VBA recolor fonts to paste into other apps
  55. hide active window using Auto_open
  56. Solved: Ampersand function help
  57. Solved: Rename a macro module
  58. UsedRange, copy paste values?
  59. Solved: save as excel file automatically
  60. auto close
  61. auto email generation
  62. auto update
  63. Solved: auto population of data
  64. Solved: Charts - Using Two Y Axes
  65. Solved: Any better suggestions for checking cells before row move?
  66. Solved: Text file extract
  67. Finding Print Area per Page
  68. Solved: Count Sheets With Specific Name
  69. Need to open Outlook Template out of Excel
  70. Making a Database out of Excel
  71. Solved: Create worksheets based on column
  72. is it possible to delete a workbook with code?
  73. [SOLVED:] Find Next
  74. Using a Variable in a V-Look up formula
  75. Solved: How do you make text wrap in a textbox?
  76. Solved: Mouse/Cursor Speed
  77. Solved: Using a range in a chart with VBA
  78. excel to access
  79. Find Cut and Paste at bottom
  80. Solved: Counting 1's in a column
  81. Exporting charts as GIFs, help needed
  82. changing code with code
  83. Solved: ActiveWorkbook.Activesheet
  84. Solved: Forcing correct data entry
  85. Solved: Code is calling Private Worksheet Code, Why?
  86. Solved: Edit this loop to loop through all Sheets
  87. Solved: Auto Close WorkBook when Idle
  88. Copy Filtered list / hidden data
  89. UserForm(Excel/Project/MSForms) - Color/Font List Box
  90. Solved: Left zero to appear as blank
  91. Good online tutorials/Where do you learn vba from?
  92. Variable scope problem
  93. Link Update
  94. Solved: not able to show all data autofilter problem
  95. Replace function not working in script form.
  96. Solved: Parameter passing with Command Button
  97. Solved: Insert rows while preserving data
  98. If statement..run macro
  99. Solved: vlookup filename
  100. Solved: return missing value
  101. Solved: Add a named workbook
  102. Object disconnected from its client error
  103. How to copy Name
  104. Solved: UCase Procedure is converting formulas
  105. collection keys
  106. Solved: Two validation in one cell
  107. Discussion on Objects
  108. Adding Description to UDF
  109. Solved: Hide WorkBook then Userform Show
  110. Solved: Transform the position of data on a table
  111. reference myinput in vlookup formula
  112. Solved: Trim Function...
  113. Solved: Hash Problems
  114. Password Help PLEEEASE !
  115. Solved: Entering Cell Comments On A Protected Worksheet
  116. VBA to open spreadsheet (name dynamic through var call), extract and process data
  117. Solved: Paste Special between Worksheets
  118. Solved: Data From Previous Months file
  119. Solved: Detect if a form is opened
  120. Email using VBA and AOL
  121. Solved: Convert to proper
  122. Disable Cut in a Specific Range
  123. Check Lotus Notes if Open
  124. Solved: Add item to File Menu Bar in certain position
  125. Elseif ?
  126. Add hyperlink to unknown sheet
  127. Add toolbar on workbook open
  128. Solved: Weird Error Message
  129. SumIf using background color as criteria
  130. Solved: Add textbox values to database using loop
  131. What's the difference between VBA.method vs Strings.method
  132. Solved: Creating Drop Down Lists that Filter
  133. Solved: update from master data
  134. Solved: Accessing Target Spreadsheets existing VBA Code
  135. Find string in sheet and pass location to variable?
  136. Looping through worksheets question
  137. Solved: Multi Column Listbox
  138. Solved: Save As and replace existing file
  139. Solved: Dynamic Autofill?
  140. Solved: Creating success variable from FollowHyperlink
  141. ENABLE FILE SAVE & REMAIN IN THE SAME WORKSHEET
  142. Solved: File Address
  143. Solved: Pivot Chart Positioning
  144. Solved: Display records against Single Date
  145. Solved: User form to appear when certain cell are clicked
  146. Insert row code help
  147. Search table, copy rown and paste into new sheet
  148. Solved: How does this line Select D5
  149. Solved: Command Bar Position
  150. [SOLVED:] How to paste a value
  151. Compare 2 Columns & Return In Third
  152. Combining 2 files in one
  153. Change Directory on Workbook Open?
  154. Hide Rows based on 3 column variables
  155. How do you search a cell for key words?
  156. get cell address without the $'s
  157. Solved: Text Format
  158. Solved: Hide hyperlink address
  159. Setting Default Property in a Class Module
  160. [SOLVED:] Tricks with Zips
  161. Convert a range to Proper Case
  162. to automate cells with a hyperlink
  163. examning if a cell is emty
  164. How to add a column to a collection
  165. date
  166. Solved: Select printer & sheet code modification
  167. Solved: Can excel disable close button at right corner
  168. Solved: Trying to delete rows based on 3 variables
  169. user form
  170. Data manipulation with files
  171. Listbox control help
  172. Stock data downloading code
  173. Solved: If....Flash cell-Module
  174. Listbox column Headings
  175. Solved: Select Range with variables
  176. Solved: VBA beginner: Code in the Workbook_Open() does not get called
  177. VBA pass by reference or value
  178. Solved: Auto_Open Query
  179. Open Up a Store Email Template out of Excel
  180. Solved: add leading zero(s)
  181. Solved: Import Word Table & text into Excel
  182. Solved: Can you set Security through VBA?
  183. Access to Excel transferspreadsheet and automatic sort data
  184. Solved: Any way to prevent repeating the same executing code for 4 worksheets?
  185. Solved: application.speech.speak
  186. Excel 2007 - Application.ScreenUpdating won't change?
  187. file search/auto import in excel 2000
  188. Solved: Copy PDF into Excel and Keep PDF Structure
  189. Solved: Find empty cell
  190. [SOLVED:] Delete empty rows
  191. Solved: function to retrieve characters between to given values
  192. Solved: Make cells inactive
  193. concatenating strings & data from ranges without typing a formula
  194. Solved: how to diferentiate between text and value?
  195. Items in Dropdown box of Internet Form
  196. Solved: Force user to fill cell
  197. ADODB.Connection Copy RecordSet to Array
  198. Formula help
  199. Solved: Data Validation / Array
  200. Solved: Copying and Pasting from each Spreadsheet in a Folder
  201. Mask the Salary
  202. Solved: graying out check boxes
  203. Error - manipulate dates in VBA
  204. Solved: How to Determine Which Fonts Are Being Used (Loaded)
  205. [SOLVED:] How to Clear the ?Last Cell?
  206. Selection not displaying in dropdown box
  207. Solved: User Defined Function
  208. Sort
  209. Solved: Need help with this macro
  210. workbooks.open question
  211. Sheet and cell validation
  212. Solved: Insert code to worksheet programmatically and run it in the same Sub - compiler error
  213. Solved: Find Method not working properly
  214. how to connect one excel file to another?
  215. Solved: File Exists Issue
  216. Solved: VBA tutorial greenhorn
  217. save file as CSV
  218. [SLEEPER:] Multiple Worksheet Entry
  219. Solved: Populate Specific Column Cell based on ListBox Selection
  220. Solved: extracting info from cells
  221. Ignore blank in Data Validation
  222. Solved: Combobox column width
  223. Solved: Add text in title bar
  224. Solved: Choose sheet code
  225. Solved: Looping required
  226. Auto deletion of data when deleted from master file
  227. Create/Clean-up of Objects
  228. Generate Exe from Workbook
  229. Additional Control in Vista
  230. Uninstall ADD-INS
  231. Solved: Array as a Public Const
  232. Convert Formula R1C1 to Range
  233. Solved: Question on Option Buttons on Forms vs Control
  234. How to make a range dynamic?
  235. Solved: ?Cells? and ?Range? Properties
  236. Delete Rows Based on Partial Cell Value
  237. Save as the active sheet into a new workbook
  238. Solved: LastRow on every page
  239. Importing CSV Files Without Preserving External Links
  240. Solved: how to find charecters in texts?
  241. I'm new to this and trying to fix an error
  242. Combine rows from multiple different worksheets / workbooks into a Master workbook
  243. Creating a List in Memory
  244. Solved: Hidding Data Hides Chart, Why?
  245. Add " at the beginning and end of a string
  246. Import with troubles - Date format
  247. Solved: countif question
  248. how to write code for doing format cells/ patterns/ no vcolors?
  249. Solved: Print macro
  250. Solved: Last Date of Last Month