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. combobox update
  2. Solved: Run Macro against a non-active sheet
  3. Turning an Array into a String and Vice Versa
  4. define last value in filter criteria
  5. ODBC to Access from Excel problem
  6. Google rank in excel
  7. Is it possible to avoid compile errors programmatically?
  8. Need to split a 6 digit number
  9. Solved: Macro not working correctly for different user
  10. calender where the date colors change
  11. Solved: Clear worksheet except for Row 1 Macro
  12. Solved: Call a function from personal.xlsb
  13. adding submenus to a drop down menu
  14. Working with hidden rows
  15. mqasimalihot - What are you up to?
  16. Very easy VBA problem!
  17. Making my full macro much faster
  18. Solved: Force save different name on WB open or save
  19. Solved: Change worksheet value to ensure data integrity
  20. Solved: Restrict mulilpe entries is N/A or No error is selcted
  21. Solved: If Statements
  22. [SOLVED:] Whole Numbers
  23. Comparison formatting
  24. Advanced Filter
  25. Solved: Compare two columns
  26. Problem with ' in filename
  27. Efficiency
  28. IF Date falls within a Month - Help!
  29. Combo Box - How???
  30. [SOLVED:] Troubles with Counting Used Rows
  31. UserForms and Public Vars
  32. Solved: Excel freezes when code to add reference runs
  33. Worksheet_Change Query
  34. What is Application.Calculate
  35. VBA code to convert xls to PDF
  36. Solved: Mass Mailing Macro for excel and office 2007
  37. Sleeper: Editing a macro to display 0's next to a name
  38. Solved: Loop Through a UserForms Controls and Change TextBox Properties
  39. 2007 Chart not updating
  40. There has to be a faster way.
  41. Script to paste only values in cell- Excel
  42. Dynamic Field:= in Autofilter
  43. Solved: Loop through All Worksheets to remove Autofiler & Freeze Pans before close
  44. Solved: how to hide sheets for posting
  45. Paste selection to the first blank cell in a column
  46. Solved: Unwanted Microsoft message
  47. Solved: Routine to replace all cells with gibberish
  48. UsedRange
  49. Solved: Simplify this listbox code
  50. Cells Formatting for DATE
  51. Solved: size of sheet
  52. FTP Upload Advice
  53. ADO Recordset FetchComplete Event
  54. [SLEEPER:] How to customize KBase sort routine?
  55. Solved: Syntax error
  56. Solved: multiple column vlookup
  57. Average of a Count in Pivot Table?
  58. Solved: Resize with Vlookup Help
  59. Digital signatures gets removed on a shared workbook
  60. Walking Through Many Subdirectories, Many Workbooks, Many Worksheets
  61. Define variable from cell value, append, and embed images.
  62. [SLEEPER:] Required fields, validate on save
  63. Internet Explorer Automation Wait for HTML Tag to appear
  64. Send mail and avoid security message pop up
  65. Teaching coworkers excel basics
  66. Sleeper: Macro Slowdown due to Multiple Processes?
  67. Solved: List Box not linking!!!
  68. Solved: Restrict download area
  69. Chart data based on user input
  70. Solved: Invalid or Unqulified Reference
  71. Solved: Copying & Sorting
  72. Solved: Goalseek error
  73. Apply query to Recordset
  74. Solved: Embedded controls
  75. User Form
  76. Alter Code to show value in column 'A"
  77. Solved: Excel workbooks as a Database
  78. Problems with referencing a .xla file
  79. Solved: Import CSV & Ignore Items With No Text Qualifier
  80. Copy Autofilter Items
  81. CANNOT MADE CODE WORK
  82. Max and min values
  83. UPDATING NOW() AUTOMATICALLY
  84. Iterative copy paste problem
  85. Sleeper: Excel Solver Question
  86. Solved: Greater, Less than formula
  87. Help to enable VBA in excel 2007
  88. vba to automatically hit a key on the keyboard
  89. Code to show if cell interior colour is red
  90. Solved: paste value for filtered data
  91. Pivot table defaults
  92. Running Delete Row Code For All Tabs In A Spreadsheet
  93. Solved: remove signs (wildcards) from a string
  94. Solved: rename folder
  95. Help With/Code To Enable Macros . .
  96. count matching cell colors
  97. Solved: Need Windows Login of User who changed the data
  98. Or Function
  99. filter by dates
  100. Sender in VBA?
  101. Problem using "range.find" in VBA
  102. Solved: Lect combobox item, display wksheet name in listbox
  103. ftp upload
  104. Random Sampler
  105. Solved: separate rows with blank rows
  106. Need a macro to copy data to main file
  107. Solved: How to capture position info of a cell
  108. VBA help - code to loop through a certain folder structure
  109. Solved: Set Print Area - Last Row/Cell Used
  110. VBA cannot activate cell after first loop
  111. Solved: Excel Userform textbox's
  112. Solved: Adding a Treeview control to a Userform
  113. excel template error handling
  114. Get CSV from a PHP script on a server (mysql 5)
  115. UDF causes other macro to fail w/ err 1004
  116. find next blank row and input information from form
  117. Best Way to Loop Through Range?
  118. automatic spell check on open fields in protected document?
  119. get last cell value and add 1 for next number
  120. Solved: Set column width in pixels
  121. Pull out the values which are not Unique
  122. What is PERSONAL.xlsb??
  123. Auto Scale Chart Font in Excel 2007
  124. Removing HTMLCheckboxes
  125. Solved: Excel 2007: Bypass Workbook_Open Code
  126. Why is this ElseIF not the same as this Select Case?
  127. Autofilter On One Column?
  128. Copying from one file to another
  129. VBA
  130. Excel to PDF
  131. VBA
  132. Change cell color to color of adjacent cell
  133. Solved: repopulate formulas
  134. Solved: positioning a Chart
  135. Excel generate a task in Outlook
  136. Find all xls files except one subfolder
  137. Frequency function and open intervals
  138. retentive variable
  139. To random_noise
  140. Solved: Need help with toggle button
  141. Working with Charts
  142. Finding a Value
  143. Find the next date in column
  144. populating combobox at runtime
  145. Error: Excel cannot complete task with available resources???
  146. Solved: Text-to-column but right to left
  147. Error Copying Data
  148. Checking Tab Names
  149. Import Address Book from Outlook
  150. [SOLVED:] Solved: Selectively copy ActiveCell onChange
  151. Solved: Save as & file name\path problem
  152. Solved: vlookup with multiple criteria
  153. Solved: Filtering records older than one year ago
  154. Solved: Date formula in vba
  155. detect more than one border color along single edge of range
  156. Trendline data/info
  157. How to access the methods of .xla from VBA?
  158. copy & paste
  159. Solved: script to copy multiple cell values into one cell
  160. [SOLVED:] Shifting rows to a worksheet depending on a cell value
  161. userform apply code after userform end
  162. Will deleting defined name delete data??
  163. Removing pictures
  164. Deleting words in a string
  165. Validating Textbox's on Worksheet using Class Modules`
  166. Group and filter the data
  167. Solved: accidently save over file
  168. Insert Chart Help Needed
  169. Hidden Module?
  170. Column values based on entries on another sheet
  171. Solved:
  172. Solved: VBA userform
  173. What Does This Mean??
  174. conditional formatting based on date?
  175. time sum
  176. Solved: run DOS command without waiting ?
  177. Solved: Extract Text to columns
  178. SeriesCollection by name
  179. Solved: Deleting / Reordering columns in a Worksheet
  180. Solved: .formula not working with Excel
  181. Vanishing controls...
  182. Solved: Working with Shapes
  183. Code to copy and insert rows
  184. Pulling folder content file info into worksheet
  185. Solved: Check date & compare to another date
  186. Excel to SQL Server
  187. Query Table in Excel
  188. Faster method for VLOOKUP
  189. Solved: Sending Copy of WorkSheet from 1 Book to Another
  190. Solved: all caps combo box
  191. Highlight Row Based on Cell Value
  192. Highlight cells that did not match
  193. Solved: Bar Chart doubt
  194. display range value in message box
  195. [SLEEPER:] Automatically populate userform from row selection in excel
  196. [SOLVED:] Input more than 15 digits numbers in a cell in a worksheet
  197. How to Calculate Tax from Net Amount--Help
  198. [HELP] Merging all the details of the work book in one sheet.
  199. Problem with ComboBoxes (control toolbox ones)
  200. need some code to move items into new sheets
  201. Excel to PDF
  202. Solved: search next value with textbox
  203. TAB Name
  204. Extra Information alongside Pivot Table
  205. Excel chart in PowerPoint
  206. Solved: Regression Analysis macro
  207. [SOLVED:] Trying to get Code to run in excel 2007
  208. Solved: search next value with textbox in other sheet
  209. First date in week from <WeekNo, Year>
  210. [SOLVED:] Order an array from the smallest number to the biggest
  211. Format Cell For Time
  212. Fairly simple problem
  213. Survey in Excel using Visual Basic Need to edit!
  214. Dynamic pivot charts using pivot table
  215. [SOLVED:] Is this something that I can do in VBA?
  216. Speed up loop?
  217. update procedure in excel file from personal.xls
  218. Open Template with file picker
  219. Limit amount of rows formatted
  220. "INDIRECT" worksheet fuction problem
  221. [SOLVED:] Return default save path for an excel add-in
  222. string manipulation problem
  223. Solved: I'm having trouble selecting a range
  224. Solved: BeforeDoubleClick Issue?
  225. Solved: count all equal combinations
  226. Calculating An Average
  227. Solved: Combine Data into one Cell
  228. Drop down List
  229. Summing Similar Conditons
  230. Help uploading excel cells into website
  231. Inserting a Range on a Chart as TextBox ?
  232. Count Files in Several Folders
  233. Solved: Auto fit columns in whole workbook
  234. Formula to Prevent a higher % to be entered...Help
  235. [SOLVED:] Open access and run macro in access
  236. Date Format
  237. Solved: Text To Columns - passing FieldInfo value as a string
  238. run code from personal.xls
  239. Solved: Code Amend to OK Msg Box Before Close
  240. Write to a text file
  241. Conditional formatting
  242. Solved: make visible based on value
  243. modify nextrow code
  244. Error Msg: MS Office is waiting for another application to complete an ole action
  245. 2007 Pivot Table Conditional Formatting macro problem
  246. Can’t Find Project on Library . . .
  247. Transform data to Columns
  248. Image Popup when mouse arrow is on Button
  249. Runtime Error 5: Invalid procedure call or argument
  250. problem unprotect vbproject