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