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: .Find and activate a Visible Cell within a Filtered Range
  2. VBA / Formula approach
  3. Solved: Copy only part of items
  4. Automatically sharing specific data to other workbooks
  5. Solved: Saving as xls
  6. Help with creating Excel VBA Password system
  7. Please Help - Stupid Mistake
  8. [SOLVED:] Web query help
  9. Copy values from another workbook
  10. running macros
  11. Solved: Restart macro after blank cell
  12. Help with Search
  13. Scripting Dictionnary - key is already associated with an element of this collection
  14. Format isn't working
  15. Naming the created worksheet?
  16. Solved: Fax
  17. Hide and unhide rows by selecting a letter from a userform ComboBox
  18. Update macro application search to V2007
  19. Solved: Selecting multiple cells
  20. How to make a ComboBox select a specific value when i enter the workbook ?
  21. Extract ChildNodes' value from Website to Excel
  22. Solved: import record from text file & match with record in excel
  23. Solved: CC another person on an email
  24. Solved: Moving document to recycle bin
  25. Solved: Filling certain Cells
  26. Solved: Excel function: Sumproduct to match certain veriables with a date parameter
  27. Solved: Dont email if no attachment exists
  28. Problem Hiding Rows Based on CheckBox Event - Reaching Maximum Limit
  29. Solved: Use a function to access DB
  30. Solved: Formatting issues
  31. [SOLVED:] Paste & Delete Via VBA
  32. Excel VBA for Longtitude and Latitude Help Please!!!
  33. Solved: Changing Range of sources for chart
  34. Automatic Create report using data from another sheets in excel
  35. Question / Challenge - Lorenz Cipher Excel
  36. Solved: Arrange Columns based on header values
  37. Solved: VBA to do job of lookups
  38. Need help in Excel Macro
  39. [SLEEPER:] Disable Arrow Keys
  40. Split the files based on the Specific Column and update the Row Count
  41. Solved: Merge/join cells if same ID
  42. total characters in a cell
  43. Referencing certain cells to send emails out
  44. Solved: Removing Defined Names in Worksheet
  45. Solved: Multi page form refreshing data
  46. Solved: highlighting matching cells
  47. Excel compare data
  48. [SLEEPER:] Save email attachment to existing workbook
  49. Solved: Resize a table
  50. Selecting Range Names from a Table with Vlookup
  51. filling date
  52. select 3 columns
  53. Solved: Append text to a cell with color
  54. Solved: List file names and directory
  55. Help in VBA-Excel needed
  56. fill dates
  57. Range("Cells(a,b),Cells(a,b)").Select is not work
  58. VBA Copy All Rows With Today's Date in a Cell
  59. creat chart
  60. data
  61. VBA and vlookup
  62. Solved: linking with word
  63. [SOLVED:] Export to csv
  64. Make highlighed cells Bold using VBA
  65. Importing data into Excel based on Month
  66. Moving cells to another sheet
  67. Multidimensional array problem
  68. Selecting two sheets with workbook_beforeprint
  69. Excel 2003 Sortfields VBA runtime error 438
  70. Reset Autofilter and Unselect specific numbers
  71. VBA to stack pivot table data
  72. [SLEEPER:] Copy Data from Certain Cells in Multiple Workbooks to One Master Worksheet
  73. VBA Command to Find Invoices designated as NotPrinted and place invoice number into c
  74. Solved: Apply Data Validation to a Named Range
  75. Define String from Cell Cell Value
  76. Solved: vba ignore if statement in optiobutton
  77. Check the entire row and delete duplicate values
  78. Solved: E-Mail from Address found in Worksheet
  79. Solved: XLDs CFColorIndex and Chart sheets
  80. Formulas becoming values
  81. find and sort
  82. Help with cell formatting
  83. Solved: Help with modifying error bars via VBA
  84. Need help with Hyperlink question
  85. VBA VLookup Function
  86. Set focus on check box value and not on caption
  87. Excel Object Model and Embedded Word Document
  88. Excel timeclock data vba help
  89. Solved: sort multi dimensional array
  90. Why does this Previos Cell code some times error, most of the time not ?
  91. Search for cells with comments and cocatatenate to Col(N)
  92. VBA code to use Other Programs with Excel
  93. VBA code to click submit button in ie after checkbox is checked
  94. Excel Mail Merge
  95. Slot Machine help in VBA
  96. Sleeper: Chart with user-defined range
  97. Time Comparison
  98. Solved: Global Search/Replace in Formulas
  99. Complicated issue dealing with large file maintenance
  100. Solved: Allocations for CSV
  101. Solved: Function to copy sheet to new file
  102. Solved: Import XML Attribute Data To Worksheet
  103. Solved: Uploading a ComboBox from a Column in Excel
  104. Solved: Use VBA to create a named range
  105. macro for charting
  106. macro for charting
  107. Checklist automation from Outlook Senders
  108. Transferring formula to vba
  109. String lookup to get month
  110. Solved: Borders to all the used cells for all worksheets in a workbook
  111. Solved: Adjust Macro Range To 2 Columns.
  112. Solved: For Each and Pivot Table items?
  113. Need Code to Unhide Rows
  114. code will not work when I change the name
  115. Windows 7 external file open
  116. Unable to solve using macro
  117. Solved: Finding 2nd instance of a colored row seems to be much slower than it should be.
  118. Solved: Finding a Date in a Range
  119. Vlookup text values
  120. chart to be created in new sheet This macro creates chart in the worksheet same as da
  121. Solved: Copy worksheet to new workbook and more
  122. Rename files at unzip!
  123. issue reading from a .csv file
  124. Problem with formula
  125. Not work for upload file when the Window Language format - VBA
  126. Solved: How to: Function > Calculate sumof and divide
  127. Solved: Progressbar
  128. conditional formatting with vba
  129. data conversion
  130. paste text into chart
  131. [SOLVED:] Get a list of files from Directory order by the date modified
  132. Solved: Macro inserting colon in time returning #value! in output column
  133. Solved: I need help with InStr and searching a string for characters
  134. Conditional formatting
  135. [SOLVED:] Inserting more than one value into a single cell in an excel worksheet using VB.
  136. Converting sheet based stopwatch to a userform
  137. Sleeper: Turning Off Error Alerts, of sorts
  138. Solved: VBA code launching problem
  139. Calendar problem
  140. I need to create several random files
  141. Solved: execute code on the lines with data in column "B"
  142. Excel 2007 Ribbon Problem...
  143. User Defined Functions
  144. thisWorkbook.Save going to TMP file
  145. select last 20 cells
  146. Filter by value in cell to the left.
  147. [SOLVED:] Solved: Build Dynamic String into Cell
  148. Worksheet_calculate runs based on every formula in sheet
  149. [SOLVED:] Insert New Rows Between Rows
  150. Solved: VBA code to count blank cells in a dynamic range
  151. Right click
  152. Solved: Transferring the Userform Textbox Values To a Single Cell As Comment Indicator
  153. Deleting Rows when using for each cell in loop
  154. Solved: Sum 'A' if there's any digit into string in 'B'
  155. Solved: Personal.xls vs xla
  156. Sleeper: Working with Oracle CLOB DataType
  157. Building third large table which consists of matched rows of two smaller tables
  158. Solved: Image on Command Button
  159. [SOLVED:] Compare and insert missing Row Values Problem
  160. [SOLVED:] Replace all values in column with combobox selection
  161. Copy Picture generates Insufficient Resources error
  162. Solved: GoTo in VBA
  163. Image Viewer in VBA?
  164. fuzzy search macro
  165. A function to monitor changes on the data
  166. Solved: Using find function
  167. Pivot Table with both Compact & Classic Layouts
  168. Macro Help
  169. Need help with macro to detect if cell value changes from current value
  170. Help needed with small issues in function
  171. Error in calling function
  172. Macro Code Overwrites Previous Data
  173. Solved: Step Backwards through range
  174. VBA code to "Save" for dialog box
  175. Solved: Look for Values in Range
  176. How to keep an excel file from being copied
  177. VBA code to read and update text file
  178. Unzip only "text" files in a particular folder
  179. Solved: Worksheet_Change vs Worksheet_BeforeDoubleClick
  180. extract html data (not in table) from website to excel
  181. Solved: Excel 2007 vba - Filter criteria problem
  182. How to create a macro that opens a webpage and introduces text into a form !
  183. Autofill range in formula
  184. Workbook Revision Update Onload?
  185. Solved: Comparing Between 2 Workbooks and Inserting Missing Data
  186. Copy Cells and keep Source Formatting
  187. points on a graph
  188. help needed with lookups & conditions
  189. Excel Access Log VBA
  190. Solved: need help to display workhours in days:hours:minutes
  191. moving objects from excel to PowerPoint can not turn lock aspect ratio off
  192. A simple printing pages depending on cell value
  193. Solved: vlookup problems
  194. Scroll to column via Combobox
  195. Looking for a faster way to autohide rows
  196. Error occuring then code is already launched
  197. Error occurs then the code is already launched
  198. vba sumifs
  199. Solved: Auto Hyperlink to Folders
  200. Solved: Check if today is a specific date that falls on certain weekday regardless of year
  201. Excel VBA Error 'Excel Ran out resources' - Reg
  202. macro loop through 2 worksheets
  203. Unlock all VBA projects
  204. MERGING SHEETS
  205. help with user forms
  206. [SLEEPER:] Set Pie Chart & Pie Chart Tags to be Same
  207. New here: I have som questions about Excel and VBA
  208. Sleeper: vba Appointment body
  209. Difference between .responsetext and .document
  210. Writing a macro within an exel document
  211. [SOLVED:] Convert exponential format to a number ?
  212. [SLEEPER:] Browse a Folder and Populate Listbox with Folder Items
  213. Hide and unhide the worksheets in vba with dialog box
  214. [SOLVED:] Excel countif multiple criteria
  215. Merge all data in column just to 1 cell
  216. go to
  217. Solved: extract data from website to excel
  218. Solved: Delete dash with space
  219. Solved: compare 1 cell with 5 cell
  220. [SOLVED:] Date format
  221. VBA to automate a process
  222. Solved: hyperlink a cell to a textbox
  223. Search for row, check and count max match with another range
  224. Subscript out of range
  225. Excel VBA and CUDA
  226. PLEASE Help with Looping
  227. Solved: Macro to convert num to char
  228. using formula in coding
  229. Search and Compare
  230. Using ADO to import Data
  231. Solved: Compare 2 sheets and delete matched rows
  232. Dates
  233. Solved: Listbox value as input
  234. Wanna sb can do sth would help!Ty in advanced anyways.
  235. Prob in substitution
  236. Solved: move data with * symbol to another sheet
  237. [SOLVED:] Macro to sum each row if have same value
  238. copy found data to other cloumn
  239. Solved: Run time error 91
  240. Solved: formula to collection
  241. How check if add ins run?
  242. Combination
  243. Solved: Excel VBA changing case
  244. Equalities
  245. Get Data from Closed Wrokbook based on Criteria
  246. Conditional format an indentation based upon a formula from separate cell
  247. Solved: create html code from parsed xml data on worksheet
  248. Send email when changes made
  249. hyperlink
  250. Solved: Cdate in range form number => date