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

  1. Solved: For next i help
  2. Dates and Days
  3. help please
  4. Calling macros
  5. sheet protection options
  6. Check if a shape is selected
  7. Editing in Word and saving in Notepad while controlling everything in Excel
  8. Unstable event code
  9. Convert workbook code to worksheet code
  10. Auto print last filled page
  11. Sum of column
  12. Effectively using Classes and Property Let/Get; referring to parent or sub class...
  13. Displaying missing values from 2 worksheets in another separate worksheet
  14. Solved: Deleting part of a merged cell
  15. Solved: Calculate Time Left
  16. Solved: Delete all info other than name on left side of cell.
  17. Login to yahoo mail.
  18. Solved: VBA code for checking possible combinations of 4 numeric digits
  19. copy folder WB to a one workbook
  20. Macro to drill into pivot table
  21. Automation error (Error 440)
  22. Solved: Pivot Table
  23. Dynamic Looping Help
  24. Help to disable popup calendar
  25. Filter Problems
  26. Solved: Enabled Button
  27. Excel VBA Coding for xls transformation
  28. Solved: DoubleClick event in a textbox
  29. copying a range from multiple csv files
  30. Solved: how fix it - vlookup in visible range (not invisible)
  31. Share workbook with digital signature
  32. Solved: Checklist compare
  33. Solved: Zero the negatives
  34. Effect of AND and OR operators on Type Long
  35. Append excel table into Access table on weekly or monthly basis
  36. Solved: To reflect latest data updated in a row range
  37. How to generate weekly/monthly reports from daily report using macros
  38. Changing Chart Titles
  39. Deleting empty worksheets in a workbook
  40. Copying a picture from a web page and pasting into Excel
  41. Solved: goal seek w/ value from another workbook
  42. interact with web page
  43. Compare 4 columns & find dissimilar
  44. Search Function Problem
  45. Round off Issues and more...
  46. Search data within the spreadsheet to log
  47. How to create the menu w/o the code as the attached file
  48. Function Help
  49. Solved: Data Validation: Combine Two Cells In Drop Down Only
  50. find with xlprevious not working
  51. Solved: Dissect result
  52. Search Date in Worksheet and Set Format
  53. Solved: 2003 Multibox Color fix
  54. help with vba code please
  55. Help with code
  56. Solved: Help Date's
  57. Solved: Red Font
  58. Copy data
  59. Problem with If...Then...ElseIf Loop
  60. custom format
  61. Solved: Import Web Data with HTML format
  62. timekeeping template
  63. Problem showing images in locked sheet
  64. Count non empty cells
  65. Getting Error when No visible Cells found. What to do?
  66. Macro to look at list in sheet1, if not in sheet2, pull in
  67. How to re-arrange the listcolumns?
  68. Reading Data and creating a table from it
  69. Textbox Userform: Autopopulate textbox from another textbox
  70. Solved: Lookup County
  71. Updating sheet automatically periodically
  72. Copying a range from a different workbook
  73. Height of Prina Area
  74. Drill into a Pivot Table using a Macro
  75. Data Validation code error
  76. How to destroy (de-filter) individual advanced filters in a worksheet?
  77. Macro vlookup with fill down
  78. Linking dynamically allocated row offset to stacked column chart data range variable.
  79. Solved: loop Error
  80. Solved:Looping a section of code
  81. Solved: Basic VBA problem with Format
  82. Solved: VBA to Excel Add-in
  83. Data Validation based on 2criteria
  84. Solved: Look excel range?
  85. Make a report with data taken from cells
  86. Solved: Delete Empty Cells
  87. Solved: Entering Value in Combobox with Dynamic Range
  88. cannot get rid of error message
  89. Why doesn't the xlcelltypelastcell not giving the last cell inside a list?
  90. Move files and ignore file extension?
  91. vlookup with input box to select a new month when run
  92. Set the values for .TextFileFixedColumnWidths in code
  93. Solved: concatenate cells in IF statements
  94. List Ranges with Missing Data in Column
  95. HTML table code
  96. Solved: Range Selection error
  97. Moving to Excel 2010 - worksheets.move compatibility
  98. Macro: Highlight Cell in Col B that DOES NOT exist in Col A
  99. Help Exiting Loop
  100. Combo box in Excel to query MySQL
  101. Unlock Blank Cells in Column G
  102. Advanced Filter Command Buttons
  103. Copying Characters to the Right of a Selected String in a .txt file
  104. Drop Down Validation Double Dependency
  105. How to password protect grouping?
  106. Solved: SUM Formula
  107. Cells that update automatically
  108. VBA Data Analysis Loop Problem
  109. Creating a list of variables
  110. Unhide bug
  111. Solved: Range matrix
  112. Solved: multiple interior.colorindex
  113. Solved: error handling failed
  114. Solved: Conditional Formatting Help :-)
  115. Solved: Range selection with array of ranges
  116. Solved: Cannot switch to an active excel workbook from word
  117. Code understanding
  118. Create worksheets from a list
  119. Solved: Find
  120. Tricking Sort Logic
  121. Convert UTC to local time with DST
  122. E-mailer from individual e-mail to 1 e-mail
  123. Solved: Setting wb.Name to string for VLOOKUP formula
  124. Solved: searching a word in lower and uppercase
  125. Replace Chart labels with Textboxs
  126. Question about vba programming
  127. how to search for a string in text file
  128. Solved: Shell and Wait Issue
  129. Solved: Stripping numbers from alphanumeric strings
  130. Solved: Delete Rows
  131. VBA code to hide rows
  132. Solved: Listbox1: Highlight Pre selected Item
  133. Copy Paste File Specified in Cell to Another Folder
  134. Confusing issue with Copying and moving work tabs
  135. Solved: Quick VBA Userform Pivot query
  136. Solved: Copy from one workbook, to another, keeping format.
  137. connetct own help file in excelVBA function addina
  138. Problem with .xlsm file adding code via VBA
  139. Solved: Strange Error in simple VBA macro
  140. userform filtered search
  141. Solved: Sumproduct with HLookup
  142. Solved: Find text in a cell,copy row and paste into new sheet
  143. How To Copy Paste File Named in Cell to Another Folder Named in Cell?
  144. RGB (R, G, B) to hex function
  145. VBA Code Freezing
  146. Need Help - Macro Not Working Properly
  147. Compare two spreadsheets
  148. Solved: VBA for updating every worksheet in workbook.
  149. Solved: Problem with more then one each.. for cicle
  150. Solved: Display the first word separated by comma in textbox
  151. Filling in IE form with values from Excel
  152. Solved: Strange problem when protecting/unprotecting sheets
  153. Solved: copy cells to column without blanks
  154. saving spreadheet to network drive
  155. Converting Matlab Code to Vba
  156. Why the Set temp(0) = Activesheet.Columns(3).insert is not working?
  157. VBA Help
  158. Solved: Workbooks.Open issue in Excel 2010 (Network Drive)
  159. VBA Excel Transpose all files in a folder
  160. Solved: Conditional Format 2 arguments; one of them is only a part of a cell contents
  161. Comparing string differences between two separate column of sheets???
  162. Merge first sheet of multiple excel file
  163. Solved: Userform Option Button Issues
  164. replacing characters in a column which occu at random positions
  165. Publishing Defined Names to single Htm page
  166. Expressing a " in an excel Formula as VBA code
  167. Solved: Filter and VBA
  168. Solved: VLOOKUP Code
  169. Solved: Allow Authorisation On 2 Computers
  170. Solved: Application.Countif - separate workbook
  171. Solved: VBA Copy
  172. save as with auto name
  173. Solved: Speed up an Array Formula in VBA
  174. Solved: UserForms: Passing inputs from one to another
  175. Reading values from a closed excel sheet
  176. Solved: making a list of the datasheet
  177. Sorting Options for Several Data
  178. Compare two spreadsheets-Macro
  179. Debugging Runtime Error '13' Type Mismatch
  180. Solved: MsgBox to list missing .references
  181. on each day, at 6am, the excel file will be opened by itself
  182. Macro Help: Replacement for cut and delete Speed wise
  183. Sorting sheets within a workbook
  184. Solved: rd_filename = Active.Workbook.Name
  185. Find cells within range equal to 70% of sum of total range
  186. Solved: select worksheet and display selected sheet in workbook
  187. Master Filter for Pivot Tables
  188. Solved: make VBA code shorter
  189. Problem with VBA script reading from MySql database
  190. Solved: Working on a not visible Worksheet
  191. String and Combox Question
  192. Solved: Not understanding Custom Icon Macro
  193. Return Types in Excel VBA
  194. Solved: Insert Row after Specific Text
  195. Solved: Runing a macro by clicking on a sheet
  196. Delete and Move a row in excel
  197. Automate Click, Save Close
  198. Make a simple report with VBA
  199. Solved: userform multiselect listbox - select item
  200. mutliselect listbox via looping a range
  201. Extract email out of changing string count
  202. controlling cell entries
  203. Solved: Re-calculating cells with unrecognized functions
  204. Copy text from Word and paste into Excel VBA
  205. Solved: Msgbox interrupts drawing on worksheet
  206. Solved: Separate generated password with dashes
  207. Cannot Insert Column
  208. VBA web queries - error 1004 "The site reports that the address is not valid"
  209. Solved: variable formular depending on number of work sheets
  210. SendKeyys command turns off Numlock
  211. Two Columns (Search and Copy)
  212. Comboboxes filling with for loop
  213. Declaring global Boolean variable?
  214. read/write to textfile
  215. Loop through all visible worksheets in excel
  216. On error resume next
  217. Is it possible to automate results from an access query into Excel?
  218. Using data collected in a module/ macro
  219. Solved: Variable dimension of a matrix
  220. Solved: Copy deleted info
  221. FileDateTime(pathname)
  222. find info in cells,delete cells with no info and paste to printsheet. then repeat
  223. Is it possible to do automation to control another application through vba code?
  224. Need help in event
  225. VBA code to import pdf as txt to Excel
  226. Solved: .Find not working between Workbooks
  227. Solved: PRICING GRID
  228. Copy WS to a Named WS values only
  229. Auto open file at fixed length of time
  230. Copying File issue
  231. Solved: Problem with ListBox
  232. Swapping Cells
  233. Solved: Problem with declarations and Str function
  234. Solved: Message Box Reminder
  235. Solved: Problem with cut/paste to last row of sheets
  236. right-click in textbox
  237. Solved: Start Counting when cell changes
  238. How to pick the random numbers from a set of numbers
  239. draw arrows
  240. Solved: Setting filters from a form
  241. Solved: Creation of Folders and Sub-Folder
  242. Insert picture in sheet + send range via email
  243. Solved: VBA to calculate last month
  244. Solved: Page Break
  245. How to Connect to an API
  246. Solved: Returning TextBox data to msgbox or cell
  247. Solved: copy first sheets from all work books in a file into a collective sheet
  248. Get Final URLS?
  249. Solved: Help modifying excel timer
  250. how to create a aktive excel table